This discussion is archived
9 Replies Latest reply: Sep 25, 2013 10:30 AM by Avinash P RSS

Scheduler services is not strating

1001368 Newbie
Currently Being Moderated

When I restarting OPMN scheduler services is not coming up, in log file i found bellow error. servers in Linux only

My database is running,i checked schema passwords is not expire.

Pls help on this.

[tid: 41471940]  [nQSError: 16001] ODBC error state: IM002 code: 0 message: [DataDirect][ODBC lib] Data source name not found and no default driver specified.

[2013-09-13T14:45:51.000+00:00] [OracleBISchedulerComponent] [ERROR:1] [] [] [ecid: 004t^JdEGZmApI4pzSw0yW0005ju000000] [tid: 9b7b6810]  [nQSError: 16001] ODBC error state: IM002 code: 0 message: [DataDirect][ODBC lib] Data source name not found and no default driver specified.

[2013-09-13T14:45:51.000+00:00] [OracleBISchedulerComponent] [ERROR:1] [] [] [ecid: 004t^JdEGZmApI4pzSw0yW0005ju000000] [tid: 41471940]  [nQSError: 16001] ODBC error state: IM002 code: 0 message: [DataDirect][ODBC lib] Data source name not found and no default driver specified.

[2013-09-13T14:45:51.000+00:00] [OracleBISchedulerComponent] [ERROR:1] [] [] [ecid: 004t^JdEGZmApI4pzSw0yW0005ju000000] [tid: 9b7b6810]  [nQSError: 16001] ODBC error state: IM002 code: 0 message: [DataDirect][ODBC lib] Data source name not found and no default driver specified.

[2013-09-13T14:45:51.000+00:00] [OracleBISchedulerComponent] [ERROR:1] [] [] [ecid: 004t^JdEGZmApI4pzSw0yW0005ju000000] [tid: 41471940]  [nQSError: 16001] ODBC error state: IM002 code: 0 message: [DataDirect][ODBC lib] Data source name not found and no default driver specified.

[2013-09-13T14:45:51.000+00:00] [OracleBISchedulerComponent] [ERROR:1] [] [] [ecid: 004t^JdEGZmApI4pzSw0yW0005ju000000] [tid: 9b7b6810]  [nQSError: 16001] ODBC error state: IM002 code: 0 message: [DataDirect][ODBC lib] Data source name not found and no default driver specified.

[2013-09-13T14:45:51.000+00:00] [OracleBISchedulerComponent] [ERROR:1] [] [] [ecid: 004t^JdEGZmApI4pzSw0yW0005ju000000] [tid: 41471940]  [nQSError: 16001] ODBC error state: IM002 code: 0 message: [DataDirect][ODBC lib] Data source name not found and no default driver specified.

[2013-09-13T14:45:51.000+00:00] [OracleBISchedulerComponent] [ERROR:1] [] [] [ecid: 004t^JdEGZmApI4pzSw0yW0005ju000000] [tid: 9b7b6810]  [nQSError: 16001] ODBC error state: IM002 code: 0 message: [DataDirect][ODBC lib] Data source name not found and no default driver specified.

[2013-09-13T14:45:51.000+00:00] [OracleBISchedulerComponent] [ERROR:1] [] [] [ecid: 004t^JdEGZmApI4pzSw0yW0005ju000000] [tid: 9b7b6810]  [[

Current Table: S_NQ_JOB.

[nQSError: 16001] ODBC error state: IM002 code: 0 message: [DataDirect][ODBC lib] 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: [DataDirect][ODBC lib] Data source name not found and no default driver specified.

Current Table: S_NQ_INSTANCE.

[nQSError: 16001] ODBC error state: IM002 code: 0 message: [DataDirect][ODBC lib] 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: [DataDirect][ODBC lib] Data source name not found and no default driver specified.. Errors were encountered while initializing Scheduler's backend database, check database configuration.

 

 

]]

[2013-09-13T14:45:52.000+00:00] [OracleBISchedulerComponent] [ERROR:1] [] [] [ecid: ] [tid: 9b7b6810]  [68008] Scheduler Error:  [[

Current Table: S_NQ_JOB.

[nQSError: 16001] ODBC error state: IM002 code: 0 message: [DataDirect][ODBC lib] 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: [DataDirect][ODBC lib] Data source name not found and no default driver specified.

Current Table: S_NQ_INSTANCE.

[nQSError: 16001] ODBC error state: IM002 code: 0 message: [DataDirect][ODBC lib] 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: [DataDirect][ODBC lib] Data source name not found and no default driver specified.. Errors were encountered while initializing Scheduler's backend database, check database configuration.

 

 

]]

[2013-09-13T14:45:57.000+00:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: 004t^Jd^STbApI4pzSw0yW0005kK000000] [tid: 96fab810]  [67004] Configuration value iBots\NumGlobalRetries not set.

[2013-09-13T14:45:57.000+00:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: 004t^Jd^STbApI4pzSw0yW0005kK000000] [tid: 96fab810]  [67004] Configuration value iBots\MinGlobalSleepSecs not set.

[2013-09-13T14:45:57.000+00:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: 004t^Jd^STbApI4pzSw0yW0005kK000000] [tid: 96fab810]  [67004] Configuration value iBots\MaxGlobalSleepSecs not set.

[2013-09-13T14:45:57.000+00:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: 004t^Jd^STbApI4pzSw0yW0005kK000000] [tid: 96fab810]  [67004] Configuration value iBots\NumRequestRetries not set.

[2013-09-13T14:45:57.000+00:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: 004t^Jd^STbApI4pzSw0yW0005kK000000] [tid: 96fab810]  [67004] Configuration value iBots\MinRequestSleepSecs not set.

[2013-09-13T14:45:57.000+00:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: 004t^Jd^STbApI4pzSw0yW0005kK000000] [tid: 96fab810]  [67004] Configuration value iBots\MaxRequestSleepSecs not set.

[2013-09-13T14:45:57.000+00:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: 004t^Jd^STbApI4pzSw0yW0005kK000000] [tid: 96fab810]  [67004] Configuration value iBots\NumDeliveryRetries not set.

[2013-09-13T14:45:57.000+00:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: 004t^Jd^STbApI4pzSw0yW0005kK000000] [tid: 96fab810]  [67004] Configuration value iBots\MinDeliverySleepSecs not set.

[2013-09-13T14:45:57.000+00:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: 004t^Jd^STbApI4pzSw0yW0005kK000000] [tid: 96fab810]  [67004] Configuration value iBots\MaxDeliverySleepSecs not set.

[2013-09-13T14:45:57.000+00:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: 004t^Jd^STbApI4pzSw0yW0005kK000000] [tid: 96fab810]  [67004] Configuration value iBots\Debug not set.

[2013-09-13T14:45:57.000+00:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: 004t^Jd^STbApI4pzSw0yW0005kK000000] [tid: 96fab810]  [67004] Configuration value iBots\KeepErrorLogFiles not set.

[2013-09-13T14:45:57.000+00:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: 004t^Jd^STbApI4pzSw0yW0005kK000000] [tid: 96fab810]  [67004] Configuration value iBots\LogMailContent not set.

[2013-09-13T14:45:57.000+00:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: 004t^Jd^STbApI4pzSw0yW0005kK000000] [tid: 96fab810]  [67004] Configuration value iBots\MaxRowsTimesColumns not set.

[2013-09-13T14:45:57.000+00:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: 004t^Jd^STbApI4pzSw0yW0005kK000000] [tid: 96fab810]  [67004] Configuration value iBots\Generate7BitPlainText not set.

[2013-09-13T14:45:57.000+00:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: 004t^Jd^STbApI4pzSw0yW0005kK000000] [tid: 96fab810]  [67004] Configuration value iBots\ForceUTF8 not set.

[2013-09-13T14:45:57.000+00:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: 004t^Jd^STbApI4pzSw0yW0005kK000000] [tid: 96fab810]  [67004] Configuration value Workflow\Server not set.

[2013-09-13T14:45:57.000+00:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: 004t^Jd^STbApI4pzSw0yW0005kK000000] [tid: 96fab810]  [67004] Configuration value Workflow\System not set.

[2013-09-13T14:45:57.000+00:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: 004t^Jd^STbApI4pzSw0yW0005kK000000] [tid: 96fab810]  [67004] Configuration value Workflow\Service not set.

[2013-09-13T14:45:57.000+00:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: 004t^Jd^STbApI4pzSw0yW0005kK000000] [tid: 96fab810]  [67004] Configuration value Mail\SmtpCaCertificateFile not set.

[2013-09-13T14:45:57.000+00:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: 004t^Jd^STbApI4pzSw0yW0005kK000000] [tid: 96fab810]  [67004] Configuration value Mail\SmtpCaCertificateDirectory not set.

[2013-09-13T14:45:57.000+00:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: 004t^Jd^STbApI4pzSw0yW0005kK000000] [tid: 96fab810]  [67004] Configuration value Mail\SmtpCipherList not set.

[2013-09-13T14:45:57.000+00:00] [OracleBISchedulerComponent] [NOTIFICATION:1] [] [] [ecid: 004t^Jd^STbApI4pzSw0yW0005kK000000] [tid: 96fab810] Verifying Scheduler's backend database configuration [[

 

 

]]

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points