My Oracle Support Banner

PostInstallDBSetup Fails On Step 2 SeedSchemaManifest Processing - Unable to create the Business Service '<?>'(SBL-DAT-00227) (Doc ID 2833309.1)

Last updated on JANUARY 11, 2022

Applies to:

Siebel CRM - Version 21.9 and later
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:

Unable to create the Business Service '<?>'(SBL-DAT-00227)

In the import_schema_sif.log found under the same directory the following trace is found:

2021 2021-10-21 13:32:47 2021-10-21 13:33:26 -0400 0000affe 001 003f 0001 09 siebdevcli 12708 13496 D:\siebel_app\siebsrvr\log\siebdevcli.log 21.9.0.0 [2021_09]
...
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


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