Error in OCS default gathering "Error running stored procedure The conversion of the nvarchar value '9820420191' overflowed an int column. Maximum integer value exceeded"
Error running stored procedure PR_OCS_PopulateIMAndFileTransferData
Instant Messages that specifically contain very large numbers in their body with no characters in it will give errors during Instant Message and file transfer gathering for arithmetic overflow.
The attached sql script can be downloaded and run against the MessageStats database using sql query analyzer/management studio.
This will delete all stored procedures, and re-add them. The data will remain in tact.
This script will also update all the affected stored procedures to the latest version.
This script can be run against any version of Messagestats console, independently of the Messagestats data.
