IT31839: CTGGE1006 - MICROSOFT SQL SERVER BACKUP AND RESTORE JOBS FAILINGIN A MULTI-LAN ENVIRONMENT

APAR status

• Closed as program error.

Error description

• When different Microsoft SQL cluster servers are located at
  multiple LAN environments (eg. LAN1 and LAN2) and if Spectrum
  Protect Plus server and vSnap server are on LAN2, the SQL backup
  and restore job's can fail due to 'no network interfaces' found
  that support CIFS.
  
  The Spectrum Protect Plus job log shows following error
  messages:
   Error, CTGGE1006 [w1.x1.y01.z01] Unable to attach CIFS share
    [\\w2.x2.y02.z02\vpool1_fs1] Please check the required network
    and system configurations required for CIFS share access.
   Warn,  CTGGA1951 [w1.x1.y01.z01] Enable log backup status was
    reported as failed: null
   Error, CTGGA2296 Enable log backup failed for database
    Test:Could not attach CIFS drive: \\w2.x2.y02.z02\vpool1_fs1
   Info, CTGGA2326 Application server w1.x1.y01.z01 will be used
    as the backup preferred node for instance IBM1234-01\SQL_ALL
   Error, CTGGA2073 Failed to perform backup of db instance
    IBM1234-01\SQL_ALL on application server w1.x1.y01.z01 : null
  
  At the same time the VIRGO log shows:
   INFO asyncTaskExecutor-212 c.c.e.s.protection.application.cal.
    logbackup.Log BackupHandler 1510203040506 Error details:
    com.syncsort.dp.xsb.commons.XSBException: Failed to find a
    network interface that supports cifs
      at com.catalogic.ecx.serviceprovider.protection.application.
         cal.protection.BackupTargetVolumeHandlerCifs.getCifsHost
         AndPathInfo(BackupTargetVolumeHandlerCifs.java:159)
      at com.catalogic.ecx.serviceprovider.protection.application.
         cal.protection.BackupTargetVolumeHandlerCifs.setupTarget
         Volume(BackupTargetVolumeHandlerCifs.java:64)
      at com.catalogic.ecx.serviceprovider.protection.application.
         cal.logbackup.LogBackupHandler.setupBackupTargetVolumes
         (LogBackupHandler.java:424)
      at com.catalogic.ecx.serviceprovider.protection.application.
         cal.logbackup.LogBackupHandler.createLogBackupJobsFor
         Instances(LogBackupHandler.java:148)
      at com.catalogic.ecx.serviceprovider.protection.application.
         cal.logbackup.LogBackupHandler.performLogBackups
         (LogBackupHandler.java:84)
      at com.catalogic.ecx.serviceprovider.protection.application.
         cal.protection.DatabaseProtectionHandler.protectDatabases
         (DatabaseProtectionHandler.java:86)
      at com.catalogic.ecx.serviceprovider.protection.application.
         cal.protection.ProtectionChunkExecutor.process
         (ProtectionChunkExecutor.java:41)
      at com.syncsort.dp.xsb.service.jobmanager.sb.BasicProcessor.
         process(BasicProcessor.java:14)
  
  
  IBM Spectrum Protect Versions Affected:
  IBM Spectrum Protect Plus 10.1.x
  
  Initial Impact: Medium
  
  Additional Keywords: SPP, SPPLUS, TS003072475, multiple LAN
  

Local fix

• NA
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus level 10.1.4 and 10.1.5            *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION                                        *
  ****************************************************************
  * 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

• Fixed a problem with finding the peer host addresses in the
  cluster
  

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