[#HHQ-1628] Oracle has a limitation of 1000 values in a SQL "IN" stmt. HQ needs to address this

Hyperic HQ

Oracle has a limitation of 1000 values in a SQL "IN" stmt. HQ needs to address this

Created: 12/Feb/08 10:41 AM Updated: Wednesday 11:02 AM

Component/s:

Server

Affects Version/s:

3.2.0

Fix Version/s:

3.2.7

Verify By:	Kashyap Parikh
Last comment:	21 weeks, 6 days ago

Sub-Tasks:

All

Open

~~Upgrading from 3.2.5-EE to 4.0.0-EE build 856 displays error in server log~~

Closed

Scott Feldstein

Description

« Hide

ORA-01795: maximum number of expressions in a list is 1000

This mainly affects the DataManager.

All

Comments

Change History

Sort Order:

Ascending order - Click to sort in descending order

[ Permlink | « Hide ]

Ryan Morgan - 12/Feb/08 11:04 AM

I assume ~~HHQ-1627~~ is a duplicate?

[ Permlink | « Hide ]

Ryan Morgan - 21/Feb/08 10:02 AM

Move to 3.2.2.

[ Permlink | « Hide ]

Kashyap Parikh - 13/Mar/08 11:20 AM

Marking major and moving to 3.2.3

[ Permlink | « Hide ]

Doug MacEachern - 20/Jun/08 01:00 PM

Seeing this on a Network Device Interface auto-group with 52 services:

2008-06-20 14:56:34,938 [http-0.0.0.0-7080-4] WARN [DataManagerEJBImpl] getAggregateData()
java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
at org.jboss.resource.adapter.jdbc.CachedPreparedStatement.executeQuery(CachedPreparedStatement.java:76)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:211)
at org.hyperic.hibernate.dialect.HQDialectUtil.getAggData(HQDialectUtil.java:115)
at org.hyperic.hibernate.dialect.Oracle9Dialect.getAggData(Oracle9Dialect.java:135)
at org.hyperic.hq.measurement.server.session.DataManagerEJBImpl.getAggregateData(DataManagerEJBImpl.java:1988)