SqlState: 22007, ErrorCode: 0, ErrorMsg: [Oracle][ODBC]Invalid datetime format.

[#1]

Hey guys,

I am loading data from Oracle and I get the following error:

QVX_UNEXPECTED_END_OF_DATA: SQL##f - SqlState: 22007, ErrorCode: 0, ErrorMsg: [Oracle][ODBC]Invalid datetime format.

From what I read in the internet the problem is with the time format in the database.

Since I cannot touch the database itself, how can I load my data, only by fixing my script?

[nizamsha]

Hi

Did u got or not what u want

try this if still  you are not getting

comment the two date field and check weather its working  it should work

even that u r not getting  again load the data from the  database and check what is the difference between this code vs

your new code

if u got what u want mark this a correct  or helpful so it will be helpful to others

LOAD

     ID,
     Type,
     Date(DATA_BEG,'DD-MM-YYYY') as DATA_BEG,
     Date(DATA_END,'DD-MM-YYYY') as DATA_END,
     Vaue,
     ID2,
     ID3,

     ID4,
     STATUS;

SQL SELECT *

FROM TableX;

[nizamsha]

Hi

As cleveranjos said do u have a access ,try to load only the query and post the  error

[#4]

Yes, I have access. I load other tables from there (the oracle database). Only some are giving me this error. The error would appear in the beginning of the load or it could appear after some millions of records are loaded. I also tried all that Nizam HM suggested, but to no avail. Still doesn't work.

[Clever_Anjos]

If is it possible:

1. Dump your query results to a text file
2. Try to load this file into QlikView

If generates the error, the trace screen will show nearly the row line that is generating that error