PostInstallDBSetup Is Failing During Import Schema Step with Error "!!ERROR::Unable to find requested object 'User Key Attribute' 'WS_ID' & SBL-DEV-00116
(Doc ID 2775578.1)
Last updated on NOVEMBER 17, 2021
Applies to:
Siebel CRM - Version 20.8 to 21.4 [Release V17]Information in this document applies to any platform.
Symptoms
While installing Siebel 21.4 update on top of Siebel 20.8, PostInstallDBSetup is failing during import Schema.sif step.
ERROR
-----------------------
import_schema_sif.log
Comparing import objects with repository objects ...
Checking that projects are already locked ...
Applying changes to repository at 13:0:9
!!ERROR::Unable to find requested object 'User Key Attribute' 'WS_ID'
siebdevcli.log
SELECT /*+ ALL_ROWS */
T4.CONFLICT_ID,
T4.LAST_UPD,
T4.CREATED,
T4.LAST_UPD_BY,
T4.CREATED_BY,
T4.MODIFICATION_NUM,
T4.ROW_ID,
T4.UKA_SEQUENCE,
T4.COMMENTS,
T4.IT_COLNAME_BASIS,
T2.MODULE_NAME,
T1.NAME,
T4.INACTIVE_FLG,
T4.NAME,
T1.OBJ_LOCKED_LANG,
T1.OBJ_LOCKED_FLG,
T1.OBJ_LOCKED_BY,
T4.USER_KEY_ID,
T2.NAME,
T1.PROJECT_ID,
T3.LOCKED_FLG,
T3.LOCKED_BY,
T3.NAME,
T3.UIFREEZE_FLG,
T3.UIFREEZE_BY,
T4.REPOSITORY_ID,
T1.MODULE_NAME,
:1
FROM
SIEBEL.S_TABLE T1,
SIEBEL.S_USER_KEY T2,
SIEBEL.S_PROJECT T3,
SIEBEL.S_USER_KEY_ATT T4
WHERE
T2.TBL_ID = T1.ROW_ID AND
T4.USER_KEY_ID = T2.ROW_ID AND
T1.PROJECT_ID = T3.ROW_ID (+) AND
(T4.REPOSITORY_ID = :2) AND
(T4.NAME = :3 AND T4.USER_KEY_ID = :4)
ORDER BY
T4.REPOSITORY_ID, T4.NAME
ObjMgrSqlLog Detail 4 0000000260926e5c:0 2021-05-05 08:21:47 Bind variable 1: ,,,SADMIN,0000000260926e5c:0,,Repository User Key Attribute,
ObjMgrSqlLog Detail 4 0000000260926e5c:0 2021-05-05 08:21:47 Bind variable 2: 1-1CZA5-1
ObjMgrSqlLog Detail 4 0000000260926e5c:0 2021-05-05 08:21:47 Bind variable 3: WS_ID
ObjMgrSqlLog Detail 4 0000000260926e5c:0 2021-05-05 08:21:47 Bind variable 4: 1-1CZA5-5XH3
ObjMgrSqlLog Debug 5 0000000260926e5c:0 2021-05-05 08:21:47 User search spec: "WS_ID"
AND 1-1CZA5-5XH3
SBL-DEV-00116: Unable to find requested object 'User Key Attribute' 'WS_ID'
The archive file might refer to an object that does not exist in this repository, or this repository might have internal inconsistencies that can be analyzed in detail by the Repository Validator.(SBL-DEV-00116)
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Stop current Siebel 20.8 instance
2. Invoke 21.4 installation as update installation
3. During installation wizard, provide all values to run PostInstallDBSetup
3. Binary installation is successful but PostInstallDBSetup is failing during Schema.sif import step with error "SBL-DEV-00116: Impossible de trouver l'objet demandé User Key Attribute avec ID "WS_ID"
Changes
Update from 20.8 to 21.4
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 |