Alertprofile not deleted together with account
NAV 4.2.6 Have done some cleaning in NAV's account list. Discovered afterwards that the associated alertprofiles were not deleted and now I have a couple of "ghost"-profiles generating alerts, sending to non-existent mail addresses etc. How can I clean the database? Which tables are involved? Is this bug is still present in 4.3.X it should be fixed. --Ingeborg -- Ingeborg Østrem Hellemo -- ingeborg.hellemo@uit.no Dep. of Information Technology --- Univ. of Tromsø
On Mon, 30 Nov 2015 12:17:41 +0100 Ingeborg Hellemo <ingeborg.hellemo@uit.no> wrote:
NAV 4.2.6
Have done some cleaning in NAV's account list. Discovered afterwards that the associated alertprofiles were not deleted and now I have a couple of "ghost"-profiles generating alerts, sending to non-existent mail addresses etc.
How can I clean the database? Which tables are involved?
Is this bug is still present in 4.3.X it should be fixed.
This bug has never been present in NAV, that I know of. The referential integrity between the `account` and the `alertprofile` tables is enforced by PostgreSQL, via the foreign key constraint `alertprofile_accountid_fkey`. You cannot have accountless profiles, unless you have been fiddling with your database schema outside of NAV. I assume "cleaning NAV's account list" means deleting users? -- Morten Brekkevold UNINETT
morten.brekkevold@uninett.no said:
I assume "cleaning NAV's account list" means deleting users?
Yes. Via /useradmin/. There was no problem after all. The user had more than one account and had removed only one of them - and not the one with the active alertprofile. When I now saw the foreign key constraint I was able to connect the errant alertprofile with the correct user. Sorry for the false alarm. --Ingeborg
participants (2)
-
Ingeborg Hellemo -
Morten Brekkevold