Project:
View Revisions: Issue #41149 | [ All Revisions ] [ 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 | ||
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 | ||
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". |
Copyright © 2000 - 2009 MantisBT Group |