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.
SAP Knowledge Base Article - Preview