IRM gives error DDLDICT-ERR-1017: Unable To Copy Data From Siebel Dictionary when database username is not in UPPERCASE

(Doc ID 1630424.1)

Last updated on SEPTEMBER 01, 2016

Applies to:

Siebel CRM - Version 8.1.1.11 [IP2013] and later
Information in this document applies to any platform.
corrected on 9-1-16

Symptoms

During migration to Siebel 8.1.1.11, when running IRM > Upgphys customer was facing following error:


Additional Message: Index 'S_APPLNT_GRP_F1' Column 1 Id '1-JBPQ' in S_INDEX_COLUMN points to a non-existent column in S_COLUMN
Additional Message: Index 'S_LOCATION_F1' Column 1 Id '1-JDL2' in S_INDEX_COLUMN points to a non-existent column in S_COLUMN
Additional Message: Index 'S_LOCATION_F3' Column 1 Id '1-JDL4' in S_INDEX_COLUMN points to a non-existent column in S_COLUMN
Additional Message: Index 'S_LOCATION_F4' Column 1 Id '1-JDL6' in S_INDEX_COLUMN points to a non-existent column in S_COLUMN
Additional Message: Index 'S_LOCATION_F6' Column 1 Id '1-JDL0' in S_INDEX_COLUMN points to a non-existent column in S_COLUMN

Additional Message: Index 'S_ORDER_STOP_F2' Column 1 Id '1-JELJ' in S_INDEX_COLUMN points to a non-existent column in S_COLUMN
Additional Message: Index 'S_ORG_EXT_F68' Column 1 Id '1-JEPX' in S_INDEX_COLUMN points to a non-existent column in S_COLUMN
Additional Message: Index 'S_ST_VST_QUEST_F2' Column 1 Id '1-JGIM' in S_INDEX_COLUMN points to a non-existent column in S_COLUMN


2014-02-10 01:07:15 DDLDICT-ERR-1017: Unable to copy data from Siebel dictionary (This index points to a non-existing column, check the logfile under log directory for more information.).

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