Upgphys On IP2016 Fails at Ddldict Utility. (Doc ID 2263631.1)

Last updated on MAY 15, 2023

Applies to:

Symptoms

On : 16.0 [IP2016] version, Upgrade

Customer's IP16 upgphys fails at ddldict step during exporting of logical definition to schema.dll

ACTUAL BEHAVIOR
---------------
Siebel IP2016 upgphys fails at ddldict step trying to export logical definition to schema.ddl. Here is corresponding log files.

upgwiz.log
------------------
2021 2017-04-28 10:47:40 2017-04-28 10:48:09 -0700 0000037b 001 003f 0001 09 upgwiz 160 904 C:\Siebel\16.0.0.0.0\ses\siebsrvr\log\upgphys_dev_155\output\\upgwiz.log 16.0.0.0 [23057] ENU
...
Trace TracingInfo 3 00000002590300a0:0 2017-04-28 10:47:40 CFG Entry (Siebel Sub Version=v15_5SIA)
...
Trace TracingInfo 3 00000002590300a0:0 2017-04-28 10:47:43 CFG Entry (Status=Error)
UpgradeLog UpgradeInfo 3 00000002590300a0:0 2017-04-28 10:47:43 Action begin (Export schema definition)
UpgradeLog UpgradeInfo 3 00000002590300a0:0 2017-04-28 10:47:43 Item=8
UpgradeLog UpgradeInfo 3 00000002590300a0:0 2017-04-28 10:47:43 Status Message (Executing...)
UpgradeLog UpgradeInfo 3 00000002590300a0:0 2017-04-28 10:47:43 Executing (C:\Siebel\16.0.0.0.0\ses\siebsrvr\bin\ddldict.exe /u sadmin /p ******** /c "sba_16_dsn" /d siebel /f C:\Siebel\16.0.0.0.0\ses\dbsrvr\oracle\schema.ddl /e y /a y /l C:\Siebel\16.0.0.0.0\ses\siebsrvr\log\upgphys_dev_155\output\sch_dict.log /n "New Customer Repository" /T DCIR)
UpgradeLog UpgradeError 1 00000002590300a0:0 2017-04-28 10:47:57 (err=1) was returned by application (C:\Siebel\16.0.0.0.0\ses\siebsrvr\bin\ddldict.exe /u sadmin /p ******** /c "sba_16_dsn" /d siebel /f C:\Siebel\16.0.0.0.0\ses\dbsrvr/oracle/schema.ddl /e y /a y /l C:\Siebel\16.0.0.0.0\ses\siebsrvr\log\upgphys_dev_155\output/sch_dict.log /n "New Customer Repository" /T DCIR).
UpgradeLog UpgradeError 1 00000002590300a0:0 2017-04-28 10:47:57 There was an error in launching the application.
UpgradeLog UpgradeError 1 00000002590300a0:0 2017-04-28 10:47:57 Execute file action failed.
UpgradeLog UpgradeError 1 00000002590300a0:0 2017-04-28 10:47:57 Error executing action (Export schema definition).
UpgradeLog UpgradeInfo 3 00000002590300a0:0 2017-04-28 10:47:57 Status Message (Errors encountered)

sch_dict.log
------------------
2021 2017-04-28 10:47:40 2017-04-28 10:48:09 -0700 0000037b 001 003f 0001 09 upgwiz 160 904 C:\Siebel\16.0.0.0.0\ses\siebsrvr\log\upgphys_dev_155\output\\upgwiz.log 16.0.0.0 [23057] ENU
UpgradeLog UpgradeInfo 3 00000002590300a0:0 2017-04-28 10:47:40 Start execute ReadConfigFile
...
UpgradeLog UpgradeInfo 3 00000002590300a0:0 2017-04-28 10:47:43 Executing (C:\Siebel\16.0.0.0.0\ses\siebsrvr\bin\ddldict.exe /u sadmin /p ******** /c "SIEBEL_DSN" /d siebel /f C:\Siebel\16.0.0.0.0\ses\dbsrvr\oracle\schema.ddl /e y /a y /l C:\Siebel\16.0.0.0.0\ses\siebsrvr\log\upgphys_dev_155\output\sch_dict.log /n "New Customer Repository" /T DCIR)
...
2017-04-28 10:47:57 Message: DIC-06,
Additional Message: S_OPTY_SIGN

2017-04-28 10:47:57 Message: DIC-06,
Additional Message: S_PTL_STCONHIST

2017-04-28 10:47:57 Message: DIC-06,
Additional Message: S_USER_EVT_DTL

2017-04-28 10:47:57 Message: DIC-06,
Additional Message: T_EXEC_CFG_USER

2017-04-28 10:47:57 Message: DIC-07,
Additional Message: pTable->pColumns is NULL

2017-04-28 10:47:57 Message: GEN-10,
Additional Message: Calling Function: DICLoadDict; Called Function: DICFindColumnInTable row_id

2017-04-28 10:47:57 Unable to load dictionary data.
2017-04-28 10:47:57 Error in DDLDictStartApis function..
2017-04-28 10:47:57 (logapi.cpp (184) err=1 sys=2) SBL-GEN-00001: (logapi.cpp: 184) error code = 1, system error = 2, msg1 = (null), msg2 = (null), msg3 = (null), msg4 = (null)

EXPECTED BEHAVIOR
-----------------------
Upgphys should run without error.

STEPS TO REPRODUCE
-----------------------
1) Before IP2016 installation, Siebel software version was IP2015.6 (equal or higher than IP2015.5).
2) After IP2016 was installed, run "config.bat -mode dbsrvr".
3) Select "Upgrade Database" at Siebel Database Operation.
4) Select "Development" at Environment Type.
5) Select "Upgrade Siebel Database Schema (upgrep)" at Upgrade Options for Incremental Repository Merge (IRM).
6) Select "Siebel Industry Application" at Siebel Industry Application.
7) Select "v15_5SIA" at Current Siebel Version.
8) Select appropriate options for the rest of the steps and start upgrep.
9) Assuming upgrep has been done successfully, run "config.bat -mode dbsrvr" for upgphys.
10) Select "Upgrade Database" at Siebel Database Operation.
11) Select "Development" at Environment Type.
12) Select "Upgrade Custom Database Schema (upgphys)" at Upgrade Options.
13) Select "Siebel Industry Application" at Siebel Industry Application.
14) Select "v15_5SIA" at Current Siebel Version.
15) Select appropriate options for the rest of the steps and start upgphys.

Cause

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