asked on

Lotus Notes Agent runs but no output

I have several agents that have been running for a couple of years that have all of a sudden stopped working properly.
They are scheduled to run once a day at between 1:00AM and 2:00AM.
They check a database for past due records and send mail to the appropriate people.
As I said, these have been running for years. No changes have been made to the agents.
The only thing done since the last changes to the agents was an upgrade from Domino 8.0 server to Domino 8.5.1
All of the date fields used are default calendar/time control fields.

Here is the code of one of the agents that has stopped working.
reqdcompl field is Calendar/time control
dateclosed is Calendar/time control
salesperson is text field
complaintnum is number field
customername is text field

Any ideas anyone??

Overdue := @Adjust(reqdcompl;0;0;5;0;0;0);
@If(dateclosed = "" & @Today=Overdue;@MailSend(salesperson;"John Doe/MyCompany":"Jane Smith/MyCompany":"Charles Darwin/MyCompany":"Sam Jones/MyCompany";"Bob Brown/MyCompany";"Overdue Customer Complaint";"The Following Customer Complaint is five days overdue:  # " + @Text(complaintnum)+ "  Customer: " + customername;"";[IncludeDoclink]);"")
;SELECT @All

Open in new window

ASKER CERTIFIED SOLUTION

doninja

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Sjef Bosman

http://haras-du-lerchenberg.fr/help/help85_designer.nsf/f4b82fbb75e942a6852566ac0037f284/89aab6da4cb55a1485257607005f5f76?OpenDocument

And from the hand of the expert on this matter:
http://www.ibm.com/developerworks/lotus/library/ls-Troubleshooting_agents_ND5_6/

Briancslnet

ASKER

checking the logs showed no errors and that the agents are indeed running. However, the results are not what they should be, i.e. mail should have been sent and was not.
I did notice that in checking the signature for the agent, the Administrator account was not Specifically entered in the server configuration document as being allowed to run agents, so I included it and will see if this helps correct the problem tonight.

Briancslnet

ASKER

Answer led me in a good direction. Problem still not completely solved but moved me toward the solution