Hi I have noticed this error message in the event viewer on our crm server.

Error: Can't clean up the following tables: Activity.

Source: MSCRMDeletionService

Event ID: 5895

We are having sychronizing issues with the Active Directory and SQL.

Why is the DeletionService trying to cleanup the ActivityBase table?

Why can't the DeletionService clean up that table?

Is there any way to find out exactly what the DeletionService is trying to
do to the ActivityBase table?

Thanks for the help

Mark

Hi Mark,
The MSCRMDeletionSerivce runs once in a while to clean up all the
Deleted data from the MSCRM. I guess there is some type of issue with your
installation process OR the servies forthe Deletion is not enabled. I think
there is also a patch being released some time back for this kind of problme.
Please contact the partner source regarding this patch and they will be able
to update you.

Thanks
Vijay

"acdmark" wrote:

Mark,

There is a known bug in the DeletionService that occurs when there are
attachements tied to an object via Notes. It doesn't delete the dependant notes
first, so the delete itself fails.

You can try fixing this manually by trying to find the record in the system and
removing it yourself, or just live with the message.

Matt Parks
MVP - Microsoft CRM

----------------------------------------
----------------------------------------
On Thu, 18 Nov 2004 12:47:15 -0800, "acdmark"
<acdmark@discussions.microsoft.com> wrote:

Hi I have noticed this error message in the event viewer on our crm server.

Error: Can't clean up the following tables: Activity.

Source: MSCRMDeletionService

Event ID: 5895

We are having sychronizing issues with the Active Directory and SQL.

Why is the DeletionService trying to cleanup the ActivityBase table?

Why can't the DeletionService clean up that table?

Is there any way to find out exactly what the DeletionService is trying to
do to the ActivityBase table?

Thanks for the help

Mark

Matt,
How would one go about finding a record such at this in the system?

Thanks

"Matt Parks" wrote:

One would be to try to manually delete records with DeletionStateCode = 2 and
see what kind of erors come back. Then you'd need to dig in to figure out which
records were causing the errors. There isn't an easy way to do this other than
brute force and a lot fo queries.

Matt Parks
MVP - Microsoft CRM

----------------------------------------
----------------------------------------
On Mon, 22 Nov 2004 15:19:03 -0800, "Chef 3 Fingers"
<Chef3Fingers@discussions.microsoft.com> wrote:

Matt,
How would one go about finding a record such at this in the system?

Thanks

"Matt Parks" wrote: