HELP!!! ODBC access error. Possible lost connection to database or unsuccessful access to catalog index in the database.

[fl]

We're having major issues with our backup solution. We have a single BE 12 server. We been receiving the following errors from all Windows, Linux and Mac servers. And also errors relating to "value out of range" When I try to restore the Backup Set Number that ends with a negative value (ie, -30577) and catalog File Name ending in a negative value (ie, ....._-30577.xml) are the ones that doesn't show the restore list after the backup job is successful. We trying everything from repair DB, renaming Catalog folders, etc... still no luck! Please help! As we are not able to do any kind of backups at this point we can not afford to start over and lose months of backups. Backup Exec Alert: Catalog Error ODBC access error. Possible lost connection to database or unsuccessful access to catalog index in the database. From application event log: Access to catalog index (Catalog index database) failed. Reason: [Microsoft][ODBC SQL Server Driver]Numeric value out of range cat_RecordSet::Open() r:\catalina\1364r\becat\segodbc\seg_odbc.cpp(2404) SELECT distinct CatMedia.*, ImageObjectView.FragmentState FROM CatMedia, ImageObjectView WHERE CatMedia.MediaFamilyGuid = ImageObjectView.MediaFamilyGuid AND CatMedia.MediaNumber = ImageObjectView.MediaNumber AND CatMedia.PartitionID = ImageObjectView.PartitionID AND ImageObjectView.ImageNumber = ? AND CatMedia.PartitionID = ? AND CatMedia.MediaFamilyGuid = ? AND CatMedia.Status & ? = 0

Case History Actions View Case Detail Add Case Comment Add Case Files Close Case

[Dev_T]

Hello,

1  : Stop all BE services and the SQL service for Backup Exec
2  : Go to C:\prog files\symantec\backup exec and rename the CATALOGS folder to DATALOGS.OLD
3  : Create a new CATALOGS folder at the same location.
4  : start the SQL service 1st and then all the BE services.
5  : Run Inventory on the TAPE and then the catalog job

Hope this helps....

[AmolB]

Refer to http://support.veritas.com/docs/334732  or http://support.veritas.com/docs/305862

Also clear job log history which is 3 months old.