2 Replies Latest reply: Sep 13, 2013 3:39 AM by Donald Posthuma RSS

    SQL error 'incorrectly formatted date/time' while extracting Universe database

    Donald Posthuma

      Hi,

       

      During the load of an Universe database I get the following error and the load ends:

       

      QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: S1000, ErrorCode: 0, ErrorMsg: [Rocket U2][UVODBC][2301131]Error ID: 13  Severity: ERROR  Facility: DATUMERR - Incorrectly formatted date/time.Error noticed at the character or token ending at column 6 of line 65535 of the input SQL statement.

       

      I use the Universe ODBC driver from Rocket U2.

       

      Does anybody know how to change the format so it will load the line, or is there a way to input a default value so I can check which lines give the error?

       

      Thanks in advance!!