SAP Knowledge Base Article - Preview

1901966 - Error 11707 "Incorrect time syntax" while executing LOAD TRAN ..WITH UNTIL_TIME -SAP ASE

Symptom

  • An error 11701 was raised converting a datetime  string to use in the command  "LOAD TRANSACTION db_name FROM dump_file WITH UNTIL_TIME "08/16/2013 15:31:18":

Server message number=11707 severity=15 state=1 line=1 server=MyServer text=Incorrect time syntax in time string '08/16/2013 15:31:18' used in the LOAD TRANSACTION UNTIL_TIME statement.
Correct format is month day, year hour:minute:seconds:milliseconds[am | pm]

  • In this case, the string "08/16/2013 15:31:18" is being passed into a Perl program where a LOAD TRANSACTION command is set up and executed.
     
  • How can it be converted to the required format that includes the month name?


Read more...

Environment

SAP Sybase Adaptive Server Enterprise (ASE) 15.x any release

Product

SAP Adaptive Server Enterprise 15.7 ; Sybase Adaptive Server Enterprise all versions

Keywords

partial,restore , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.