Verify Repository After Upgrade Fails with DIC-03, Check DObj Rule (Doc ID 2226270.1)

Last updated on JANUARY 24, 2017

Applies to:

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

Symptoms


When attempting to run Upgphys , it fails during the step Verify Repository After Upgrade
the following error occurs on the log file postupg_dbchck.log

ERROR
-----------------------

2017-01-18 05:55:13 Message: DIC-03,
Additional Message: Check DObj Rule: Source Join Column is NULL.


2017-01-18 05:55:13 Message: GEN-10,
Additional Message: Calling Function: DICLoadDObjectInfo; Called Function: Calling DICGetDOVRules


2017-01-18 05:55:13 Message: GEN-10,
Additional Message: Calling Function: DICLoadDict; Called Function: DICLoadDObjectInfo


2017-01-18 05:55:14 ERROR: Failure in DICLoadDict. Unable to load dictionary!

2017-01-18 05:55:14 ERROR: Unable to login with:
ODBC Source: "ENTSIEBIP16_DSN",
User: "SADMIN",
Table owner: "SIEBEL"
Repository: "Siebel Repository".

2017-01-18 05:55:14 (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)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. complete upgprep, merge
2. run upgphys , choosing to "Verify Repository After Upgrade fails"
3. stop on the step "Verify Repository After Upgrade fails"

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