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
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?
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