9 Replies Latest reply: Sep 25, 2013 12:30 PM by Avinash P RSS

    Scheduler services is not strating

    1001368

      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 [[

       

       

      ]]