A number of users have reported this error in their CRM application event
logs where it says cannot clean up activitybase table.
Microsoft now has a hot fix for this issue as per this article
TechKnowledge
Microsoft CRM Deletion Service Failure Error "Cannot Clean Up
ActivityBase Table" in the Application Event Log on the Microsoft CRM Server
Return to previous page
Document ID: 30380
Date Created: 4/24/2003
Date Last Modified: 12/8/2003 3:56:45 PM
Language: English - United States
Country: USA
Product: Microsoft CRM
Versions: 1.0
Modules: Microsoft CRM Miscellaneous
SYMPTOMS
Microsoft CRM Deletion Service failure error - "Cannot clean up
ActivityBase table." occurs in the Application Event Log on the Microsoft
CRM Server.
CAUSE
This error usually appears when an attachment is attached to an
Activity record, where the Activity record has been deleted from the
application. At that point, the record is marked to be deleted from the
database. Then, the deletion service sees that this record needs to be
deleted. However, when the service tries to delete the Activity record, it
cannot because there is an attachment assigned to the Activity record.
Since the Attachment is stored in a separate table, there is a dependency on
the Activity record, so it cannot be deleted.
RESOLUTION
To verify this, on the Microsoft SQL Server where you installed
the Microsoft CRM databases, please open the Query Analyzer tool (Start |
Programs | Microsoft SQL Server | Query Analyzer). Point to the
<organization_name>_MSCRM database, and execute the following script:
SELECT * FROM ActivityBase WHERE DeletionStateCode = 2
This statement will return records in the ActivityBase table,
where all Activity records are stored, that are marked for deletion. The
Microsoft CRM Deletion Service removes any records with a DeletionStateCode
= 2 for any entity in the database.
If the Activity record(s) in question are not being removed,
there is most likely a reference to that record in the Activity Attachment
table.
MORE INFORMATION
Microsoft Business Solutions does have a hotfix available for
this issue. If you would like to receive this hotfix, please contact
Microsoft Business Solutions CRM Support at
http://www.greatplains.com/support or call 1-888-477-7877.
