Cycle Sends Long Running Queries To The Database (Doc ID 2249600.1)

Last updated on MARCH 29, 2017

Applies to:

Oracle Insurance Policy Administration J2EE - Version 10.1.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 10.1.2.9 version, Cycle Issues

Problem Description
Users report performance issues and error due to long running queries.
Example, queries that select from AsPlan which has over 250,000 records and it takes some time to retrieve them.


Error
SEVERE: [Cycle] Fatal error encountered while trying to mark PRECLIENT [GUID] as being processed. java.lang.NullPointerException
Feb 06, 2017 9:42:05 PM com.adminserver.cycle.agent.bll.tasks.CycleGroupTask run
SEVERE: Encountered error.
com.adminserver.utl.exception.AsExceptionUtl: com.adminserver.utl.exception.AsExceptionUtl: [Cycle] Error occurred processing activities on PRECLIENT [GUID]

Steps to Reproduce
Using client database, SQL Profiler was used to capture long running SQL statements.

Business Impact
Due to this issue, users experience slow response time and even failed activity processing.

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