topic Re: OLEDB Failed in QlikView

OLEDB Failed

khasimvali85 — Wed, 05 Aug 2015 08:28:21 GMT

! !Hi,

Please find the attachment for issue

When run the script showing the error like OLEDB Error

same issue coming today also its not resolved i couldn't find out the issue

Error: QVX_UNEXPECTED_END_OF_DATA

Error: OLEDB Read Failed

this issue repeated again and again what could be the solution for this?

given below attached log file

please find second image for the issue and log file also

Can any one resolve the issue

Regards,

Khasim.

Re: OLEDB Failed

Digvijay_Singh — Wed, 05 Aug 2015 08:36:19 GMT

The similar problem discussed here... QVX_UNEXPECTED_END_OF_DATA

Re: OLEDB Failed

khasimvali85 — Wed, 05 Aug 2015 09:59:39 GMT

Hi,

i am also restart the QVS but same issue coming

how could i solve?

Re: OLEDB Failed

vardhancse — Wed, 05 Aug 2015 10:03:31 GMT

Hi,

even though we are able to connect to DB from server or from local system.

if the qlikview service accounts dont have access to the table will get and OLEDB/ODBC error.

In DB level we need to give access to qlikview service accounts to all the tables we are trying to reload from QlikView.

Once check with your DB admin team

Re: OLEDB Failed

khasimvali85 — Wed, 05 Aug 2015 10:38:56 GMT

Hi Sasi,

Thanks for Reply

all the tables have been updating till yesterday the issue was came today whenever the scheduler running,

i think its not for the access for qv service account, its connection problem between QV and OLEDB.

anyway i will go through this way also to find out issue.

and how we check the qlikview services accounts for all the tables?

Re: OLEDB Failed

vardhancse — Wed, 05 Aug 2015 10:54:53 GMT

in DB level there are some queries to know which users have access to the tables.

Re: OLEDB Failed

khasimvali85 — Wed, 19 Aug 2015 05:54:44 GMT

Hi Community,

The issue was resolved and 15 days i have faced this error, i did some steps to resolve this issue.

its wonder automatically resolved.

1, Restart all the QV services

2, restart the QV Server

3, Deleted old scheduler tasks and created new tasks

4, always check memory utilization not more than 70(CPU & Physical Memory(RAM))

5, Given the new connection between QV to DB