cancel
Showing results for 
Search instead for 
Did you mean: 

Error when migrating from SAP ME 5.1

Former Member
0 Kudos


Hi,

we met an error when execute a script 'DBMigrate51xto52 (WIP migration disabled). Error is:

Setting Trace level:1
Running com.sap.me.dbmigration.migrate51xto52.DBMigrateInventoryReceipt
Migrating the Archive Table AR_INVENTORY
Rolling Back WIP  Connection.
Error executing batch process com.sap.me.dbmigration.migrate51xto52.DBMigrate
(Message 607)
(Message 607)
        at com.sap.me.frame.BatchConnection.executeUpdate(BatchConnection.java:2
48)
        at com.sap.me.frame.BatchProcess.executeUpdate(BatchProcess.java:546)
        at com.sap.me.dbmigration.migrate51xto52.AbstractDBMigrate.executeUpdate
(AbstractDBMigrate.java:110)
        at com.sap.me.dbmigration.migrate51xto52.DBMigrationBase.executeUpdate(D
BMigrationBase.java:289)
        at com.sap.me.dbmigration.migrate51xto52.DBMigrateInventoryReceipt.migra
teTable(DBMigrateInventoryReceipt.java:137)
        at com.sap.me.dbmigration.migrate51xto52.DBMigrationBase.migrate(DBMigra
tionBase.java:113)
        at com.sap.me.dbmigration.migrate51xto52.DBMigrate.migrateAll(DBMigrate.
java:96)
        at com.sap.me.dbmigration.migrate51xto52.DBMigrate.executeProcess(DBMigr
ate.java:60)
        at com.sap.me.frame.BatchProcess.start(BatchProcess.java:176)
        at com.sap.me.frame.BatchProcess.main(BatchProcess.java:793)

Press any key to continue . . .

AR_ -tables are located in WIP -database, not in ODS -database.

How to avoid errors when migrate AR -tables?

Regards,

- Jukka

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Jukka

Is this a non-production database?

You say the AR_ tables are "in the WIP database", but can you confirm they are in a different database user from the WIP user?

Does the DBMigrate script ask for connection details to both WIP and ODS database/users?

Former Member
0 Kudos

Hi Stuart,

we are migrating non-production database.

There is different database user for AR_ -tables.

DBMigrate script will not ask any database or user.

Regards,

- Jukka

Former Member
0 Kudos

Hi,

any updates?

Regards,

- Jukka

Former Member
0 Kudos

Jukka

I recommend you open a support ticket for this, I see no reason why it should not work with both users on the same database.

Former Member
0 Kudos

Hi Stuart,

support ticket (0000108915) opened before discussion started but no response got  -> create discussion to get some response

May you ask someone from your Support to start investigating this issue?

Regards,

- Jukka

0 Kudos

To close this thread, the workaround was to create synonyms.