topic Re: OLEDB read failed in Connectivity & Data Prep

OLEDB read failed

vijetas42 — Mon, 28 Jan 2019 11:09:42 GMT

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!

Re: OLEDB read failed

arvind_patil — Mon, 28 Jan 2019 11:26:39 GMT

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

Thanks & Regards,
Arvind Patil

Re: OLEDB read failed

vijetas42 — Mon, 28 Jan 2019 12:38:37 GMT

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.

Re: OLEDB read failed

arvind_patil — Mon, 28 Jan 2019 12:41:43 GMT

Thanks for update