IT29986: SQL LOG BACKUP WINDOWS TASK SCHEDULER CREATION FAILS WITH ERROR "STRING WAS NOT RECOGNIZED AS A VALID DATETIME"

APAR status

• Closed as program error.

Error description

• When creating Windows Task Scheduler on SQL server to enable
  Spectrum Protect Plus log backups of SQL databases, it returns
  below error in jog lob:
  
  WARN,1563520286019,<date, time, timezone>,2,CTGGE1025,[SQL
  server IP address] Unhandled exception:
  System.Reflection.TargetInvocationException: Exception has been
  thrown by the target of an invocation. --->
  System.FormatException: String was not recognized as a valid
  DateTime..
  DETAIL,1563520286021,<date, time, timezone>,2,CTGGE0037,[SQL
  server IP address] Log backup configuration ends.
  ERROR,1563520302408,<date, time, timezone>,2,CTGGA2066,[SQL
  server IP address] Log backup failed for instance
  <SQL Instance> on application server <SQL server IP address>
  ERROR,1563520302408,<date, time, timezone>,2,,Failed to get
  remote execution results from server <SQL server IP address>
  
  This occurs if the SQL server is using a Day/Month/Year date
  format instead of a Month/Day/Year date format.
  

Local fix

• Change date format on SQL server to MM/dd/yyyy
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * IBM Spectrum Protect Plus level 10.1.4                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See ERROR DESCRIPTION                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply fixing level when available. This problem is currently *
  * projected to be fixed in Spectrum Protect Plus levels        *
  * 10.1.4.222 and 10.1.5. Note that this is subject to change   *
  * at the discretion of IBM                                     *
  ****************************************************************
  

Problem conclusion

• Fixed an issue with date/time processing in some Locale settings
  

Temporary fix

Comments

APAR Information

• 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