Fixes are available
APAR status
Closed as program error.
Error description
When working with Oracle database, the above message can pop up using the Business Console. The below Exception can also be thrown in the logs : java.lang.RuntimeException: java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000 at ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl. findObjects(IlrSessionFacadeImpl.java:3895) at ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl. findElements(IlrSessionFacadeImpl.java:4098) at ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl. findElements(IlrSessionFacadeImpl.java:4192) at sun.reflect.GeneratedMethodAccessor651.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke( DelegatingMethodAccessorImpl.java:55) at java.lang.reflect.Method.invoke(Method.java:619) at ilog.rules.teamserver.transaction. IlrTransactionalInvocationHandler.invoke( IlrTransactionalInvocationHandler.java:35) at com.sun.proxy.$Proxy43.findElements(Unknown Source) at ilog.rules.teamserver.model.impl.IlrAbstractSession. findElements(IlrAbstractSession.java:642) at ilog.rules.teamserver.model.impl. IlrAbstractCachingSession.findElements( IlrAbstractCachingSession.java:325) at ilog.rules.teamserver.model.finders.Finder. doFindActivities(Finder.java:245) at ilog.rules.teamserver.model.finders.Finder. findPageActivities(Finder.java:127) at ilog.rules.teamserver.model.finders. ActivityEventRuleFinder.findPageActivities( ActivityEventRuleFinder.java:52) at com.ibm.rules.decisioncenter.web.core.ActivityHelper. getEventRuleChangesSince(ActivityHelper.java:2609) at com.ibm.rules.decisioncenter.web.core.ActivityHelper. getRuleUpdates(ActivityHelper.java:2582) at com.ibm.rules.decisioncenter.web.core.ActivityHelper. getRuleUpdatesUI(ActivityHelper.java:2552) [...] Caused by: java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer. java:445) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer. java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java: 879) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531) at oracle.jdbc.driver.T4CPreparedStatement.doOall8( T4CPreparedStatement.java:207) at oracle.jdbc.driver.T4CPreparedStatement. executeForDescribe(T4CPreparedStatement.java:884) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe( OracleStatement.java:1167) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout( OracleStatement.java:1289) at oracle.jdbc.driver.OraclePreparedStatement. executeInternal(OraclePreparedStatement.java:3584) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery( OraclePreparedStatement.java:3628) at oracle.jdbc.driver.OraclePreparedStatementWrapper. executeQuery(OraclePreparedStatementWrapper.java:1493) at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement. pmiExecuteQuery(WSJdbcPreparedStatement.java:1112) at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement. executeQuery(WSJdbcPreparedStatement.java:714) at ilog.rules.teamserver.ejb.service.dao.IlrElementDAOJDBC. retrieveDetailsFromStatement(IlrElementDAOJDBC.java:8565) at ilog.rules.teamserver.ejb.service.dao.IlrElementDAOJDBC. findElements(IlrElementDAOJDBC.java:6984) at ilog.rules.teamserver.ejb.service.IlrSessionFacadeImpl. findObjects(IlrSessionFacadeImpl.java:3892) ... 78 more
Local fix
Problem summary
SQL query generated to open the console do not scale properly with oracle where only 1000 literal can be added to a list
Problem conclusion
The code is fixed
Temporary fix
Comments
APAR Information
APAR number
RS02073
Reported component name
WS DECISION CTR
Reported component ID
5725B6900
Reported release
851
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2015-07-20
Closed date
2015-07-29
Last modified date
2015-07-29
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
999
Fix information
Fixed component name
WS DECISION CTR
Fixed component ID
5725B6900
Applicable component levels
R851 PSY
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSQP76","label":"IBM Operational Decision Manager"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.5.1","Line of Business":{"code":"LOB45","label":"Automation"}}]
Document Information
Modified date:
03 November 2021