How to execute migrate_unload.bat command for cvp data migration

[fahadibm001]

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

[david.macias]

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

[fahadibm001]

Hi David,

Thanks for your reply.

I did the same and facing permission issues.

Sharing logs in a moment.

[fahadibm001]

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

[david.macias]

I just loaded my lab to try this as I was curious.

1. From the installer I moved CVP\migration to c:\migration.

2. Logged in as cvp_admin local admin account.

3. Stopped CVP Call Server service.

4. Open cmd prompt.

5. Ran c:\migration\migrate_unload.bat

Output:

C:\migration>migrate_unload.bat

C:\migration>dbaccess cvp_data unl

Database selected.

Routine dropped.

Routine created.

(expression)  call

(expression)  callevent

(expression)  callicminfo

(expression)  outgoingeccvariable

(expression)  vxmlcustomcontent

(expression)  vxmlelement

(expression)  vxmlelementdetail

(expression)  vxmlelementflag

(expression)  vxmlerror

(expression)  vxmlhotevent

(expression)  vxmlhotlink

(expression)  vxmlsession

(expression)  vxmlsessionvariable

(expression)  vxmlvoiceinteractdetail

(expression)  call_15

(expression)  call_daily

(expression)  call_weekly

(expression)  call_monthly

(expression)  applicationsummary_15

(expression)  applicationsummary_daily

(expression)  applicationsummary_weekly

(expression)  applicationsummary_monthly

(expression)  device

(expression)  resource

(expression)  usage

25 row(s) retrieved.

Routine dropped.

Database closed.

C:\migration>dbaccess callback unl

Database selected.

Routine dropped.

Routine created.

(expression)  callback_current

(expression)  callback_historical

(expression)  callbackevent

(expression)  callbackqueue

(expression)  queueref

5 row(s) retrieved.

Routine dropped.

Database closed.

C:\migration>echo unload to schedule select * from agg_schedule   | dbaccess cis
coadmin

Database selected.

10 row(s) unloaded.

Database closed.

C:\migration>

I hope this helps.

[fahadibm001]

Hi David,

Where/how did you login. Is it on command prompt,

". Logged in as cvp_admin local admin account"

[fahadibm001]

Hi David,

Do we have to login to Command prompt with CVP_admin ?
Do we have to login to VM with CVP_Admin ?

I'm running the command prompt as "Administrator" before I execute migration_unload command.

Thanks

[david.macias · Accepted solution]

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

[fahadibm001]

Not sure why this is returning erro below.

A subdirectory or file c:\migrate\cvpdb\cvp_data already exists.

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

No such file or directory

I can see c:/temp/colordel.sql file available.

[fahadibm001]

i believe I need to login to server using the db admin. trying it now

[fahadibm001]

Issue Resolved:

I had to login to the CVP server using the local CVP_DBADMIN.

Thank you for your help.

Thanks,

Fahad

[david.macias]

Thanks for reporting back with what was the fix and for marking what was the right answer.

Glad I could help.

[awickland]

Hey David,  I am running into a similar but different issue.  When logging in as cvp_dbadmin and running the command, I don't get the same output as you.

C:\migration>migrate_unload.bat

C:\migration>dbaccess cvp_data unl

Database selected.

Routine dropped.

Routine created.

26154: Could not open file: (file, errno)=(call.unl,13).
Error in line 47
Near character position 1

Routine dropped

Database closed.

C:\migration>dbaccess callback unl

Database selected.

Routine dropped.

Routine created.

26154: Could not open file: (file, errno)=(\callback_current.unl,13).
Error in line 47
Near character position 1

Routine dropped.

Database closed.

C:\migration>echo unload to schedule select * from agg_schedule   | dbaccess cis
coadmin

Database selected.

10 row(s) unloaded.

Database closed.

C:\migration>

I know this an older post, but I thought I would try to see if there was any traction before I open a new one.

Thanks

Aaron

[awickland]

This all ended up being a folder permissions issue. I was able to figure it out.  Thanks

[david.macias]

Thanks for posting your solution!

david