DBCHCK verifies that the physical schema is in sync with
repository
D:\sba81\siebsrvr\BIN\dbchck /u sadmin /p sadmin /s
SBA81ENT_DSN /dict /all /r "Siebel Repository" /t SIEBEL /l
D:\Automation\dbchck.log
The output on command prompt will be shown as below
dbchck: Logging into source "SBA81ENTMBA_DSN" as user
"sadmin"...
dbchck: Connected to Oracle (table owner: SIEBEL, schema version:
45.19.0.176).
dbchck: Loading application dictionary (repository: Siebel Repository)
...
dbchck: Identified 3730 tables (0 columns) to check.
dbchck: S_ASSET checking completed: 2 checks failed.
dbchck: S_CONTACT checking completed: 3 checks failed.
dbchck: S_EVT_ACT checking completed: 7 checks failed.
dbchck: S_OPTY checking completed: 2 checks failed.
dbchck: S_ORDER checking completed: 3 checks failed.
dbchck: S_ORG_EXT checking completed: 1 check failed.
dbchck: S_PARTY_REL checking completed: 2 checks failed.
dbchck: Checking completed: 20 checks failed in 7 tables.
Output from Log File
2014-07-21 13:59:05 SQLstyle
is 'Oracle'
2014-07-21 13:59:05 SARM is
OFF -change param SARMLevel to enable
2014-07-21 13:59:05 SARM
Client is OFF -change param SARMClientLevel to enable
2014-07-21 13:59:05 SARM is
OFF -change param SARMLevel to enable
2014-07-21 13:59:05 SARM
Client is OFF -change param SARMClientLevel to enable
2014-07-21 13:59:05 SARM is
OFF -change param SARMLevel to enable
2014-07-21 13:59:05 SARM
Client is OFF -change param SARMClientLevel to enable
2014-07-21 13:59:43 Failure:
Dictionary for S_ASSET different from physical schema
2014-07-21 13:59:43 1 Physical column X_BRCL_NIMBLE_MASTER_ID not
in the dictionary.
2014-07-21 13:59:43 2 Physical column X_BRCL_NIMBLE_PAO_ID not in
the dictionary.
2014-07-21 14:00:28 Failure:
Dictionary for S_CONTACT different from physical schema
2014-07-21 14:00:28 1 Physical column X_BRCL_NIMBLE_FCON_FAX not
in the dictionary.
2014-07-21 14:00:28 2 Physical column X_BRCL_NIMBLE_SCON_EMAIL
not in the dictionary.
2014-07-21 14:00:28 3 Physical column X_BRCL_NIMBLE_SCON_FAX not
in the dictionary.
2014-07-21 14:01:22 Failure:
Dictionary for S_EVT_ACT different from physical schema
2014-07-21 14:01:22 1 Dictionary different from physical schema
for index S_EVT_ACT_F10:
2014-07-21 14:01:22 dictionary:
(TARGET_OU_ID APPT_START_DT ROW_ID)
2014-07-21 14:01:22 physical: (TARGET_OU_ID APPT_START_DT ROW_ID)
2014-07-21 14:01:22 2 Dictionary different from physical schema
for index S_EVT_ACT_M10:
2014-07-21 14:01:22 dictionary:
(TARGET_OU_ID TEMPLATE_FLG APPT_START_DT)
2014-07-21 14:01:22 physical: (TARGET_OU_ID TEMPLATE_FLG APPT_START_DT)
2014-07-21 14:01:22 3 Dictionary different from physical schema
for index S_EVT_ACT_M11:
2014-07-21 14:01:22 dictionary:
(EVT_STAT_CD EVT_PRIORITY_CD APPT_START_DT)
2014-07-21 14:01:22 physical: (EVT_STAT_CD EVT_PRIORITY_CD APPT_START_DT)
2014-07-21 14:01:22 4 Dictionary different from physical schema
for index S_EVT_ACT_M2:
2014-07-21 14:01:22 dictionary:
(CREATED_BY TODO_PLAN_START_DT OWNER_PER_ID)
2014-07-21 14:01:22 physical: (CREATED_BY TODO_PLAN_START_DT OWNER_PER_ID)
2014-07-21 14:01:22 5 Dictionary different from physical schema
for index S_EVT_ACT_M3:
2014-07-21 14:01:22 dictionary:
(TODO_DUE_DT)
2014-07-21 14:01:22 physical: (TODO_DUE_DT)
2014-07-21 14:01:22 6 Dictionary different from physical schema
for index S_EVT_ACT_M6:
2014-07-21 14:01:22 dictionary:
(OWNER_PER_ID APPT_START_DT)
2014-07-21 14:01:22 physical: (OWNER_PER_ID APPT_START_DT)
2014-07-21 14:01:22 7 Dictionary different from physical schema
for index S_EVT_ACT_M8:
2014-07-21 14:01:22 dictionary:
(TODO_PLAN_START_DT)
2014-07-21 14:01:22 physical: (TODO_PLAN_START_DT)
2014-07-21 14:02:39 Failure:
Dictionary for S_OPTY different from physical schema
2014-07-21 14:02:39 1 Dictionary different from physical schema
for index S_OPTY_M1:
2014-07-21 14:02:39 dictionary:
(SUM_EFFECTIVE_DT)
2014-07-21 14:02:39 physical: (SUM_EFFECTIVE_DT)
2014-07-21 14:02:39 2 Dictionary different from physical schema
for index S_OPTY_M55:
2014-07-21 14:02:39 dictionary:
(SECURE_FLG CONSUMER_OPTY_FLG SUM_EFFECTIVE_DT)
2014-07-21 14:02:39 physical: (SECURE_FLG CONSUMER_OPTY_FLG
SUM_EFFECTIVE_DT)
2014-07-21 14:02:50 Failure:
Dictionary for S_ORDER different from physical schema
2014-07-21 14:02:50 1 Dictionary different from physical schema
for index S_ORDER_M3:
2014-07-21 14:02:50 dictionary:
(ORDER_DT)
2014-07-21 14:02:50 physical: (ORDER_DT)
2014-07-21 14:02:50 2 Dictionary different from physical schema
for index S_ORDER_M4:
2014-07-21 14:02:50 dictionary:
(ORDER_CAT_CD ORDER_DT)
2014-07-21 14:02:50 physical: (ORDER_CAT_CD ORDER_DT)
2014-07-21 14:02:50 3 Dictionary different from physical schema
for index S_ORDER_M7:
2014-07-21 14:02:50 dictionary:
(CRDT_STATUS_CD ORDER_DT)
2014-07-21 14:02:50 physical: (CRDT_STATUS_CD ORDER_DT)
2014-07-21 14:02:57 Failure:
Dictionary for S_ORG_EXT different from physical schema
2014-07-21 14:02:57 1 Dictionary different from physical schema
for index S_ORG_EXT_F1:
2014-07-21 14:02:57 dictionary:
(LAST_UPD)
2014-07-21 14:02:57 physical: (LAST_UPD)
2014-07-21 14:03:08 Failure:
Dictionary for S_PARTY_REL different from physical schema
2014-07-21 14:03:08 1 Dictionary different from physical schema
for index S_PARTY_REL_U1:
2014-07-21 14:03:08 dictionary:
(PARTY_ID REL_TYPE_CD REL_PARTY_ID START_DT ONFLICT_ID) unique
2014-07-21 14:03:08 physical: (PARTY_ID REL_TYPE_CD REL_PARTY_ID START_DT
ONFLICT_ID) unique
2014-07-21 14:03:08 2 Dictionary different from physical schema
for index S_PARTY_REL_U2:
2014-07-21 14:03:08 dictionary:
(REL_PARTY_ID REL_TYPE_CD PARTY_ID START_DT ONFLICT_ID) unique
2014-07-21 14:03:08 physical: (REL_PARTY_ID REL_TYPE_CD PARTY_ID START_DT
CONFLICT_ID) unique
No comments:
Post a Comment