IT46800: MICROSOFT SQL INVENTORY OR BACKUP FAILS WHEN A SQL SERVER ALWAYS ON FAILOVER CLUSTER INSTANCES (FCI) IS OFFLINE

APAR status

• Closed as program error.

Error description

• Microsoft SQL Server Always On failover cluster instances (FCIs)
  
  use Windows Server Failover Clustering (WSFC) to provide local
  high availability.
  
  When an FCI is offline, the IBM Storage Protect Plus SQL Agent
  running on the Microsoft SQL server can crash.
  
  The message seen in the application inventory or SQL backup job
  will stop with the message :
  
  ERROR .. CTGGE0119,[<SQLServerAddress>] Instance
                    [<SQLInstanceName>] is offline.
  
  On the Windows host, the application event log will report the
  IBM Storage Protect Plus SQL Agent sqlvdiwrapper.exe crash :
  
  Error,<timestamp>,Application Error,1000,(100),
        "Faulting application name: sqlvdiwrapper.exe,
                                    version: 10.1.999.4406,
                                    time stamp: 0x6644fcb3
         Faulting module name: sqlvdiwrapper.exe,
                               version: 10.1.999.4406,
                               time stamp: 0x6644fcb3
               Exception code: 0xc0000005
                 Fault offset: 0x000000000065b4ad
          Faulting process id: 0xcf8
          ..."
  Information,<timestamp>,Windows Error Reporting,1001,None,
      "Fault bucket , type 0
              Event Name: APPCRASH
                Response: Not available
                  Cab Id: 0
       Problem signature:
          P1: sqlvdiwrapper.exe
          P2: 10.1.999.4406
          P3: 6644fcb3
          P4: sqlvdiwrapper.exe
          P5: 10.1.999.4406
          P6: 6644fcb3
          P7: c0000005
          P8: 000000000065b4ad
          P9:
          P10:
       ...
       Report Status: 4100
       Hashed bucket: "
  
  IBM Storage Protect Plus Versions Affected:
  IBM Storage Protect Plus 10.1.x
  
  Additional Keywords: SPP, SPPLUS, TS016779250
  

Local fix

• Ensure there is no offline FCI for the protected Microsoft SQL
  server.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus level 10.1.16.3 and lower levels   *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * sqlvdiwrapper is crashing if one of the SQL FCI instance is  *
  * down. See Error Description for more details.                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply the fix available in IBM Spectrum Protect Plus level   *
  * 10.1.16.4 or above.                                          *
  ****************************************************************
  

Problem conclusion

• While logging the information about offline SQL-FCI, "node name"
  was missing, which was causing segmentation fault and
  sqlvdiwrapper.exe to crash. Fix has been added in IBM Spectrum
  Protect Plus 10.1.16.4 and any later levels.
  

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

  SP PLUS

• Fixed component ID

  5737SPLUS

Applicable component levels