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

Article:TECH150111  |  Created: 2011-01-24  |  Updated: 2012-03-19  |  Article URL http://www.symantec.com/docs/TECH150111
Article Type
Technical Solution

Product(s)

Environment

Issue



Browsing restore selections gives ODBC errors and restarting the services causes a large number of alerts with the same error


Error



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


Cause



There are corrupt catalog files with a hypen "-" before the catalog increment.


Solution




Solution 1:

1.Move all the catalog files with the bad name to a new folder outside of the catalogs folder.
2.Example of bad file name:  {CF0BA828-29F7-4515-AA14-0D2B48504A23}_-32370.xml
3.Note: This will cause the restore selections for the moved files to not be available until they are recataloged.

Solution 2 :

1.From the Backup Exec interface go to Tools ->Backup Exec services ->Stop all services.
2.Go to the installation directory of Backup Exec (default location is C:\Program Files\Symantec\Backup Exec\) and rename the 'Catalogs' folder to 'Catalogs.Old'.
3.Open the Windows command prompt and browse to the installation directory \Program Files\Symantec\Backup Exec\ and run the command "CatRebuildIndex -r".
4.Start all Backup Exec services. A new 'Catalogs' folder will now be created on the Backup Exec installation directory.
5.Lauch the Backup Exec console and go to Tools ->Options ->Catalog -> Uncheck use ''storage media based catalog''.
5.Run catalog job on all media that are needed for the backup or restore job.

Solution 3 :

1.Change the location of Catalogs folder to another volume using Beutility.
  www.symantec.com/docs/TECH50241


Solution 4 :

1.For Backup Exec version 12.5,ensure that hot fix 327039 is installed. To check all updates that have already been installed from the Backup Exec interface go to Help ->About ->Installed updates.
2.If hotfix 327039 is not on the list of installed updates then go to Tools -> Live update. Install all available hot fix or service packs. You will have to repeat this step again until you get a message that states all available updates have been installed.
3.Push install the Remote Agent for Windows Servers to all remote servers.
  How to push install the Remote Agent for Windows Servers (RAWS) from the Backup Exec Media Server Console .
 http://www.symantec.com/docs/TECH127916


Supplemental Materials

SourceEvent ID
Value34338
Description

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




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


Terms of use for this information are found in Legal Notices