EBC: SBL-DBC-00105 - SQL error (Doc ID 532121.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 7.7.2.6 SIA [18372] and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.7.2.6 [18372]
Database: Oracle 9.2.0.6
Application Server OS: Microsoft Windows 2000 Server SP 3
Database Server OS: Sun Solaris 8

This document was previously published as Siebel SR 38-3136796301.

Checked for Relevance on **Dec-20-2011**
**Checked for Relevance on 02/05/2016**

Symptoms

We are trying to have an External Business Component attach to a table using a working datasource. For instance, we have one EBC that works well - it is issuing a distinct query to the external database, and is returning the correct records. I am trying this with a different business component (created by copying the working buscomp), and have defined the table object and modified the buscomp to use the new columns.

The application is generating the following SQL:

SELECT DISTINCT
      T1.NAME
   FROM
       LABSDEV.I7_CANDIDATEPROGRAMSTATUS T1
   ORDER BY
      T1.NAME

Which is exactly what I want it to do, and in fact when I log into our external database with the proper user account, I am able to run this and get results. So the SQL is not the issue.

Because this error:

***** Begin SQL Error Message*****

An error has occurred executing a Sql statement.

Please continue or ask your systems administrator to check your application configuration if the problem persists.(SBL-DBC-00105)

***** End SQL Error Message *****

is quite generic, and the support portal posts for this error and EBCs are not describing our problem (most have to do with joins), I'm not sure where else to look. Again, other EBCs using this data source work very well.

Please let me know if there is another step to look at. I am attaching .sifs of the Table definition and the External Business Component definition.

Changes

 .

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