IBM Support

IT04613: ANS1086E (RC104) FILE NOT FOUND ON SQL DB RESTORE FROM VMVSS BACKUP IMAGE

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • The restore of a SQL database from a VMVSS type backup image
    might stop with the message :
    
    ANS1086E (RC104)  File not found during Backup, Archive or
                      Migrate processing
    ACO5060E A Tivoli Storage Manager API error has occurred.
    
    in the dsmerror.log of the TSM client agent node the following
    will be seen :
    
    <timestamp> ANS2448E Mount command failed.
       Command was "C:\Program Files(x86)\Tivoli\TSM\TDPVMware\
                    shell\TDPVMwareShell.exe"
       -c mount add -rep "tsm: ip=<ip from the TSM server> port=1500
       node=<datamover node name> -from_node=<datacenter node name>
       pass=" -vmname <vmname> -disk 2 -date "<backup image
       timestamp in en_US format>" -type partition -PartitionNumber
       0  -target F:\TEMP\TSM20140130151625
    Shell command returned:
    FBSC1413I Working with Recovery Agent on <vmname> (<ip of the
              Recovery Agent Shell host>)
    FBSC1428I Waiting for connection to Recovery Agent 1 seconds...
     Connected to Recovery Agent
    FBSC7269E   Mount- failed to find the job
    <timestamp> ANS5250E An unexpected error was encountered.
       TSM function name : rpDoFileCopy
       TSM function      : fioOpen for file '\\<vmname>\<path\SQL DB
                           filename>' failed with rc = 104.
       TSM return code   : 104
       TSM file          : ..\..\common\ba\restproc.cpp (5990)
    <timestamp> ANS5266E File-level copy restore of '<SQL DB name>'
                         failed.
    <timestamp> ANS4005E Error processing '\\<vmname>\<path\SQL DB
                         filename>': file not found
    
    The above errors appears because the recovery agent searches for
    the needed backup image with a en_US date and time format as
    received from the Data Protection for Microsoft SQL Server
    Client and does not find it because the available backup image
    created with the Tivoli Storage Manager for Virtual Environment
    Data Protection for VMware client has a different time stamp
    format.
    This issue will happen when the VMVSS backup images timestamps
    are recorded in a non-US date and time format.
    
    Tivoli Storage Manager Versions Affected:
    Tivoli Storage Manager client 7.1 on Windows
    
    Initial Impact: high
    
    Additional Keywords: zztsm sql VMVSS datamover tdp4ve RA
    recovery agent VM restore tdpsqlc
    

Local fix

  • Use non-VMVSS type backups (VSS or Legacy) until the fix is
    available
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: Users of:                                    *
    *                                                              *
    *                 Tivoli Storage  FlashCopy Manager for        *
    *                 Microsoft SQL Server 4.1.0 - 4.1.1.1         *
    *                 Tivoli Storage Manager for Databases:        *
    *                 Data Protection for Microsoft SQL            *
    *                 Server 7.1.0 - 7.1.1.1                       *
    ****************************************************************
    * PROBLEM DESCRIPTION: See ERROR DESCRIPTION                   *
    ****************************************************************
    * RECOMMENDATION: This issue is projected to be fixed in       *
    *                 the following components and levels          *
    *                 - Tivoli Storage Manager Client on           *
    *                   Windows: 7.1.2                             *
    *                 - Tivoli Storage FlashCopy Manager           *
    *                   VSS Requestor 4.1.2                        *
    *                                                              *
    *                 Note 1: The Tivoli Storage Manager (TSM)     *
    *                 Client 7.1 on Windows is a prerequisite to   *
    *                 using the Data Protection for Microsoft      *
    *                 Exchange Server 7.1. In FlashCopy Manager    *
    *                 environments, the TSM Client 7.1 is also     *
    *                 known as the FlashCopy Manager VSS           *
    *                 Requestor 4.1 component.                     *
    *                                                              *
    *                 Note 2: This information is subject to       *
    *                 change at the discretion of IBM.             *
    ****************************************************************
    *
    

Problem conclusion

  • The Tivoli Storage Manager Client and Tivoli Storage FlashCopy
    Manager VSS Requestor components have been updated to restore
    SQL database from a VMVSS backup regardless of the system
    date/time format.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT04613

  • Reported component name

    TDP FOR SQL WIN

  • Reported component ID

    5698DPSAP

  • Reported release

    71W

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-09-30

  • Closed date

    2014-12-08

  • Last modified date

    2014-12-08

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

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

Fix information

  • Fixed component name

    TSM CLIENT

  • Fixed component ID

    5698ISMCL

Applicable component levels

  • R71W PSY

       UP



Document information

More support for: Tivoli Storage Manager

Software version: 71W

Reference #: IT04613

Modified date: 08 December 2014