Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

khasimvali85
Contributor II

OLEDB Failed

! !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.

1 Solution

Accepted Solutions
khasimvali85
Contributor II

Re: OLEDB Failed

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

6 Replies
Digvijay_Singh
Honored Contributor III

Re: OLEDB Failed

The similar problem discussed here... QVX_UNEXPECTED_END_OF_DATA

khasimvali85
Contributor II

Re: OLEDB Failed

Hi,

i am also restart the QVS but same issue coming

how could i solve?

vardhancse
Valued Contributor II

Re: OLEDB Failed

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

khasimvali85
Contributor II

Re: OLEDB Failed

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?

vardhancse
Valued Contributor II

Re: OLEDB Failed

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

khasimvali85
Contributor II

Re: OLEDB Failed

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

Community Browser