Cycle Sends Long Running Queries To The Database
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.
On : 10.1.2.9 version, Cycle Issues
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.
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.
Due to this issue, users experience slow response time and even failed activity processing.
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