What other objects can prevent a report from being deleted? The selected item(s) cannot be removed..

[dhoppmann]

A client is trying to delete a report from the repository and I told him to remove scheduled reports associated with the reports before attempting to delete the report because I figured there was a foreign key from scheduled reports pointing to them. He did that and for a couple of them he is still getting this error:

The selected item(s) cannot be removed due to being referenced by other objects. 

What other foreign keys/objects need to be deleted to allow this. I haven't seen this before and am not by a system to check the db fk's, hoping someone could have an answer....

Thanks!

 

[dhoppmann]

JIReportUnit.id has foreign key references from these table.columns, but there's nothing in those tables with the id of the reports I'm looking at. If anybody could help that would be great....

JIAdhocReportUnit.id

JIDataDefinerUnit.id

JIReportOptions.report_id

JIReportUnitInputControl.report_unit_id

JIReportUnitResource.report_unit_id

Using 3.7.1...

[dhoppmann]

OK, manually deleting it from the database back to the JIResource.id showed me that there were constraints with JIResource.id in:

JIDashboardResource.resource_id

JIAccessEvent.resource_id

...so someone must have referenced it in a dashboard. Adios report!

[ramnik]

Yes ..if teh report is being used in dashboard or as sub-report in another report , you wont be able to delete. This is refrential integrity feature in use.

Ramnik Kaur

Senior QA Engineer