IT26902: SQL BACKUPS FAIL WITH "FAILED TO GET PREFERRED NODE INFORMATION ERROR" WHEN MORE THAN ONE INSTANCE & NON DEFAULT PORTS ARE USED

APAR status

• Closed as program error.

Error description

• IBM Spectrum Protect Plus SQL backups fail with
  the following error when the SQL server contains
  more than one instance and uses non default SQL ports:
  Failed to get preferred node information error
  [Failed to get secondary replica list] skip group
  [myserver-AG1]
  SQL backup job log:
  Failed to find a db group from the discovery ouput for
  myserver-AG1 on server myserver.ibm.com. This is normal
  on the passive node of a failover cluster.
  [myserver.ibm.com] Failed to get preferred node information
  error [Failed to get secondary replica list] skip group
  [myserver-AG1]
  The command.log shows:
  2018-10-26 13:13:58,427 [0x00002bf8] INFO sqlvdiwrapper -
  SQLRoutine: connecting to server (myserver\inst02)
  2018-10-26 13:15:03,867 [0x00002bf8] ERROR sqlvdiwrapper -
  SQLRoutine: SQLDriverConnect to [myserver\inst02] failed,
  err [[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL
  Server does not exist or access denied.], ret (0)
  2018-10-26 13:15:03,867 [0x00002bf8] ERROR sqlvdiwrapper -
  Failed to execute SQL command, err [SQLRoutine: SQLDriverConnect
  to [myserver\inst02] failed, err[[Microsoft][ODBC SQL Server
   Driver][DBNETLIB]SQL Server does not exist or access
   denied.], ret (0)
  
  Versions affected: 10.1.0, 10.1.1, 10.1.2
  keywords: TS001533701 alwayson always-on
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus level 10.1.0, 10.1.1 and 10.1.2    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * This problem is currently projected to be fixed in IBM       *
  * Spectrum Protect Plus levels 10.1.2.209, 10.1.3. Note that   *
  * this is subject to change at the discretion of IBM.          *
  ****************************************************************
  

Problem conclusion

• IBM Spectrum Protect plus has been updated to be more resilient
  to operating within SQL Server environments that do not use the
  default ports.
  

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