APAR status
Closed as program error.
Error description
The log backup of Microsoft SQL databases with IBM Spectrum Protect Plus can fail with these job log messages : ERROR,..,CTGGE1107,[<SQLServerAddress>] The log backup is discontinuous for database [<DBName>] on instance [<SQLInstance>]. ERROR,..,CTGGA3276,Log backup failed for database <SQLServerAddress>-><SQLInstance>-><DBName>: Exception of type 'SqlLogBackup. DiscontinuousLogBackupException' was thrown. Forcing a base database backup using the SLA policy option 'Force full backup of resources' completes successfully but the next log backup still fails with the above errors. The cause is to be found in the database backup but the job log of this backup will display no message, warning or error. For this APAR to apply, both following conditions will be seen: 1. The Microsoft SQL server language found with the t-sql query SELECT @@language is a non-english locale 2. The following error has to be seen in the command log found in the job log of the database backup: .. DEBUG sqlvdiwrapper - ExecSQLStatement: Executing SQL (SELECT TOP 1 s.first_lsn, s.last_lsn FROM msdb.dbo. backupset s ... .. DEBUG sqlvdiwrapper - ExecSQLStatement: Checking the return status (0xFFFFFFFF) of SQLExecDirect() .. ERROR sqlvdiwrapper - ProcessStatementOutput: rc is SQL_ERROR ... .. ERROR sqlvdiwrapper - ProcessMessages: Msg: [[Microsoft] [ODBC Driver 11 for SQL Server] [SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.], Msg 242, SevLevel 16, State 3, SQLState 22007, .. ERROR sqlvdiwrapper - Failed to execute SQL command, error [ProcessStatementOutput: SQL_ERROR [[Microsoft][ODBC Driver 11 for SQL Server][SQL Server]The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.]] This issue was observed with a Microsoft SQL server using the locale 'deutch' IBM Spectrum Protect Plus Versions Affected: IBM Spectrum Protect Plus 10.1.x Additional Keywords: SPP, SPPLUS, TS011819394
Local fix
If posible set SQL server locale to english
Problem summary
**************************************************************** * USERS AFFECTED: * * IBM Spectrum Protect Plus level 10.1.5 - 10.1.13 * **************************************************************** * 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.14. 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 Germany language SQL server can be completed successfully.
Temporary fix
Comments
APAR Information
APAR number
IT42938
Reported component name
SP PLUS
Reported component ID
5737SPLUS
Reported release
A1C
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2023-01-23
Closed date
2023-02-01
Last modified date
2023-02-01
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":"A1C","Line of Business":{"code":"LOB26","label":"Storage"}}]
Document Information
Modified date:
01 February 2024