My Oracle Support Banner

Client Level Activity Processing Got Hung Due To SQL Exception (Doc ID 2698177.1)

Last updated on AUGUST 07, 2020

Applies to:

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

Symptoms

On : 10.2.2.0 version, General

Current Analysis:
IN client level EOD went to hung state after client level processing resulted in multiple SQL exceptions, causing EOD to go to a hung state.

Exception as below
4/26/20 12:12:34:682] 000000e9 PasCycleBll E Fatal error. Failed to process PRECLIENT [GUID] because of null

[4/26/20 12:23:20:415] 000000cf SystemOut O [EL Warning]: 2020-04-26 12:23:20.411--UnitOfWork(-621132443)--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.3.0.v20110604-r9504): org.eclipse.persistence.exceptions.DatabaseException

Internal Exception: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
Error Code: 1795

Analysis known so far
There are 6 customers, for these clients, there are more than 1000 create policy XMLs that are pending with error. As per Oracle, when every client is processed, base code prepares an exclusion list to avoid processing of activities that are pending with error . This exclusion list is then embedded in a query, in this case, since this list was more than 1000, SQL exception was thrown, thus impacting the client level EOD.

Cause

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
Symptoms
Cause
Solution
References


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