Qlik Community

Qlik Sense Data Connectivity

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist
Specialist

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
Highlighted
Partner
Partner

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

Thanks & Regards,
Arvind Patil

Highlighted
Specialist
Specialist

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

Highlighted
Partner
Partner

Thanks for update