SRProc Is Failing To Start Due To Error SBL-GEN-03006: Error calling function: DICFindTable m_pReqTbl
(Doc ID 2929438.1)
Last updated on MARCH 23, 2023
Applies to:
Siebel CRM - Version 8.1.1.11.17 [IP2013] and laterInformation in this document applies to any platform.
Symptoms
Siebel Server service cannot be started because SRProc component is failing to start with generic error as shown below:
File Name or Source: SRProc.log
GenericLog GenericError 1 <timestamp> Message: GEN-10, Additional Message: Calling Function: DICVRuleDOTablePaths; Called Function: DICFindColumnInTable src column id
GenericLog GenericError 1 <timestamp> Message: GEN-10, Additional Message: Calling Function: DICLoadDObjectInfo; Called Function: DICVRuleDOTablePaths
GenericLog GenericError 1 <timestamp> Message: GEN-10, Additional Message: Calling Function: DICLoadDict; Called Function: DICLoadDObjectInfo
GenericLog GenericError 1 <timestamp> (srpdb.cpp (862) err=3006 sys=2) SBL-GEN-03006: Error calling function: DICFindTable m_pReqTbl
The issue can be reproduced at will with the following steps:
1. Start Siebel Service
2. SRProc component is failing to start
In order to gather more details about dictionary cache issue, the dbchck utility was executed after additional logging (SQL Tracing for Siebel Database utilities) was increased on affected Siebel machine.
Note:
In order to enable SQL tracing for Siebel database utilities, set the system environment variable as follows in Windows:
DBUTIL_LOG_EVENTS=SQLParseAndExecute=5,SQLDBUtilityLog=3
In Linux/Unix, add it to the siebenv.sh as below:
export DBUTIL_LOG_EVENTS=SQLParseAndExecute=5,SQLDBUtilityLog=3
Execute dbchck using the instructions from Doc ID 475677.1
In dbchck log we can see that S_DOCK_OBJECT table is queried right before the failure.
File Name or Source: dbchck.log
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 |
| Cause |
| Solution |