topic Inconsistent Data between Access Point and Development in QlikView

Inconsistent Data between Access Point and Development

Thu, 11 Mar 2010 18:28:39 GMT

I am experiencing a strange issue between the Access Point ajax client and my QV development environment. It seems a data inconsistency between the two platforms. I have yet to find a reason why this is happening so I have posted it to get more eyes on it.

I develop on the same server QV Server/Access Point is on. Data reduction and section access is used on this document. All the below examples are shown using the same user.

It seems when the user logs into Access Point using any of clients (Ajax, IE, Java) drills down into 2010 he is able to accurately see the correct numbers for booked and sales. Then when the user makes a month selection 'December 09' to show just order in the month. The order then moves from being booked on the 17^th and the 23th. This same behavior does not occur on the server/development side.

This does not appear to be a bug within QV but it also does not make sense why the data would be accurate in the QV Developer but not on the web client(s). The data should be exactly the same between the developer and the web client. I understand if the layout/graphics are a bit different but the numbers can not change or be inaccurate.

If you need more information or screen shots let me know. Thanks for any help or advice on this matter.

Inconsistent Data between Access Point and Development

Anonymous — Mon, 18 Apr 2011 12:52:19 GMT

We are experiencing the same issue here for one Qlikview application.

On the server the data is accurate, but in the AccessPoint the same report seems to show limited data . . . Could it be an error in Qlikview plugin??

Did you find a solution for this problem? Or what causes this problem?

rgrds,

Anita

Inconsistent Data between Access Point and Development

Mon, 18 Apr 2011 14:42:22 GMT

If I recall correctly. I believe a reload of QV data and restart of the users browser fixed this issue. Maybe something was cached someplace? This did not happen again it just a freak event.

SV:Inconsistent Data between Access Point and Development

gandalfgray — Mon, 18 Apr 2011 15:04:18 GMT

Hi Jacob & Anita

I am not sure if my problem is exact the same you have but I have experienced cases of missing data, when accessing data using QVS, a couple of times.

Looking at the exact same qvw using the fat QV developer client, and using IE plugin (or ajax) data is missing in the plugin (and ajax) version.

The solution for me is to restart the QVS process, that has always fixed the problem.

My QVS version: 9.00.7646.0409.10

Inconsistent Data between Access Point and Development

Anonymous — Mon, 18 Apr 2011 15:11:24 GMT

I had experienced similar (but not the same) inconsistencies between local qvw and accesspoint when a new object was introduced. I had resolved the issue by restarting the services as it appeared to be a memory corruption issue.

Can you try to restart the service and see if the problem goes away?

Regards,

Dinesh.

Re: Inconsistent Data between Access Point and Development

ramasaisaksoft — Thu, 13 Mar 2014 10:53:25 GMT

Hi Friends,

I am very poor in English so please understand carefully.

For this Problem you can go to AccessPoint->which ever Report showing the data inconsistently , you click a symbol + left hand side of that report /Drill down for that report then you can find a button right hand side "Remove Last Document State" button click on that button ,before refreshing the report(I think this is need only for first time). Now refresh the AccessPoint and see the correct result.

and let me know any updates /problems.

In your Chrome window(or any Browser), can you pls try clicking on “Remove Last Document State” button before refreshing the report (I think this is needed only for first time)

Re: Inconsistent Data between Access Point and Development

marcelo_7 — Wed, 08 Oct 2014 09:46:15 GMT

Did not work for me.

Re: Inconsistent Data between Access Point and Development

sadickbasha — Thu, 16 Oct 2014 13:35:53 GMT

Hi Friends.

I am also facing the same issue. in a pie chart we are aggregating the revenue based on Gross Margin % interval. in desktop version it comes perfect. but in the Access Point the few records fall under null category. Kindly advice if any solution or settings need to be verified?

Re: Inconsistent Data between Access Point and Development

marcelo_7 — Thu, 16 Oct 2014 13:38:26 GMT

For me Dinesh Thoniparambil's answer helped. I restarted all services on the server and that solved the problem. Good luck!

Re: Inconsistent Data between Access Point and Development

marcelo_7 — Mon, 02 Mar 2015 08:26:56 GMT

If anyone ever comes to this thread looking for solutions, one of them might be to delete the .Shared file on the server which could be corrupt and cause irregularities.

Re: Inconsistent Data between Access Point and Development

awhitfield — Mon, 02 Mar 2015 10:10:37 GMT

Hi Jake,

It's the QV Service user that is loading the data into the qvw, you need to ensure the service user is included in you section access details as admin and full access to all the required data. If not, then not all of your data will be loaded.

Re: Inconsistent Data between Access Point and Development

nirav_bhimani — Thu, 05 Mar 2015 10:50:01 GMT

Hi Friends,

I have faced similar issue after doing some R&D, I resolved my issue

We can resolve this by two ways.

1. You can delete the .shared file.

2. You can create a copy of that object & delete the old object, so your object id will change.

You should try the 2nd way first because in the 1st you will loose all the user bookmark & their created objects.

Regards,

Nirav Bhimani

Re: Inconsistent Data between Access Point and Development

alexdataiq — Thu, 19 Nov 2015 18:05:21 GMT

Thanks, worked for me.

Re: Inconsistent Data between Access Point and Development

Tue, 23 Feb 2016 14:36:26 GMT

Go to internet options in your IE setting, under general tab click on setting (bottom right), browse to Caches and databases tab and uncheck Allow website caches and databases. Once done click ok, and then OK again. Close the browser window, and try and access the document. I believe that should do the trick.

Regards

Re: Inconsistent Data between Access Point and Development

marcelo_7 — Tue, 23 Feb 2016 15:47:54 GMT

It doesn't make sense that the user has to set some options locally to see correct data. Reduction of data is out of the users control so this has to be something else.

Re: Inconsistent Data between Access Point and Development

marcelo_7 — Tue, 23 Feb 2016 15:51:50 GMT

Hi, Do you have the checkbox Strixt exclusion, because if not and there is not "hit" in the section access table the user will be able to see everything. Also if you have * on a dimension in the section access table and haven't specified that dimension in the table it won't work either. When it comes to why the user gets another date than you do you could try to delete the .Shared file. But doing that will also delete all the users bookmarks and created objects so do that with caution. There is also a small program Shared File Viewer that "cleans" .Shared files. Link below. https://community.qlik.com/docs/DOC-3059 Cheers!

Re: Inconsistent Data between Access Point and Development

Sat, 12 Nov 2016 09:06:20 GMT

Hi,

Did anyone find a solution to this issue?

Has anyone raised the issue with Qlik support? I did raise the issue with Qlik support and they have been clueless with respect to the issue and have time and again asked us to help them in replicating the issue. This issue happens abruptly and when we reload the full data then it disappears. I am facing the same issue wherein the data on accesspoint goes for a toss whereas it appears correctly in the .qvw file when checked from Qlikview desktop.

I did discuss it with Qlik support, telling them that this is a common issue and the forum has complaints from many customer regarding this behaviour however they have claimed that the issue raised by us has not been reported by any customer yet with the Qlik support.

Would appreciate if someone has a concrete solution to this issue. Restarting the services, deleting the .shared files all these seem to be a temporary fix and not a permanent solution.

Thank you in advance.

Sincerely,

Harshraj Sanghvi

Re: Inconsistent Data between Access Point and Development

psk180590 — Mon, 05 Dec 2016 13:38:40 GMT

Hello All,

Even i'm facing similar issue with one of my App pages.

Have created a new thread QlikView displays Null Values on Access Point before i came across this.

Any solution or pointers are much appreciated.

TIA!!

Re: Inconsistent Data between Access Point and Development

philipp_ebner — Fri, 08 Jun 2018 09:58:37 GMT

Hi,

we faced the same issue.

After contact with qlik support we found that there existed an inconsistent deployment of

QV plugin versions within the companie's PCs using QV plugin.

You will find the info when analyzing the Event LOGS!

there you will find infos which user is using which version of the "Client build number" of the plugin.

there should not be different Versions.

Regards