topic Re: Data is reloading but not getting updated in Access point in QlikView

Data is reloading but not getting updated in Access point

varunreddy — Mon, 18 Jan 2016 21:38:01 GMT

Hi Guys,

My data source is excel. We will update data every week. When, I run in my desktop, application is running fine and data is getting updated. When I send the files to deploy them in UAT, All the files are running fine but the data is not getting updated in Access Point. Does anyone came across this kind of situation?

Thanks in advance!

Regards,

Varun

Re: Data is reloading but not getting updated in Access point

sunny_talwar — Mon, 18 Jan 2016 21:40:30 GMT

Have you looked at the logfile to see what is going on? The file is missing or if there is an error in reloading or did the reload went through smoothly? If I were you, I would start from there and then explore other options.

Re: Data is reloading but not getting updated in Access point

varunreddy — Mon, 18 Jan 2016 21:42:27 GMT

Hi Sunny,

Yes, I did. Everything looks fine in logfile. The application got executed smoothly.

Re: Data is reloading but not getting updated in Access point

sunny_talwar — Mon, 18 Jan 2016 21:44:41 GMT

Any Section Access which might be prohibiting you from seeing the data?

Re: Data is reloading but not getting updated in Access point

varunreddy — Mon, 18 Jan 2016 21:45:26 GMT

I am the admin. I should have all access to see the data

Re: Data is reloading but not getting updated in Access point

maxgro — Mon, 18 Jan 2016 21:45:59 GMT

If you have publisher does the task include the distribution to the server?

Did you check if the file on the server is updated or if there is another .qvw with the same name?

Re: Data is reloading but not getting updated in Access point

varunreddy — Mon, 18 Jan 2016 22:06:26 GMT

In the access point, application reload time is showing updated time stamp

Re: Data is reloading but not getting updated in Access point

varunreddy — Mon, 18 Jan 2016 22:07:28 GMT

Number of fields when I reload in desktop and number of fields when ran in UAT are same and all the applications are running smooth

Re: Data is reloading but not getting updated in Access point

sunny_talwar — Mon, 18 Jan 2016 23:18:50 GMT

I am not so much concerned about number of field. I am more interested in knowing if number of records loaded in desktop version are the same as the records loaded on the server?

Re: Data is reloading but not getting updated in Access point

jagan — Tue, 19 Jan 2016 00:45:04 GMT

Hi,

Get the file from the Qlikview server folder and check whether there is new data in the QV file, Are you loading the same file in the QV server, recheck this.

Regards,

jagan.

Re: Data is reloading but not getting updated in Access point

varunreddy — Tue, 19 Jan 2016 00:46:54 GMT

I am sorry number of records and number of fields are same

Re: Data is reloading but not getting updated in Access point

varunreddy — Tue, 19 Jan 2016 00:49:04 GMT

Hi Jagan,

I am using same QVD for both Server and in local desktop. I guess application is not creating issues. Will there be any issue while deploying in the server?

Re: Data is reloading but not getting updated in Access point

jagan — Tue, 19 Jan 2016 00:52:03 GMT

Not sure, that is what I am saying get the file from Qlikview server and then check whether it is updated with the latest data.

Or try like this, sometimes qlikview load from the Cache, clear the cache by following below steps.

Accesspoint -> Click on View Details link of the Dashboard -> Click the Remove Last Document State button.

click Ctrl + F5 to load freshly from the server in Browser.

Hope this helps you.

Regards,

jagan.

Re: Data is reloading but not getting updated in Access point

varunreddy — Tue, 19 Jan 2016 00:58:56 GMT

Thanks for your help Jagan, but it is not working.

Re: Data is reloading but not getting updated in Access point

jagan — Tue, 19 Jan 2016 01:09:23 GMT

I am not sure where you are going wrong, but his are the possible reasons. Cross check again, sometimes our eyes may not point out the error, take your friend/colleague help they may spot the error.

Regards,

Jagan.

Re: Data is reloading but not getting updated in Access point

PradeepReddy — Tue, 19 Jan 2016 04:52:28 GMT

there might be several possibilities in QVD creation application,

1) The new excel file location is not inline with source file path location(defined initially)

2) New and old File Names might be different.

Re: Data is reloading but not getting updated in Access point

maxgro — Tue, 19 Jan 2016 18:11:18 GMT

you can compare the .qvw log of the server reload and desktop reload

same .qvw, same source data, the 2 log will show no difference

Re: Data is reloading but not getting updated in Access point

varunreddy — Tue, 19 Jan 2016 19:41:29 GMT

Hi Guys,

Thanks for your response. I found the issue. It was relating to Section Access.

Best Regards,

Varun

Re: Data is reloading but not getting updated in Access point

sunny_talwar — Tue, 19 Jan 2016 19:43:39 GMT

Ha! I did ask you this thing earlier and you said that you were the admin

Re: Data is reloading but not getting updated in Access point

varunreddy — Tue, 19 Jan 2016 19:47:06 GMT

Sorry for that Sunny.

I am the Admin, So I could run it locally. But when I sent this to deploy in Admin. It was geting executed in different directory and I haven't provided proper access to that directory.