topic Re: Re: Scheduled dashboard cannot load data in QlikView

Scheduled dashboard cannot load data

Fri, 05 Sep 2014 12:41:24 GMT

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

Re: Scheduled dashboard cannot load data

maxgro — Fri, 05 Sep 2014 12:44:46 GMT

post the log of the reload on your server (same folder as the .qvw)

Re: Scheduled dashboard cannot load data

Fri, 05 Sep 2014 13:17:43 GMT

Thanks - Massimo.

I don't set up generate log file. I will do it later and post here for analysis.

Re: Re: Scheduled dashboard cannot load data

Mon, 08 Sep 2014 16:34:04 GMT

Hi Massimo,

Please see attached log file. Let me know if you can find any issues.

Thank you very much,

Dust

Re: Scheduled dashboard cannot load data

ashfaq_haseeb — Mon, 08 Sep 2014 17:55:43 GMT

Hi,

As per this script reload is successful.

Do you have any other stage or this is final one.

Regards

ASHFAQ

Re: Scheduled dashboard cannot load data

Mon, 08 Sep 2014 18:09:12 GMT

ASHFAQ,

Even this reload is successfully done. I still see some page don't have data. this is the only step I have for this dashboard.

Thank you very much for your attention.

Best.

Re: Scheduled dashboard cannot load data

ashfaq_haseeb — Mon, 08 Sep 2014 18:13:54 GMT

Ok,

Can you tell me if you reload manually do you get data.]?

What database you connect with?

Regards

ASHFAQ

Re: Re: Scheduled dashboard cannot load data

Mon, 08 Sep 2014 18:19:22 GMT

Thank you - ASHFAQ.

Manually load this dashboard has no problem at all. It can load all data for the app. I schedule this dashboard run daily and cannot load some data.

We use Oracle database for this app.

Thank you very much,

Dust

Re: Re: Scheduled dashboard cannot load data

ashfaq_haseeb — Mon, 08 Sep 2014 18:26:54 GMT

Ok, In this case.

Make sure that service account you use to schedule/ Run Qlikview services have read only access to tables you use in your dashboard.

Let me know if that worked.

Regard

ASHFAQ

Re: Scheduled dashboard cannot load data

maxgro — Mon, 08 Sep 2014 18:28:32 GMT

post the script

are oracle connection and qvd the same in manual and scheduledreload?

and the manual log is the same as scheduled log?

Re: Re: Scheduled dashboard cannot load data

Mon, 08 Sep 2014 18:48:36 GMT

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.

Re: Re: Scheduled dashboard cannot load data

ashfaq_haseeb — Mon, 08 Sep 2014 18:52:20 GMT

Hi,

did you try my suggestion.

Regards

ASHFAQ

Re: Scheduled dashboard cannot load data

Colin-Albert — Mon, 08 Sep 2014 18:54:58 GMT

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.

Re: Re: Scheduled dashboard cannot load data

Mon, 08 Sep 2014 19:01:10 GMT

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

Re: Re: Scheduled dashboard cannot load data

ashfaq_haseeb — Mon, 08 Sep 2014 19:06:04 GMT

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

Re: Re: Scheduled dashboard cannot load data

Mon, 08 Sep 2014 19:07:01 GMT

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

Re: Re: Scheduled dashboard cannot load data

ashfaq_haseeb — Mon, 08 Sep 2014 19:19:58 GMT

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

Re: Scheduled dashboard cannot load data

maxgro — Mon, 08 Sep 2014 19:34:02 GMT

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

Re: Scheduled dashboard cannot load data

ashfaq_haseeb — Mon, 08 Sep 2014 19:47:59 GMT

Bill Britt can confirm the same.

Regards

ASHFAQ

Re: Scheduled dashboard cannot load data

Bill_Britt — Mon, 08 Sep 2014 19:59:33 GMT

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