0041149: It is not possible to delete a module if an alert rule references one of its tabs

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #41149		[ Back to Issue ]
Summary	0041149: It is not possible to delete a module if an alert rule references one of its tabs

Revision	2019-06-24 17:29 by AugustoMauch
Steps To Reproduce	- Install the attached module (copy it into modules, run ant ant smartbuild -Dlocal=no). It will include a module with a tab - Execute the attached sql script. It will insert an alert rule that references the tab of the module, and an alert for the new alert rule. - Remove the new module from the modules/ folder and compile again. The update.database process will fail because, the alert rule is removed, the alert that references it is not.

Revision	2019-06-24 17:29 by AugustoMauch
Description	When deleting a module that has a tab referenced by an alert rule, the following error is shown in the console (if the alert rule has produced any alerts) Example: [java] 33423 [main] ERROR org.apache.ddlutils.DatabaseOperationException - Error while executing SQL [java] org.postgresql.util.PSQLException: ERROR: update or delete on table "ad_alertrule" violates foreign key constraint "ad_alert_ad_alertrule" on table "ad_alert" [java] Detail: Key (ad_alertrule_id)=(035B3FEA7F244F0E8D85F25CB5FF5C5E) is still referenced from table "ad_alert".

Revision	2019-06-24 17:17 by AugustoMauch
Steps To Reproduce	- Create a new module - Create an ad_alertrule in this module - Do the update database - Create an alert manually (ad_alert) - Delete the module from the environment . Update database

Revision	2019-06-24 17:17 by AugustoMauch
Description	When deleting a module that has referenced data, the update database fails. Example: [java] 33423 [main] ERROR org.apache.ddlutils.DatabaseOperationException - Error while executing SQL [java] org.postgresql.util.PSQLException: ERROR: update or delete on table "ad_alertrule" violates foreign key constraint "ad_alert_ad_alertrule" on table "ad_alert" [java] Detail: Key (ad_alertrule_id)=(035B3FEA7F244F0E8D85F25CB5FF5C5E) is still referenced from table "ad_alert".