Unable To Connect To ODBC Datasource As User Xxxx SBL-CDM-00191 When Tryng To Create Target List

(Doc ID 2196653.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Life Sciences CRM - Version 15.0 [IP2015] and later
Information in this document applies to any platform.

Symptoms

On : IP15 version, Client Functionality

When trying to create target list using OBIEE 11.1.1.9 and Siebel CRM 15.5 both installed on same Windows machine


ERROR
-----------------------
Unable to connect to ODBC datasource as user xxxx SBL-CDM-00191


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

- Enable BI Target List" as described in Siebel Life Sciences Guide

- MUST use High Interactivity
- MUST use IE 8 32 bit
- biadmin user must exist in OBI, in Siebel, Siebel DB and can login using ODBC

Steps:

1) Logon to a machine with IE8

2) Run Pharma: http://xxxxxxxxx/epharma_enu
UserName: biadmin
Password: xxxxxx

3) go to Answers screen

4) Create an Analysis > Subject Area can be any but choose "Activities"

5) On the left frame, select "Contacts" and double click in "First Name"

6) Add a filter by placing the cursor in the icon at the right side of "First Name" column > choose "Filter" > Operator "begins with" > Value = A > OK

7) Click in "Results" tab

8) Click in the 7th icon at the top for "New View" > Other Views > Create Target List

9) A link "Create Target List" link is added at the bottom just below the data results.

10) Click in the "Create Target List" link and enter any List Name > OK

Error:

Unable to connect to ODBC datasource "coreapplication_OH594158318" as user "BIADMIN."(SBL-CDM-00191)

 

=== Log shows "NO DNS" error ==========

ProcessRequest ProcessRequestDetail 4 000001b6571f04c4:0 2016-04-26 08:41:45 SWE Frame Manager - Invoke Service Method: service=LS Analytics Target Service; method=CreateTargetList

ObjMgrBusServiceLog InvokeMethod 4 000001b6571f04c4:0 2016-04-26 08:41:45 Begin: Business Service 'LS Analytics Target Service' invoke method: 'CreateTargetList' at 17f4df58

SQLTraceAll SQLTraceAll 4 000001b6571f04c4:0 2016-04-26 08:41:45 (SQLAllocEnv) Env Handle: 77670360, Time: 0s

SQLTraceAll SQLTraceAll 4 000001b6571f04c4:0 2016-04-26 08:41:45 (SQLAllocConnect) Env Handle: 77670360, Conn Handle: 77670480, Time: 0s

SQLConnectOptions Allocate Connection 4 000001b6571f04c4:0 2016-04-26 08:41:45 (SQLAllocConnect) Conn Handle: 77670480, Time: 0s

SQLTraceAll SQLTraceAll 4 000001b6571f04c4:0 2016-04-26 08:41:45 No DNS found

SQLTraceAll SQLTraceAll 4 000001b6571f04c4:0 2016-04-26 08:41:45 (SQLDisconnect) Conn Handle: 77670480, Time: 0s

SQLConnectOptions Disconnect 4 000001b6571f04c4:0 2016-04-26 08:41:45 (SQLDisconnect) Conn Handle: 77670480, Time: 0s

SQLTraceAll SQLTraceAll 4 000001b6571f04c4:0 2016-04-26 08:41:45 (SQLFreeConnect) Conn Handle: 77670480, Time: 0s

SQLConnectOptions Free Connection 4 000001b6571f04c4:0 2016-04-26 08:41:45 (SQLFreeConnect) Conn Handle: 77670480, Time: 0s

SQLProfiling Statement 4 000001b6571f04c4:0 2016-04-26 08:41:45 ********************************* Begin 10 Worst Performing Queries *********************************

SQLProfiling Statement 4 000001b6571f04c4:0 2016-04-26 08:41:45 ********************************* End 10 Worst Performing Queries *********************************

SQLTraceAll SQLTraceAll 4 000001b6571f04c4:0 2016-04-26 08:41:45 (SQLFreeEnv) Env Handle: 77670360, Time: 0s

ObjMgrBusServiceLog Error 1 000001b6571f04c4:0 2016-04-26 08:41:45 (lsanalyticstrgtsvc.cpp (509)) SBL-CDM-00191: Unable to connect to ODBC datasource "coreapplication_OH594158318" as user "BIADMIN."

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