ODBC error "Access to catalog index (Catalog index database) failed" appears every four hours on Backup Exec 2012 server.

Article:TECH186630

Created: 2012-04-17

Updated: 2013-02-05

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

Article Type
Technical Solution

Product(s)

Show all

Languages

Show all

Problem

Every four hours, Backup Exec 2012 will generate ODBC events in the Alerts as well as the Application Event Log on the Backup Exec Media Server.

Error

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

Environment

Backup Exec 2012

Cause

Application Log Errors:

Event ID: 34326
Description:
Access to catalog index (Catalog index database) failed.
Reason: [Microsoft][ODBC Driver Manager] Fehler in der Funktionsreihenfolge cat_RecordSet::GetRecordCount()
r:\honshu\1798r.amd64\becat\segodbc\seg_odbc.cpp(4063)
SELECT [ImageGuid], [MediaGuid], [ImageName], [CartridgeLabel], [DeviceGuid],
[ImageLocation], [ImageStorageUsageByte], [ImageExpirationTimeUTC],
[JobHistoryGuid], [ContainerGuid] FROM [dbo].[CATDLM_GetExpirableImage_BE]
(?, ?, ?, ?, ?, ?)

Event ID: 34338
Description:
Backup Exec message: Catalog Error
(Server: "ServerName") ODBC access error. Possible Cause: Closed Connection to database or unsuccessful access to catalog index in the database.

Solution

This issue is resolved by applying Backup Exec 2012 Service Pack 1a (TECH186717).

After applying Backup Exec 2012 Service Pack 1a, it may be necessary to run a Backup Exec SQL script against the Backup Exec database (TECH190352).

Supplemental Materials

Source	ETrack
Value	2749244
Description	CORE: ODBC Access errors. Event ID 34338 and 34326 reported on Media Server running Backup Exec 2012.

Source	Event ID
Value	34326
Description	Access to catalog index (Catalog index database) failed. Reason: [Microsoft][ODBC Driver Manager] Fehler in der Funktionsreihenfolge cat_RecordSet::GetRecordCount() r:\honshu\1798r.amd64\becat\segodbc\seg_odbc.cpp(4063) SELECT [ImageGuid], [MediaGuid], [ImageName], [CartridgeLabel], [DeviceGuid], [ImageLocation], [ImageStorageUsageByte], [ImageExpirationTimeUTC], [JobHistoryGuid], [ContainerGuid] FROM [dbo].[CATDLM_GetExpirableImage_BE] (?, ?, ?, ?, ?, ?)

Source	Event ID
Value	34338
Description	ODBC access error. Possible Cause: Closed Connection to database or unsuccessful access to catalog index in the database.