SAP Knowledge Base Article - Preview

2108908 - Error while performing JLoad import step

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

SAP NetWeaver 7.4

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.