My Oracle Support Banner

Upgphys Failed At Step Export Schema Definition With "Message: GEN-10, Additional Message: Calling Function: DICLoadDict; Called Function: DICFindColumnInTable row_id" Error (Doc ID 2793581.1)

Last updated on SEPTEMBER 16, 2023

Applies to:

Siebel CRM - Version 21.5 to 21.6 [Release V17]
Information in this document applies to any platform.


When trying to execute upgphys step to export schema definition, the upgphys step fails and the following errors are recorded in the sch_dict.log

2021-07-06 20:24:45 Message: DIC-07,
 Additional Message: pTable->pColumns is NULL
2021-07-06 20:24:45 Message: GEN-10,
 Additional Message: Calling Function: DICLoadDict; Called Function: DICFindColumnInTable row_id
2021-07-06 20:24:46 Unable to load dictionary data.
2021-07-06 20:24:46 Error in DDLDictStartApis function..
2021-07-06 20:24:46 (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)

The issue can be reproduced at will with the following steps:
1. Perform upgrade from previous IP versions to either Siebel 21.5 or 21.6
2. Execute upgrep, IRM, mark conflict resolution as complete and then run FullPublish
3. Execute upgphys and check to see if the upgphys is successful


Siebel Database Upgrade from previous Siebel Innovation Pack versions to 21.5 or 21.6


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.