SAP Knowledge Base Article - Preview

2744350 - Exception is java.sql.SQLSyntaxErrorException: ORA-00904: "STEP_ID": invalid identifier (Message 607)

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

SAP Manufacturing Execution 15.0 ; SAP Manufacturing Execution 15.1 ; SAP Manufacturing Execution 15.2 ; SAP Manufacturing Execution 15.3 ; SAP NetWeaver 7.5

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.