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

Article:TECH179801  |  Created: 2012-01-25  |  Updated: 2013-04-09  |  Article URL http://www.symantec.com/docs/TECH179801
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


Issue



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


Error



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 
 
 


Environment



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


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.


Supplemental Materials

SourceETrack
Value2647202
Description

CATALOG: Unable to restore or Catalog Data “ODBC Access Error”


SourceUMI
Value V-79-57344-1538
Description

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.


SourceUMI
ValueV-79-57344-2304
Description

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


SourceError Code
Value0xe0000602
Description

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.


SourceError Code
Value0xe0000900
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.




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


Terms of use for this information are found in Legal Notices