Loading...

This issue belongs to an archived project. You can view it, but you can't modify it. Learn more

XML

Word

Printable

Type: Bug
Resolution: Fixed
Priority: Medium
Fix Version/s: 1.10.0
Affects Version/s: 1.9.6
Component/s: None
Labels:
- affects-server

Bug Fix Policy:
View Atlassian Server bug fix policy

Summary

Importing issues into JPO Backlog Failed with java.sql.SQLException error

Environment

JIRA 6.4.4
JIRA Agile 6.7.4
Jira Portfolio 1.9.6

Steps to Reproduce

Create a board
Choose "initiatives"
Import issues
Repeat until issue occurs

Expected Results

Issues are imported successfully

Actual Results

The below exception is thrown in the atlassian-jira.log file:

Exception timestamp: 1434621271764 

java.sql.SQLException :Failed to execute SQL [SELECT "w0"."ID_OTHER" , "w0"."TYPE" , "w0"."TITLE" , "w0"."DETAILS" , "w0"."SORT_ORDER" , "w0"."VERSION" , "w0"."STATUS" , "w0"."HAS_ORIGINAL_ESTIMATES" , "w0"."AOEARLIEST_START" , "w0"."AOTARGET_START" , "w0"."AOTARGET_END" , "w0"."AOTEAM_ID" , "w0"."AOSPRINT_ID" , "w0"."AORELEASE_ID" , "w0"."AOSTREAM_ID" , "w0"."AOTHEME_ID" , "w1"."ID_OTHER" , "w1"."TYPE" , "w1"."TITLE" , "w1"."DETAILS" , "w1"."SORT_ORDER" , "w1"."VERSION" , "w1"."STATUS" , "w1"."HAS_ORIGINAL_ESTIMATES" , "w1"."AOEARLIEST_START" , "w1"."AOTARGET_START" , "w1"."AOTARGET_END" , "w1"."AOTEAM_ID" , "w1"."AOSPRINT_ID" , "w1"."AORELEASE_ID" , "w1"."AOSTREAM_ID" , "w1"."AOTHEME_ID" , "w2"."ID_OTHER" , "w2"."TYPE" , "w2"."TITLE" , "w2"."DETAILS" , "w2"."SORT_ORDER" , "w2"."VERSION" , "w2"."STATUS" , "w2"."HAS_ORIGINAL_ESTIMATES" , "w2"."AOEARLIEST_START" , "w2"."AOTARGET_START" , "w2"."AOTARGET_END" , "w2"."AOTEAM_ID" , "w2"."AOSPRINT_ID" , "w2"."AORELEASE_ID" , "w2"."AOSTREAM_ID" , "w2"."AOTHEME_ID" , "estimate"."ESTIMATE" , "estimate"."ORIGINAL" , "estimate"."REPLANNING" , "estimate"."TARGET_ID" , "estimate"."TARGET_TYPE" FROM "public"."AO_A415DF_AOWORK_ITEM" "w0" LEFT JOIN "public"."AO_A415DF_AOWORK_ITEM" "w1" ON "w1"."AOPARENT_ID" = "w0"."ID_OTHER" LEFT JOIN "public"."AO_A415DF_AOWORK_ITEM" "w2" ON "w2"."AOPARENT_ID" = "w1"."ID_OTHER" LEFT JOIN ( SELECT "estimate"."ESTIMATE" , "estimate"."ORIGINAL" , "estimate"."REPLANNING" , "estimate"."TARGET_ID" , "estimate"."TARGET_TYPE" , "estimate"."AOWORK_ITEM_ID" FROM "public"."AO_A415DF_AOESTIMATE" "estimate" WHERE "estimate"."REPLANNING" != true ) estimate ON "estimate"."AOWORK_ITEM_ID" = "w0"."ID_OTHER" OR "estimate"."AOWORK_ITEM_ID" = "w1"."ID_OTHER" OR "estimate"."AOWORK_ITEM_ID" = "w2"."ID_OTHER" WHERE "w0"."AOPARENT_ID" IS NULL AND "w0"."AOPLAN_ID" = ? ORDER BY COALESCE( (CASE WHEN "w0"."TYPE" IN (?) THEN "w0"."SORT_ORDER" ELSE NULL END) , (CASE WHEN "w1"."TYPE" IN (?) THEN "w1"."SORT_ORDER" ELSE ? END) , (CASE WHEN "w2"."TYPE" IN (?) THEN "w2"."SORT_ORDER" ELSE NULL END) ) , COALESCE( (CASE WHEN "w0"."TYPE" IN (?, ?) THEN "w0"."SORT_ORDER" ELSE NULL END) , (CASE WHEN "w1"."TYPE" IN (?, ?) THEN "w1"."SORT_ORDER" ELSE ? END) , (CASE WHEN "w2"."TYPE" IN (?, ?) THEN "w2"."SORT_ORDER" ELSE NULL END) ) ] 

  at com.radiantminds.roadmap.common.data.persistence.ao.sql.BaseAOPersistenceSQL.sql:282
  at com.radiantminds.roadmap.common.data.persistence.ao.sql.BaseAOPersistenceSQL.sql:222
  at com.radiantminds.roadmap.common.data.persistence.ao.sql.BaseAOPersistenceSQL.sql:218
  at com.radiantminds.roadmap.common.data.persistence.ao.entities.workitems.workitem.sql.select.WorkItemSelectQueryBuilder.execute:174
  at com.radiantminds.roadmap.common.data.persistence.ao.entities.workitems.workitem.PortfolioActiveObjectsWorkItemPersistence.listFullWorkItemsForPlanAndFilter:318
  at com.radiantminds.roadmap.common.rest.services.workitems.PlanWorkItemServiceHandler$Impl.getFiltered:210
  at sun.reflect.GeneratedMethodAccessor2913.invoke:-1
  at sun.reflect.DelegatingMethodAccessorImpl.invoke:43
  at java.lang.reflect.Method.invoke:606
  at com.radiantminds.roadmap.common.handlers.SecuredInvocationHandler.invoke:159
  at com.sun.proxy.$Proxy3828.getFiltered:-1
  at com.radiantminds.roadmap.common.rest.services.workitems.PlanWorkItemService.getFiltered:102
  at sun.reflect.GeneratedMethodAccessor2912.invoke:-1
  at sun.reflect.DelegatingMethodAccessorImpl.invoke:43
  at java.lang.reflect.Method.invoke:606
  at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$ResponseOutInvoker$1.invoke:234
  at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$1.intercept:100
  at com.atlassian.plugins.rest.common.interceptor.impl.DefaultMethodInvocation.invoke:61
  at com.atlassian.plugins.rest.common.expand.interceptor.ExpandInterceptor.intercept:38
  at com.atlassian.plugins.rest.common.interceptor.impl.DefaultMethodInvocation.invoke:61
  at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper.invokeMethodWithInterceptors:132
  at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$ResponseOutInvoker._dispatch:230
  at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch:75
  at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept:288
  at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept:147
  at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept:108
  at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept:147
  at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept:84
  at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest:1469
  at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest:1400
  at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest:1349
  at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest:1339
  at com.sun.jersey.spi.container.servlet.WebComponent.service:416
  at com.sun.jersey.spi.container.servlet.ServletContainer.service:537
  at com.atlassian.plugins.rest.module.RestDelegatingServletFilter$JerseyOsgiServletContainer.doFilter:178
  at com.sun.jersey.spi.container.servlet.ServletContainer.doFilter:795
  at com.atlassian.plugins.rest.module.RestDelegatingServletFilter.doFilter:73
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:77
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:63
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.plugins.rest.module.servlet.RestServletUtilsUpdaterFilter.doFilterInternal:26
  at com.atlassian.plugins.rest.module.servlet.RestServletUtilsUpdaterFilter.doFilter:40
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter:25
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.mywork.client.filter.ServingRequestsFilter.doFilter:37
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.plugins.cors.CorsFilter.doFilter:65
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.prettyurls.filter.PrettyUrlsSiteMeshFixupFilter.doFilter:36
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.prettyurls.filter.PrettyUrlsDispatcherFilter.doFilter:60
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.prettyurls.filter.PrettyUrlsSiteMeshFilter.doFilter:92
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.prettyurls.filter.PrettyUrlsMatcherFilter.doFilter:56
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.labs.botkiller.BotKillerFilter.doFilter:36
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:77
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:63
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.jira.web.filters.accesslog.AccessLogFilter.executeRequest:107
  at com.atlassian.jira.web.filters.accesslog.AccessLogFilter.doFilter:91
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.jira.security.xsrf.XsrfTokenAdditionRequestFilter.doFilter:54
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.jira.web.filters.pagebuilder.PageBuilderFilter.doFilter:90
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.jira.web.filters.CommittedResponseHtmlErrorRecoveryFilter.doFilter:63
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:46
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.prettyurls.filter.PrettyUrlsCombinedMatchDispatcherFilter.doFilter:61
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:77
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:63
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.seraph.filter.SecurityFilter.doFilter:239
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter:100
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.seraph.filter.BaseLoginFilter.doFilter:172
  at com.atlassian.jira.web.filters.JiraLoginFilter.doFilter:70
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:46
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter:79
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.plugins.rest.module.servlet.RestSeraphFilter.doFilter:40
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.bonfire.web.filters.BonfireP3PFilter.doFilter:57
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.prettyurls.filter.PrettyUrlsCombinedMatchDispatcherFilter.doFilter:61
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:77
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:63
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter:71
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite:176
  at org.tuckey.web.filters.urlrewrite.RuleChain.doRules:145
  at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest:92
  at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter:394
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:46
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.analytics.client.filter.JiraAnalyticsFilter.doFilter:40
  at com.atlassian.analytics.client.filter.AbstractHttpFilter.doFilter:32
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.prettyurls.filter.PrettyUrlsCombinedMatchDispatcherFilter.doFilter:61
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:77
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:63
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter:87
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.core.filters.cache.AbstractCachingFilter.doFilter:33
  at com.atlassian.core.filters.AbstractHttpFilter.doFilter:31
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter:41
  at com.atlassian.core.filters.AbstractHttpFilter.doFilter:31
  at com.atlassian.jira.web.filters.PathMatchingEncodingFilter.doFilter:45
  at com.atlassian.core.filters.AbstractHttpFilter.doFilter:31
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.jira.startup.JiraStartupChecklistFilter.doFilter:79
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.jira.web.filters.MultipartBoundaryCheckFilter.doFilter:41
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter:87
  at com.atlassian.jira.web.filters.JiraFirstFilter.doFilter:61
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.gzipfilter.GzipFilter.doFilterInternal:121
  at com.atlassian.gzipfilter.GzipFilter.doFilter:92
  at com.atlassian.jira.web.filters.gzip.JiraGzipFilter.doFilter:56
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at org.apache.catalina.core.StandardWrapperValve.invoke:220
  at org.apache.catalina.core.StandardContextValve.invoke:122
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke:501
  at org.apache.catalina.core.StandardHostValve.invoke:171
  at org.apache.catalina.valves.ErrorReportValve.invoke:103
  at org.apache.catalina.core.StandardEngineValve.invoke:116
  at org.apache.catalina.valves.AccessLogValve.invoke:950
  at org.apache.catalina.connector.CoyoteAdapter.service:408
  at org.apache.coyote.http11.AbstractHttp11Processor.process:1070
  at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process:611
  at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run:314
  at java.util.concurrent.ThreadPoolExecutor.runWorker:1145
  at java.util.concurrent.ThreadPoolExecutor$Worker.run:615
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run:61
  at java.lang.Thread.run:745
Caused by java.lang.NullPointerException :

  at com.radiantminds.roadmap.jira.common.components.extension.issues.data.hierarchy.LinkEnrichmentData.create:24
  at com.radiantminds.roadmap.jira.common.components.extension.issues.data.hierarchy.IssueHierarchyJGraphTImpl.create:98
  at com.radiantminds.roadmap.jira.common.components.extension.issues.data.hierarchy.HierarchicalJiraIssueDataExtractor.getData:26
  at com.radiantminds.roadmap.jira.common.components.extension.issues.data.IssueDataRequestHandler.getData:61
  at com.radiantminds.roadmap.jira.common.components.extension.JiraWorkItemExtension.getExtensionLinkData:157
  at com.radiantminds.roadmap.common.extensions.workitems.WorkItemEnrichmentUtils.enrichItemsWithStatusAndProgress:45
  at com.radiantminds.roadmap.common.data.persistence.ao.entities.workitems.workitem.sql.select.SubqueryDataEnrichment.enrichItems:72
  at com.radiantminds.roadmap.common.data.persistence.ao.entities.workitems.workitem.sql.select.WorkItemSelectQueryParser.parse:173
  at com.radiantminds.roadmap.common.data.persistence.ao.entities.workitems.workitem.sql.select.WorkItemSelectQueryBuilder$1.handleResult:380
  at com.radiantminds.roadmap.common.data.persistence.ao.entities.workitems.workitem.sql.select.WorkItemSelectQueryBuilder$1.handleResult:174
  at com.radiantminds.roadmap.common.data.persistence.ao.sql.BaseAOPersistenceSQL.sql:263
  at com.radiantminds.roadmap.common.data.persistence.ao.sql.BaseAOPersistenceSQL.sql:222
  at com.radiantminds.roadmap.common.data.persistence.ao.sql.BaseAOPersistenceSQL.sql:218
  at com.radiantminds.roadmap.common.data.persistence.ao.entities.workitems.workitem.sql.select.WorkItemSelectQueryBuilder.execute:174
  at com.radiantminds.roadmap.common.data.persistence.ao.entities.workitems.workitem.PortfolioActiveObjectsWorkItemPersistence.listFullWorkItemsForPlanAndFilter:318
  at com.radiantminds.roadmap.common.rest.services.workitems.PlanWorkItemServiceHandler$Impl.getFiltered:210
  at sun.reflect.GeneratedMethodAccessor2913.invoke:-1
  at sun.reflect.DelegatingMethodAccessorImpl.invoke:43
  at java.lang.reflect.Method.invoke:606
  at com.radiantminds.roadmap.common.handlers.SecuredInvocationHandler.invoke:159
  at com.sun.proxy.$Proxy3828.getFiltered:-1
  at com.radiantminds.roadmap.common.rest.services.workitems.PlanWorkItemService.getFiltered:102
  at sun.reflect.GeneratedMethodAccessor2912.invoke:-1
  at sun.reflect.DelegatingMethodAccessorImpl.invoke:43
  at java.lang.reflect.Method.invoke:606
  at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$ResponseOutInvoker$1.invoke:234
  at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$1.intercept:100
  at com.atlassian.plugins.rest.common.interceptor.impl.DefaultMethodInvocation.invoke:61
  at com.atlassian.plugins.rest.common.expand.interceptor.ExpandInterceptor.intercept:38
  at com.atlassian.plugins.rest.common.interceptor.impl.DefaultMethodInvocation.invoke:61
  at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper.invokeMethodWithInterceptors:132
  at com.atlassian.plugins.rest.common.interceptor.impl.DispatchProviderHelper$ResponseOutInvoker._dispatch:230
  at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch:75
  at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept:288
  at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept:147
  at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept:108
  at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept:147
  at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept:84
  at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest:1469
  at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest:1400
  at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest:1349
  at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest:1339
  at com.sun.jersey.spi.container.servlet.WebComponent.service:416
  at com.sun.jersey.spi.container.servlet.ServletContainer.service:537
  at com.atlassian.plugins.rest.module.RestDelegatingServletFilter$JerseyOsgiServletContainer.doFilter:178
  at com.sun.jersey.spi.container.servlet.ServletContainer.doFilter:795
  at com.atlassian.plugins.rest.module.RestDelegatingServletFilter.doFilter:73
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:77
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:63
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.plugins.rest.module.servlet.RestServletUtilsUpdaterFilter.doFilterInternal:26
  at com.atlassian.plugins.rest.module.servlet.RestServletUtilsUpdaterFilter.doFilter:40
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.applinks.core.rest.context.ContextFilter.doFilter:25
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.mywork.client.filter.ServingRequestsFilter.doFilter:37
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.plugins.cors.CorsFilter.doFilter:65
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.prettyurls.filter.PrettyUrlsSiteMeshFixupFilter.doFilter:36
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.prettyurls.filter.PrettyUrlsDispatcherFilter.doFilter:60
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.prettyurls.filter.PrettyUrlsSiteMeshFilter.doFilter:92
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.prettyurls.filter.PrettyUrlsMatcherFilter.doFilter:56
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.labs.botkiller.BotKillerFilter.doFilter:36
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:77
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:63
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.jira.web.filters.accesslog.AccessLogFilter.executeRequest:107
  at com.atlassian.jira.web.filters.accesslog.AccessLogFilter.doFilter:91
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.jira.security.xsrf.XsrfTokenAdditionRequestFilter.doFilter:54
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.jira.web.filters.pagebuilder.PageBuilderFilter.doFilter:90
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.jira.web.filters.CommittedResponseHtmlErrorRecoveryFilter.doFilter:63
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:46
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.prettyurls.filter.PrettyUrlsCombinedMatchDispatcherFilter.doFilter:61
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:77
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:63
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.seraph.filter.SecurityFilter.doFilter:239
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.security.auth.trustedapps.filter.TrustedApplicationsFilter.doFilter:100
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.seraph.filter.BaseLoginFilter.doFilter:172
  at com.atlassian.jira.web.filters.JiraLoginFilter.doFilter:70
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:46
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.oauth.serviceprovider.internal.servlet.OAuthFilter.doFilter:79
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.plugins.rest.module.servlet.RestSeraphFilter.doFilter:40
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.bonfire.web.filters.BonfireP3PFilter.doFilter:57
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.prettyurls.filter.PrettyUrlsCombinedMatchDispatcherFilter.doFilter:61
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:77
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:63
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.johnson.filters.AbstractJohnsonFilter.doFilter:71
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite:176
  at org.tuckey.web.filters.urlrewrite.RuleChain.doRules:145
  at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest:92
  at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter:394
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:46
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.analytics.client.filter.JiraAnalyticsFilter.doFilter:40
  at com.atlassian.analytics.client.filter.AbstractHttpFilter.doFilter:32
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter$1.doFilter:70
  at com.atlassian.prettyurls.filter.PrettyUrlsCombinedMatchDispatcherFilter.doFilter:61
  at com.atlassian.plugin.servlet.filter.DelegatingPluginFilter.doFilter:78
  at com.atlassian.plugin.servlet.filter.IteratingFilterChain.doFilter:42
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:77
  at com.atlassian.plugin.servlet.filter.ServletFilterModuleContainerFilter.doFilter:63
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter:87
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.core.filters.cache.AbstractCachingFilter.doFilter:33
  at com.atlassian.core.filters.AbstractHttpFilter.doFilter:31
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.core.filters.encoding.AbstractEncodingFilter.doFilter:41
  at com.atlassian.core.filters.AbstractHttpFilter.doFilter:31
  at com.atlassian.jira.web.filters.PathMatchingEncodingFilter.doFilter:45
  at com.atlassian.core.filters.AbstractHttpFilter.doFilter:31
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.jira.startup.JiraStartupChecklistFilter.doFilter:79
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.jira.web.filters.MultipartBoundaryCheckFilter.doFilter:41
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.jira.web.filters.steps.ChainedFilterStepRunner.doFilter:87
  at com.atlassian.jira.web.filters.JiraFirstFilter.doFilter:61
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at com.atlassian.gzipfilter.GzipFilter.doFilterInternal:121
  at com.atlassian.gzipfilter.GzipFilter.doFilter:92
  at com.atlassian.jira.web.filters.gzip.JiraGzipFilter.doFilter:56
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter:241
  at org.apache.catalina.core.ApplicationFilterChain.doFilter:208
  at org.apache.catalina.core.StandardWrapperValve.invoke:220
  at org.apache.catalina.core.StandardContextValve.invoke:122
  at org.apache.catalina.authenticator.AuthenticatorBase.invoke:501
  at org.apache.catalina.core.StandardHostValve.invoke:171
  at org.apache.catalina.valves.ErrorReportValve.invoke:103
  at org.apache.catalina.core.StandardEngineValve.invoke:116
  at org.apache.catalina.valves.AccessLogValve.invoke:950
  at org.apache.catalina.connector.CoyoteAdapter.service:408
  at org.apache.coyote.http11.AbstractHttp11Processor.process:1070
  at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process:611
  at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run:314
  at java.util.concurrent.ThreadPoolExecutor.runWorker:1145
  at java.util.concurrent.ThreadPoolExecutor$Worker.run:615
  at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run:61
  at java.lang.Thread.run:745

===================
=== Client Info ===
===================

User agent: Mozilla/5.0 (Windows NT 6.3; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/43.0.2357.124 Safari/537.36 
Local time: Thu Jun 18 2015 10:55:13 GMT+0100 (GMT Daylight Time)

===============
=== Request ===
===============

URL: /rest/roadmap/1.0/plans/14/workitems/filter.json?planVersion=246&clientId=9bf37078-4ee8-4f2b-9f56-4bf3e21d78d5
Type: POST
Status: 500
Data: "{\"showCompleted\":true}"

===================
=== System Info ===
===================

Plugin build: 1.9.6 

JIRA Title: JIRA
JIRA Edition: enterprise
JIRA Version: 6.4.4
SEN: SEN-XXXXXXX

duplicates

JPOSERVER-397 Failed to execute SQL error while importing large numbers of backlog issues

Closed

is cloned from: JPO-3940 Loading...

Assignee:: Unassigned

Reporter:: Chung Park Chan

Archiver:: Aakrity Tibrewal

Created:: 24/Jun/2015 12:41 AM

Updated:: 14/Aug/2019 6:19 AM

Resolved:: 29/Jun/2015 4:24 AM

Archived:: 12/Oct/2023 2:33 AM

Details

Description

Summary

Environment

Steps to Reproduce

Expected Results

Actual Results

Attachments

Issue Links

Activity

People

Dates