Mystery problem with @Mailsend Agent - R. 6.5.2

HCL Domino Domino Forum
1

This is something I never expect could happened to me :slight_smile: . I have been created Agent using Formula and never failed with scheduled by Daily or more than once a day. Recently I have scheduled to run Notifcation Mail for couple projects. I have all test and run manually those agents and all working well. When I scheduled them to run at 1:00 AM , the server Log telling me that the agent were run and document has been accessed but the mail never arrived to recipients’ mail box.

Sample of one of the agent formula called: ‘Automatically Send Milestone Start Date Reminders’

@If(StartDate=@Yesterday;

@MailSend(PCMailAddress;“jagoe@american.edu”;“myle@american.edu”;"Milestone Start Date on : " + @Text(StartDate;“D0S0”) ;

@NewLine + “Tanisha and " + @Left(PCName;” ") + “:”

  • @NewLine + @NewLine +

"Please be aware that the following Milestone start date was yesterday: " +

@NewLine + @NewLine +

“Milestone Name: "” + CompName + “"” + @NewLine +

"Primary Contact: " + PCName + @NewLine +

"Start Date: " + @Text(StartDate;“D0S0”) +

@NewLine +

“Please double-click on the doclink to review it.”; “”;[IncludeDoclink]);“”);

SELECT @All

The Agent Log:

Started running agent ‘Automatically Send Milestone Start Date Reminders’ on 03/01/2005 06:36:12 PM

Running on all documents in database: 533 total

Found 1 document(s) that match search criteria

1 document(s) were modified by formula

Done running agent ‘Automatically Send Milestone Start Date Reminders’ on 03/01/2005 06:36:14 PM

I checked the server log and found no errors messages. I hope Notes experts out there can see something did I missed or have any idea where the mail went? This is a tiny problem but is a big head-ache mystery.

Thanks in advance for reading my problems.

Myle

2

Subject: Mystery problem with @Mailsend Agent - R. 6.5.2

a couple of things:

1- u said its scheduled to run at 1am yet ur log is 6:36 PM? Im guessing its a test run. If so access prviledges are different on the client side from the server side. Make sure the ID the agent is signed by has access to run on the server.

2- perhaps there is a mismatch between startdate and @yesterday. make sure your startdate is actually datetime and not text otherwise the your mail will not be sent.

instead of your ELSE statement being “” put another @Mailsend (to yourself) with the subject “StartDate is not of timedate type”.

If thats the problem u can check to see if startdate is datetime and if its not convert it to datetime then compare it to @yesterday.

hope this helps

ST

3

Subject: RE: Mystery problem with @Mailsend Agent - R. 6.5.2

Stephen,

Thank youvery much for you reply. I have set the agent run by the Server Name but I will sign the database over with Server ID from Notes Admin to see if it will behave nicer.

Thanks again & have a great evening.

Myle

4

Subject: RE: Mystery problem with @Mailsend Agent - R. 6.5.2

Hi Stephen,

After signing the agent, it did not triggered, I removed the [Includedoclink] then it worked !! Never happened before but I think this could be ACL issue to the form, even I have granted MANAGER level access to all of the Localserver groups and primary server.

I have to use web link to replace the doclink but this is really strange.

Thanks again!

Myle

5

Subject: Make sure you have a “Default” view in the database.

The [IncludeDocLink] parameter requires one. Pick any view in designer, go to View properties, 2nd Tab and Select “Default when database is first opened”

6

Subject: BIll Once again I owe you BIG KUDOS !!!

What I can do without you ??? when your name show up I know the problem will be solved automatically. But amazing thing,I have scheduled more complicated agents, Newsletter send from other database and I didn’t have a default view at all.

Thanks again and Bests to you.

Myle