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

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

Thu, 12 Sep 2013 13:15:15 GMT

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!!

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

vikasmahajan — Fri, 13 Sep 2013 04:09:11 GMT

Can you attach your scripts so that I can try !

Vikas

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

Fri, 13 Sep 2013 07:39:17 GMT

My script is very basic:

SQL SELECT

FIELD_A,

FIELD_B,

FIELD_C

FROM SOURCE_A;

The only way I can now load from SOURCE_A is by removing the field which gives the error.