2108908 - Error while performing JLoad import step | SAP Knowledge Base Article

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

Search for additional results

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