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

Atlassian JIRA | Daniel Santos | 2 years ago
  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 | 1 year 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 | 1 year 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