Re: SQL error 'incorrectly formatted date/time' wh... - Qlik Community

Report Inappropriate Content · ‎2013-09-12

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

vikasmahajan · ‎2013-09-13

Can you attach your scripts so that I can try !

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2013-09-13

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.

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