2205696 - Field MSGID: type BINARY does not have a devault value | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

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

Symptom

The import phase of a system copy, using Software Provisioning Manager (SWPM)  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 ONE Support launchpad (Login required).

Search for additional results

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