Niagara R2 Enterprise Server – Clearing Alarm History and Alarm File to Improve Station Performance

[Product_Support]

Issue

Niagara R2 Enterprise Server stations may experience slow startup or performance issues due to excessive historical alarms stored in the database. Users need methods to remove alarm history or the alarm file to restore normal operation.

Product Line

TAC IA Series

Environment

Niagara R2 Enterprise Server

Cause

Accumulation of alarms and logged data in the station’s database increases boot time and impacts performance. The alarm archive file and associated historical data can grow significantly over time.

Resolution

There are two main approaches to clear alarms and logged data:

---

Method 1: Delete the APP Folder (Complete Removal)

This method removes all archived data, including alarms, logs, and events.
Steps:

1. Stop the Niagara Service:
   • Open Control Panel → Administrative Tools → Services.
   • Locate Niagara, right-click, and select Stop.
2. Delete the APP Folder:
   • Navigate to:

     C:\Niagara\stations\[station name]\app
     

   • Delete the app folder.
3. Restart the Niagara Service:
   • Return to Services, right-click Niagara, and select Start.

Result: The station will recreate the APP folder and Cloudscape structure on restart. All archived data, including alarms, will be cleared.

---

Method 2: Use SQL Queries via appdb/queryForm Servlet (Selective Removal)

This method allows targeted deletion of alarm history without removing all logged data.
Steps:

1. Open a browser and navigate to:

   http://[ipaddress]/appdb/queryForm
   

2. Enter and execute the SQL query:

   delete from event.eventhistory
   

3. Repeat for other tables if needed (refer to SQL_Tutorial\QueryExamples_10_6_04.pdf for examples).

Note: This process may take time depending on database size.