NS7 / SMP sends a blank email to administrators daily at 9AM

Products

• Management Platform (Formerly known as Notification Server)

Issue/Introduction

RTCI Remote Access Purge policy mail gets sent daily at 9:00 to administrators, while SMP shows no active automation policy.

Cause

If you click on the Edit query link in the  Data Source section, and then select the Resolved Query tab it will generate the SQL that is being submitted to the database server. If you copy and paste the resolved query results and run it against your database you will probably see (usually)

Total Records    Left Records   Deleted Records
 0                        0                        0

This is why the policy is firing and sending an email. The query is actually returning one row. Albeit it isn't a row that we would want it to fire on.

Resolution

 By saving the policy, regardless of changes made, it will overwrite current settings, effectively stopping the emails from being sent.

 

Applies To

  SMP 7 SP3, SP4 ; 7.1 SP1, SP2