Some restore selection may not show files to restore. Re-cataloging the media fails with ODBC alerts and An error occurred while retrieving catalog information.

Article:TECH162746  |  Created: 2011-06-20  |  Updated: 2011-07-05  |  Article URL http://www.symantec.com/docs/TECH162746
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 a successful backup job some restore selections my not show file history or files to restore with a message "No Selections exist for this resource".  This may happen if the backup job was an append job and many appends to the same media or media family has taken place.  Additionally  the restore selection sets displays a negative Backup Set Number (FIGURE 1).

 

(FIGURE 1)


Error



 

0xe0000904 - An error occurred while retrieving catalog information.
Final error category: Backup Media Errors

 

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



 


Environment



 

Backup Exec for Windows 12.5

Backup Exec 2010 R1, R2, and R3

 

 


Cause



 

This issue occurs because the Backup Set Number or Image number contains a "negative value".

 

The following Application Log Event appear when attempting to catalog any media in the set.

 

Application Log Errors:

 

(Backup Exec 12.5)  

 

The description for Event ID ( 34326 ) in Source ( Backup Exec CatErrorHandler Server ) could not be found. It contains the following insertion string(s): .

Catalog index database

[Microsoft][ODBC SQL Server Driver]Numeric value out of range cat_RecordSet::Open()

r:\corsica\2213r\becat\segodbc\seg_odbc.cpp(2436)

{CALL DeleteCatImageByImageNumberMediaFamilyGuid ( ?, ?, ?) }

 

(Backup Exec 2010 R3)

  

 

The description for Event ID ( 34326 ) in Source ( Backup Exec CatErrorHandler Server ) could not be found. It contains the following insertion string(s): .

Catalog index database

[Microsoft][ODBC Driver Manager] Function sequence error cat_RecordSet::GetRecordCount()

e:\nicobar\5204r\becat\segodbc\seg_odbc.cpp(4015)

SELECT distinct CatMedia.*, ImageObjectView.FragmentState FROM CatMedia, ImageObjectView WHERE CatMedia.MediaFamilyGuid = ImageObjectView.MediaFamilyGuid AND CatMedia.MediaNumber = ImageObjectView.MediaNumber AND ImageObjectView.ImageNumber = ? AND CatMedia.MediaFamilyGuid = ? AND CatMedia.Status & ? = 0

 


Solution



 

WORKAROUND:

Use media sets to limit the appendable period of the media and configure jobs to “append to media, overwrite if no appendable media is available.”  The recommendation is to configure the appendable period so that Backup Exec can switch to overwrite once a week or another set time period.

 

NOTE: If data needs to be restored please contact Symantec Technical support.  A supported hotfix has been made available for this issue in Backup Exec 2010 R3. Please contact Symantec Technical Support to obtain this fix. This hotfix has not yet gone through any extensive Q&A testing. Consequently, if you are not adversely affected by this problem and have a satisfactory temporary workaround in place, we recommend that you wait for the public release of this hotfix.
 

 

 
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.
There are no plans to address this issue by way of a patch or hotfix in the current or previous versions of the software at the present time. However, the issue is currently scheduled to be addressed in the next major revision of the product. Please be sure to refer back to this document periodically as any changes to the status of the defect will be reflected here.  Please note that Symantec Corporation reserves the right to remove any fix from the targeted release if it does not pass quality assurance tests.  Symantec's plans are subject to change and any action taken by you based on the above information or your reliance upon the above information is made at your own risk.

Please contact your Symantec Sales representative or the Symantec Sales group for upgrade information including upgrade eligibility to the release containing the resolution for this issue.  For information on how to contact Symantec Sales, please see    http://www.symantec.com 
 
 

Supplemental Materials

SourceUMI
ValueV-79-57344-2308
Description

0xe0000904 - An error occurred while retrieving catalog information. Final error category: Backup Media Errors

 


SourceError Code
Value0xe0000904
Description

0xe0000904 - An error occurred while retrieving catalog information. Final error category: Backup Media Errors
 


SourceEvent ID
Value34326
Description

Access to catalog index (Catalog index database) failed.
Reason:  [Microsoft][ODBC Driver Manager] Function sequence error
cat_RecordSet::GetRecordCount()
 


SourceUMI
ValueV-79-57344-2304
Description

Final error: 0xe0000900 - The requested media is not listed in the media index and could not be mounted. To add the media's catalog information to the disk-based catalogs, run an inventory operation on the media and resubmit the Catalog operation


SourceEvent ID
Value34338
Description

 

 

 

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


SourceEvent ID
Value34326
Description

 

 

 

The description for Event ID ( 34326 ) in Source ( Backup Exec CatErrorHandler Server ) could not be found. It contains the following insertion string(s): .

Catalog index database

[Microsoft][ODBC Driver Manager] Function sequence error cat_RecordSet::GetRecordCount()

e:\nicobar\5204r\becat\segodbc\seg_odbc.cpp(4015)

SELECT distinct CatMedia.*, ImageObjectView.FragmentState FROM CatMedia, ImageObjectView WHERE CatMedia.MediaFamilyGuid = ImageObjectView.MediaFamilyGuid AND CatMedia.MediaNumber = ImageObjectView.MediaNumber AND ImageObjectView.ImageNumber = ? AND CatMedia.MediaFamilyGuid = ? AND CatMedia.Status & ? = 0


SourceEvent ID
Value4326
Description

 

 

 

The description for Event ID ( 34326 ) in Source ( Backup Exec CatErrorHandler Server ) could not be found. It contains the following insertion string(s): .

Catalog index database

[Microsoft][ODBC SQL Server Driver]Numeric value out of range cat_RecordSet::Open()

r:\corsica\2213r\becat\segodbc\seg_odbc.cpp(2436)

{CALL DeleteCatImageByImageNumberMediaFamilyGuid ( ?, ?, ?) }


SourceEvent ID
Value34338
Description

 

 

 

Backup Exec Alert: Catalog Error

(Server: ) ODBC access error. Possible lost connection to database or unsuccessful access to catalog index in the database.


SourceETrack
Value2413855
Description

CATALOG: Unable to restore or catalog data ODBC Error Function sequence error



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


Terms of use for this information are found in Legal Notices