Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

OLEDB read failed

I'm getting an error when trying to load a certain field that holds dates from one of my tables.

Capture1.PNG

I noticed that the script works fine when I use a limited load, but errors out when I try to load the whole table.  I started playing around with the limited load and found that it consistently fails when I try to load more than 113145 lines.


I get the following error:

Script error: QVX_UNKNOWN_ERROR:

OLEDB read failed: SQL SELECT CUTEOMERNBR, ACCTOPENDATE FROM CUSTOMER

If I comment out the ACCTOPENDATE field, it loads fine.

I exported the table to Excel and scrolled down to the 113146 line to look at the ACCTOPENDATE field and the date looks just like every other date above it... no special characters or anything:

Capture2.PNG

Any thoughts?  Is there a way I can create a script to skip any individual rows it fails on?

Thanks!

1 Reply
Not applicable
Author

I setup an ODBC connection and tried to load the same data.  It fails on the same record but gives me a slightly different message:

Capture3.PNG

Any thoughts?