Scheduled dashboard cannot load data

[#1]

Hello Everyone,

I have a scheduled dashboard run once everyday and publish to upfront. The dashboard can only partially load some data. I manually load data has no problem.

Do you have any idea what's wrong with this dashboard setting?

Thank you very much.

Dust

[#2]

Hi ASHFAQ,

Here is the service I can find for Qlikview:

Which one I should as DBA add access to?

Thank you very much,

Dust

[ashfaq_haseeb]

In the same screenshot after start up type you will find Logon as domain\user

ask dba to provide read access to this user.

Have a look at bill reply, if that help.

Regards

ASHFAQ

[#4]

‌, ‌

Hello Sir,

We are using OLEDB Connection for Oracle Database to get the table data. We are able to reload when we do it manually but when we are using the same code on SERVER Reload is not working. My QV Admin asked me to get the read permission to the service account which he has shared with me. Now when I asked my DBA for the read permission granted for the SERVICE ACCOUNT crated at QlikView side, I got the response as

"you can't access to DB objects if you have no account in the database".

Requesting  you to kindly guide me what exactly I have to do to get this permission

Regards,

Vijay.

‌

[Bill_Britt]

Hi Vijay,

I would try changing the Distribution Service service account to the one your were login in with you ran the qvw successfully on the desktop. The see if it will run.

Bill

[Peter_Cammaert]

In the QMC reload tab, you can also enter your Windows credentials in the Section Access fields, to force the reload process to run using your account instead of the service account. This may be easier to do, on condition that this document doesn't have Section Access enabled (or you are present in the SA table with ACCESS=ADMIN).

[Bill_Britt]

Hi,

You can try that, but if you open a ticket with support, we will have you do it through the service account.

Bill

[Peter_Cammaert]

On a production system?