IT19216: RESTORE FROM VMVSS BACKUP TERMINATES WITH ANS9892E IF THE DATABASE IS LOCATED BEHIND A MOUNTPOINT

Download Information: Version 8.1.0.x Data Protection for VMware
IBM Spectrum Protect client 8.1.x.y interim fix downloads
Download Information: Version 8.1.2 IBM Spectrum Protectâ„¢ for Virtual Environments

APAR status

• Closed as program error.

Error description

• Tivoli Storage Manager for Virtual Environments - Data
  Protection for VMware provides a database level recovery
  from virtual guest backups using Tivoli Storage Manager for
  Databases - Data Protection for Microsoft SQL Server and
  Tivoli Storage Manager for Mail - Data Protection for Microsoft
  Exchange Server.
  If database files are located behind a mountpoint, restore of
  such database may terminate with with the following error
  sequences in the guest agent node logs:
  tdpsql.log:
  ANS9892E (RC974)  Unable to find snapshot(s) in the local
  repository.
  ACO5060E A Tivoli Storage Manager API error has occurred.
  dsmerror.log:
  ANS5250E An unexpected error was encountered.
     TSM function name : objEnumGetNextObj
     TSM function      : Unable to find volume '<volume mount
  point>' for file '<database file behind the mount point>' in
  snap volume list
     TSM return code   : 105
  
  Products affected:
  IBM Spectrum Protect for Virtual Environments: Data Protection
  for VMware version 8.1.0 on Windows
  
  This problem also affects IBM Spectrum Protect Backup-Archive
  Client which is the data mover for Data Protection for
  VMware 7.1. If you are using Data Protection for VMware
  7.1 refer to APAR IT17252.
  
  Initial Impact: High
  Additional Keywords: tsm spectrum protect sql exchange restore
  file-level vmtsmvss application protection
  

Local fix

• Mount the snapshots using Recovery agent and restore database
  files from the mounted snapshot manually.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Users of:                                                    *
  *  Spectrum Protect for Mail: Data Protection Microsoft        *
  * Exchange Server 8.1                                          *
  *  Spectrum Protect Snapshot for Microsoft Exchange Server 8.1 *
  *  Spectrum Protect for Databases: Data Protection for         *
  * Microsoft SQL Server 8.1                                     *
  *  Spectrum Protect Snapshot for Microsoft SQL Server 8.1      *
  *                                                              *
  * who perform restore from VMVSS backups.  Which was done by   *
  * IBM Spectrum Protect for Virtual Environments Data           *
  * Protection for VMware Data Mover versions 7.1 or 8.1.0 on    *
  * Windows x64 platform                                         *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * This issue is projected to be fixed in the Data Protection   *
  * for VMware Data Mover version 8.1.0.1 and 8.1.2 on all       *
  * Microsoft Windows x64 platforms                              *
  * Note 1: This is subject to change at the discretion of IBM.  *
  ****************************************************************
  

Problem conclusion

• IBM Spectrum Protect for Virtual Environments Data Protection
  for VMware Data Mover has been updated to handle correctly a
  restore of Microsoft Exchange and SQL databases that are located
  behind a mountpoint from VMVSS backups.
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

  IT17252

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• dsmagent
  

Fix information

• Fixed component name

  TSM FOR VE DP V

• Fixed component ID

  5725TVEVM

Applicable component levels

• R81W PSY

     UP