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]

This dashboard load direct from database. I ahve another app load 4 times a day and has no problem.

I will check the manual log and the sechedule log.

I will post script later.

Thanks you very much for you input. Appreciate.

[ashfaq_haseeb]

Hi,

did you try my suggestion.

Regards

ASHFAQ

[Colin-Albert]

This sounds like a permissions issue. The server will be accessing files using the QDS service account. So the service account must have permissions to read any data files used by your application. Also unless you are using a named database user, then the service account will need per.issions to access the database and any tables, views or procedures.

[#5]

Hi ASHFAQ,

Sorry, missed you suggestion here.

Can you tell me more on this? I just use my account to login to the server and I have Admin privilige on this server.

On the other hand, I have another app hasthe same data sourece and run every 6 hours without any issue.

Can you go more detail on this service account?

Appreciate,

Dust

[ashfaq_haseeb]

Hi,

Simple just make sure that the service account you use has read permission to your tables you read.

If not then give read permission to service account on table you use.

Regards

ASHFAQ

[#7]

Colin,

Thank you very much.

Other team memebr schedule this dashboard before. I found the app missing data and delete this task. Then I scheduled this app by myself.

I have admin privilige on this server. I have no problem with other apps use the same data source.

Very frustrated.

Appreciate your input,

Dust

[ashfaq_haseeb]

Hi Dust Just Relax

go to run

services.msc --> Go to QlikView service --> have a note of this account.

Now ask your DBA to provide access for this account to your relevant tables/Views you used in your QlikView application.

You logged in what what account doesn't matter here.

QlikView services/ schedules will be triggered with service account the one we identified above.

Make sure this account have necessary permissions.

Hope it helps

Regards

ASHFAQ

[maxgro]

Usually for oracle db the connection is made with user and password 

you can check it in the oledb .....statement in your script (manual and scheduled)

so if user of scheduled and manual are the same I don't think is a permission problem

Also, if you have a permission problem, you should get an error in the log script, not a partial result set

[ashfaq_haseeb]

Bill Britt can confirm the same.

Regards

ASHFAQ

[Bill_Britt]

Hi,

Change the distribution service to use your UserID and Password. If it works then there is an issue with the rights and the service account.

Bill