Last updated on AUGUST 25, 2017
Applies to:Siebel System Software - Version 7.7.2 SIA  and later
We are trying to create an EBC that will write data to an External table.
1. Used External Table Schema Import to create external table. Created business component based of this table and exposed it in the user interface. Data Source (TSTCHT04) has been specified at Table and Business Component level. Compiled the changes and copied the srf file on Server and Client.
2. In utility.cfg file added the following:
TSTCHT04 = TSTCHT04
Docked = TRUE
ConnectString = <connectstring>
TableOwner = <table_owner>
UserName = <username>
Password = <password>
DLL = sscdo90.dll
SqlStyle = OracleCBO
3. Created Run Time Parameters in Server Configuration and updated server component to use new data source.
# First issue:
When we login using Dedicated Client and go the View that exposes data from external table, following message is observed:
- - -
The user ID or password that you entered is incorrect. Please check the spelling and try again.
- - -
After clicking on OK, Siebel login applet is displayed. After I enter the external database user name and password in the login box, I can access the view.
How do I setup so that users are not prompted to enter user name and password for external database?
# Second issue:
When we login to Web Client and go the View that exposes data from external table, following error is observed:
- - -
An error has occurred creating business component 'ERCOT Com Quote Interface' used by business object 'ERCOT Com Quote Interface'.
Please ask your systems administrator to check your application configuration.(SBL-DAT-00222)
- - -
NOTE: The Server srf is same as srf on dedicated client and we connect through web client and dedicated client from the same machine. we can connect to external table using SQL PLUS from this machine, which indicates that my Data Source and TNS entry are correct.
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