My Oracle Support Banner

Siebel Upgrade with DB2 Z/OS : DDLIMP-ERR-1071: Unable to build ddl statement "table load/unload" (loadStrId is NULL) (Doc ID 1996613.1)

Last updated on JULY 22, 2021

Applies to:

Siebel Financial Services CRM - Version [IP2014] and later
Information in this document applies to any platform.



Running Siebel upgrade to [IP2014]  with  DB2 10 z/os database.

When attempting to run ddlimp (Verify the schema step) during the UPGPHYS of Production Test upgrade phase, it fails as following:


ddlimp /u username /p ***** /c DBAH /a SIEBEL /g SSEROLE /f /appl/sba81/dbsrvr/db2390/schema.ddl /y /appl/sba81/dbsrvr/db2390/storage_postupg.ctl /i n /t y /m y /e y /j y /q /appl/sba81/dbsrvr/db2390/dboutput/upgrade/synctab.sql /l /appl/sba81/siebsrvr/log/upgrep_prod_81111_mf/output/sync_tab.log /5 y

2015-03-18 11:18:08        Merging   table                   S_APP_VER_PATCH ...  
2015-03-18 11:18:08    DDLIMP-ERR-1071: Unable to build ddl statement "table load/unload" (loadStrId is NULL).
writeExecDDL error (UTLDbDdlTblLoadUnload).
Error in MainFunction (UTLDbDdlDbMerge).
Error in Main function...


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.