We have around 8 databases. In all these database we have one agent which run daily at 1:00 AM. The function of this agent is to update all the related documents (in other databases) for a new or modified documents in this database.
The number of documents selected by this agent in these database is around 10,000.The agent log is showing the error message as “Agent execution time limit exceeded”.
In one of these 8 database the number of documents selected by the agent (for which update is to be done in other databases) is 180. In this database agent runs fine.
Could you please help me what is the reson behind this? Why this execution limit is exceeding. The time taken by agent to process 180 doc is around 3 mins. So it should process all the docs in other database as well. The agent log shows that it is stopped at 7:00 AM.
It sounds to me like you are using some code that is very inefficient. For instance, if you are using GetFirstDocument and GetNextDocument to walk a view, you can expect that processing 10,000 documents would take about 100 times as long as processing 100 documents; but if you use GetNthDocument to do the same thing, just getting to the document will take nearly 10,000 times as long (ignoring the actual processing time) for 10,000 documents as it does for 100 documents. If you post the code, we can probably point out the problem and suggest improvements that can speed things up considerably.
I have seen the code and we are using GetFirstDocument and GetNextDocument to walk a view. I have modified the schedule of this agent and made to run on weekend as well, so that it can process the unprocessed doc on weekend and reduce the number of docs. I will check this agent on Monday and will share you my findings.
It’s normally because the agent takes too long to run, and indicates a problem with the agent (or with its schedule—if the server is busy doing a lot of other things at the time, the agent may take considerably longer than it otherwise would). Create you own question, describe the agent(s) as completely as you can and post code.