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 number
IT26902
Reported component name
SP PLUS
Reported component ID
5737SPLUS
Reported release
A12
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2018-11-08
Closed date
2018-11-14
Last modified date
2018-11-14
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
[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSNQFQ","label":"IBM Spectrum Protect Plus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A12","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
30 January 2024