cancel
Showing results for 
Search instead for 
Did you mean: 
cancel

How to execute migrate_unload.bat command for cvp data migration

fahadibm001
Beginner
Beginner

As per CVP reporting server migration

 

1 - Login to informix user

2 - Access CVP installtion directory

3 - Run command

migrate_unload -p c:\migration

 

My question how to execute step 1 and 2 in one command prompt session as when I login to informix user through db access I do not have interface to access CVP installation directory.

 

When I am executing the command in a different command prompt session I'm facing "No Connect Permission" since dbaccess is unable to access the informix database.

 

Please guide.

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions

Remember from the CVP Reporting install guide you have to create a Windows local admin account to install the software. You login with this user in order to run that bat file.

 

david

View solution in original post

14 REPLIES 14

david.macias
VIP Advocate VIP Advocate
VIP Advocate

The cmd prompt for DB access and the command prompt to run migrate_unload.bat are different. Find the .bat file then open a command prompt in that location and run the command you posted.

 

david

Hi David,

Thanks for your reply.

 

I did the same and facing permission issues.

 

Sharing logs in a moment.

Hi David,

 

Can you please help me understand this log. I'm running these command via Administrator

 

 

C:\Installables\CVP\migration>migrate_unload.bat -p "c:\migration"

 

  387: No connect permission.

 

  111: ISAM error:  no record found.

Error in line 1

Near character position 16

 

  349: Database not selected yet.

Error in line 2

Near character position 19

 

  387: No connect permission.

 

  111: ISAM error:  no record found.

Error in line 4

Near character position 18

 

  349: Database not selected yet.

Error in line 5

Near character position 45

Required disk space is 1 MB, available free space is XXXXXX MB. Will continue to

unload data.

dbaccess cvp_data c:/temp/colorder.sql 2>NUL

No such file or directory

The system cannot find the file specified.

22:08:04 Fri Oct 25 2019Read list of tables

22:08:04 Fri Oct 25 2019 : onpladm create project migrate

 

22:08:04 Fri Oct 25 2019 : onpladm create job applicationsummary_15 -p migrate -

d "\\.\pipe\EXPPIPE" -D cvp_data -t applicationsummary_15 -fu -zD

 

Unloading applicationsummary_15

22:08:05 Fri Oct 25 2019 : onpload -p migrate -j applicationsummary_15 -fu

 

Error occured at HPL failpoint: 16603

 

Cannot open database 'onpload' - SQL error -329, ISAM error -111

 

 

vdata for table:applicationsummary_15

22:08:05 Fri Oct 25 2019 : dbaccess cvp_data c:/temp/validation_query.sql 2>NUL

 

 

No such file or directory: c:/temp/temp_validate.unl

22:08:07 Fri Oct 25 2019Read list of tables

22:08:07 Fri Oct 25 2019 : onpladm create project migrate

 

22:08:07 Fri Oct 25 2019 : onpladm create job callback_current -p migrate -d "\\

.\pipe\EXPPIPE" -D callback -t callback_current -fu -zD

 

Unloading callback_current

22:08:08 Fri Oct 25 2019 : onpload -p migrate -j callback_current -fu

 

The process cannot access the file because it is being used by another process.

Error occured at HPL failpoint: 16603

 

Cannot open database 'onpload' - SQL error -329, ISAM error -111

 

 

vdata for table:callback_current

22:08:08 Fri Oct 25 2019 : dbaccess callback c:/temp/validation_query.sql 2>NUL

 

 

No such file or directory: c:/temp/temp_validate.unl

22:08:09 Fri Oct 25 2019Read list of tables

22:08:10 Fri Oct 25 2019 : onpladm create project migrate

 

22:08:10 Fri Oct 25 2019 : onpladm create job agg_schedule -p migrate -d "\\.\pi

pe\EXPPIPE" -D ciscoadmin -t agg_schedule -fu -zD

 

Unloading agg_schedule

22:08:11 Fri Oct 25 2019 : onpload -p migrate -j agg_schedule -fu

 

The process cannot access the file because it is being used by another process.

Error occured at HPL failpoint: 16603

 

Cannot open database 'onpload' - SQL error -329, ISAM error -111

 

 

vdata for table:agg_schedule

22:08:11 Fri Oct 25 2019 : dbaccess ciscoadmin c:/temp/validation_query.sql 2>NU

L

 

No such file or directory: c:/temp/temp_validate.unl

Load perl scripts execution failed !!

Press any key to continue . . .

 

Thanks,

Fahad