IBM Support

webMethods Knowlegebase : ORA-01795: maximum number of expressions in a list is 1000 (1761771)

Troubleshooting


Problem

In AE (Analytic Engine) log, the following error is found:

"(OPTIMIZE) [Analytic Engine v9.6.0.0.TemporaryEventStage.UnknownKey] 2013-12-18 12:40:32.912 MET ERROR: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-01795: maximum number of expressions in a list is 1000

(OPTIMIZE) [Analytic Engine v9.6.0.0.TemporaryEventStage.UnknownKey] 2013-12-18 12:40:32.912 MET ERROR: java.sql.SQLException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-01795: maximum number of expressions in a list is 1000

at com.wm.dd.jdbc.oraclebase.ddcr.b(Unknown Source)

at com.wm.dd.jdbc.oraclebase.ddcr.a(Unknown Source) at com.wm.dd.jdbc.oraclebase.ddcq.b(Unknown Source)

at com.wm.dd.jdbc.oraclebase.ddcq.a(Unknown Source)

at com.wm.dd.jdbc.oracle.ddam.t(Unknown Source)

at com.wm.dd.jdbc.oraclebase.dde3.w(Unknown Source)

at com.wm.dd.jdbc.oraclebase.dde3.s(Unknown Source)

at com.wm.dd.jdbc.oraclebase.dddz.execute(Unknown Source)

at com.webmethods.optimize.event.handler.EventMetadataStorage.deleteTemporaryEvents(EventMetadataStorage.java:2158)

at com.webmethods.optimize.event.engine.TemporaryEventStage.cleanupTempEventsForDefinition(TemporaryEventStage.java:208)

at com.webmethods.optimize.event.engine.TemporaryEventStage.onCacheUpdate(TemporaryEventStage.java:198)

at com.webmethods.optimize.caching.CacheNotificationDispatcher$UpdateNotificationTask.run(CacheNotificationDispatcher.java:329)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)

at java.lang.Thread.run(Thread.java:744)"

What needs to be done to resolve this error?

Document Location

Worldwide

[{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSAWP1J","label":"IBM webMethods BPM"},"ARM Category":[{"code":"a8mKe00000000AQIAY","label":"webMethods Optimize for Infrastructure (WMI)"}],"ARM Case Number":"","Platform":[{"code":"PF027","label":"Solaris"}],"Version":"9.6"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
20 March 2025

UID

ibm17197904

Page Feedback