APAR status
Closed as program error.
Error description
SQL backup sometimes reports "Failed to enable log backup" in a SQL Server AlwaysOn environment Problem Description: In a SQL Server AlwaysOn environment, SQL databases sometimes reports "Failed to enable log backup": CTGGA2081,Failed to enable log backup for <SQL-AG-Name> ==> <SQL-DB-Name> [ Last run for database [SP_Social] failed.] The backup preferences is set on the AG level. The log backup is successful on one node, while fails on another non-backup node. The command.log shows following error: [date time] Debug 3848 Thread-10 agent_sql_log: Log Backup Exception full exception: SqlLogBackup.IdentifiableSqlExecutionFailureException: Exception of type 'SqlLogBackup.IdentifiableSqlExecutionFailureException' was thrown. at SqlLogBackup.SqlLogBackup.BackupLog(DatabaseInstanceEx database) ... [date time] Debug 3848 Thread-1 agent_sql_log: Result of DB: [SQL-DB-Name]; [FAILURE] The t-sql returns exception when trying to determine preferred replica on non-backup node. Versions affected: v10.1.* Additional keywords: TS013158733 SPP
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: * * IBM Spectrum Protect Plus level 10.1.x. * **************************************************************** * PROBLEM DESCRIPTION: * * See ERROR DESCRIPTION * **************************************************************** * RECOMMENDATION: * * Apply fixing level when available. This problem is currently * * projected to be fixed in IBM Spectrum Protect Plus level * * 10.1.16. Note that this is subject to change at the * * discretion of IBM * ****************************************************************
Problem conclusion
This problem has been fixed so that SQL log backup of alwayson databases can be completed successfully, as long as SQL T-SQL query "sys.fn_hadr_backup_is_preferred_replica" returns correct output.
Temporary fix
Comments
APAR Information
APAR number
IT44700
Reported component name
SP PLUS
Reported component ID
5737SPLUS
Reported release
A19
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2023-10-10
Closed date
2023-11-21
Last modified date
2023-11-21
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":"A19","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
01 February 2024