Database Trim Events PME2022

[RdM]

A PME 2022 server was installed on a network with approx. 50 existing ION meters (7350, 7400, 8000). These meters backfilled historical data and the database was trimmed. However, Events and Alarms were not removed from the database as the PME2022 TrimRecords stored procedure has a check for AcknowledgementID. Has anyone tested using the PME2021 TrimRecords SP on the new software version?  

[Charles_Murison · Accepted solution]

Hello @RdM ,

I have never tried using PMe2021 TrimRecords store procedure on PME 2022 system. Possible the Store procedure does not have instructions to remove tables that may have been created in PME 2022 or changed to include a link to new or different tables.

One option would be to remove the "and a.AcknowledgementID IS NULL" from the TrimRecords 

Regards,

Charles