My Oracle Support Banner

IP17 Upgphys Process Failed On Data Dictionary Error - The Key Index For Encrypted Column Can't Be Empty (Doc ID 2429096.1)

Last updated on NOVEMBER 30, 2021

Applies to:

Siebel CRM - Version 17.0 [IP2017] and later
Information in this document applies to any platform.


Automated Solution Alert: Do not delete or modify this document without first referring to Doc ID 2778233.1.

On :  17.0 [IP2017] version, Upgrade

When attempting to upgrade the DEV database schema from IP2014 to IP2017 (Upgphys) the process exited with below errors:

2018-07-16 12:05:54 Loading the Siebel dictionary...
2018-07-16 12:06:07 Message: GEN-10,
Additional Message: Calling Function: DICGetColumns; Called Function: The key index for encrypted column can't be empty

2018-07-16 12:06:07 Message: GEN-10,
Additional Message: Calling Function: DICLoadDict; Called Function: Calling DICGetColumns

2018-07-16 12:06:07 Unable to load dictionary data.
2018-07-16 12:06:07 Error in DDLDictStartApis function..
2018-07-16 12:06:07 (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 above error is returned when ddldict is executed with the following options:

/siebel/dev/ses/siebsrvr/bin/ddldict /u sadmin /p ***** /c SBA_17_DEV_DSN /d siebel /f /siebel/dev/ses/dbsrvr/oracle/schema.ddl /e y /a y /l /siebel/dev/ses/siebsrvr/log/upgphys_dev_82214/output/sch_dict.log /n "New Customer Repository" /T DCIR



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.