SAP Knowledge Base Article - Preview

2205696 - SWPM Error: Field MSGID: type BINARY does not have a devault value

Symptom

The import phase of a system copy, using Software Provisioning Manager (SWPM Tool SAP Note 1680045) fails with error:

"Execution of tool '<path>/sapinstlog/sapjvm/sapjvm_5/bin/java -classpath <path>/sapinstlog/sltools/sharedlib/sap.com~tc~bl~offline_launcher~impl.jar
 -showversion -Xmx1540m -XX:+HeapDumpOnOutOfMemoryError com.sap.engine.offline.OfflineToolStart
com.sap.inst.jload.Jload /usr/sap/SID/SYS/global/security/lib/tools/iaik_jce.jar:/usr/sap/SID/SYS/global/
security/lib/tools/iaik_jsse.jar:/usr/sap/SID/SYS/global/security/lib/tools/iaik_smime.jar:/usr/sap/SID/SYS
/global/security/lib/tools/iaik_ssl.jar:/usr/sap/SID/SYS/global/security/lib/tools/w3c_http.jar:<path>/sapinstlog/sltools/sharedlib:
/oracle/client/11x_64/instantclient/ojdbc14.jar -sec SID,jdbc/pool/DXI,/usr/sap/SID/SYS/global/security/data/SecStore.properties,
/usr/sap/DXI/SYS/global/security/data/SecStore.key -dataDir <path>/JAVA/JDMP -job <path>/sapinstlog/IMPORT.XML -log jload.log' aborts with return code 1"

Checking mentioned 'jload.log', the following message is found:

"13.08.15 13:15:12 com.sap.inst.jload.Jload logStackTrace
 SEVERE: com.sap.dictionary.database.dbs.JddException: CREATE TABLE BC_JMSQUEUE failed

 E R R O R ******* (DbColumn)
 13:15:12 2015-08-13 dbs-Error:  Field MSGID: type BINARY does not have a devault value"


Read more...

Environment

  • SAP NetWeaver PI/Mobile/Banking 7.1
  • SAP EHP1 for SAP NetWeaver PI/Mobile/Banking 7.1
  • All RDBMS
  • All Operating systems

Product

SAP NetWeaver Process Integration 7.1 ; SAP enhancement package 1 for SAP NetWeaver Process Integration 7.1

Keywords

MSGID, BC_JMSQUEUE, import, system copy, migration, jload, jddi.jar, return code 1 , KBA , BC-INS-MIG , OS/DB Migrations with SWPM and DB refresh , 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.