Qlik Community

Community Corner

Discussion board for questions about the Qlik Community, its features, sharing information, general discussions and even some fun. This is for both new and longtime community members. Everyone is welcome!

Highlighted
vijetasharma
Valued Contributor

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

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

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