External BC user login problem (Doc ID 546700.1)

Last updated on AUGUST 12, 2015

Applies to:

Siebel System Software - Version 7.7.2 [18325] and later
Generic Windows



Symptoms

The user/password (SIEBEL/SIEBEL) is specified in the .cfg file and this user can be used to connect to the new datasource using TOAD.

In the log file it stated that "There are no database credentials assigned for this user", are there any explicit requirements on the user priviliges for the user in the external database?

Below it the .cfg file settings for the external datasource:

 

[GPMF]
Docked                   = TRUE
ConnectString            = XXXXXX
TableOwner               = XXXXXX
DLL                      = sscdo90.dll
SqlStyle                 = OracleCBO
MaxCachedCursors        = 16
MaxCachedDataSets        = 16
ReverseFillThreshold     = 100
CaseInsensitive          = FALSE
InsensitivityFactor      = 2
FileSystem               =
GatewayAddress           =
EnterpriseServer        =
CurrentSQLID             = Startup
MaxCursorSize            =
PrefetchSize             =
ChartServer              = localhost:8001
ChartImageFormat        = png
DSPassword         = SIEBEL
DSUserName         = SIEBEL


Below is an extract from the log file:

EventContext    EvtCtxView    3    0    2005-06-16 16:23:18    ITT GPMF List View

DBCLog    DBCLogError    1    0    2005-06-16 16:23:18    OCIStmtExecute: ALTER SESSION SET OPTIMIZER_MODE = FIRST_ROWS_10

ObjMgrLog    Error    1    0    2005-06-16 16:23:18    (oracon.cpp (3033)) SBL-DBC-00111: An error has occurred writing to a record.

Please continue or ask your systems administrator to check your application configuration if the problem persists.

ObjMgrLog    Error    1    0    2005-06-16 16:23:18    (oracon.cpp (2994)) SBL-DBC-00107: An Oracle database error has occurred.

Please continue or ask your systems administrator to check your application configuration if the problem persists.

ObjMgrLog    Error    1    0    2005-06-16 16:23:18    (oracon.cpp...

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