Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

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

2 Replies
vikasmahajan
Honored Contributor III

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

Can you attach your scripts so that I can try !

Vikas

Not applicable

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

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.

Community Browser