Reporting Aggregation fails with error "Conversion failed when converting datetime from character (4287464)

Report Aggregation fails and gives error message â€Conversion failed when converting datetime from character stringg†after upgrading SQL Server.

Clients who originally installed the MessageStats database on SQL Server 2000 and then later upgrade SQL Server may have failures during the Report Aggregation task. This is due to the PR_CalculateRollups stored procedure failing with the message â€Conversion failed when converting datetime from character stringgâ€.

To workaround this issue, follow the below steps:

1 - Open SQL Management Studio Tools

2 - Navigate to the Messagestats Database | Properties and select Options.

3 - Changing the Compatability Level dropdown from SQL 2000 to be the version of SQL that is being used.  (See attachment for more information)