Error when going to the second page of a search result: "SearchResultTable SRT_dbo_MessageSearch_458d7af716a73c1dfd604170acf8a7a3_20150806230749Z

Error when going to the second page of a search result: "SearchResultTable SRT_dbo_MessageSearch_458d7af716a73c1dfd604170acf8a7a3_20150806230749Z_3584 has column CheckSum" (4222358)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Error when going to the second page of a search result: "SearchResultTable SRT_dbo_MessageSearch_458d7af716a73c1dfd604170acf8a7a3_20150806230749Z_3584 has column CheckSum"
Description

When search results are returned and clicking in the second page you see an error similar to the following:
"SearchResultTable SRT_dbo_MessageSearch_458d7af716a73c1dfd604170acf8a7a3_20150806230749Z_3584 has column CheckSum where it should be _ID"
Cause

The AfterMail_Temp database cleanup has not been cleaning up the tables from the search results.
Resolution

Run the following Stored Procedure manually which will clean up the AfterMail_TEMP database:
USE AfterMail_TEMP
exec sp_MSforeachtable "DROP TABLE ? PRINT '? dropped' "
GO

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Request a KB Article

Error when going to the second page of a search result: "SearchResultTable SRT_dbo_MessageSearch_458d7af716a73c1dfd604170acf8a7a3_20150806230749Z_3584 has column CheckSum" (4222358)

Title

Description

Cause

Resolution

Leave a Comment