OBIEE 12.2.1.3.0 Nqscheduler Service Consumes 100% CPU (Doc ID 2447981.1)

Last updated on APRIL 01, 2019

Applies to:

Symptoms

OBIEE 12.2.1.3.0 nqscheduler process consumes 100% CPU at least once per day.


Problem goes away temporarily after  stop/start the service in EM  until it starts all over again.

In the log  continuously see the following:

[2018-08-23T11:30:41.66-04:00] [OBISCH] [NOTIFICATION:1] [] [] [ecid: ] [sik: service1] [tid: 3f351700] Connection Pool exit for DSN biplatform_datasource, DB name is , connection pool name is PRIMARY_POOL [[
Properties: description=PRIMARY_POOL Exchange; producerID=0x54994008; requestID=0xfffe0049; sessionID=0xfffe0000; userName=PROD_BIPLATFORM;
]]
[2018-08-23T11:30:41.66-04:00] [OBISCH] [NOTIFICATION:1] [] [] [ecid: ] [sik: service1] [tid: 3f351700] Connection destroyed due to timeout. dsn is biplatform_datasource, DB name is [[
Properties: description=PRIMARY_POOL Exchange; producerID=0x54994008; requestID=0xfffe0049; sessionID=0xfffe0000; userName=PROD_BIPLATFORM;

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.