My Oracle Support Banner

Siebel Upgrade Upgphys Fails While Processing DDLDICT With Error: DDLDICT-ERR-1017: Unable To Copy Data From Siebel Dictionary (This Index Points To A Non-existing Column) (Doc ID 2721384.1)

Last updated on MAY 27, 2021

Applies to:

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


Siebel Database Upgrade (IRM) is being executed from to 20.6 in Development environment.

The following error occurs while processing the Upgphys phase DDLDICT command: 

2020-10-09 10:04:46 Message: DIC-29,

Additional Message: Index 'S_TRG_TOPIC_LS_F1' Column 1 Id '1-8EWXPYC' in S_INDEX_COLUMN points to a non-existent column in S_COLUMN


2020-10-09 10:04:53        Reading index              S_TRG_TOPIC_LS_F1 ...
DDLDICT-ERR-1017: Unable to copy data from Siebel dictionary (This index points to a non-existing column.

Steps executed during this upgrade:

1 - Upgrep (first upgrade phase)

2 - Incremental Repository Merge

3 - Conflicts resolution

4 - Fullpublish

5 - Upgphys ( failed step)


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.