My Oracle Support Banner

Record Count Applet Feature - Incorrect SQL Query Generated - Errors SBL-DBC-00108 And ORA-01747 (Doc ID 1539187.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Siebel Tools - Version 8.1.1.4 SIA [21225] and later
Information in this document applies to any platform.

Symptoms

In our Siebel application we have a performance issue when the Record Count feature is used from a Contact List Applet. This issue is addressed in another Service Request.
When reviewing our log files for this issue we found that when the Record Count feature is used a SQL query is generated with an odd join in the log file:
- - -
SIEBEL.(SLA 23) S_CONTACT_XM.NAME = T2.ROW_ID (+) AND
- - -

This incorrect query triggers the following errors:
- - -
ObjMgrSqlCursorLog Prepare 5 0000000251239010:0 2013-02-20 04:32:09 Begin: PrepareStmt for Sql Cursor at 305ccfe8
ObjMgrLog Error 1 0000000251239010:0 2013-02-20 04:32:09 (oracon.cpp (3254)) SBL-DBC-00108: An error has occurred preparing a Sql statement.

Please continue or ask your systems administrator to check your application configuration if the problem persists.
SQLParseAndExecute Execute 5 0000000251239010:0 2013-02-20 04:32:09 ORA-01747: invalid user.table.column, table.column, or column specification

ObjMgrSqlCursorLog Prepare 5 0000000251239010:0 2013-02-20 04:32:09 End: PrepareStatement for Sql Cursor at 305ccfe8
- - -

Please let us know why we have this join with "SIEBEL.(SLA 23)" and these errors. I don't find any join with such alias in our Contact BC.

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
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.