com.atlassian.jira.appconsistency.integrity.exception.IntegrityException: Error occurred while performing check.

Atlassian JIRA | Matt Doar [ServiceRocket] | 1 decade ago
  1. 0

    I imported data from Bugzilla and forgot to map a custom status to anything in Jira. That's a problem with the importer, that it doesn't disallow that. The subsequent problem is tthat running the Admin, Ingegrity Checker and selecting just "Check jira issues with null status" causes the checker itself to die. From the trace below, I believe that the problem is with the line below, where an assumption is made that the genericValue.getInteger() returns non-null, which is not true in this case. com/atlassian/jira/appconsistency/integrity/check/WorkflowIssueStatusNull.java:132 StepDescriptor step = workflow.getDescriptor().getStep(genericValue.getInteger("stepId").intValue()); if(step == null) throw new IllegalStateException("Can not resolve a step with id: " + genericValue.getInteger("stepId") + " from workflow " + workflow.getName()); com.atlassian.jira.appconsistency.integrity.exception.IntegrityException: Error occurred while performing check. at com.atlassian.jira.appconsistency.integrity.check.WorkflowIssueStatusNull.doCheck(WorkflowIssueStatusNull.java:116) at com.atlassian.jira.appconsistency.integrity.check.WorkflowIssueStatusNull.preview(WorkflowIssueStatusNull.java:40) at com.atlassian.jira.appconsistency.integrity.IntegrityChecker.preview(IntegrityChecker.java:72) at com.atlassian.jira.appconsistency.integrity.IntegrityChecker.previewWithIds(IntegrityChecker.java:42) at com.atlassian.jira.web.action.admin.IntegrityChecker.doExecute(IntegrityChecker.java:64) at webwork.action.ActionSupport.execute(ActionSupport.java:153) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:57) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132) at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:185) 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.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:51) 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:119) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55) at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:38) 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:182) 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.LoginFilter.doFilter(LoginFilter.java:181) 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:132) at com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.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.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:39) 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.JohnsonFilter.doFilter(JohnsonFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.gzip.GzipFilter.doFilter(GzipFilter.java:64) 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.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37) 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.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) 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:856) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744) 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:595) Caused by: java.lang.NullPointerException at com.atlassian.jira.appconsistency.integrity.check.WorkflowIssueStatusNull.getStatusFromWorkflow(WorkflowIssueStatusNull.java:132) at com.atlassian.jira.appconsistency.integrity.check.WorkflowIssueStatusNull.doCheck(WorkflowIssueStatusNull.java:77) ... 54 more Referer URL: https://jira/secure/admin/jira/IntegrityChecker!default.jspa Build Information: Uptime: N/A Edition: Professional Version: 3.6.5 Build Number: 161 Atlassian Partner: null Server Information: Application Server: Apache Tomcat/5.5.9 Servlet Version: 2.4 File Paths: Location of entityengine.xml: file:/data/jira/atlassian-jira-professional-3.6.5-standalone/atlassian-jira/WEB-INF/classes/entityengine.xml Location of atlassian-jira.log: file:/data/jira/atlassian-jira.log Memory Information: Total Memory: 508 MB Free Memory: 403 MB Used Memory: 105 MB System Information: System Date: Thursday, 07 Dec 2006 System Time: 10:11:33 Current Working Directory: /data/jira Java Version: 1.5.0_09 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.5.0_09-b03 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: root User Timezone: America/Los_Angeles User Locale: English (United States) System Encoding: UTF-8 Operating System: Linux 2.6.9-42.ELsmp OS Architecture: i386 Application Server Container: Database type: mysql Database JNDI address: java:comp/env/jdbc/JiraDS Database version: 4.1.20 Database driver: MySQL-AB JDBC Driver mysql-connector-java-3.1.12 ( $Date: 2005-11-17 15:53:48 +0100 (Thu, 17 Nov 2005) $, $Revision$ ) Request Information: Request URL: https://jira/500page.jsp - Scheme: https - Server: jira - Port: 443 - URI: /500page.jsp - - Context Path: - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: Request Attributes: - javax.servlet.forward.request_uri : /secure/admin/jira/IntegrityChecker.jspa - javax.servlet.forward.context_path : - javax.servlet.forward.servlet_path : /secure/admin/jira/IntegrityChecker.jspa - javax.servlet.forward.path_info : /500page.jsp - javax.servlet.error.message : - javax.servlet.error.exception : javax.servlet.ServletException: Error occurred while performing check. - javax.servlet.request.key_size : 0 - os_securityfilter_already_filtered : true - com.atlassian.jira.web.filters.ActionCleanupDelayFilter : true - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - javax.servlet.error.request_uri : /secure/admin/jira/IntegrityChecker.jspa - jira.webwork.generic.dispatcher : webwork.dispatcher.GenericDispatcher@15e01c2 - javax.servlet.error.status_code : 500 - __sitemesh__filterapplied : true - jira.webwork.cleanup : false - javax.servlet.request.cipher_suite : TLS_DHE_RSA_WITH_AES_128_CBC_SHA - javax.servlet.error.servlet_name : action - com.atlassian.jira.web.filters.gzip.GzipFilter_already_filtered : true - atlassian.core.seraph.original.url : /secure/admin/jira/IntegrityChecker.jspa - loginfilter.already.filtered : true - webwork.result : Value stack =========== =========== - javax.servlet.request.ssl_session : 457858ccc2a25d9b9ca738a92b8e2dbccf3f9000582ae79ea93c2dc4d0169ee0 Request Logging: 0 log statements generated by this request:

    Atlassian JIRA | 1 decade ago | Matt Doar [ServiceRocket]
    com.atlassian.jira.appconsistency.integrity.exception.IntegrityException: Error occurred while performing check.
  2. 0

    I imported data from Bugzilla and forgot to map a custom status to anything in Jira. That's a problem with the importer, that it doesn't disallow that. The subsequent problem is tthat running the Admin, Ingegrity Checker and selecting just "Check jira issues with null status" causes the checker itself to die. From the trace below, I believe that the problem is with the line below, where an assumption is made that the genericValue.getInteger() returns non-null, which is not true in this case. com/atlassian/jira/appconsistency/integrity/check/WorkflowIssueStatusNull.java:132 StepDescriptor step = workflow.getDescriptor().getStep(genericValue.getInteger("stepId").intValue()); if(step == null) throw new IllegalStateException("Can not resolve a step with id: " + genericValue.getInteger("stepId") + " from workflow " + workflow.getName()); com.atlassian.jira.appconsistency.integrity.exception.IntegrityException: Error occurred while performing check. at com.atlassian.jira.appconsistency.integrity.check.WorkflowIssueStatusNull.doCheck(WorkflowIssueStatusNull.java:116) at com.atlassian.jira.appconsistency.integrity.check.WorkflowIssueStatusNull.preview(WorkflowIssueStatusNull.java:40) at com.atlassian.jira.appconsistency.integrity.IntegrityChecker.preview(IntegrityChecker.java:72) at com.atlassian.jira.appconsistency.integrity.IntegrityChecker.previewWithIds(IntegrityChecker.java:42) at com.atlassian.jira.web.action.admin.IntegrityChecker.doExecute(IntegrityChecker.java:64) at webwork.action.ActionSupport.execute(ActionSupport.java:153) at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:57) at webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132) at com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:185) 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.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:51) 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:119) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55) at com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:38) 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:182) 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.LoginFilter.doFilter(LoginFilter.java:181) 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:132) at com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.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.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:39) 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.JohnsonFilter.doFilter(JohnsonFilter.java:91) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.atlassian.jira.web.filters.gzip.GzipFilter.doFilter(GzipFilter.java:64) 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.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37) 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.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482) 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:856) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744) 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:595) Caused by: java.lang.NullPointerException at com.atlassian.jira.appconsistency.integrity.check.WorkflowIssueStatusNull.getStatusFromWorkflow(WorkflowIssueStatusNull.java:132) at com.atlassian.jira.appconsistency.integrity.check.WorkflowIssueStatusNull.doCheck(WorkflowIssueStatusNull.java:77) ... 54 more Referer URL: https://jira/secure/admin/jira/IntegrityChecker!default.jspa Build Information: Uptime: N/A Edition: Professional Version: 3.6.5 Build Number: 161 Atlassian Partner: null Server Information: Application Server: Apache Tomcat/5.5.9 Servlet Version: 2.4 File Paths: Location of entityengine.xml: file:/data/jira/atlassian-jira-professional-3.6.5-standalone/atlassian-jira/WEB-INF/classes/entityengine.xml Location of atlassian-jira.log: file:/data/jira/atlassian-jira.log Memory Information: Total Memory: 508 MB Free Memory: 403 MB Used Memory: 105 MB System Information: System Date: Thursday, 07 Dec 2006 System Time: 10:11:33 Current Working Directory: /data/jira Java Version: 1.5.0_09 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.5.0_09-b03 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: root User Timezone: America/Los_Angeles User Locale: English (United States) System Encoding: UTF-8 Operating System: Linux 2.6.9-42.ELsmp OS Architecture: i386 Application Server Container: Database type: mysql Database JNDI address: java:comp/env/jdbc/JiraDS Database version: 4.1.20 Database driver: MySQL-AB JDBC Driver mysql-connector-java-3.1.12 ( $Date: 2005-11-17 15:53:48 +0100 (Thu, 17 Nov 2005) $, $Revision$ ) Request Information: Request URL: https://jira/500page.jsp - Scheme: https - Server: jira - Port: 443 - URI: /500page.jsp - - Context Path: - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: Request Attributes: - javax.servlet.forward.request_uri : /secure/admin/jira/IntegrityChecker.jspa - javax.servlet.forward.context_path : - javax.servlet.forward.servlet_path : /secure/admin/jira/IntegrityChecker.jspa - javax.servlet.forward.path_info : /500page.jsp - javax.servlet.error.message : - javax.servlet.error.exception : javax.servlet.ServletException: Error occurred while performing check. - javax.servlet.request.key_size : 0 - os_securityfilter_already_filtered : true - com.atlassian.jira.web.filters.ActionCleanupDelayFilter : true - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - javax.servlet.error.request_uri : /secure/admin/jira/IntegrityChecker.jspa - jira.webwork.generic.dispatcher : webwork.dispatcher.GenericDispatcher@15e01c2 - javax.servlet.error.status_code : 500 - __sitemesh__filterapplied : true - jira.webwork.cleanup : false - javax.servlet.request.cipher_suite : TLS_DHE_RSA_WITH_AES_128_CBC_SHA - javax.servlet.error.servlet_name : action - com.atlassian.jira.web.filters.gzip.GzipFilter_already_filtered : true - atlassian.core.seraph.original.url : /secure/admin/jira/IntegrityChecker.jspa - loginfilter.already.filtered : true - webwork.result : Value stack =========== =========== - javax.servlet.request.ssl_session : 457858ccc2a25d9b9ca738a92b8e2dbccf3f9000582ae79ea93c2dc4d0169ee0 Request Logging: 0 log statements generated by this request:

    Atlassian JIRA | 1 decade ago | Matt Doar [ServiceRocket]
    com.atlassian.jira.appconsistency.integrity.exception.IntegrityException: Error occurred while performing check.
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    h3. Summary After migrating JIRA from MySQL to SQL Server, the following error occurred when the Integrity Checker runs. In this example, JIRA has 2 workflow with the name 'purchases' and 'Purchases'. {code:borderStyle=solid} SELECT id,workflowname FROM jiraschema."jiraworkflows" where workflowname = 'purchases' id workflowname 10022 purchases 12820 Purchases {code} {noformat} Technical details Log's referral number: b52389f3-69c3-4a3c-96da-89cc5c3f600f Cause Referer URL: http://jiratest/secure/admin/IntegrityChecker!default.jspa com.atlassian.jira.appconsistency.integrity.exception.IntegrityException: Error occurred while performing check. com.atlassian.jira.appconsistency.integrity.exception.IntegrityException: Error occurred while performing check. at com.atlassian.jira.appconsistency.integrity.check.WorkflowCurrentStepCheck.doCheck(WorkflowCurrentStepCheck.java:167) at com.atlassian.jira.appconsistency.integrity.check.WorkflowCurrentStepCheck.preview(WorkflowCurrentStepCheck.java:54) at com.atlassian.jira.appconsistency.integrity.IntegrityChecker.preview(IntegrityChecker.java:63) at com.atlassian.jira.appconsistency.integrity.IntegrityChecker.previewWithIds(IntegrityChecker.java:35) at com.atlassian.jira.web.action.admin.IntegrityChecker.doExecute(IntegrityChecker.java:71) ... Caused by: com.atlassian.cache.CacheException: java.lang.IllegalStateException: There are more than one workflows associated with 'Purchases' in the database! at com.atlassian.cache.memory.DelegatingCache$DelegatingLoadingCache.get(DelegatingCache.java:270) at com.atlassian.jira.workflow.CachingWorkflowDescriptorStore.getWorkflow(CachingWorkflowDescriptorStore.java:68) at com.atlassian.jira.workflow.JiraWorkflowFactory.getWorkflow(JiraWorkflowFactory.java:37) at com.opensymphony.workflow.config.DefaultConfiguration.getWorkflow(DefaultConfiguration.java:89) at com.atlassian.jira.workflow.OSWorkflowManager.getWorkflow(OSWorkflowManager.java:202) at com.atlassian.jira.workflow.OSWorkflowManager.getWorkflow(OSWorkflowManager.java:548) at com.atlassian.jira.appconsistency.integrity.check.WorkflowCurrentStepCheck.doCheck(WorkflowCurrentStepCheck.java:111) ... 188 more Caused by: java.lang.IllegalStateException: There are more than one workflows associated with 'Purchases' in the database! at com.atlassian.jira.workflow.OfBizWorkflowDescriptorStore.getWorkflowDescriptorGV(OfBizWorkflowDescriptorStore.java:155) at com.atlassian.jira.workflow.OfBizWorkflowDescriptorStore.getWorkflow(OfBizWorkflowDescriptorStore.java:46) at com.atlassian.jira.workflow.CachingWorkflowDescriptorStore$WorkflowCacheLoader.load(CachingWorkflowDescriptorStore.java:139) at com.atlassian.jira.workflow.CachingWorkflowDescriptorStore$WorkflowCacheLoader.load(CachingWorkflowDescriptorStore.java:132) ... {noformat} h3. Environment * JIRA on MS SQL Server * Recommended collation used - {{SQL_Latin1_General_CP437_CI_AI}} h3. Steps to Reproduce # Install JIRA with MySQL # Create two workflow with the following names. This will be 2 distinct workflows. #* Purchases #* purchases # Create an XML backup # Deploy a JIRA with SQL Server # Restore XML backup # Run Integrity Checker h3. Notes # MySQL is case sensitive so it reads the workflow as separate entity; however, SQL Server is case insensitive thus throwing the error # Case sensitivity should be similar across all supported database for JIRA h3.Workaround # Shutdown JIRA # Manually update the database to change one of the workflow name so you have a distinct name for each workflow # Restart JIRA

    Atlassian JIRA | 1 year ago | Chung Park Chan [Atlassian]
    com.atlassian.jira.appconsistency.integrity.exception.IntegrityException: Error occurred while performing check.

    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.lang.NullPointerException

      No message provided

      at com.atlassian.jira.appconsistency.integrity.check.WorkflowIssueStatusNull.getStatusFromWorkflow()
    2. com.atlassian.jira
      IntegrityChecker.doExecute
      1. com.atlassian.jira.appconsistency.integrity.check.WorkflowIssueStatusNull.getStatusFromWorkflow(WorkflowIssueStatusNull.java:132)
      2. com.atlassian.jira.appconsistency.integrity.check.WorkflowIssueStatusNull.doCheck(WorkflowIssueStatusNull.java:77)
      3. com.atlassian.jira.appconsistency.integrity.check.WorkflowIssueStatusNull.preview(WorkflowIssueStatusNull.java:40)
      4. com.atlassian.jira.appconsistency.integrity.IntegrityChecker.preview(IntegrityChecker.java:72)
      5. com.atlassian.jira.appconsistency.integrity.IntegrityChecker.previewWithIds(IntegrityChecker.java:42)
      6. com.atlassian.jira.web.action.admin.IntegrityChecker.doExecute(IntegrityChecker.java:64)
      6 frames
    3. webwork.action
      ActionSupport.execute
      1. webwork.action.ActionSupport.execute(ActionSupport.java:153)
      1 frame
    4. com.atlassian.jira
      JiraActionSupport.execute
      1. com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:57)
      1 frame
    5. webwork.dispatcher
      GenericDispatcher.executeAction
      1. webwork.dispatcher.GenericDispatcher.executeAction(GenericDispatcher.java:132)
      1 frame
    6. com.atlassian.jira
      JiraServletDispatcher.service
      1. com.atlassian.jira.web.dispatcher.JiraServletDispatcher.service(JiraServletDispatcher.java:185)
      1 frame
    7. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
      1 frame
    8. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2 frames
    9. com.atlassian.jira
      AccessLogFilter.doFilter
      1. com.atlassian.jira.web.filters.AccessLogFilter.doFilter(AccessLogFilter.java:51)
      1 frame
    10. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2 frames
    11. Sitemesh
      PageFilter.doFilter
      1. com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:119)
      2. com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:55)
      2 frames
    12. com.atlassian.jira
      SitemeshExcludePathFilter.doFilter
      1. com.atlassian.jira.web.filters.SitemeshExcludePathFilter.doFilter(SitemeshExcludePathFilter.java:38)
      1 frame
    13. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2 frames
    14. com.atlassian.seraph
      SecurityFilter.doFilter
      1. com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:182)
      1 frame
    15. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2 frames
    16. com.atlassian.seraph
      LoginFilter.doFilter
      1. com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181)
      1 frame
    17. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2 frames
    18. com.atlassian.util
      ProfilingFilter.doFilter
      1. com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132)
      1 frame
    19. com.atlassian.jira
      ProfilingAndErrorFilter.doFilter
      1. com.atlassian.jira.web.filters.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:35)
      1 frame
    20. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2 frames
    21. com.atlassian.jira
      ActionCleanupDelayFilter.doFilter
      1. com.atlassian.jira.web.filters.ActionCleanupDelayFilter.doFilter(ActionCleanupDelayFilter.java:39)
      1 frame
    22. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2 frames
    23. com.atlassian.johnson
      JohnsonFilter.doFilter
      1. com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:91)
      1 frame
    24. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2 frames
    25. com.atlassian.jira
      GzipFilter.doFilter
      1. com.atlassian.jira.web.filters.gzip.GzipFilter.doFilter(GzipFilter.java:64)
      1 frame
    26. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      2 frames
    27. com.atlassian.core
      AbstractEncodingFilter.doFilter
      1. com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:37)
      1 frame
    28. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
      5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:482)
      6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
      7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
      8. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
      9. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
      9 frames
    29. Grizzly HTTP
      LeaderFollowerWorkerThread.runIt
      1. org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856)
      2. org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:744)
      3. org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
      4. org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
      4 frames
    30. Tomcat Util
      ThreadPool$ControlRunnable.run
      1. org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
      1 frame
    31. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:595)
      1 frame