My Oracle Support Banner

Dbcheck error "Physical column WS_SRC_ID not in the dictionary" reported in ProdTest Upgraded (RR) Environment (Doc ID 2770862.1)

Last updated on APRIL 22, 2021

Applies to:

Siebel CRM - Version 20.10 and later
Information in this document applies to any platform.

Symptoms

While running full migration from Dev to prodtest upgraded (RR) environment, dbcheck step reported with below errors, but these columns not present Siebel Repository in DR or RR environments. 

dbchck.log


2021-03-18 17:53:06 Failure: Dictionary for S_EVT_ACT different from physical schema
2021-03-18 17:53:06 1    Physical column X_ORACLE_SR_TEST not in the dictionary.
2021-03-18 17:53:06 STATUS: S_EVT_ACT checking completed: 1 check failed.
2021-03-18 17:54:52 Failure: Dictionary for S_TU_BRANCH different from physical schema
2021-03-18 17:54:52 1    Physical column WS_SRC_ID not in the dictionary.
2021-03-18 17:54:52 STATUS: S_TU_BRANCH checking completed: 1 check failed.
2021-03-18 17:54:52 Failure: Dictionary for S_TU_BRNCH_COND different from physical schema
2021-03-18 17:54:52 1    Physical column WS_SRC_ID not in the dictionary.
2021-03-18 17:54:52 STATUS: S_TU_BRNCH_COND checking completed: 1 check failed.
2021-03-18 17:54:52 Failure: Dictionary for S_TU_BR_CON_VAL different from physical schema
2021-03-18 17:54:52 1    Physical column WS_SRC_ID not in the dictionary.



STEPS
-----------------------

The issue can be reproduced at will with the following steps:


1. Siebel 20.10 as Dev upgrade

2. Run prod test upgrade in RR environment by taking custrep.dat & schema.ddl from Dev environment

3. After upgrade in RR environment, run full migration from Dev to Test

4. During full migration, dbcheck reported with errors "Physical column WS_SRC_ID not in the dictionary"

 

 

Changes

 prod test upgrade to 20.x from 15.x

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.