Restore jobs or catalog jobs would fail with error "0xe0000602" and "0xe0000900"

Problem

When trying to restore jobs or catalogs the job would fail with the following error

Error Message

Restore Job would give the following error:

Final error: 0xe0000602 - A query for media on which the data set being read is continued was unsuccessful. Ensure that all media in the family have been inventoried and cataloged.
Final error category: Backup Media Errors

For additional information regarding this error refer to link V-79-57344-1538

The query for media sequence number -15878 of this media family was unsuccessful.
Ensure that all media in the family have been inventoried and cataloged.


Catalog job would fail with the following error:

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.
Final error category: Backup Media Errors

For additional information regarding this error refer to link V-79-57344-2304

In the Event Viewer it shows the following:

Error     12/15/2011   1:43:14 PM  Backup Exec CatErrorHandler Server   34326
    Access to catalog index (Catalog index database) failed.
    Reason:
    [Microsoft][ODBC Driver Manager] Function sequence error
cat_RecordSet::GetRecordCount()
    e:\nicobar\5204r\becat\segodbc\seg_odbc.cpp(4015)
    SELECT * FROM CatMedia WHERE 1=1 AND  CatMedia.MediaNumber = ? AND
CatMedia.MediaFamilyGuid = ?  AND CatMedia.Status & ? = 0 
 
 

Solution

Workaround:

1. Duplicate the backup set for which the catalog jobs are failing

2. If the backups are on tape, restore from tape and discard the backups which are running to disk. Then create new backup jobs that target new backup-to-disk folders.

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 currently 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. This issue may be resolved in a future major revision of the software at a later time. 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.

 

Applies To

Issue is seen when the backup is on the disk. From Tape backups restore and catalogs jobs work fine.

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

Search

Survey

Did this article answer your question or resolve your issue?

No
Yes

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

No
Yes

How can we make this article more helpful?

Email Address (Optional)