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

Issue



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)


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


Terms of use for this information are found in Legal Notices