Qlik Community

New to Qlik Community

Discussion board for questions on how to use Qlik Community and its features.

Announcements
This forum is for questions and information about how to use the Qlik Community.
Please do not post product related questions here.
Select the correct forum from: Qlik Product Forums
Highlighted
vijetasharma
Contributor III

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
vijetasharma
Contributor III

Re: OLEDB read failed

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.

 

3 Replies
arvind_patil
Valued Contributor III

Re: OLEDB read failed

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

Thanks & Regards,
Arvind Patil

vijetasharma
Contributor III

Re: OLEDB read failed

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
Valued Contributor III

Re: OLEDB read failed

Thanks for update

Community Browser