Symptom
An error occurred while migrating the data. The error message is: java.lang.RuntimeException: java.lang.RuntimeException: Error on executing SQL statement UPDATE BUYOFF_LOG SET STEP_ID = '10' WHERE BUYOFF_BO = 'BuyoffBO:1770,TEST,A' AND ROUTER_BO = 'RouterBO:1770,ROUTING,U,A' AND OPERATION_BO = 'OperationBO:1770,OP,#' AND STEP_ID IS NULL; exception is java.sql.SQLSyntaxErrorException: ORA-00904: "STEP_ID": invalid identifier (Message 607) at com.sap.me.ctc.services.dictionary.DictionaryService.migrate(DictionaryService.java:1105) at com.sap.me.ctc.services.dictionary.migration.framework.BaseMigrationCommand.migrateData(BaseMigrationCommand.java:34) at com.sap.me.ctc.services.dictionary.migration.framework.BaseMigrationCommand.execute(BaseMigrationCommand.java:16) at com.sap.me.ctc.services.dictionary.migration.framework.MigrationManager.migrate(MigrationManager.java:216) 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:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498)
sap.com/me~safeguards#C000AC1446EB001B0000001700007317##sap.com/me~safeguards#com.sap.me.safeguards.actions.NetWeaverCategoryLogAc tion#Guest#0##56E3E2D5B2C111E884E9000000FB866E#56e3e2d5b2c111e884e9000000fb866e##0#Thread[Session Invalidator Thread-14,5,main]#Plain## {SafeguardStatus id=[{StatusId safeguardName=[Check ME SqlServer Configuration] runTime=[2018-09-07 12:34:28.06]}] status=[MALFUNCTION] explanation=[failed to call stored procedure [me_system_check]: ORA-06550: line 1, column 7: PLS-00221: 'ME_SYSTEM_CHECK' is not a procedure or is undefined ORA-06550: line 1, column 7: PL/SQL: Statement ignored ]}# #2.#2018 09 07 12:34:38:250#0-500#Error#/Applications/CTC# #BC-INS-CTC#tc~lm~ctc~cul~core_sda#C000AC1446EB03220000000800007317#16483950000000004#sap.com/tc~lm~itsam~ui~mainframe~wd#com.sap.tc
Read more...
Environment
SAP Manufacturing Execution
Product
Keywords
SAP ME Database and Data Migration for Upgrade, ORA-00904: "STEP_ID" , Upgrading SP level , KBA , MFG-ME-IM , Installation and Migration , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview