External Business Component (EBC) - How to Avoid Prompt for Username and Password? (Doc ID 532808.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel System Software - Version 7.7.2 SIA [18325] and later
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 7.7.2 [18325] Com/Med
Database: Oracle 9.2.0.4
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""

Symptoms

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:

[DataSources]
...
TSTCHT04          = 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.

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