After A Scale-Out On OBIEE 11g (11.1.1.6.0) On Windows, The Scheduler On Node 2 Fails To Start With Error "Data source name not found and no default driver specified" in nQScheduler.Log

(Doc ID 1459480.1)

Last updated on MAY 24, 2012

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.6.0 and later
Generic Windows
Microsoft Windows x64 (64-bit) - Version: 2008 R2

Symptoms

After performing a scale-out of OBIEE 11g (11.1.1.6) the scheduler system component on node1 starts successfully, the scheduler on node2 fails to start.
MS SQL Server is used as the repository database for the scheduler schemas (i.e.- The Repository Creation Utility [RCU] installed the schemas on the SQL Server database)

 

The node 2 nqscheduler.log shows the following:

 

[2012-05-16T13:47:14.000+00:00] [OracleBISchedulerComponent] [ERROR:1] [] [] [ecid: ] [tid: 46c]  [68008] Scheduler Error:  [[
Current Table: S_NQ_JOB.
[nQSError: 16001] ODBC error state: IM002 code: 0 message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
Current Table: S_NQ_JOB_PARAM.
[nQSError: 16001] ODBC error state: IM002 code: 0 message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
Current Table: S_NQ_INSTANCE.
[nQSError: 16001] ODBC error state: IM002 code: 0 message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.
Current Table: S_NQ_ERR_MSG.
[nQSError: 16001] ODBC error state: IM002 code: 0 message: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified.. Errors were encountered while initializing Scheduler's backend database, check database configuration.

 

 

There may also be a message with the DSN Name not found that you configured in Enterprise Manager for the scheduler.

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