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

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.

Hi David,

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

". Logged in as cvp_admin local admin account"

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

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

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.

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

Issue Resolved:

 

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

 

Thank you for your help.

 

Thanks,

Fahad

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

 

Glad I could help.

awickland
Beginner
Beginner

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

 

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

Thanks for posting your solution!

 

david

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: