nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Ingo Volkhausen

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

All comments

Mayur Jadhav_30osel

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_30osel

@Ingo Volkhausen Please raise a ticket with Bigpicture Support.

Ingo Volkhausen

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira-software

jira-software-server

big-picture

softwareplant