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 DECEMBER 01, 2016

Applies to:

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

Symptoms

 

Running Siebel upgrade to 8.1.1.14 [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...




Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms