Recovery Solution 6.2 sP3 (6.2.2801) - SSM job fails with arithmetic overflow error

Article:TECH187980

Created: 2012-05-03

Updated: 2012-05-03

Article URL http://www.symantec.com/docs/TECH187980

Article Type
Technical Solution

Languages

Show all

Problem

GetDelBlobRecs SP is unable to use INT to allocate amount of deleted data

Error

There was an error with the record set associated with the GetDelBlobRecs
stored procedure.
Arithmetic overflow error converting expression to data type int.

There was an error with the record set associated with the GetDelBlobRecs
stored procedure.
State:22003,Native:8115,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]

GetDeletedBlobRecs() returned an error.
Local Event Code: 0xc0040016
System Event Code: 0x80004005: Unspecified error
SbsName: , SbsKey: 0, 0

The stored procedure GetDelBlobRecsEx failed.
Local Event Code: 0xc0070101
System Event Code: 0x00000000
SbsName: , SbsKey: 0, 0

GetDeletedBlobRecs() returned an error.
Local Event Code: 0xc0040016
System Event Code: 0x80004005: Unspecified error
SbsName: , SbsKey: 0, 0

Environment

Applies to RS version 6.2 SP3 (6.2.2801)

Solution

Please find the reworked stored procedure attached. Instructions to apply:

- Make sure RS Server does not run SSM or Deletion job at the moment
- Load the attached script into SQL Management Studio
- Execute it against the RS SQL database

Execution of the script will drop the existing stored procedure and create an improved one.

Attachments

2765890_6_2_2801_GetDelBlobRecs.sql (2 kBytes)