[CONFSERVER-22985] Space directory fails to load: ORA-01795: maximum number of expressions in a list is 1000

Type: Bug
Resolution: Fixed
Priority: Low
Fix Version/s: 4.2.13
Affects Version/s: 3.5
Component/s: None
Labels:
Environment:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
SQL Server 2008

Bug Fix Policy:
View Atlassian Server bug fix policy

When visiting the Spaces Directory page an SQL Exception is thrown. Attached is a patch, also see https://support.atlassian.com/browse/CSP-64954.

2011-07-28 16:11:02,245 ERROR [http-8080-Processor25] [sf.hibernate.util.JDBCExceptionReporter] logExceptions ORA-01795: maximum number of expressions in a list is 1000

 -- url: /confluence/spacedirectory/view.action | userName: testuser | referer: http://paulaner:8080/confluence/display/ds/Home | action: view
2011-07-28 16:11:02,248 ERROR [http-8080-Processor25] [sf.hibernate.util.JDBCExceptionReporter] logExceptions ORA-01795: maximum number of expressions in a list is 1000

 -- url: /confluence/spacedirectory/view.action | userName: testuser | referer: http://paulaner:8080/confluence/display/ds/Home | action: view
2011-07-28 16:11:02,249 ERROR [http-8080-Processor25] [velocity] logVelocityMessage Exception in macro #paginationBase at template/includes/macros.vm[line 295, column 5]
 -- url: /confluence/spacedirectory/view.action | userName: testuser | referer: http://paulaner:8080/confluence/display/ds/Home | action: view
2011-07-28 16:11:02,250 ERROR [http-8080-Processor25] [velocity] logVelocityMessage Exception in macro #pagination at /templates/spacedirectory.vm[line 60, column 21]
 -- url: /confluence/spacedirectory/view.action | userName: testuser | referer: http://paulaner:8080/confluence/display/ds/Home | action: view
2011-07-28 16:11:02,252 ERROR [http-8080-Processor25] [opensymphony.webwork.dispatcher.VelocityResult] doExecute Unable to render Velocity Template, '/templates/spacedirectory.vm'
 -- url: /confluence/spacedirectory/view.action | userName: testuser | referer: http://paulaner:8080/confluence/display/ds/Home | action: view
org.apache.velocity.exception.MethodInvocationException: Invocation of method 'getStartIndex' in  class com.atlassian.confluence.plugins.spacedirectory.util.ListBuilderPaginationSupport threw exception org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000
 at template/includes/macros.vm[line 221, column 52]
	at org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:223)
	at org.apache.velocity.runtime.parser.node.ASTReference.execute(ASTReference.java:252)
	at org.apache.velocity.runtime.parser.node.ASTReference.value(ASTReference.java:487)
	at org.apache.velocity.runtime.parser.node.ASTMathNode.value(ASTMathNode.java:84)
	at org.apache.velocity.runtime.parser.node.ASTExpression.value(ASTExpression.java:71)
	at org.apache.velocity.runtime.parser.node.ASTSetDirective.render(ASTSetDirective.java:142)
	at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
	at org.apache.velocity.runtime.parser.node.ASTIfStatement.render(ASTIfStatement.java:87)
	at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
	at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:212)
	at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:247)
	at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:175)
	at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
	at org.apache.velocity.runtime.directive.VelocimacroProxy.render(VelocimacroProxy.java:212)
	at org.apache.velocity.runtime.directive.RuntimeMacro.render(RuntimeMacro.java:247)
	at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:175)
	at org.apache.velocity.runtime.parser.node.ASTBlock.render(ASTBlock.java:72)
	at com.atlassian.confluence.setup.velocity.ApplyDecoratorDirective.render(ApplyDecoratorDirective.java:159)
	at org.apache.velocity.runtime.parser.node.ASTDirective.render(ASTDirective.java:175)
	at org.apache.velocity.runtime.parser.node.SimpleNode.render(SimpleNode.java:336)
	at org.apache.velocity.Template.merge(Template.java:328)
	at org.apache.velocity.Template.merge(Template.java:235)
	at com.opensymphony.webwork.dispatcher.VelocityResult.doExecute(VelocityResult.java:91)
	at com.atlassian.xwork.results.ProfiledVelocityResult.doExecute(ProfiledVelocityResult.java:21)
	at com.opensymphony.webwork.dispatcher.WebWorkResultSupport.execute(WebWorkResultSupport.java:116)
	at com.opensymphony.xwork.DefaultActionInvocation.executeResult(DefaultActionInvocation.java:263)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:187)
	at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
	at com.atlassian.confluence.util.LoggingContextInterceptor.intercept(LoggingContextInterceptor.java:49)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
	at com.atlassian.confluence.core.CancellingInterceptor.intercept(CancellingInterceptor.java:23)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
	at com.atlassian.confluence.security.websudo.WebSudoInterceptor.intercept(WebSudoInterceptor.java:58)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
	at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:57)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
	at com.atlassian.confluence.setup.webwork.BootstrapAwareInterceptor.intercept(BootstrapAwareInterceptor.java:26)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
	at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
	at com.atlassian.confluence.user.actions.UserAwareInterceptor.intercept(UserAwareInterceptor.java:58)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
	at com.atlassian.confluence.pages.actions.CommentAwareInterceptor.intercept(CommentAwareInterceptor.java:43)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
	at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:106)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
	at com.atlassian.confluence.spaces.actions.SpaceAwareInterceptor.intercept(SpaceAwareInterceptor.java:68)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
	at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
	at com.atlassian.confluence.core.actions.LastModifiedInterceptor.intercept(LastModifiedInterceptor.java:38)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
	at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:38)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
	at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
	at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
	at com.atlassian.xwork.interceptors.TransactionalInvocation.invokeAndHandleExceptions(TransactionalInvocation.java:76)
	at com.atlassian.xwork.interceptors.TransactionalInvocation.invokeInTransaction(TransactionalInvocation.java:61)
	at com.atlassian.xwork.interceptors.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:56)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
	at com.atlassian.confluence.xwork.SetupIncompleteInterceptor.intercept(SetupIncompleteInterceptor.java:40)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
	at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:35)
	at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:165)
	at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115)
	at com.atlassian.confluence.servlet.ConfluenceServletDispatcher.serviceAction(ConfluenceServletDispatcher.java:53)
	at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:199)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66)
	at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:25)
	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74)
	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.confluence.security.websudo.MessagesDecoratorFilter.doFilter(MessagesDecoratorFilter.java:49)
	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:118)
	at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:84)
	at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:54)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.confluence.jmx.JmxFilter.doFilter(JmxFilter.java:106)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.core.filters.ServletContextThreadLocalFilter.doFilter(ServletContextThreadLocalFilter.java:19)
	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.confluence.util.LoggingContextFilter.doFilter(LoggingContextFilter.java:40)
	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.confluence.web.filter.ThreadLocalCacheFilter.doFilter(ThreadLocalCacheFilter.java:22)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.confluence.util.UserThreadLocalFilter.doFilter(UserThreadLocalFilter.java:44)
	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:211)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:98)
	at com.atlassian.confluence.util.AbstractBootstrapHotSwappingFilter.doFilter(AbstractBootstrapHotSwappingFilter.java:30)
	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.seraph.filter.BaseLoginFilter.doFilter(BaseLoginFilter.java:150)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66)
	at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:71)
	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74)
	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.confluence.util.ClusterHeaderFilter.doFilter(ClusterHeaderFilter.java:34)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter(AbstractJohnsonFilter.java:72)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:170)
	at com.atlassian.spring.filter.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:29)
	at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:75)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.confluence.util.ConfluenceErrorFilter.doFilter(ConfluenceErrorFilter.java:22)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:99)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.confluence.core.datetime.RequestTimeThreadLocalFilter.doFilter(RequestTimeThreadLocalFilter.java:35)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.gzipfilter.GzipFilter.doFilterInternal(GzipFilter.java:81)
	at com.atlassian.gzipfilter.GzipFilter.doFilter(GzipFilter.java:51)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.core.filters.cache.AbstractCachingFilter.doFilter(AbstractCachingFilter.java:33)
	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:46)
	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter(DelegatingPluginFilter.java:66)
	at com.atlassian.confluence.extra.webdav.servlet.filter.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:43)
	at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter(DelegatingPluginFilter.java:74)
	at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter(IteratingFilterChain.java:42)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:77)
	at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter(ServletFilterModuleContainerFilter.java:63)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.confluence.web.filter.validateparam.RequestParamValidationFilter.doFilter(RequestParamValidationFilter.java:58)
	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.confluence.plugin.servlet.filter.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:71)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.confluence.web.filter.LanguageExtractionFilter.doFilter(LanguageExtractionFilter.java:52)
	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.confluence.util.RequestCacheThreadLocalFilter.doFilter(RequestCacheThreadLocalFilter.java:25)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:41)
	at com.atlassian.core.filters.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.core.filters.HeaderSanitisingFilter.doFilter(HeaderSanitisingFilter.java:44)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at com.atlassian.confluence.servlet.FourOhFourErrorLoggingFilter.doFilter(FourOhFourErrorLoggingFilter.java:65)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)
	at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
	at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
	at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
	at java.lang.Thread.run(Thread.java:680)
Caused by: org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar []; nested exception is java.sql.SQLException: ORA-01795: maximum number of expressions in a list is 1000

	at org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:107)
	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.spaces.persistence.dao.hibernate.HibernateSpaceDao.countSpaces(HibernateSpaceDao.java:447)
	at com.atlassian.confluence.spaces.DefaultSpaceManager$1.getAvailableSize(DefaultSpaceManager.java:795)
	at com.atlassian.confluence.core.DefaultListBuilder.getAvailableSize(DefaultListBuilder.java:51)
	at com.atlassian.confluence.plugins.spacedirectory.util.ListBuilderPaginationSupport.getTotal(ListBuilderPaginationSupport.java:161)
	at com.atlassian.confluence.plugins.spacedirectory.util.ListBuilderPaginationSupport.getStartIndex(ListBuilderPaginationSupport.java:39)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
	at java.lang.reflect.Method.invoke(Method.java:597)
	at org.apache.velocity.runtime.parser.node.PropertyExecutor.execute(PropertyExecutor.java:142)
	at org.apache.velocity.util.introspection.UberspectImpl$VelGetterImpl.invoke(UberspectImpl.java:533)
	at org.apache.velocity.runtime.parser.node.ASTIdentifier.execute(ASTIdentifier.java:198)
	... 206 more
Caused by: 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:1038)
	at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1133)
	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
	at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
	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:1552)
	at net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:49)
	at net.sf.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:550)
	at com.atlassian.confluence.spaces.persistence.dao.hibernate.HibernateSpaceDao$7.doInHibernate(HibernateSpaceDao.java:455)
	at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:370)
	... 219 more

The equivalent error in SQL Server database:

Error formatting macro: recently-updated-dashboard: org.springframework.dao.DataIntegrityViolationException: Hibernate operation: Could not execute query; SQL []; Prepared or callable statement has more than 2000 parameter markers.; nested exception is java.sql.SQLException: Prepared or callable statement has more than 2000 parameter markers.

- - Sort By Name
  - Sort By Date
  - Ascending
  - Descending
  - Thumbnails
  - List

CSP-64954.patch
2 kB
01/Aug/2011 12:19 AM
CSP-64954.zip
3 kB
19/Oct/2011 7:42 PM

is related to

CONFSERVER-21870 "maximum number of expressions in a list is 1000" error when user is in more than 1000 groups visits dashboard

Closed

CONFSERVER-27470 ORA-01795 is thrown when Scheduled Job for Workbox Notifications is run

Closed

CONFSERVER-40394 Space export fails with error: "Couldn't backup database data"

Closed

CONFSERVER-42654 Custom Space Export Fails With "Prepared or callable statement has more than 2000 parameter markers"

Gathering Impact

CONFSERVER-44260 Confluence Throws Error ORA-01795 and Instance is Slow - page comments

Gathering Impact

CONFSERVER-53056 Content report table macro throwing ora-01795 error

Gathering Impact

relates to

CONFSERVER-43504 ORA-01795 is thrown when a single page have more than 1000 attachments

Gathering Impact

(1 is related to, 1 relates to)

GBE added a comment - 05/Jan/2017 4:13 PM

I have been redirected to this page by Hercules Log Analyzer due to the error (in SQL Context):

.

 Hibernate operation: Could not execute query; SQL []; Prepared or callable statement has more than 2000 parameter markers.; nested exception is java.sql.SQLException: Prepared or callable statement has more than 2000 parameter markers.

However, the correct link should be https://jira.atlassian.com/browse/CONF-42654 in the context of a XML Export

It might be useful for others!

GBE added a comment - 05/Jan/2017 4:13 PM I have been redirected to this page by Hercules Log Analyzer due to the error (in SQL Context): . Hibernate operation: Could not execute query; SQL []; Prepared or callable statement has more than 2000 parameter markers.; nested exception is java.sql.SQLException: Prepared or callable statement has more than 2000 parameter markers. However, the correct link should be https://jira.atlassian.com/browse/CONF-42654 in the context of a XML Export It might be useful for others!

Jeremy Largman added a comment - 15/Mar/2013 10:31 PM

I've checked the source for 4.2.12 and 4.2.13 and the code was actually committed in 4.2.13. I'm correcting the Fix Version.

Jeremy Largman added a comment - 15/Mar/2013 10:31 PM I've checked the source for 4.2.12 and 4.2.13 and the code was actually committed in 4.2.13. I'm correcting the Fix Version.

Craig Solinski added a comment - 11/Jun/2012 6:28 PM - edited

Patch fixed the problem.

Thanks,
Craig

Craig Solinski added a comment - 11/Jun/2012 6:28 PM - edited Patch fixed the problem. Thanks, Craig

Craig Solinski added a comment - 11/Jun/2012 3:46 PM - edited

It seems to be an embedded crowd error.

User specific, when user has a lot of ADS groups (this user is currently in 337 ADS groups), whenever going to Dashboard gets macro error. Snippet of log shows:

2012-06-11 11:42:57,783 INFO [TP-Processor20] [atlassian.crowd.directory.DelegatedAuthenticationDirectory] importGroups Imported remote group "obprd_TAX-Vendor Index" to directory "Delegated Authentication Directory".
2012-06-11 11:42:57,793 INFO [TP-Processor20] [atlassian.crowd.directory.DelegatedAuthenticationDirectory] importMembership Imported user "keder"'s membership of remote group "obprd_TAX-Vendor Index" to directory "Delegated Authentication Directory".
2012-06-11 11:42:58,524 ERROR [TP-Processor20] [sf.hibernate.util.JDBCExceptionReporter] logExceptions ORA-01795: maximum number of expressions in a list is 1000

 -- referer: https://test.uisapp2.iu.edu/confluence-stg/dashboard.action | url: /confluence-stg/dashboard.action | userName: keder | action: dashboard
2012-06-11 11:42:58,531 ERROR [TP-Processor20] [sf.hibernate.util.JDBCExceptionReporter] logExceptions ORA-01795: maximum number of expressions in a list is 1000

 -- referer: https://test.uisapp2.iu.edu/confluence-stg/dashboard.action | url: /confluence-stg/dashboard.action | userName: keder | action: dashboard
2012-06-11 11:42:58,537 ERROR [TP-Processor20] [renderer.v2.components.MacroRendererComponent] processMacro Unexpected error formatting macro: spaces
 -- referer: https://test.uisapp2.iu.edu/confluence-stg/dashboard.action | url: /confluence-stg/dashboard.action | userName: keder | action: dashboard
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

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

	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440)

At our institution we are forced to use Confluence Option to 'sync LDAP groups upon login' due to size of ADS (LDAP) DB.

Thanks,
Craig

Craig Solinski added a comment - 11/Jun/2012 3:46 PM - edited It seems to be an embedded crowd error. User specific, when user has a lot of ADS groups (this user is currently in 337 ADS groups), whenever going to Dashboard gets macro error. Snippet of log shows: 2012-06-11 11:42:57,783 INFO [TP-Processor20] [atlassian.crowd.directory.DelegatedAuthenticationDirectory] importGroups Imported remote group "obprd_TAX-Vendor Index" to directory "Delegated Authentication Directory" . 2012-06-11 11:42:57,793 INFO [TP-Processor20] [atlassian.crowd.directory.DelegatedAuthenticationDirectory] importMembership Imported user "keder" 's membership of remote group "obprd_TAX-Vendor Index" to directory "Delegated Authentication Directory" . 2012-06-11 11:42:58,524 ERROR [TP-Processor20] [sf.hibernate.util.JDBCExceptionReporter] logExceptions ORA-01795: maximum number of expressions in a list is 1000 -- referer: https: //test.uisapp2.iu.edu/confluence-stg/dashboard.action | url: /confluence-stg/dashboard.action | userName: keder | action: dashboard 2012-06-11 11:42:58,531 ERROR [TP-Processor20] [sf.hibernate.util.JDBCExceptionReporter] logExceptions ORA-01795: maximum number of expressions in a list is 1000 -- referer: https: //test.uisapp2.iu.edu/confluence-stg/dashboard.action | url: /confluence-stg/dashboard.action | userName: keder | action: dashboard 2012-06-11 11:42:58,537 ERROR [TP-Processor20] [renderer.v2.components.MacroRendererComponent] processMacro Unexpected error formatting macro: spaces -- referer: https: //test.uisapp2.iu.edu/confluence-stg/dashboard.action | url: /confluence-stg/dashboard.action | userName: keder | action: dashboard 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 Caused by: java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000 at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) At our institution we are forced to use Confluence Option to 'sync LDAP groups upon login' due to size of ADS (LDAP) DB. Thanks, Craig

Craig Solinski added a comment - 11/Jun/2012 3:24 PM

Same Confluence error started hitting us last week, Confluence Version: 3.5.16

We only have 179 spaces.

Seems to only affect users with a lot of ADS groups.

Running Linux Linux 2.6.18-308.4.1.el5, Oracle 11.2.0.2.0, OS Architecture: amd64, App Server: Apache Tomcat/5.5.27

Craig
Indiana University

Craig Solinski added a comment - 11/Jun/2012 3:24 PM Same Confluence error started hitting us last week, Confluence Version: 3.5.16 We only have 179 spaces. Seems to only affect users with a lot of ADS groups. Running Linux Linux 2.6.18-308.4.1.el5, Oracle 11.2.0.2.0, OS Architecture: amd64, App Server: Apache Tomcat/5.5.27 Craig Indiana University

Guilherme Nedel (Inactive) added a comment - 19/Oct/2011 6:58 PM - edited

How to apply the patch

To apply it you need to extract the attached zip file at the root of your Confluence installation directory. To test that it has been applied, can you please check that the file confluence/WEB-INF/classes/com/atlassian/confluence/spaces/persistence/dao/hibernate/HibernateSpacesQueryBuilder.class exists.

You'll need to restart Confluence for the changes to take effect, and then hopefully the issue will be resolved.

as per Sam directions

Guilherme Nedel (Inactive) added a comment - 19/Oct/2011 6:58 PM - edited How to apply the patch To apply it you need to extract the attached zip file at the root of your Confluence installation directory. To test that it has been applied, can you please check that the file confluence/WEB-INF/classes/com/atlassian/confluence/spaces/persistence/dao/hibernate/HibernateSpacesQueryBuilder.class exists. You'll need to restart Confluence for the changes to take effect, and then hopefully the issue will be resolved. as per Sam directions

Matt Ryall added a comment - 15/Aug/2011 1:18 AM

Needs a test:

go to space directory with ~250 spaces
possibly requires group permissions configured on each space.

Matt Ryall added a comment - 15/Aug/2011 1:18 AM Needs a test: go to space directory with ~250 spaces possibly requires group permissions configured on each space.

Confluence Data Center

Details

Description

Attachments

Attachments

Issue Links

Forms

Activity

Collapse comment: GBE added a comment - 05/Jan/2017 4:13 PM

Expand comment: GBE added a comment - 05/Jan/2017 4:13 PM

Collapse comment: Jeremy Largman added a comment - 15/Mar/2013 10:31 PM

Expand comment: Jeremy Largman added a comment - 15/Mar/2013 10:31 PM

Collapse comment: Craig Solinski added a comment - 11/Jun/2012 6:28 PM, Edited by Craig Solinski - 11/Jun/2012 7:45 PM

Expand comment: Craig Solinski added a comment - 11/Jun/2012 6:28 PM, Edited by Craig Solinski - 11/Jun/2012 7:45 PM

Collapse comment: Craig Solinski added a comment - 11/Jun/2012 3:46 PM, Edited by Craig Solinski - 11/Jun/2012 5:46 PM

Expand comment: Craig Solinski added a comment - 11/Jun/2012 3:46 PM, Edited by Craig Solinski - 11/Jun/2012 5:46 PM

Collapse comment: Craig Solinski added a comment - 11/Jun/2012 3:24 PM

Expand comment: Craig Solinski added a comment - 11/Jun/2012 3:24 PM

Collapse comment: Guilherme Nedel (Inactive) added a comment - 19/Oct/2011 6:58 PM, Edited by Guilherme Nedel - 19/Oct/2011 7:43 PM

Expand comment: Guilherme Nedel (Inactive) added a comment - 19/Oct/2011 6:58 PM, Edited by Guilherme Nedel - 19/Oct/2011 7:43 PM

Collapse comment: Matt Ryall added a comment - 15/Aug/2011 1:18 AM

Expand comment: Matt Ryall added a comment - 15/Aug/2011 1:18 AM

People

Dates

Time Tracking