Last updated on MARCH 02, 2017
Applies to:Siebel Tools - Version 184.108.40.206 SIA  and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 220.127.116.11 
Database: Oracle 18.104.22.168
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**
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:
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms