Last updated on MARCH 02, 2017
Applies to:Siebel System Software - Version 7.7.2 SIA  and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.7.2  Com/Med
Database: Oracle 22.214.171.124
Application Server OS: Microsoft Windows 2000 Advanced Server SP 4
Database Server OS: HP-UX 11i
***Checked for relevance on 15-Jun-2014***
This document was previously published as Siebel SR 38-1577945977.
""Checked for Relevance on 25-Nov-2015""
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 = TSTCHT04
TableOwner = tch_prd
UserName = tch_prd
Password = tch_ptest4
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
Million Knowledge Articles and hundreds of Community platforms