SRBroker Fails With SBL-SRM-00016 Without Detailed Error (Doc ID 2290240.1)

Last updated on JULY 31, 2017

Applies to:

Siebel CRM - Version 15.18 [IP2015] and later
Information in this document applies to any platform.

Symptoms

On : 15.18 [IP2015] version, Installation

All servers except one is fixed now by following the instruction in below document.
- Assignment Manager Unavailable with errors dict-ERR-1109 - dict-ERR-1107 (Doc Id 540799.1)
However one of the server is not working with the ODBC driver "Siebel Oracle90 E:/sba81/siebsrvr" and when the driver was changed to OraClient11Home1_32bit it was working fine without any issue.



ERROR
-----------------------
SRBroker log shows the following messages.

SQLTraceAll SQLTraceAll 4 07cd0ff7596a0594:0 2017-07-21 19:05:08 (SQLSetConnectOption) Conn Handle: 2520216, Time: 0s
SQLConnectOptions Set Connection Option 4 07cd0ff7596a0594:0 2017-07-21 19:05:08 (SQLSetConnectOption) Handle: 2520216, Time: 0s
SQLConnectOptions Set Connection Option Detail 5 07cd0ff7596a0594:0 2017-07-21 19:05:08 (SQLSetConnectOption) Option: 1042, Param: 1875593340
SQLTraceAll SQLTraceAll 4 07cd0ff7596a0594:0 2017-07-21 19:05:08 (SQLDisconnect) Conn Handle: 2520216, Time: 0s
SQLConnectOptions Disconnect 4 07cd0ff7596a0594:0 2017-07-21 19:05:08 (SQLDisconnect) Conn Handle: 2520216, Time: 0s
SQLTraceAll SQLTraceAll 4 07cd0ff7596a0594:0 2017-07-21 19:05:08 (SQLFreeConnect) Conn Handle: 2520216, Time: 0s
SQLConnectOptions Free Connection 4 07cd0ff7596a0594:0 2017-07-21 19:05:08 (SQLFreeConnect) Conn Handle: 2520216, Time: 0s
SQLProfiling Statement 4 07cd0ff7596a0594:0 2017-07-21 19:05:08 ********************************* Begin 10 Worst Performing Queries *********************************
SQLProfiling Statement 4 07cd0ff7596a0594:0 2017-07-21 19:05:08 ********************************* End 10 Worst Performing Queries *********************************
SQLTraceAll SQLTraceAll 4 07cd0ff7596a0594:0 2017-07-21 19:05:08 (SQLFreeEnv) Env Handle: 2520096, Time: 0s
GenericLog GenericError 1 07cd0ff7596a0594:0 2017-07-21 19:05:08 (srbthrd.cpp (4075) err=2097168 sys=0) SBL-SRM-00016: Unable to initialize the Database environment -- Unable to connect to DB (data ops)

** Usually the actual reason of SBL-SRM-00016, such as the incorrect combination of user-id and password, should be recorded together. But in this scenario, no outstanding information is recorded even with the highest event log level (%=5).



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Fix the ODBC setting for DataDirect ODBC Driver on the registry.
2. Restart Siebel Server.



BUSINESS IMPACT
-----------------------
The issue has the following business impact:
One Siebel Server cannot run correctly.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms