Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
vijetas42
Specialist
Specialist

OLEDB read failed

Hi All,

I am loading data from oracle and while loading a specific table giving me OLEDB read failed error. and then it show QVX_UNKNOWMN_ERROR. I have tried dividing this table into different qvd's then it's loading data <2018 and 2018 into respective qvd's but, while loading data for 2019. It start reading data and loads some of the records after that i am getting OLEDB read failed.

Table has more than 1 million records from which only 19K records are of 2019.

Is anyone faced the same issue. Please suggest!

 

1 Solution

Accepted Solutions
vijetas42
Specialist
Specialist
Author

This issue has been resolved after checking each column data type defined in db and one of the column is having NUMBER but, values are long having 15 decimal values so, after formatting that column at qv load script. table got loaded.

 

View solution in original post

3 Replies
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Vijetasharma,
Its may be internet connection , connection lost while loading please check.

Thanks & Regards,
Arvind Patil

vijetas42
Specialist
Specialist
Author

This issue has been resolved after checking each column data type defined in db and one of the column is having NUMBER but, values are long having 15 decimal values so, after formatting that column at qv load script. table got loaded.

 

arvind_patil
Partner - Specialist III
Partner - Specialist III

Thanks for update