Error "BigPicture loading crashed" after Snapshot - now BigPicture out of order

[Ingo Volkhausen]

Hi All,

I prepared for a Jira Server Upgrade by also taken a snopshot of BigPicture (V) to be on the save side. But After Snapshot done, BigPicture is showing this and is totaly out of order:

I already checked this BigPicture loading crashed (softwareplant.com), run the Jira Upgrade, run the BigPicture upgrade, deleted Cache, everything fine, but not BigPicture. 

1. BigPicture SnapShot -> done -> BigPicture loading crashed
2. Searched Log files regarding BigPicture loading crashed (softwareplant.com) -> no indication
3. Run Jira Server Upgrade 8.21.1 -> 8.22.3 -> still BigPicture error
4. Run BigPicture Upgrade 8.4.7 -> 8.5.1 -> still BigPicture error
5. Cleared Cache .osgi-plugins .bundled-plugins, work and pluginstate -> still BigPicture error

I already raised a ticket at softwareplant, but no solution so far. Hope somebody may help with this.

Thx a lot in advance + Rgds Ivo

[Ingo Volkhausen · Accepted solution]

Based on BP developers, you have to

1. remove the snapshot files from

{JIRA_HOME}/export/softwareplant/bigpicture/backup

2. disable + enable the BP Add-On

That worked for us.

Rgds Ivo 

[Mayur Jadhav]

Hi @Ingo Volkhausen ,

Hope you are doing good !!

I have also phased the same issue long back!! I have raised a support ticket with Big picture and they have given solution to fix it.

• run the following SQL query

  DELETE
  FROM "AO_0456E7_GLOBAL_TASK"
  WHERE "ID" IN
        (SELECT "ID"
         FROM (SELECT "ID", ROW_NUMBER() OVER ( PARTITION BY "TASK_ID" ORDER BY "ID" DESC ) AS "ROW_NUM"
               FROM "AO_0456E7_GLOBAL_TASK") t
         WHERE t."ROW_NUM" > 1);
  

• disable the plugin, wait around 10 minutes and then re-enable it

Note: Please take a backup of your DB before performing queries to the database. 

Hope this help.

Cheers,
Mayur

[Ingo Volkhausen]

Hi @Mayur Jadhav 

thank you very much for this input.

I did run a SELECT in advance and in our table there are no records to delete. I also tried disable + wait 10' + enable and still get the above error with no entry in the logs.

select *
  FROM "AO_0456E7_GLOBAL_TASK"
 WHERE "ID" IN
           (SELECT "ID"
            FROM (SELECT "ID", ROW_NUMBER() OVER ( PARTITION BY "TASK_ID" ORDER BY "ID" DESC ) AS "ROW_NUM"
            FROM "AO_0456E7_GLOBAL_TASK") t
            WHERE t."ROW_NUM" > 1);

Thanks + Regards Ivo

[Mayur Jadhav]

@Ingo Volkhausen Please raise a ticket with Bigpicture Support.