"ORA-01795: maximum number of expressions in a list is 1000" Exception Trying to Export Records from Online Booking/Tendering (Doc ID 1663295.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Transportation Management - Version 6.0 to 6.3.5 [Release 6 to 6.3]
Information in this document applies to any platform.

Symptoms

When trying to export all the records from Online Booking/Tendering (Shipment Management -> Online Booking/Tendering -> Search -> Export), the following error is thrown:

java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000

at java.lang.Throwable.(Throwable.java:67)
at java.sql.SQLException.(SQLException.java:101)
at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:68)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1187)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3386)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3430)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at weblogic.jdbc.wrapper.PreparedStatement.executeQuery(PreparedStatement.java:135)
at glog.util.jdbc.noserver.SqlQuery.executeQuery(SqlQuery.java:164)
at glog.util.jdbc.noserver.SqlQuery.resetArguments(SqlQuery.java:137)
at glog.util.jdbc.noserver.SqlQuery.open(SqlQuery.java:107)
at glog.server.executionapi.servprov.tenderresp.TenderSessionBean.getLocationTimezoneDetails(TenderSessionBean.java:543)
at glog.server.executionapi.servprov.tenderresp.TenderSessionServerSideEJBWrapper.getLocationTimezoneDetails(TenderSessionServerSideEJBWrapper.java:458)
at glog.server.executionapi.servprov.tenderresp.TenderSessionHome_vasp01_EOImpl.getLocationTimezoneDetails(TenderSessionHome_vasp01_EOImpl.java:69)
at glog.server.executionapi.servprov.tenderresp.TenderSessionHome_vasp01_EOImpl_WLSkel.invoke(Unknown Source)
at weblogic.rmi.internal.BasicServerRef.invoke(BasicServerRef.java:589)
at weblogic.rmi.cluster.ClusterableServerRef.invoke(ClusterableServerRef.java:230)
at weblogic.rmi.internal.BasicServerRef$1.run(BasicServerRef.java:477)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:363)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:147)
at weblogic.rmi.internal.BasicServerRef.handleRequest(BasicServerRef.java:473)
at weblogic.rmi.internal.wls.WLSExecuteRequest.run(WLSExecuteRequest.java:118)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:201)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:173)

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