Cycle Sends Long Running Queries To The Database
(Doc ID 2249600.1)
Last updated on FEBRUARY 25, 2019
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document