How to resolve data corruption in Dataplane's temporary database tables

This article suggests the steps to be followed if there is data corruption in Dataplane's temporary database tables. Usually, users will not be able to run the index in Dataplane due to data corruption.

 Instructions

1. Please enable Dataplane debug logging. In case of any further issues, it helps to share logs with Appfire support.

2. Disable the Dataplane app by navigating to Manage apps → Expand the Arsenale Dataplane app → Click Disable button.

3. Take a full backup of the database.

4. Drop/remove the following four Dataplane-specific tables in the Jira database:
   
   

   • artcluster

   • artelection

   • arthistevent

   • artidxevent
     These tables will be recreated automatically once Dataplane is re-enabled.
     
     

5. Enable the Dataplane app by navigating to the Manage app → Expand the Arsenale Dataplane app → Click Enable button.

6. Go to Dataplane Reports → Administration → Configuration, click on Remove Index, if available, and then Build Index.

7. Disable Dataplane debug logging after Dataplane rebuilt its index successfully.