Corrupt documents stopping scheduled Agents functioning

Some corrupted documents are appearing in the database. They cannot be deleted because of the error ‘Invalid or Non-existent document’. Agents stop functioning when they encounter such corrupted documents.

I have done fix up in database and all the corrupted documents were deleted, but again those documents (Invalid or Non-existent documents) are appearing every few days and restricting the functioning of agents.

What might be the cause for this?

How can we permanently delete them from database?

Subject: Sounds more like you have stale views

Documents are being deleted but the views aren’t being brought up to date… Can you modify your agent to bring all views it’s going to be using up to date before it executes… Might want to look at those views in designer and see how they are configured for updating…

jpaganet@us.ibm.com

Subject: Might also be this SPR/bug

http://www-01.ibm.com/support/docview.wss?rs=203&context=SW000&dc=DA410&dc=DA450&dc=DA430&dc=DA440&dc=D600&dc=D700&dc=DB510&dc=DB520&dc=D800&dc=D900&dc=DA900&dc=DA800&dc=DB540&dc=DB400&dc=DB560&dc=DB530&dc=DA600&dc=DB550&dc=D100&q1=view+form+optimize&uid=swg21236831&loc=en_US&cs=UTF-8&lang=all