Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

In general, if If you see any symptoms that your Jira index is corrupted (for example, your JQL queries will return wrong data), disable BigPicture, perform Jira reindex, and enable BigPicture back.

Work breakdown structure data is stored in the BigPicture table called:

Code Block
languagesql
T_DEP_STATE_VERSION
T_DEP_TREE_EVENT
T_DEP_LINK_EVENT
T_DEP_NODE_SIBLING

...

Maintaining a Jira index is critical - when the index is corrupted, synchronizing tasks can result in data loss (the existing task hierarchy is changed). When the index is corrupted, JQL does not work, and the plugins treat all the issues as new during upon the synchronization; this . This means that the task structure based on artificial tasks is changed changes during a sync. The old structure is lost. 

More about Jira index corruption can be found in the Atlassian documentation:

...

Full synchronization is not run when BigPicture gets information about the corrupted index from the Jira API. A user can perform a Jira reindex; this . This should solve the corrupted index problem. Users can also continue without reindexing, which can cause irreversible and unintended changes in Box scope.

...