ME 6.0 to ME 15 migration script failure.

[former_member202208]

Hi,

We are migrating code from ME 6.0 to 15. We have setup ME 15 on NW 7.4.

We have used WIP & ODS database dump from ME 6.0.

Task 'SAP ME Database and Data Migration for Upgrade' fails with the following message. Due to this some of the activities are still referring to old Class.

Are we missing any steps?

Log:

MigrationManger.migrate(): An error occurred while migrating the data. The error stack trace is: java.sql.SQLException: ORA-12154: TNS:could not resolve the connect identifier specified

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)

at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1046)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)

at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3694)

at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1354)

at com.sap.engine.services.dbpool.wrappers.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:397)

at com.sap.me.ctc.services.dao.SAPMEWIPQuery.executeCommand(SAPMEWIPQuery.java:48)

at com.sap.me.ctc.services.dictionary.DictionaryService.executeWIPQuery(DictionaryService.java:65)

at com.sap.me.ctc.services.dictionary.DictionaryService.executeUpgradeScriptsBundleForOracle(DictionaryService.java:712)

at com.sap.me.ctc.services.dictionary.DictionaryService.executeViewsOrSynonymsUpgrade(DictionaryService.java:879)

at com.sap.me.ctc.services.dictionary.DictionaryService.executeUpgradeMEDatabaseSchema(DictionaryService.java:158)

at com.sap.me.ctc.services.dictionary.migration.command.MigrationCommand60_61.migrateSchema(MigrationCommand60_61.java:13)

at com.sap.me.ctc.services.dictionary.migration.framework.BaseMigrationCommand.execute(BaseMigrationCommand.java:15)

at com.sap.me.ctc.services.dictionary.migration.framework.MigrationManager.migrate(MigrationManager.java:186)

at com.sap.me.ctc.services.dictionary.MigrationService.migrate(MigrationService.java:22)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at com.sap.tc.lm.ctc.provider.javaServiceProvider.JavaMethodExecuter.invoke(JavaMethodExecuter.java:259)

at com.sap.tc.lm.ctc.provider.javaServiceProvider.JavaServiceExecuter.executeService(JavaServiceExecuter.java:86)

at com.sap.tc.lm.ctc.cul.broker.BrokerServiceExecuter.executeService(BrokerServiceExecuter.java:59)

at com.sap.tc.lm.ctc.cul.serviceimpl.executor.CULServiceExecutor.executeService(CULServiceExecutor.java:36)

at com.sap.tc.lm.ctc.cul.serviceimpl.process.InvokeServiceControllerDefault.execute(InvokeServiceControllerDefault.java:133)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.remoteOrLocalExecution(ProcessControllerImpl.java:741)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.execute(ProcessControllerImpl.java:286)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.remoteOrLocalExecution(ProcessControllerImpl.java:741)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.execute(ProcessControllerImpl.java:286)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.remoteOrLocalExecution(ProcessControllerImpl.java:741)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.execute(ProcessControllerImpl.java:286)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessExecuter.run(ProcessExecuter.java:156)

at java.lang.Thread.run(Thread.java:743)

Thanks in advance.

Regards,

[sergiy_katerinich]

Hi!

The root cause is at Oralce layer. In particular, see SAP Notes  2005211 and 1654099.

Regards,

Sergiy

[sergiy_katerinich]

Make sure you are using the latest patches of all SAP ME 15.0 components.

[former_member202208]

Hi Sergiy,

Thanks for your response.

Thanks,

Shridhar..

[former_member202208]

Hi Sergiy,

TNS issue is resolved. Thanks for that.

Now on executing Upgrade script, I an getting issue on SAPMEWIP.CREATE_SYNONYM_PROC.. Can you help us on this.

An error occurred while migrating the data. The error message is: java.sql.SQLException: ORA-20002: An error was encountered - -955 -ERROR- ORA-00955: name is already used by an existing object

ORA-06512: at "SAPMEWIP.CREATE_SYNONYM_PROC", line 27

ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)

at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)

at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)

at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)

at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)

at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:205)

at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1043)

at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)

at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)

at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3694)

at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4780)

at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1354)

at com.sap.engine.services.dbpool.wrappers.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:397)

at com.sap.me.ctc.services.dao.SAPMEWIPQuery.executeCallableCommand(SAPMEWIPQuery.java:114)

at com.sap.me.ctc.services.dao.SAPMEWIPQuery.executeCommand(SAPMEWIPQuery.java:42)

at com.sap.me.ctc.services.dictionary.DictionaryService.executeWIPQuery(DictionaryService.java:65)

at com.sap.me.ctc.services.dictionary.DictionaryService.executeUpgradeScriptsBundleForOracle(DictionaryService.java:712)

at com.sap.me.ctc.services.dictionary.DictionaryService.executeViewsOrSynonymsUpgrade(DictionaryService.java:879)

at com.sap.me.ctc.services.dictionary.DictionaryService.executeUpgradeMEDatabaseSchema(DictionaryService.java:158)

at com.sap.me.ctc.services.dictionary.migration.command.MigrationCommand60_61.migrateSchema(MigrationCommand60_61.java:13)

at com.sap.me.ctc.services.dictionary.migration.framework.BaseMigrationCommand.execute(BaseMigrationCommand.java:15)

at com.sap.me.ctc.services.dictionary.migration.framework.MigrationManager.migrate(MigrationManager.java:186)

at com.sap.me.ctc.services.dictionary.MigrationService.migrate(MigrationService.java:22)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

at java.lang.reflect.Method.invoke(Method.java:597)

at com.sap.tc.lm.ctc.provider.javaServiceProvider.JavaMethodExecuter.invoke(JavaMethodExecuter.java:259)

at com.sap.tc.lm.ctc.provider.javaServiceProvider.JavaServiceExecuter.executeService(JavaServiceExecuter.java:86)

at com.sap.tc.lm.ctc.cul.broker.BrokerServiceExecuter.executeService(BrokerServiceExecuter.java:59)

at com.sap.tc.lm.ctc.cul.serviceimpl.executor.CULServiceExecutor.executeService(CULServiceExecutor.java:36)

at com.sap.tc.lm.ctc.cul.serviceimpl.process.InvokeServiceControllerDefault.execute(InvokeServiceControllerDefault.java:133)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.remoteOrLocalExecution(ProcessControllerImpl.java:741)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.execute(ProcessControllerImpl.java:286)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.remoteOrLocalExecution(ProcessControllerImpl.java:741)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.execute(ProcessControllerImpl.java:286)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.remoteOrLocalExecution(ProcessControllerImpl.java:741)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.execute(ProcessControllerImpl.java:286)

at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessExecuter.run(ProcessExecuter.java:156)

at java.lang.Thread.run(Thread.java:743)

An error occurred while migrating the data. The error message is: java.sql.SQLException: ORA-20002: An error was encountered - -955 -ERROR- ORA-00955: name is already used by an existing object ORA-06512: at "SAPMEWIP.CREATE_SYNONYM_PROC", line 27 ORA-06512: at line 1 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:205) at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1043) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3694) at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4780) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1354) at com.sap.engine.services.dbpool.wrappers.PreparedStatementWrapper.executeUpdate(PreparedStatementWrapper.java:397) at com.sap.me.ctc.services.dao.SAPMEWIPQuery.executeCallableCommand(SAPMEWIPQuery.java:114) at com.sap.me.ctc.services.dao.SAPMEWIPQuery.executeCommand(SAPMEWIPQuery.java:42) at com.sap.me.ctc.services.dictionary.DictionaryService.executeWIPQuery(DictionaryService.java:65) at com.sap.me.ctc.services.dictionary.DictionaryService.executeUpgradeScriptsBundleForOracle(DictionaryService.java:712) at com.sap.me.ctc.services.dictionary.DictionaryService.executeViewsOrSynonymsUpgrade(DictionaryService.java:879) at com.sap.me.ctc.services.dictionary.DictionaryService.executeUpgradeMEDatabaseSchema(DictionaryService.java:158) at com.sap.me.ctc.services.dictionary.migration.command.MigrationCommand60_61.migrateSchema(MigrationCommand60_61.java:13) at com.sap.me.ctc.services.dictionary.migration.framework.BaseMigrationCommand.execute(BaseMigrationCommand.java:15) at com.sap.me.ctc.services.dictionary.migration.framework.MigrationManager.migrate(MigrationManager.java:186) at com.sap.me.ctc.services.dictionary.MigrationService.migrate(MigrationService.java:22) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at com.sap.tc.lm.ctc.provider.javaServiceProvider.JavaMethodExecuter.invoke(JavaMethodExecuter.java:259) at com.sap.tc.lm.ctc.provider.javaServiceProvider.JavaServiceExecuter.executeService(JavaServiceExecuter.java:86) at com.sap.tc.lm.ctc.cul.broker.BrokerServiceExecuter.executeService(BrokerServiceExecuter.java:59) at com.sap.tc.lm.ctc.cul.serviceimpl.executor.CULServiceExecutor.executeService(CULServiceExecutor.java:36) at com.sap.tc.lm.ctc.cul.serviceimpl.process.InvokeServiceControllerDefault.execute(InvokeServiceControllerDefault.java:133) at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.remoteOrLocalExecution(ProcessControllerImpl.java:741) at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.execute(ProcessControllerImpl.java:286) at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.remoteOrLocalExecution(ProcessControllerImpl.java:741) at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.execute(ProcessControllerImpl.java:286) at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.remoteOrLocalExecution(ProcessControllerImpl.java:741) at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessControllerImpl.execute(ProcessControllerImpl.java:286) at com.sap.tc.lm.ctc.metamodel.process.controller.ProcessExecuter.run(ProcessExecuter.java:156) at java.lang.Thread.run(Thread.java:743)

Thanks,

Shridhar..

[sergiy_katerinich]

Hi!

Which "upgrade script" are you talking about?

Sounds strange. If you did everything correctly, then it means there is a bug in Upgrade process, though you are the first one facing it.

Provided the error message, a procedure with such name does already exist. So, as a workaround, you might try to manually delete CREATE_SYNONYM_PROC procedure in SAPMEWIP database and then re-run the script. Though, this is a risky step away from the process.

Regards,

Sergiy

[former_member202208]

Hi,

I have already tried by deleting the procedure and in that can i see the below message ;

MigrationManger.migrate(): An error occurred while migrating the data. The error message is: ORA-06550: line 1, column 7:

PLS-00201: identifier 'CREATE_SYNONYM_PROC' must be declared

ORA-06550: line 1, column 7:

PL/SQL: Statement ignored

Thanks,

Shridhar

[sergiy_katerinich]

What is the script?

[former_member202208]

Sorry, I am executing 'SAP ME Database and Data Migration for Upgrade' script.

[sergiy_katerinich]

Make sure that you are using the latest patch of SAPMECORE and SAPMECTC because a month or two ago there were some changes to CTC.

If the issue still persists, then submit a support ticket and provide a database dump.

Regards,

Sergiy

[former_member202208]

Hi Sergiy,

I have updated ME components to latest patch, but its still failing.

I have submitted a support ticket.

Thanks,

Shridhar..

[former_member202208]

Hi Sergiy,

I have submitted a support ticket.

( 890237 / 2015 )  Can you please check and suggest a fix for this.

Thanks,

Shridhar..

[sergiy_katerinich]

My colleagues from Product Support will take care of it.