Policy Search Using Product Throws Stack Trace

(Doc ID 2344326.1)

Last updated on DECEMBER 31, 2017

Applies to:

Oracle Insurance Policy Administration J2EE - Version 10.2.0.0 to 10.2.0.29 [Release 10.0]
Information in this document applies to any platform.

Symptoms

Description
Users are receiving a stack trace when trying to search for policies.
This does not happen in every environment, started as the number of plans and policies grew.

Error
Internal Exception: java.sql.SQLException: Prepared or callable statement has more than 2000 parameter markers.

Steps to Reproduce
1. Policy, Search
2. Select Company
3. Select Product
Stack trace returns

Changes

 

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