My Oracle Support Banner

Unable To Start SSA ID Api In SRBroker Log When Using Oracle DB Server 12.2.0.1.0 (Doc ID 2466851.1)

Last updated on OCTOBER 04, 2021

Applies to:

Siebel CRM - Version 15.18 [IP2015] to 15.18 [IP2015] [Release V15]
Siebel CRM - Version 16.19 [IP2016] to 16.19 [IP2016] [Release V16]
Information in this document applies to any platform.

Symptoms

On : 16.7 [IP2016] version, System Admin

When attempting to bring the Siebel Server up after the database server was moved to Linux the Siebel Server does not come up.
In the Siebel Enterprise log it is showing that SRBroker is getting terminated.

ERROR
-----------------------
ServerLog ProcessExit 1 00004acc5bb545ac:0 2018-10-03 13:20:39 SRBroker 18105 TERMINATED Process 18105 was terminated

SRBroker log file has the following pattern:

...
SQLStatementOptions Free Statement Details 5 000099755bb5634d:0 2018-10-04 12:29:26 (SQLFreeStmt) Option: SQL_DROP

SQLSummary Header 4 000099755bb5634d:0 2018-10-04 12:29:26 *******************************************************************************
SQLSummary Stmt 4 000099755bb5634d:0 2018-10-04 12:29:26
  update SIEBEL.S_SSA_ID
     set LAST_UPD         =  current_date,
         LAST_UPD_BY      =  CREATED_BY,
         MODIFICATION_NUM =  MODIFICATION_NUM + 1,
         NEXT_SESSION     =  ?
   where ROW_ID = ? AND MODIFICATION_NUM = ?
SQLSummary BindVar 4 000099755bb5634d:0 2018-10-04 12:29:26 01:DPG
02:0-11
03:518922

SQLSummary Header 4 000099755bb5634d:0 2018-10-04 12:29:26 Call                Count          Total Time          Avg. Time      Rows          
SQLSummary Sep 5 000099755bb5634d:0 2018-10-04 12:29:26 -------------------------------------------------------------------------------
SQLSummary ExecDir 5 000099755bb5634d:0 2018-10-04 12:29:26 Exec Direct             1              1.031s             1.031s         0
SQLSummary Sep 5 000099755bb5634d:0 2018-10-04 12:29:26 -------------------------------------------------------------------------------
SQLSummary Totals 4 000099755bb5634d:0 2018-10-04 12:29:26 Total                   1              1.031s             1.031s         0

GenericLog GenericError 1 000099755bb5634d:0 2018-10-04 12:29:26 Unable to start SSA ID api.

Changes

Oracle Database Server was upgraded to 12.2.0.1.0 when migrated to Linux OS

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.