PostInstallDBSetup Fails On Step 2 SeedSchemaManifest Processing - Unable to create the Business Service '<?>'(SBL-DAT-00227)
(Doc ID 2833309.1)
Last updated on NOVEMBER 08, 2022
Applies to:
Siebel CRM - Version 21.9 to 22.10 [Release V17]Information in this document applies to any platform.
Symptoms
When attempting to run PostInstallDBSetup 21.9 on top of the 20.4 installation it fails on the step 2 that performs SeedDataManifest processing.
In the dummy.txt file located under the following directory:
siebsrvr/log/PostInstallDBSetup_YYYY-MM-DD_HH-MM-DD/SeedSchemaManifest_YYYY-MM-DD_HH-MM-SS/20.3
the following error is found:
In the import_schema_sif.log found under the same directory the following trace is found:
...
ObjMgrLog Detail 4 00000002617131a4:0 2021-10-21 13:32:47 Reading .cfg file from D:\siebel_app\siebsrvr/log/PostInstallDBSetup_YYYY-MM-DD_HH-MM-DD/SeedSchemaManifest_YYYY-MM-DD_HH-MM-DD/RepositoryUpgrade.cfg.
...
ObjMgrSqlLog Detail 4 00000002617131a4:0 2021-10-21 13:33:25 SELECT statement with ID: 36089CF0
SELECT
T1.CONFLICT_ID,
T1.LAST_UPD,
T1.CREATED,
T1.LAST_UPD_BY,
T1.CREATED_BY,
T1.MODIFICATION_NUM,
T1.ROW_ID,
T1.CACHE_FLG,
T1.CLASS_NAME,
T1.NAME,
T1.STATE_MGMT_TYPE_CD,
:1
FROM
SIEBEL.S_RT_SVC T1
WHERE
(T1.INACTIVE_FLG = :2 AND T1.NAME = :3)
ORDER BY
T1.NAME
ObjMgrSqlLog Detail 4 00000002617131a4:0 2021-10-21 13:33:25 Bind variable 1: ,,,SADMIN,00000002617131a4:0,,Business Service,
ObjMgrSqlLog Detail 4 00000002617131a4:0 2021-10-21 13:33:25 Bind variable 2: N
ObjMgrSqlLog Detail 4 00000002617131a4:0 2021-10-21 13:33:25 Bind variable 3: EGSC Program Service
ObjMgrSqlLog Debug 5 00000002617131a4:0 2021-10-21 13:33:25 User search spec: N
AND "EGSC Program Service"
ObjMgrSqlLog Debug 5 00000002617131a4:0 2021-10-21 13:33:25 User sort spec: Name
ObjMgrSqlLog Debug 5 00000002617131a4:0 2021-10-21 13:33:25 System sort spec:
ObjMgrSqlLog Debug 5 00000002617131a4:0 2021-10-21 13:33:25
...
ObjMgrBusServiceLog Warning 2 00000002617131a4:0 2021-10-21 13:33:25 (model.cpp (5678)) SBL-DAT-00192: Unable to find the definition of Business Service 'EGSC Program Service' in either the repository or run-time tables.
Please ask your systems administrator to check your application configuration if the problem persists.
...
ObjMgrLog Error 1 00000002617131a4:0 2021-10-21 13:33:25 (model.cpp (4329)) SBL-DAT-00227: Unable to create the Business Service 'EGSC Program Service'
GenericLog GenericInfo 3 00000002617131a4:0 2021-10-21 13:33:25 [AUDIT_LOG]: Session audit cache cleaned.
SecAdptLog Memory Mgmt Trace 5 00000002617131a4:0 2021-10-21 13:33:25 DB SecurityFreeUser, security user=21f5da8.
SecAdptLog Debug 5 00000002617131a4:0 2021-10-21 13:33:25 Destroy Security DB user with username=SADMIN, DB connection=0.
ObjMgrBusServiceLog Warning 2 00000002617131a4:0 2021-10-21 13:33:25 (model.cpp (6456)) SBL-DAT-00227: Unable to create the Business Service '<?>'
In the referenced D:\siebel_app\siebsrvr/log/PostInstallDBSetup_YYYY-MM-DD_HH-MM-DD/SeedSchemaManifest_YYYY-MM-DD_HH-MM-DD/RepositoryUpgrade.cfg used by siebdevcli utility the following parameters are found:
[InfraObjMgr]
RequestServerName = $(RequestServer)
RepositoryType = SRF
EnableSafeBoot = TRUE
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Install 21.9 Monthly Update and proceed with the PostInstallDBSetup execution
2. The execution of PostInstallDBSetup fails on step 2 SeedSchemaManifest
Changes
PostInstallDBsetup execution as part of the 21.9 Monthly Update installation
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 |