java.sql.SQLSyntaxErrorException

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

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web659

  • via Unknown by deahayes,
  • Stack trace

    • java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:466) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:407) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1113) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:546) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:269) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:603) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:234) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:55) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:829) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1049) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1263) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:5010) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:5070) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1677) at oracle.xdo.dataengine.XMLPGEN.processQuery(XMLPGEN.java:2106) at oracle.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:552) at oracle.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:460) at oracle.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:361) at oracle.xdo.dataengine.XMLPGEN.writeXMLDataStructure(XMLPGEN.java:294) at oracle.xdo.dataengine.XMLPGEN.processDataSet(XMLPGEN.java:1996) at oracle.xdo.dataengine.XMLPGEN.processMergedDataSet(XMLPGEN.java:1602) at oracle.xdo.dataengine.DataProcessor.processData(DataProcessor.java:379) at oracle.xdo.servlet.dataengine.DataProcessorImpl.processData(DataProcessorImpl.java:309) at oracle.xdo.servlet.dataengine.DataProcessorImpl.render(DataProcessorImpl.java:684) at oracle.xdo.servlet.ReportModelContextImpl.getReportXMLData(ReportModelContextImpl.java:324) at oracle.xdo.servlet.CoreProcessor.process(CoreProcessor.java:525) at oracle.xdo.servlet.CoreProcessor.generateDocument(CoreProcessor.java:113) at oracle.xdo.servlet.ReportImpl.renderBodyHTTP(ReportImpl.java:1245) at oracle.xdo.servlet.ReportImpl.renderReportBodyHTTP(ReportImpl.java:722) at oracle.xdo.servlet.resources.ReportItemServiceImpl.runSynch(ReportItemServiceImpl.java:210) at oracle.xdo.servlet.resources.ReportItemServiceImpl.run(ReportItemServiceImpl.java:192) at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:497) at oracle.xdo.servlet.XDOServlet.writeReport(XDOServlet.java:466) at oracle.xdo.servlet.XDOServlet.doGet(XDOServlet.java:265) at javax.servlet.http.HttpServlet.service(HttpServlet.java:687) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:280) at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:254) at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:136) at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:350) at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:25) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) at oracle.xdo.servlet.metadata.track.MostRecentFilter.doFilter(MostRecentFilter.java:74) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) at oracle.xdo.servlet.security.SecurityFilter.doFilter(SecurityFilter.java:186) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) at oracle.xdo.servlet.init.InitCheckingFilter.doFilter(InitCheckingFilter.java:63) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:141) at java.security.AccessController.doPrivileged(Native Method) at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:315) at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:649) at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:124) at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:232) at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:94) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:224) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) at weblogic.servlet.internal.RequestEventsFilter.doFilter(RequestEventsFilter.java:32) at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:78) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3653) at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3619) at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:326) at weblogic.security.service.SecurityManager.runAsForUserCode(SecurityManager.java:196) at weblogic.servlet.provider.WlsSecurityProvider.runAsForUserCode(WlsSecurityProvider.java:196) at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:66) at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2422) at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2279) at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2257) at weblogic.servlet.internal.ServletRequestImpl.runInternal(ServletRequestImpl.java:1624) at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1584) at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:270) at weblogic.invocation.ComponentInvocationContextManager._runAs(ComponentInvocationContextManager.java:348) at weblogic.invocation.ComponentInvocationContextManager.runAs(ComponentInvocationContextManager.java:333) at weblogic.work.LivePartitionUtility.doRunWorkUnderContext(LivePartitionUtility.java:54) at weblogic.work.PartitionUtility.runWorkUnderContext(PartitionUtility.java:41) at weblogic.work.SelfTuningWorkManagerImpl.runWorkUnderContext(SelfTuningWorkManagerImpl.java:610) at weblogic.work.ExecuteThread.execute(ExecuteThread.java:391) at weblogic.work.ExecuteThread.run(ExecuteThread.java:340)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    79 more bugmates