IT04087: ACO0005E OUT OF MEMORY ERROR WHEN RESTORING AN SQL AVAILABILITY ALWAYSON DATABASE USING MORE THAN 1 STRIPE

Download Information: Version 7.1.2 Tivoli Storage Manager for Databases
Download Information: Version 4.1.2 Tivoli Storage FlashCopy Manager

APAR status

• Closed as program error.

Error description

• When using Tivoli Storage Manager for Databases, Data Protection
  for Microsoft SQL Server commandline or GUI to restore an
  AlwaysOn Availability Group database with more than 1 stripe
  (backup was performed with stripes greater than 1), the
  following errors are seen in the Data Protection for Microsoft
  SQL Server log:
    ACO0005E Out of memory. Stop other processes and try the
     operation again.
   ACO5436E A failure occurred on stripe number (1), rc = 102
   ANS0221E (RC2014) There was an error in the TSM API internals.
   ACO5060E A Tivoli Storage Manager API error has occurred.
   ACO0151E Errors occurred while processing the request.
   An exception occurred while executing a Transact-SQL statement
    or batch.
   Read on "TDPSQL-000098AD-0000" failed: 1003(Cannot complete
    this function.)
   A nonrecoverable I/O error occurred on file
    "TDPSQL-000098AD-0001:"
    995(The I/O operation has been aborted because of either a
    thread exit or an application request.).
  The Windows Application Event log will show the error for the
  SQLVDI:
   SQLVDI: Loc=SignalAbort. Desc=Client initiates abort.
    ErrorCode=(0).
  The SQL Server will have an Error: 18210, Severity: 16, State: 1
  Note that even though a memory error is shown for the failure,
  the machine is not out of memory, the error message is
  incorrect.
  This problem only affects the AlwaysOn Availability Database
  Restores, and does not affect other stand-alone SQL databases.
   Versions Affected:
    Tivoli Storage FlashCopy Manager, 3.2, and 4.1
    Tivoli Storage Manager for Databases: Data Protection for
      Microsoft SQL Server  6.4.x and 7.1.x
  
  Initial Impact: High
  Additional Keywords:  TSM TDP FCM
  

Local fix

• Set the STRIPES option to 1 for any Availability AlwaysOn
  restores.
  Using Stripes=1 works successfully for the restore, regardless
  of how many stripes were used for the backup.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: Users of:                                    *
  *                 - FlashCopy Manager for Microsoft SQL 3.2    *
  *                   and 4.1                                    *
  *                 - FlashCopy Manager MMC Snapin and Base      *
  *                   System Services 3.2 and 4.1                *
  *                 - Tivoli Storage Manager for Databases:      *
  *                   Data Protection for Microsoft SQL 6.4      *
  *                   and 7.1                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: see ERROR DESCRIPTION                   *
  ****************************************************************
  * RECOMMENDATION: Apply fixing level when available. This fix  *
  *                 is currently projected to be available in:   *
  *                 - FlashCopy Manager for Microsoft SQL 4.1.2  *
  *                 - FlashCopy Manager MMC Snapin and Base      *
  *                   System Services 4.1.2                      *
  *                 - Data Protection for Microsoft SQL          *
  *                   6.4.1.6, 7.1.1.1, and 7.1.2                *
  *                                                              *
  *                 Note 1: This information is subject to       *
  *                 change at the discretion of IBM.             *
  *                                                              *
  *                 Note 2: Until a FlashCopy Manager for SQL    *
  *                 Server fix is available, FlashCopy Manager   *
  *                 customers may install and use a fixed level  *
  *                 of the Data Protection for Microsoft SQL     *
  *                 Server. When installed into a FlashCopy      *
  *                 Manager on Windows environment, the Data     *
  *                 Protection for SQL Server fix provides       *
  *                 equivalent functionality.                    *
  ****************************************************************
  *
  

Problem conclusion

• Code was fixed so that a Legacy restore of AlwaysOn
  Availability Database using multiple stripes succeeds.
  

Temporary fix

Comments

APAR Information

• 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

  TDP FOR SQL WIN

• Fixed component ID

  5698DPSAP

Applicable component levels