After Upgrading To OBIEE 11.1.1.7, the OBIEE Scheduler Fails To Start (Doc ID 1583112.1)

Last updated on APRIL 10, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.1 and later
Information in this document applies to any platform.

Symptoms

The  OBIEE scheduler has been configured in Enterprise Manger Fusion Middleware Control to connect to the BIPlatform schema.

After upgrading OBIEE 11.1.1.5 to OBIEE 11.1.1.7.1 on a cluster environment, the NQScheduler will not start on either node.

All other opmn services start with no issue. The BI Scheduler component stays in "Init" status for a long time and after 5-10 minutes it changes to down.


The log files show the following:


NQScheduler.log:




[2013-07-29T12:36:29.000-05:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: ] [tid: 99631700] [67004] Configuration value iBots\NumGlobalRetries not set.
[2013-07-29T12:36:29.000-05:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: ] [tid: 99631700] [67004] Configuration value iBots\MinGlobalSleepSecs not set.
[2013-07-29T12:36:29.000-05:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: ] [tid: 99631700] [67004] Configuration value iBots\MaxGlobalSleepSecs not set.
[2013-07-29T12:36:29.000-05:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: ] [tid: 99631700] [67004] Configuration value iBots\NumRequestRetries not set.
[2013-07-29T12:36:29.000-05:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: ] [tid: 99631700] [67004] Configuration value iBots\MinRequestSleepSecs not set.
[2013-07-29T12:36:29.000-05:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: ] [tid: 99631700] [67004] Configuration value iBots\MaxRequestSleepSecs not set.
[2013-07-29T12:36:29.000-05:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: ] [tid: 99631700] [67004] Configuration value iBots\NumDeliveryRetries not set.
[2013-07-29T12:36:29.000-05:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: ] [tid: 99631700] [67004] Configuration value iBots\MinDeliverySleepSecs not set.
[2013-07-29T12:36:29.000-05:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: ] [tid: 99631700] [67004] Configuration value iBots\MaxDeliverySleepSecs not set.
[2013-07-29T12:36:29.000-05:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: ] [tid: 99631700] [67004] Configuration value iBots\Debug not set.
[2013-07-29T12:36:29.000-05:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: ] [tid: 99631700] [67004] Configuration value iBots\KeepErrorLogFiles not set.
[2013-07-29T12:36:29.000-05:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: ] [tid: 99631700] [67004] Configuration value iBots\LogMailContent not set.
[2013-07-29T12:36:29.000-05:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: ] [tid: 99631700] [67004] Configuration value iBots\MaxRowsTimesColumns not set.
[2013-07-29T12:36:29.000-05:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: ] [tid: 99631700] [67004] Configuration value iBots\Generate7BitPlainText not set.
[2013-07-29T12:36:29.000-05:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: ] [tid: 99631700] [67004] Configuration value iBots\ForceUTF8 not set.
[2013-07-29T12:36:29.000-05:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: ] [tid: 99631700] [67004] Configuration value Workflow\Server not set.
[2013-07-29T12:36:29.000-05:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: ] [tid: 99631700] [67004] Configuration value Workflow\System not set.
[2013-07-29T12:36:29.000-05:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: ] [tid: 99631700] [67004] Configuration value Workflow\Service not set.
[2013-07-29T12:36:29.000-05:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: ] [tid: 99631700] [67004] Configuration value Mail\SmtpCaCertificateFile not set.
[2013-07-29T12:36:29.000-05:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: ] [tid: 99631700] [67004] Configuration value Mail\SmtpCaCertificateDirectory not set.
[2013-07-29T12:36:29.000-05:00] [OracleBISchedulerComponent] [WARNING:1] [] [] [ecid: ] [tid: 99631700] [67004] Configuration value Mail\SmtpCipherList not set.
[2013-07-29T12:36:29.000-05:00] [OracleBISchedulerComponent] [NOTIFICATION:1] [] [] [ecid: ] [tid: 99631700] Verifying Scheduler's backend database configuration [[

]]
[2013-07-29T12:36:30.000-05:00] [OracleBISchedulerComponent] [NOTIFICATION:1] [] [] [ecid: 004sebikk^m5IfK5qVP5iY0006k3000003,0] [tid: 402ff940] [16020] Metadata Database Type: Oracle 11g [[
Data Source Name: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=db-scan.domain.com)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=xyz.domain.com)))
Data Source Type: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64b
]]
[2013-07-29T12:36:30.000-05:00] [OracleBISchedulerComponent] [ERROR:1] [] [] [ecid: 004sebikk^m5IfK5qVP5iY0006k3000003,0] [tid: 402ff940] [nQSError: 46066] Operation cancelled. [[
PRIMARY_POOL RetrieveColumnInfo from table S_NQ_JOB Exchange
]]



console~coreapplication_obisch1~1.log - shows errors/problems:

 


13/07/25 13:09:41 Start process
--------
[Util Logger] Exception occurred:
Severity:3
Type:PKN3saw9ExceptionE
File:x509credentialstore.cpp
Line:1052
Message:Assertion failure: !vConfigs.empty() at line 1052 of project/webcomm/x509credentialstore.cpp
[Util Logger] Exception occurred:
Severity:5
Type:PKN3saw9ExceptionE
File:x509credentialstore.cpp
Line:1052
Message:Assertion failure: !vConfigs.empty() at line 1052 of project/webcomm/x509credentialstore.cpp
Scheduler service started.
Scheduler service stopped.

--------
13/07/25 14:58:37 Start process
--------

--------
13/07/29 12:36:24 Start process




opmn.log:



[2013-07-29T13:12:34-05:00] [opmn] [ERROR:1] [] [libopmncustom] Ping failed in Ready callback for proc:600657683
[2013-07-29T13:12:36-05:00] [opmn] [ERROR:1] [] [libopmncustom] Process Ping Failed: coreapplication_obisch1~OracleBISchedulerComponent~coreapplication_obisch1~1 (600657683:6927) [No addresses matched the properties for the request]
[2013-07-29T13:12:36-05:00] [opmn] [ERROR:1] [] [libopmncustom] Process Ping Failed: coreapplication_obisch1~OracleBISchedulerComponent~coreapplication_obisch1~1 (600657683:6927)
[2013-07-29T13:12:36-05:00] [opmn] [ERROR:1] [] [libopmncustom] Ping failed in Ready callback for proc:600657683
[2013-07-29T13:12:38-05:00] [opmn] [ERROR:1] [] [libopmncustom] Process Ping Failed: coreapplication_obisch1~OracleBISchedulerComponent~coreapplication_obisch1~1 (600657683:6927) [No addresses matched the properties for the request]
[2013-07-29T13:12:38-05:00] [opmn] [ERROR:1] [] [libopmncustom] Process Ping Failed: coreapplication_obisch1~OracleBISchedulerComponent~coreapplication_obisch1~1 (600657683:6927)
[2013-07-29T13:12:38-05:00] [opmn] [ERROR:1] [] [libopmncustom] Ping failed in Ready callback for proc:600657683
..
....
......[2013-07-29T13:19:58-05:00] [opmn] [ERROR:1] [] [libopmncustom] Process Ping Failed: coreapplication_obisch1~OracleBISchedulerComponent~coreapplication_obisch1~1 (600657683:6927) [No addresses matched the properties for the request]
[2013-07-29T13:19:58-05:00] [opmn] [ERROR:1] [] [libopmncustom] Process Ping Failed: coreapplication_obisch1~OracleBISchedulerComponent~coreapplication_obisch1~1 (600657683:6927)
[2013-07-29T13:19:58-05:00] [opmn] [ERROR:1] [] [libopmncustom] Ping failed in Ready callback for proc:600657683
[2013-07-29T13:19:59-05:00] [opmn] [NOTIFICATION:1] [668] [pm-requests] Request 2 Completed. Command: /start
[2013-07-29T13:19:59-05:00] [opmn] [NOTIFICATION:1] [663] [pm-process] Stopping Process: coreapplication_obisch1~OracleBISchedulerComponent~coreapplication_obisch1~1 (600657683:6927)
[2013-07-29T13:20:58-05:00] [opmn] [ERROR:1] [] [libopmncustom] Forcefully Terminating Process: coreapplication_obisch1~OracleBISchedulerComponent~coreapplication_obisch1~1 (600657683:6927)
[2013-07-29T13:20:58-05:00] [opmn] [TRACE:1] [536] [pm-workers] Job 0 915 result: [[
No addresses matched the properties for the request

]]
[2013-07-29T13:20:59-05:00] [opmn] [NOTIFICATION:1] [666] [pm-process] Process Stopped: coreapplication_obisch1~OracleBISchedulerComponent~coreapplication_obisch1~1 (600657683:6927)
[2013-07-29T13:23:02-05:00] [opmn] [NOTIFICATION:1] [667] [pm-requests] Request 69 Started. Command: /start

Changes

 upgrade from 11.1.1.5 to 11.1.1.7

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