IT31470: CTGGE0084 AND CTGGA2073 MESSAGES ON SQL SERVER BACKUPS

APAR status

• Closed as program error.

Error description

• In the joblog seeing the messages :
  
  ERROR,<timestamp>,2,CTGGE0084,[<SQL server host address>] SQL
  backup failed reason [Failed to find the compressed file
  [c:\ProgramData\SPP\ffe09200-0c2d-435c-85a9-03ce1ea36f75\vssback
  updocs.zip] the backup fails].
  ERROR,<timestamp>,2,CTGGA2073,Failed to perform backup of db
  instance <SQL server instance name> on application server <SQL
  server host address> : Unable to retrieve file vssbackupdocs.zip
  from <SQL server host address>. e=java.lang.Exception: Error=
  File not Found
  
  In the joblog datacollection, in the 'command.log' file, seeing
  an 'access denied' message when attempting to compress Spectrum
  Protect Agent log files in the guest :
  
  Failed to start new process [] args
  [cmd /c powershell.exe
   "$pathToZip =
  'c:\ProgramData\SPP\d778d591-b5e1-4f17-8d95-e2b8e189889e\command
  .log';
    $zipDest =
  'c:\ProgramData\SPP\d778d591-b5e1-4f17-8d95-e2b8e189889e\command
  .zip';
    Add-Type -As System.IO.Compression;
    Add-Type -As System.IO.Compression.FileSystem;
    if (Test-Path -Path $pathToZip -PathType leaf)
       { $ZipFile = [IO.Compression.ZipFile]::Open($zipDest,
  ([IO.Compression.ZipArchiveMode]::Update));
  
  [IO.Compression.ZipFileExtensions]::CreateEntryFromFile($ZipFile
  , $pathToZip, (Split-Path $pathToZip -Leaf));
        $ZipFile.Dispose()}
    else {
  [IO.Compression.ZipFile]::CreateFromDirectory($pathToZip,
  $zipDest) }"]
    cwd
  [c:\ProgramData\SPP\d778d591-b5e1-4f17-8d95-e2b8e189889e\],
    error [(5, Access is denied.)]"
  
  The issue was observed when the Symantec Endpoint Protection
  Antivirus was updated to Version 14 (14.2 RU2) build 5323
  (14.2.5323.2000) which brings a different behavior for the
  filesystem 'Auto-Protect' feature.
  This new behavior causes 'false positive' risk detection for the
  above powershell compression command.
  This triggers the Antivirus to cancel the powershell process
  which causes the backup to fail.
  
  IBM Spectrum Protect Versions Affected:
  IBM Spectrum Protect Plus 10.1.x
  
  Initial Impact: High
  
  Additional Keywords: TS003183793, SPP, SPPLUS, SQL backup
  

Local fix

• If possible, to have a one time backup, temporarily disable the
  Symantec Endpoint Protection file system Auto-Protect feature.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus level 10.1.4 and 10.1.5            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * SQL server backup fails with error message "Failed to find   *
  * the compressed file <path>\vssbackupdocs.zip"                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in 10.1.5.2153 and 10.1.6. Note that   *
  * this is subject to change at the discretion of IBM           *
  ****************************************************************
  

Problem conclusion

• Changed the file compression method from powershell commands to
  .net APIs
  

Temporary fix

• Update Symantec End Protection to the version that white lists
  Spectrum Protect Plus and fixes the issue.
  

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

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels