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.

  • Modified Date:
  • Article ID:000094533



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).



Error Message


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.




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()


{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()


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





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 

Applies To


Backup Exec for Windows 12.5

Backup Exec 2010 R1, R2, and R3



Terms of use for this information are found in Legal Notices.



Did this article answer your question or resolve your issue?


Did this article save you the trouble of contacting technical support?


How can we make this article more helpful?

Email Address (Optional)