Big Picture plugin installation/configuration is failing

[Williams Rosario]

I have the following error over and over in my Jira logs while trying to install and configure the "BigPicture - Project Management & PPM" plugin on my Jira server (v8.8.1):

"Cannot drop index 'index_ao_0456e7_cad538718941': needed in a foreign key constraint"

So not sure this is the right place to ask about this but I am not finding any SoftwarePlant forum to ask so maybe I will get lucky in here :)

And here's more information from my logs that is related to that error/table:

2020-09-29 20:21:15,994-0400 active-objects-init-JiraTenantImpl{id='system'}-0 DEBUG casfr [c.s.l.d.bigpicture.v5.BigPictureSchemaUpgradeV5] [TC:00000000] bigpicture:DatabaseSchemaUpgrade(4 -> 5) Time:[00:00:00.000] Total
:[00:00:00.001] Process:[
--- BIGPICTURE database upgrade task 5 ---
...

2020-09-29 20:21:17,261-0400 active-objects-init-JiraTenantImpl{id='system'}-0 DEBUG casfr [n.java.ao.sql] CREATE TABLE AO_0456E7_CADENCE_ITEM (
CADENCE_ID INTEGER NOT NULL,
CREATE_DATE DATETIME,
ID INTEGER AUTO_INCREMENT NOT NULL,
LEFT_SIBLING_ID INTEGER,
TASK_ID INTEGER NOT NULL,
TEAM_ID INTEGER,
CONSTRAINT fk_ao_0456e7_cadence_item_task_id FOREIGN KEY (TASK_ID) REFERENCES AO_0456E7_TASK(ID),
CONSTRAINT fk_ao_0456e7_cadence_item_cadence_id FOREIGN KEY (CADENCE_ID) REFERENCES AO_0456E7_CADENCE(ID),
PRIMARY KEY(ID)
) ENGINE=InnoDB
...
2020-09-29 20:21:17,598-0400 active-objects-init-JiraTenantImpl{id='system'}-0 DEBUG casfr [n.java.ao.sql] CREATE INDEX index_ao_0456e7_cad538718941 ON AO_0456E7_CADENCE_ITEM(CADENCE_ID)
...

2020-09-29 20:21:17,652-0400 active-objects-init-JiraTenantImpl{id='system'}-0 DEBUG casfr [c.s.l.d.bigpicture.v6.BigPictureSchemaUpgradeV6] [TC:00000000] bigpicture:DatabaseSchemaUpgrade(5 -> 6) Time:[00:00:00.000] Total:[00:00:00.000] Process:[
--- BIGPICTURE database upgrade task 6 ---
...

2020-09-29 20:21:17,980-0400 active-objects-init-JiraTenantImpl{id='system'}-0 DEBUG casfr [n.java.ao.sql] DROP INDEX index_ao_0456e7_cad538718941 ON AO_0456E7_CADENCE_ITEM
2020-09-29 20:21:17,983-0400 active-objects-init-JiraTenantImpl{id='system'}-0 ERROR casfr [n.java.ao.sql] Exception executing SQL update <DROP INDEX index_ao_0456e7_cad538718941 ON AO_0456E7_CADENCE_ITEM>
java.sql.SQLException: Cannot drop index 'index_ao_0456e7_cad538718941': needed in a foreign key constraint

[Mateusz Sołowianiuk]

Hi @Williams Rosario 

I am sorry that you are experiencing issues with installing your plugin. 

I would like to invite you to raise a ticket via our Service Desk in order to get this investigated by the team of our experts. I am sure that they will be able to provide a resolution promptly. 

Thank you in advance. 

Best regards,

Mateusz Sołowianiuk

SoftwarePlant Support

[Daniel Ebers]

Hi Hugo,

I am pasting in a link to a bug report I found about the error message you got from the underlying database but I doubt it will help you in that case.

Not sure if here will follow a reply of someone from Community after some weeks passed. Probably the best contact to talk to would be technical support of Softwareplant.

Cheers,
Daniel