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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Atlassian JIRA by Juan Palacios [Atlassian], 1 year ago
ORA-01795: maximum number of expressions in a list is 1000
via Atlassian JIRA by Juan Palacios [Atlassian], 1 year ago
ORA-01795: maximum number of expressions in a list is 1000
via Atlassian JIRA by Amalia Sanusi [Atlassian], 1 year ago
ORA-01795: maximum number of expressions in a list is 1000
via Atlassian JIRA by Amalia Sanusi [Atlassian], 1 year ago
ORA-01795: maximum number of expressions in a list is 1000
java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
at com.atlassian.activeobjects.internal.EntityManagedActiveObjects.delete(EntityManagedActiveObjects.java:137)
at com.atlassian.activeobjects.osgi.TenantAwareActiveObjects.delete(TenantAwareActiveObjects.java:311)
at com.atlassian.stash.internal.repository.sync.dao.AoRefSyncDao.removeRefs(AoRefSyncDao.java:182)
at com.atlassian.stash.internal.repository.sync.dao.AoRefSyncDao.setEnabled(AoRefSyncDao.java:95)
at com.atlassian.stash.internal.repository.sync.DefaultRefSyncService$SetEnabledAndSynchronizeOperation$1.execute(DefaultRefSyncService.java:550)
at com.atlassian.stash.internal.repository.sync.DefaultRefSyncService$SetEnabledAndSynchronizeOperation$1.execute(DefaultRefSyncService.java:546)
at com.atlassian.stash.ao.AbstractAoTransactionCallback.doInTransaction(AbstractAoTransactionCallback.java:21)
at com.atlassian.sal.core.transaction.HostContextTransactionTemplate$1.doInTransaction(HostContextTransactionTemplate.java:25)
at com.atlassian.stash.internal.sal.spi.HostContextAccessorImpl.doInTransaction(HostContextAccessorImpl.java:27)
at com.atlassian.sal.core.transaction.HostContextTransactionTemplate.execute(HostContextTransactionTemplate.java:21)
at com.atlassian.stash.internal.repository.sync.DefaultRefSyncService$SetEnabledAndSynchronizeOperation.perform(DefaultRefSyncService.java:546)
at com.atlassian.stash.internal.repository.sync.DefaultRefSyncService$SetEnabledAndSynchronizeOperation.perform(DefaultRefSyncService.java:532)
at com.atlassian.stash.util.TimerUtils.time(TimerUtils.java:54)
at com.atlassian.stash.internal.repository.sync.DefaultRefSyncService.time(DefaultRefSyncService.java:300)
at com.atlassian.stash.internal.repository.sync.DefaultRefSyncService.setEnabled(DefaultRefSyncService.java:218)
at com.atlassian.stash.internal.repository.sync.rest.RefSyncResource.setEnabled(RefSyncResource.java:131)
at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter(ContextFilter.java:25)
at com.atlassian.stash.internal.spring.security.StashAuthenticationFilter.doFilter(StashAuthenticationFilter.java:86)
at com.atlassian.stash.internal.web.auth.BeforeLoginPluginAuthenticationFilter.doInsideSpringSecurityChain(BeforeLoginPluginAuthenticationFilter.java:111)
at com.atlassian.stash.internal.web.auth.BeforeLoginPluginAuthenticationFilter.doFilter(BeforeLoginPluginAuthenticationFilter.java:77)
at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter(TrustedApplicationsFilter.java:100)
at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter(OAuthFilter.java:79)
at com.atlassian.analytics.client.filter.DefaultAnalyticsFilter.doFilter(DefaultAnalyticsFilter.java:32)
at com.atlassian.analytics.client.filter.AbstractHttpFilter.doFilter(AbstractHttpFilter.java:32)
at com.atlassian.stash.internal.web.auth.BeforeLoginPluginAuthenticationFilter.doBeforeBeforeLoginFilters(BeforeLoginPluginAuthenticationFilter.java:89)
at com.atlassian.stash.internal.web.auth.BeforeLoginPluginAuthenticationFilter.doFilter(BeforeLoginPluginAuthenticationFilter.java:75)
at com.atlassian.stash.internal.request.DefaultRequestManager.doAsRequest(DefaultRequestManager.java:85)
at com.atlassian.stash.internal.hazelcast.ConfigurableWebFilter.doFilter(ConfigurableWebFilter.java:38)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1110)
at java.lang.Thread.run(Thread.java:722)

Users with the same issue

You are the first who have seen this exception.

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.