Q
Problem solve Get help with specific problems with your technologies, process and projects.

Getting a timeout error when I run an agent on the database

I'm doing a redesign. The current database is nearly 9 GB. I have some new fields to be populated to all the documents in the database. When I run an agent on this database, I always get stuck by the error: "Network operation did not complete in reasonable amount of time." Is there any way I can run the agent successfully in all the documents, getting the documents in batches and make sure that I am not missing any documents in the database? Thanks.
First, I would schedule the agent to run on the server after the busy hours of the day are past. Running on the server could eliminate your network timeout issue.

The other thing to do is to use a flag field and view. Create a view that selects all documents where SpecialUpdateFlag="". Have the view set to refresh the index manually. Then as part of your processing agent do the following:

  1. Get handle to the new view and refresh the index.
  2. Set autorefresh = false.
  3. Get the first document in the view.
  4. Create a counter in the script and increment it for each document you process.
  5. If your document count is less than 2,000 or your document is not nothing, process the document and add the field SpecialUpdateFlag with the current date as a value.
  6. Make the next document your current document.

Do you have comments on this Ask the Expert question and response? Let us know.

This was last published in May 2004

Dig Deeper on Lotus Notes Domino Agents

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

Search400

  • iSeries tutorials

    Search400.com's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...

SearchDataCenter

SearchContentManagement

Close