IBM Support

IT27087: IBM SPECTRUM PROTECT PLUS SQL LOG BACKUPS FAIL AFTER WINDOWS PASSWORD CHANGE AT 10.1.2.176

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • IBM Spectrum Protect Plus SQL log backups fail after
    changing the Windows password for the SQL ID being used.
    The Windows event log, specifically the
    "Microsost-Windows-TaskScheduler/Operational" log will show"
    Event ID: 101
    Task scheduler failed to start
    "\IBM\SPP Windows Agent\sppcmd_XXXX_DBNAME"
    task for user 'DOMAIN\ID' . Additional data:
    Error value: 2147943726
    (HRESULT) 0x8007052e (2147943726) "unknown user name
    or bad password"
    | MDVPARTL 10.1.2 TIV_5737SPLUS |
    Versions affected: 10.1.2.176
    Keywords: TS001539999, SPP, SPPlus; MSSQL, MS,
    Microsoft
    

Local fix

  • Remove the log backups, run the SLA, add the log backups.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * IBM Spectrum Protect Plus levels 10.1.2                      *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * See Error Description                                        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Apply fixing level when available. This problem is currently *
    * projected to be fixed IBM Spectrum Protect Plus level        *
    * 10.1.2.209 and 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 address this
    issue. The SQL log backup module will update the SQL log backup
    task with the new password if the Windows password has been
    changed since the last SQL backup job.
    

Temporary fix

Comments

APAR Information

  • APAR number

    IT27087

  • 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-26

  • Closed date

    2019-01-22

  • Last modified date

    2019-01-22

  • 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