Getting "ODBC access error. Possible lost connection to database or unsuccessful access to catalog index in the database" on restarting Backup Exec Services.

Article:TECH167225  |  Created: 2011-08-16  |  Updated: 2013-04-09  |  Article URL http://www.symantec.com/docs/TECH167225
NOTE: If you are experiencing this particular known issue, we recommend that you Subscribe to receive email notification each time this article is updated. Subscribers will be the first to learn about any releases, status changes, workarounds or decisions made.
Article Type
Technical Solution

Product(s)

Issue



After restarting the Backup Exec services lots of "ODBC access error. Possible lost connection to database or unsuccessful access to catalog index in the database" is received in the Application Log and also similar alerts are generated in Alerts tab in Backup Exec.


Error



Application Log Errors:


Source:  Backup Exec CatErrorHandler Server
Event ID: 34327
Error :  Update to catalog index (Catalog index database) failed.
Reason:
    D:\Catalogs\SERVER-NAME\{86794C68-8397-4F24-A2EA-404B54FED371}_31.xml PerformBulkInsert()
    e:\nicobar\5204r\becat\catindex\dll\..\catdbupdatethread.cpp(447)


Source:  Backup Exec
Event ID: 34338
Error :  Backup Exec Alert: Catalog Error (Server: "SERVER-NAME") ODBC access error. Possible lost connection to database or unsuccessful access to catalog index in the database.

 

Source:  Backup Exec CatErrorHandler Server
Event ID: 34327
Error :  Update to catalog index (Catalog index database) failed
Reason:
[Microsoft][ODBC SQL Server Driver][SQL Server]The INSERT statement conflicted with The FOREIGN KEY constraint "FK_CatImage_CatResource". The conflict occurred in database "BEDB", table "dbo.CatResource", column 'ResourceID'. cat_RecordSet::ExecuteBulkInsert()
    e:\nicobar\5204r\becat\segodbc\seg_odbc.cpp(3113)
    sp_sproc_columns CatImageInfoProc

 


Source:  Backup Exec CatErrorHandler Server
Event ID: 34327
Error :  Update to catalog index (Catalog index database) failed
Reason:
   D:\Catalogs\SERVER-NAME\{3E4F622C-8411-47A3-9EDC-449192907CED}_8.xml PerformBulkInsert()
    e:\nicobar\5204r\becat\catindex\dll\..\catdbupdatethread.cpp(447)
 


Solution



Symantec Corporation has acknowledged that the above-mentioned issue is present in the current version(s) of the product(s) mentioned at the end of this article. Symantec Corporation is committed to product quality and satisfied customers.This issue is currently under investigation by Symantec Corporation. Pending the outcome of the investigation, this issue may be resolved by way of a patch or hotfix in current or future revisions of the software. However, this particular issue is not currently scheduled for any release.  If you feel this issue has a direct business impact for you and your continued use of the product, please contact your Symantec Sales representative or the Symantec Sales group to discuss these concerns.  For information on how to contact Symantec Sales, please see http://www.symantec.com Please be sure to refer back to this document periodically as any changes to the status of the issue will be reflected here.

NOTE: Customers experiencing this issue are encouraged to contact Symantec Technical Support as data is still being collected to assist in resolving this issue.


Supplemental Materials

SourceETrack
Value2508459
Description

Update to catalog index (Catalog index database) failed



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


Terms of use for this information are found in Legal Notices