CountRecords BC Method - Incorrect SQL Generated When Running On Oracle DB - Errors SBL-DBC-00108 and ORA-00920
(Doc ID 1513686.1)
Last updated on NOVEMBER 22, 2019
Applies to:
Siebel CRM - Version 8.0.0.13 [20448] and laterInformation in this document applies to any platform.
Checked for Relevance on 19-May-2014
Checked for Relevance on 11-Jan-2016
Symptoms
After an upgrade from Siebel 8.0.0.6 and Oracle 10g to Siebel 8.0.0.13 and Oracle 11g we experience a scripting issue when using the CountRecords() BC method with a customized BC ('Asset Mgmt - Asset - Header'). We have isolated how to reproduce this error: using a simple BS that execute a query followed by a count record Siebel build in a wrong way the count query totally different from the previous select statement. We have two different behaviors when using ExecuteQuery:
* ForwardOnly mode --> when executing the CountRecord() the exception of bad formatted query is displayed in the UI and the count is NOT performed,
* ForwardBackward mode --> when executing the CountRecord() the exception of bad formatted query is NOT displayed in the UI, the count is performed but the error 1 is logged.
Changes
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 |