UpdateCommissionStatus BR Reports 'ORA-01795: Maximum Number Of Expressions In A List Is 1000' Message
(Doc ID 2783300.1)
Last updated on DECEMBER 04, 2024
Applies to:
Oracle Insurance Policy Administration J2EE - Version 11.2.4.1 and laterInformation in this document applies to any platform.
Symptoms
On : 11.2.4.1 version, General
When attempting to update multiple CommissionDetail with the UpdateCommissionStatus BR,
when there is an update more than 1000 CommissionDetail, the following message is reported:
ERROR
-----------------------
Caused by: com.adminserver.utl.exception.AsExceptionUtl: An error occurred while processing business rule: UpdateCommisionDetailStatus.
at com.adminserver.pas.ape.UpdateCommissionDetailStatusApe.processRule(UpdateCommissionDetailStatusApe.java:168)
at com.adminserver.sre.bll.TransactionBusinessRulePacketRuleBll.processRule_aroundBody4(TransactionBusinessRulePacketRuleBll.java:133)
at com.adminserver.sre.bll.TransactionBusinessRulePacketRuleBll$AjcClosure5.run(TransactionBusinessRulePacketRuleBll.java:1)
at org.aspectj.runtime.reflect.JoinPointImpl.proceed(JoinPointImpl.java:149)
... 56 more
Caused by: com.adminserver.utl.exception.AsExceptionUtl: Failed to Load CommissionDetail
at com.adminserver.pas.dal.DataRetrieverDal.findCommissionDetailByCommissionDetailGuidList(DataRetrieverDal.java:6084)
at com.adminserver.pas.dal.DataRetrieverDal.retrieveDataDclList(DataRetrieverDal.java:984)
at com.adminserver.pas.dal.DataRetrieverDal.retrieveDataDclList(DataRetrieverDal.java:241)
at com.adminserver.pas.dal.DataRetrieverDal$$FastClassBySpringCGLIB$$39db3697.invoke()
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218)
... 63 more
Caused by: com.adminserver.utl.exception.AsExceptionUtl: Database error occurred while performing operation SELECT.
at com.adminserver.dal.jdbc.JdbcDataAccessHelper.executeSelectQuery(JdbcDataAccessHelper.java:114)
at com.adminserver.pas.dal.DataRetrieverDal.findCommissionDetailByCommissionDetailGuidList(DataRetrieverDal.java:6080)
... 81 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Use a UpdateCommissionStatus to update more than 1000 CommissionDetails.
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 |