Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

ODBC Access Errors after Backup Exec 2010 R3 Service Pack 3 Update

Created: 09 Aug 2013 | 5 comments

Recently I updated Backup Exec 2010 R3 from SP2 to SP3 which reported no errors during the update.

Backups are now failing with the following Alerts:

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

Catagory: Catalog Error

Type: Error

Server: {Server Name}

Source: System

Event ID: 34338

System: Windows Server 2008 SP2

Backup Exec 2010 R3  Media Server Version 13.0 Rev 5204 (32 bit)

Installed Updates listed: Service Pack 3

Backup exec database is located on another SQL server on the network. I have verified that no network connection has been lost and that the DB is up and running on the other server.

Thank you in advance for your help!

Operating Systems:

Comments 5 CommentsJump to latest comment

ZeRoC00L's picture

Check if all Backup Exec services arfe running.

Also check if you can connect to the SQL server:

http://www.symantec.com/business/support/index?pag...

If this response answers your concern, please mark it as a "solution"

praposo's picture

All services are running. 

Ran the connection test in the article provided and was able to connect without issue.

VJware's picture

See if creating a new Catalogs folder or by running catrebuildindex -r helps or not.

Verbatim from KBs _

  • Stop all BE Services
  • Open command prompt and browse to x:\Program Files\Symantec\Backup Exec
  • Run "CatRebuildIndex -r".
  • Start all BE services.

If the above doesn't work, try this ~

  • Stop all Backup Exec services.
  • Rename the Catalogs folder to Catalogs_OLD (default location - x:\Program Files\Symantec\Backup Exec\)
  • Run the steps from Solution 1 above. (Regarding catrebuildindex -r)
  • Start all BE services. A new Catalogs folder will be created.
  • At this point no catalogs are present as this is a new, blank Catalogs folder.
  • It will be necessary to run a Catalog job on each piece of media prior to running any restore or duplicate job on that media.
praposo's picture

When running the catrebuildindex -r in both steps above I receive:

CatUpgrade: Schema Upgrade to 13.2 from 13.1
 
RunSQLScript via dbutil: D:\Program Files\Symantec2010\Backup Exec\catupgrade_13_0.sql
 
{dbuitil RunSQLScript info here}
 
CatUpgrade: SchemaUpgrade Catalog Schema Version= 13.1
 
CatUpgrade: SchemaUpgrade failed.
Kunal.Mudliyar's picture

Please log a support case for this issue.

Technical Support

Symantec