IBM.支持

IT26902:SQL备份失败"无法获得首选节点信息错误"当多个实例时&使用非默认端口

订阅

您可以跟踪此组件的所有活动APAR。

 

APAR状态

  • 作为程序错误关闭。

错误描述

  • 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
    

本地修复

问题摘要

  • ****************************************************************
    * 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.          *
    ****************************************************************
    

问题结论

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

临时修复

评论

APAR信息

  • Apar号码

    IT26902

  • 报告的组件名称

    SP加

  • 报告的组件ID.

    5737Splus.

  • 报告释放

    A12

  • 状态

    关闭

  • PE.

    没有

  • 侯赛人

    no

  • 特别关注

    nospecatt / xsystem.

  • 提交日期

    2018-11-08

  • 关闭日期

    2018-11-14

  • 最后修改日期

    2018-11-14

  • APAR是由以下一个或多个中的SYSROUTED:

  • APAR被SISROUTED到以下一个或多个:

修复信息

  • 固定组件名称

    SP加

  • 固定组件ID

    5737Splus.

适用组件级别

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU029","label":"Software"},"Product":{"code":"SSNQFQ","label":"IBM Spectrum Protect Plus"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A12"}]

文件信息

修改日期:
07 February 2021