[DRAFT] KB-XXXX Notification KDBs taking significant space on disk and not clearing

Symptoms

Notification KDBs keep growing and doesn't seem to free up causing significant disk space usage on the environment.

Cause

Notification alerts generated by the application that should clear up once they are past their expiration limit, but it requires the user account to actually login for the automated clearing to occur. 

Action

1. Contact Appian Technical Support for the correct version of the script based on the version of Appian used.
2. Unzip the contents of the zip into <appian home>/_admin/_scripts
3. Run executeAppianSupportScript.bat|sh based on your OS in a terminal
4. Execute the deletenotificationsforusers script. The syntax is the following:
   • DeleteNotificationsForUsers --usernames (List of String) --expired (OPTIONAL) --beforedate (OPTIONAL Date yyyy-MM-dd)

Note: For environments with a lot of user, running getNotificationsCountForUsers --all will get a list of all users and their notification count. From that, you can delete the notifications for users with the most notifications.

Affected Versions

This article applies to all versions of Appian.

Last Reviewed: March 2018