Versions Compared

Key

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

In general, if If you see any kind of symptoms that your Jira index is corrupted (for example, your JQL queries will return wrong data), then disable BigPicture, perform Jira re-indexreindex, 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

If you have a backup that contains such a table, your WBS can be restored.

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 it 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. Old The old structure is lost. 

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

...

Impact on synchronization

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

...