Dbchck messages " Failure: Dictionary for S_ASGN_LB_DATA different from physical schema" (Doc ID 1995770.1)

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

On : 8.1.1.14.4 [IP2014] version, Upgrade

When attempting to run dbchck after upgrading to version 8.1.1.14 errors occurs,
the following error occurs.

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

2015-03-25 13:45:42 SARM is OFF -change param SARMLevel to enable
2015-03-25 13:45:42 SARM Client is OFF -change param SARMClientLevel to enable
2015-03-25 13:45:42 SARM is OFF -change param SARMLevel to enable
2015-03-25 13:45:42 SARM Client is OFF -change param SARMClientLevel to enable
2015-03-25 13:45:42 SARM is OFF -change param SARMLevel to enable
2015-03-25 13:45:42 SARM Client is OFF -change param SARMClientLevel to enable
2015-03-25 13:47:11 Failure: Dictionary for S_ASGN_LB_DATA different from physical schema
2015-03-25 13:47:11 1 Dictionary different from physical schema for column SERIAL_NUM:
2015-03-25 13:47:11 dictionary: SERIAL_NUM numeric(10,0) not null
2015-03-25 13:47:11 physical: SERIAL_NUM decimal(10,0) not null
2015-03-25 13:47:13 Failure: Dictionary for S_AUDIT_ITEM different from physical schema
2015-03-25 13:47:13 1 Dictionary different from physical schema for column ITEM_IDEN_NUM:
2015-03-25 13:47:13 dictionary: ITEM_IDEN_NUM numeric(15,0) not null default 0
2015-03-25 13:47:13 physical: ITEM_IDEN_NUM decimal(15,0) not null default 0
2015-03-25 13:47:29 Failure: Dictionary for S_DOCK_TXN_LOG different from physical schema
2015-03-25 13:47:29 1 Dictionary different from physical schema for column TXN_ID:
2015-03-25 13:47:29 dictionary: TXN_ID numeric(15,0) not null
2015-03-25 13:47:29 physical: TXN_ID decimal(15,0) not null
2015-03-25 13:47:32 Failure: Dictionary for S_ESCL_ACTN_REQ different from physical schema
2015-03-25 13:47:32 1 Dictionary different from physical schema for column REQ_ID:
2015-03-25 13:47:32 dictionary: REQ_ID numeric(15,0) not null
2015-03-25 13:47:32 physical: REQ_ID decimal(15,0) not null
2015-03-25 13:47:32 Failure: Dictionary for S_ESCL_REQ different from physical schema
2015-03-25 13:47:32 1 Dictionary different from physical schema for column REQ_ID:
2015-03-25 13:47:32 dictionary: REQ_ID numeric(15,0) not null
2015-03-25 13:47:32 physical: REQ_ID decimal(15,0) not null
2015-03-25 13:48:10 Failure: Dictionary for S_RTS_STATE different from physical schema
2015-03-25 13:48:10 1 Dictionary different from physical schema for column SEQ_ID:
2015-03-25 13:48:10 dictionary: SEQ_ID numeric(10,0) not null
2015-03-25 13:48:10 physical: SEQ_ID decimal(10,0) not null
2015-03-25 13:48:10 Failure: Dictionary for S_RTS_WQ different from physical schema
2015-03-25 13:48:10 1 Dictionary different from physical schema for column SEQ_NUM:
2015-03-25 13:48:10 dictionary: SEQ_NUM numeric(10,0) not null
2015-03-25 13:48:10 physical: SEQ_NUM decimal(10,0) not null
2015-03-25 13:48:12 Failure: Dictionary for S_SD_SYNC_INFO different from physical schema
2015-03-25 13:48:12 1 Dictionary different from physical schema for column SEQ_ID:
2015-03-25 13:48:12 dictionary: SEQ_ID numeric(15,0) not null
2015-03-25 13:48:12 physical: SEQ_ID decimal(15,0) not null


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. install or upgrade to 8.1.1.14
2. run command
dbchck /s <odbc> /u sadmin /p ***** /t <table owner>  /l <log file>  /r "Siebel Repository" /d /a



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