topic Blank Tables??? in QlikView

Blank Tables???

samvile18 — Thu, 08 Nov 2012 10:00:51 GMT

Morning All,

I have an odd issue which I've not seen before. I have a QVW that I'm opening via my Access Point, when I open it the tables in a specific tab are completely blank. There is data there and the thumbnail shows the table in it's populated form, I have no idea why this is happening.

It only seems to be happening on one tab.

I am however using QV11 personal edition, the publisher and server is still QV10...does that make any difference??

Re: Blank Tables???

samvile18 — Wed, 14 Nov 2012 15:15:14 GMT

BUMP - still getting this issue, I'm back using QV10 now and it's still happening.

I've got one column of data that shows zero's on the access point although the data is present within my developer.

Re: Blank Tables???

Jason_Michaelides — Wed, 14 Nov 2012 18:34:53 GMT

Can you provide a sample?

Re: Blank Tables???

samvile18 — Thu, 15 Nov 2012 09:41:03 GMT

Hi Jason,

Here are two screen prints. The first one shows the tables from my Access Point (note the missing data in FY FC3) the second shows the tables within my developer where everything is working as expected.

Re: Blank Tables???

Jason_Michaelides — Thu, 15 Nov 2012 09:42:30 GMT

I meant a sample qvw file.

Re: Blank Tables???

samvile18 — Thu, 15 Nov 2012 09:49:06 GMT

I can but it won't show the issue I'm experiencing with the Access Point

Re: Blank Tables???

flipside — Thu, 15 Nov 2012 10:08:27 GMT

I would put my mortgage on it being a memory issue messing with your Set Analysis. I've posted this issue on here before, but nobody seems to think it's a major issue.

Reboot your services and let us know if it's fixed.

flipside

Re: Blank Tables???

samvile18 — Thu, 15 Nov 2012 10:10:57 GMT

I was thinking about the memory being a problem as our server is so poor, I hope it is the issue as this is turning my hair grey with all the thinking!

Re: Blank Tables???

samvile18 — Thu, 15 Nov 2012 10:12:45 GMT

Next question...how do I actually reboot my services??

Re: Blank Tables???

flipside — Thu, 15 Nov 2012 10:18:46 GMT

Go to the server and then to Administrative Tools > Services and look for the Qlikview Services (usually 5 or 6 of them).

You just need to restart Qlikview Server service to fix this, bear in mind this will disconnect all (Qlikview) users.

Re: Blank Tables???

samvile18 — Thu, 15 Nov 2012 10:57:26 GMT

It worked, thanks for the help chaps.

Re: Blank Tables???

flipside — Thu, 15 Nov 2012 11:47:39 GMT

I've just sent an email to Qlikview to look into this as I consider it a serious issue - not sure if they are aware of it already. In the meantime, I recommend keeping Set Analysis expressions down to a minimum, and performing regular service reboots through batch files.

flipside

Re: Blank Tables???

flipside — Mon, 19 Nov 2012 14:57:24 GMT

Hi SamVile18,

QlikView have confirmed there was a similar sounding bug first reported in V10 SR2 and was fixed for V10 SR4. The bug ID is 40688 (see attached). Can you confirm if your server release is prior to SR4?

flipside