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

[#1]

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]

Can you attach your scripts so that I can try !

Vikas

[#3]

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.