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 for Me (Login required).

Search for additional results

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