Agent is duplicating the mail send

HCL Domino Domino Forum
1

I have a shared agent that is set to run daily at 4:13AM on all documents in the database.I have selected the Select documents in view open.

The security level is set at 3.

The code is:

SELECT (Form = “CCF2” & CompAppr = “”) | (Form = “CCF4” & CompAppr = “”) | (Form = “CCF5” & CompAppr = “”);

@If(DueDate = @Today;“”;@Return(“”));

@MailSend(Owner; “”; “” ; “REMINDER: Complaint #” + ControlNumber + " for " + CompanyName + " has a reminder date of " +@Text(DueDate) ; “Please ensure the complaint is progressing towards completion and enter a new reminder date.” + @NewLine + @NewLine + “To view the customer complaint, double-click on the doclink below.”; “”; [IncludeDoclink])

THE PROBLEM:

If I run this agent manually it works as intended and sends mail only for the complaints where the the DueDate equals today.

If I leave it set to run on the server then the agent identifies the correct complaints that the mail needs to be sent on and sends it. Then sends it again a few seconds later.

I tried searching and could not come up with this issue.

Any suggestions on what to try?

Thanks

Teri

2

Subject: Agent is duplicating the mail send

Could it be that there is another replica of your db on another server?

PS You might improve the performance by rewriting the SELECT as follows:

SELECT (CompAppr = “”) & (Form = “CCF4” | Form = “CCF2” | Form = “CCF5”);

3

Subject: RE: Agent is duplicating the mail send

Rob Thanks,

I did not find a Replica, but did find a restore that the Manager of the database had requested and forgot to tell the designer that it was there.

Teri