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 FEBRUARY 21, 2024
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.
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 |