Symptom
During upgrade to NW 7.4 AS JAVA, SUM stops with below error:
An error has occurred during the execution of the Import Jload step.
Errors while performing JLoad import. See JLOADJLoadService.LOG and JLOAD_PHASEJLoadService for details. Return code condition success evaluated false for process java.exe for action import.
in JLOADJLoadService.LOG, you can see below error:
=============================================================================
21:37:57 2014-12-11 dbs-Info: <<< Modify BC_NZDM_CHANGE_LOG_VIEW >>>
E R R O R ******* (DbSqlStatement dev 30.07.2013 13:00:00)
21:37:57 2014-12-11 dbs-Error: Exception caught during SQL execution Invalid column name 'SID'.
OpenSQLExceptionCategories: [NON_TRANSIENT, COLUMN_UNKNOWN]
SQL STATEMENT:
CREATE VIEW "BC_NZDM_CHANGE_LOG_VIEW" ("TID", "COUNTER", "SID", "CHANGE_TYPE", "APPLICATION", "DATA_FORMAT", "CHANGE_DATA", "CL_TABLE_NAME")AS SELECT "tid"."TID2" "TID", "cl"."COUNTER", "cl"."SID", "cl"."CHANGE_TYPE", "cl"."APPLICATION", "cl"."DATA_FORMAT", "cl"."CHANGE_DATA", "cl"."CL_TABLE_NAME"FROM "BC_NZDM_CHANGE_LOG" "cl" INNER JOIN "BC_NZDM_FINAL_TID" "tid"ON "cl"."TID" = "tid"."TID";
E R R O R ******* (DbSqlStatement dev 30.07.2013 13:00:00)
21:37:57 2014-12-11 dbs-Error: Caused by: Invalid column name SID.
OpenSQLExceptionCategories: [NON_TRANSIENT, COLUMN_UNKNOWN] Stack trace: com.sap.sql.exception.OpenSQLException: Invalid column name SID.
......
E R R O R ******* (DbModifier dev 30.07.2013 13:00:00)
21:37:57 2014-12-11 dbs-Error: Table BC_NZDM_CHANGE_LOG_VIEW could not be modified in database
21:37:57 2014-12-11 dbs-Info: Buffer synchronization for table BC_NZDM_CHANGE_LOG_VIEW successfully executed
21:37:57 2014-12-11 dbs-Info: <<< End of phase: Execution of statements
21:37:57 2014-12-11 dbs-Info: Analysis and adjustment of tables finished with errors
at com.sap.dictionary.database.opentools.DbTableOpenTools.createView(DbTableOpenTools.java:145)
at com.sap.inst.jload.db.DBView.createObject(DBView.java:36)
at com.sap.inst.jload.db.AbstractDBObject.create(AbstractDBObject.java:109)
at com.sap.inst.jload.executor.JobExecutor.dbImport(JobExecutor.java:363)
at com.sap.inst.jload.executor.JobExecutor.executeJob(JobExecutor.java:821)
at com.sap.inst.jload.Jload.main(Jload.java:312)
Dec 11, 2014 9:37:57 PM com.sap.inst.dbtools [Thread[main,5,main]] Fatal: An error occured during execution. Please consult SAP note 942766 for first steps on troubleshooting the problem.
=============================================================================
Read more...
Product
Keywords
JLOADJLoadService, JLOAD_PHASEJLoadService, BC_NZDM_CHANGE_LOG_VIEW, Invalid column, dbs-Error: Exception caught during SQL execution Invalid column name 'SID', Modify BC_NZDM_CHANGE_LOG_VIEW, OpenSQLExceptionCategories: [NON_TRANSIENT, COLUMN_UNKNOWN], com.sap.sql.exception.OpenSQLException: Invalid column name SID. , KBA , BC-UPG-TLS-TLJ , Upgrade tools for Java , BC-UPG-OCS-SPJ , Please use component BC-UPG-TLS-TLJ , 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.