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

Oracle Community | deahayes | 3 months ago
  1. 0

    Bi Publisher errors on multiselect

    Oracle Community | 3 months ago | deahayes
    java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
  2. 0

    BI Publisher Data-Models : text parameter (with comma-separated) nullity test

    Oracle Community | 2 years ago | steve80lyon
    java.sql.SQLSyntaxErrorException: ORA-00920: invalid relational operator
  3. 0

    Invalid identifier when linking more than one data sets in a data model

    Oracle Community | 6 years ago | 862563
    java.sql.SQLSyntaxErrorException: ORA-00904: "MANAGER_KEY_2": invalid identifier[[
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error was thrown where Confluence (with Oracle Database) is trying to export a large space. {code} 2015-12-08 14:35:49,592 INFO [Long running task: Export Space] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 4937: "Reindexes all PersonalInformation objects, creating them for any users that do not have one." - Ok 2015-12-08 14:35:49,592 INFO [Long running task: Export Space] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 4526: "Remove the legacy remotable apps plugin from the user installed plugins" - Ok 2015-12-08 14:35:49,593 INFO [Long running task: Export Space] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Build number 4517: "Migrate all Page Templates using a storage format round-trip conversion" - Not Ok 2015-12-08 14:35:49,593 INFO [Long running task: Export Space] [atlassian.confluence.upgrade.AbstractUpgradeManager] getExportBuildNumber Backward compatibility for export: "Migrate all Page Templates using a storage format round-trip conversion" prevents compatibility before 4517 2015-12-08 14:36:48,836 ERROR [Long running task: Export Space] [sf.hibernate.util.JDBCExceptionReporter] logExceptions ORA-01795: maximum number of expressions in a list is 1000 -- referer: https://www-test.wiki.ed.ac.uk/spaces/exportspacexml.action?key=GenePool | url: /spaces/doexportspace.action | userName: aforres3 | action: doexportspace 2015-12-08 14:36:48,837 ERROR [Long running task: Export Space] [sf.hibernate.util.JDBCExceptionReporter] logExceptions ORA-01795: maximum number of expressions in a list is 1000 -- referer: https://www-test.wiki.ed.ac.uk/spaces/exportspacexml.action?key=GenePool | url: /spaces/doexportspace.action | userName: aforres3 | action: doexportspace 2015-12-08 14:36:48,837 ERROR [Long running task: Export Space] [confluence.importexport.impl.AbstractXmlExporter] backupEntities Couldn't backup database data. -- referer: https://www-test.wiki.ed.ac.uk/spaces/exportspacexml.action?key=GenePool | url: /spaces/doexportspace.action | userName: aforres3 | action: doexportspace org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000 at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.doTranslate(SQLStateSQLExceptionTranslator.java:97) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.orm.hibernate.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:364) at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:351) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:337) at com.atlassian.confluence.like.HibernateLikeEntityDao.getLikeEntities(HibernateLikeEntityDao.java:138) at com.atlassian.confluence.importexport.impl.XmlExporterObjectHandleCollector.getLikesFromContent(XmlExporterObjectHandleCollector.java:174) at com.atlassian.confluence.importexport.impl.XmlExporterObjectHandleCollector.getContentAndContentPropertiesFromSpace(XmlExporterObjectHandleCollector.java:136) at com.atlassian.confluence.importexport.impl.XmlExporterObjectHandleCollector.addEntityHandlesFromSpace(XmlExporterObjectHandleCollector.java:118) at com.atlassian.confluence.importexport.impl.XmlExporterObjectHandleCollector.getObjectHandles(XmlExporterObjectHandleCollector.java:94) at com.atlassian.confluence.importexport.impl.XmlExporterObjectHandleCollector.getHandlesOfObjectsForExport(XmlExporterObjectHandleCollector.java:82) at com.atlassian.confluence.importexport.impl.XmlExporter.getHandlesOfObjectsForExport(XmlExporter.java:118) at com.atlassian.confluence.importexport.impl.AbstractXmlExporter.backupEntities(AbstractXmlExporter.java:218) at com.atlassian.confluence.importexport.impl.AbstractXmlExporter.backupEverything(AbstractXmlExporter.java:104) at com.atlassian.confluence.importexport.impl.FileXmlExporter.backupEverything(FileXmlExporter.java:96) at com.atlassian.confluence.importexport.impl.AbstractXmlExporter.doExport(AbstractXmlExporter.java:97) at com.atlassian.confluence.importexport.impl.FileXmlExporter.doExport(FileXmlExporter.java:54) at com.atlassian.confluence.importexport.impl.XmlExporter.doExport(XmlExporter.java:51) at com.atlassian.confluence.importexport.DefaultImportExportManager.exportAs(DefaultImportExportManager.java:122) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at com.sun.proxy.$Proxy121.exportAs(Unknown Source) at com.atlassian.confluence.importexport.actions.ExportSpaceLongRunningTask$1.doInTransactionWithoutResult(ExportSpaceLongRunningTask.java:163) at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) at com.atlassian.confluence.importexport.actions.ExportSpaceLongRunningTask.runInternal(ExportSpaceLongRunningTask.java:124) at com.atlassian.confluence.util.longrunning.ConfluenceAbstractLongRunningTask.run(ConfluenceAbstractLongRunningTask.java:27) at com.atlassian.confluence.util.longrunning.ManagedTask.run(ManagedTask.java:58) at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source) at java.util.concurrent.FutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:225) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:53) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:774) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:925) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1111) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4798) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4845) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1501) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76) at net.sf.hibernate.impl.BatcherImpl.getResultSet(BatcherImpl.java:89) at net.sf.hibernate.loader.Loader.getResultSet(Loader.java:880) at net.sf.hibernate.loader.Loader.doQuery(Loader.java:273) at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:138) at net.sf.hibernate.loader.Loader.doList(Loader.java:1063) at net.sf.hibernate.loader.Loader.list(Loader.java:1048) at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:854) at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1570) at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49) at com.atlassian.confluence.like.HibernateLikeEntityDao$6.doInHibernate(HibernateLikeEntityDao.java:147) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370) ... 37 more {code} Seems like oracle is limiting the expression to 1000 which causing the export to fail. !exportfaileddd.png|thumbnail!

    Atlassian JIRA | 11 months ago | Jonathan Soo [Atlassian]
    org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar []; nested exception is java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.sql.SQLSyntaxErrorException

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

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