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

Atlassian JIRA | Chung Park Chan | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 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 | 2 years ago | Chung Park Chan [Atlassian]
    com.atlassian.jira.appconsistency.integrity.exception.IntegrityException: Error occurred while performing check.
  2. 0

    h3. Symptoms When using the [Database Integrity Checker|http://confluence.atlassian.com/display/JIRA/Using+the+Database+Integrity+Checker] a stack trace is generated. The following may be found within the {{atlassian-jira.log}}: {noformat:borderStyle=solid| borderColor=#6A8EB3 |bgColor=#F8F8F8} 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: java.lang.NullPointerException at com.atlassian.jira.workflow.DefaultWorkflowSchemeManager.getSchemeForProject(DefaultWorkflowSchemeManager.java:382) at com.atlassian.jira.workflow.DefaultWorkflowSchemeManager.getWorkflowName(DefaultWorkflowSchemeManager.java:350) at com.atlassian.jira.workflow.OSWorkflowManager.getWorkflowName(OSWorkflowManager.java:166) at com.atlassian.jira.workflow.OSWorkflowManager.getWorkflow(OSWorkflowManager.java:554) at com.atlassian.jira.appconsistency.integrity.check.WorkflowCurrentStepCheck.doCheck(WorkflowCurrentStepCheck.java:111) ... {noformat} h3. Cause This is caused by an issue row in the {{jiraissue}} table that referred to a project id for a Project that no longer exists in the database. h3. Workaround # Run the "Check Issue for Relation 'RelatedOSWorkflowEntry'" check first; # Fix any entries that are returned; # At this point the complete test can be run.

    Atlassian JIRA | 2 years ago | Daniel Pinheiro dos Santos
    com.atlassian.jira.appconsistency.integrity.exception.IntegrityException: Error occurred while performing check.
  3. 0

    h3. Summary After migrating JIRA from MySQL/PostgreSQL/Cloud 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/PostgreSQL or grab a Cloud backup and skip to step 4 # 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 | 2 years ago | Chung Park Chan
    com.atlassian.jira.appconsistency.integrity.exception.IntegrityException: Error occurred while performing check.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    h3. Symptoms When using the [Database Integrity Checker|http://confluence.atlassian.com/display/JIRA/Using+the+Database+Integrity+Checker] a stack trace is generated. The following may be found within the {{atlassian-jira.log}}: {noformat:borderStyle=solid| borderColor=#6A8EB3 |bgColor=#F8F8F8} 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: java.lang.NullPointerException at com.atlassian.jira.workflow.DefaultWorkflowSchemeManager.getSchemeForProject(DefaultWorkflowSchemeManager.java:382) at com.atlassian.jira.workflow.DefaultWorkflowSchemeManager.getWorkflowName(DefaultWorkflowSchemeManager.java:350) at com.atlassian.jira.workflow.OSWorkflowManager.getWorkflowName(OSWorkflowManager.java:166) at com.atlassian.jira.workflow.OSWorkflowManager.getWorkflow(OSWorkflowManager.java:554) at com.atlassian.jira.appconsistency.integrity.check.WorkflowCurrentStepCheck.doCheck(WorkflowCurrentStepCheck.java:111) ... {noformat} h3. Cause This is caused by an issue row in the {{jiraissue}} table that referred to a project id for a Project that no longer exists in the database. h3. Workaround # Run the "Check Issue for Relation 'RelatedOSWorkflowEntry'" check first; # Fix any entries that are returned; # At this point the complete test can be run.

    Atlassian JIRA | 2 years ago | Daniel Santos
    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. com.atlassian.jira.appconsistency.integrity.exception.IntegrityException

      Error occurred while performing check.

      at com.atlassian.jira.appconsistency.integrity.check.WorkflowCurrentStepCheck.doCheck()
    2. com.atlassian.jira
      IntegrityChecker.doExecute
      1. com.atlassian.jira.appconsistency.integrity.check.WorkflowCurrentStepCheck.doCheck(WorkflowCurrentStepCheck.java:167)
      2. com.atlassian.jira.appconsistency.integrity.check.WorkflowCurrentStepCheck.preview(WorkflowCurrentStepCheck.java:54)
      3. com.atlassian.jira.appconsistency.integrity.IntegrityChecker.preview(IntegrityChecker.java:63)
      4. com.atlassian.jira.appconsistency.integrity.IntegrityChecker.previewWithIds(IntegrityChecker.java:35)
      5. com.atlassian.jira.web.action.admin.IntegrityChecker.doExecute(IntegrityChecker.java:71)
      5 frames