Post Upgrade Services Are Not Starting Due to Missing Table Owner Having CHANGE_ME In SRBroker/SRProc (Doc ID 2907076.1)

Last updated on NOVEMBER 03, 2022

Applies to:

Siebel CRM - Version 21.12 and later
Information in this document applies to any platform.

Symptoms

After upgrading from Siebel IP15.14 to 21.12 version services are not starting.

In SRBroker_0002_2097155.log we could see:

SQLSummary Stmt 4 000000046359063b:0 2022-10-26 16:47:29 select DB_SCHEMA_VER, NULLIF(0, 0), NULLIF(0, 0), CUSTOM_SCHEMA_VER, NULLIF(0, 0), APP_VER, COMMENTS, NULLIF(0, 0), {fn now()}, NULLIF(0, 0), 'N', NULLIF(0, 0), NULLIF(0, 0) from CHANGE_ME.S_APP_VER
Unable to get schema version.
Please verify that you have specified the correct Table Owner (CHANGE_ME)
and you have select access to the S_APP_VER table.

In SRProc_0006_6291459.log was observed:

GenericLog GenericError 1 00000002635906a1:0 2022-10-26 16:47:29
Unable to get schema version.
Please verify that you have specified the correct Table Owner (CHANGE_ME)
and you have select access to the S_APP_VER table.
GenericLog GenericError 1 00000002635906a1:0 2022-10-26 16:47:29 (srpdb.cpp (1000) err=2097168 sys=0) SBL-SRM-00016: Unable to initialize the Database environment -- Unable to start common api

Steps to replicate:

1. Run the upgrade process from 15.14 to 21.12 ( Upgrep + Upgphys )

2. Do not update the table owner section in the upgrade Wizard.

3. Start the services.