Issue with Year selection which gets resolved once QV server is restarted

[#1]

Hi All, swuehl, Miguel Angel Baeyens, John Witherspoon

Henric CronströmDeepak VadithalaHenric Cronström

I am a facing a weird issue wherein the QV charts and tables get stuck for an year( eg 2014). These QV object does not refresh the numbers for 2013 provided 2013 is selected, and this is happening only for a particular year which is 2013. If I select 2014 or 2012 or 2011 etc etc the QV objects get refreshed.

Note: This is only the case when the file is deployed on Server

Known solution as of now: Once we restart the Production server everything gets rectified.

Can anyone help me out? Its been around 2.5 years since I am working on QlikView but I have never faced this sort of Problem

Any help will be highly appreciated

Thanks in Advance

Sagar Gupta

[#2]

Hi,

Is so strange this issue... try to clean Year field with trim() and then specify you want to get this data like a number ... something like this:

Let vYear = Num(Trim(Year));  // If you declare variable in script editor

or just

Num(Trim(Year))  // Make sure don't tip "=" at the beginning if you declare variable in variable overview

Best regards.

[ashfaq_haseeb]

Hi,

From how long you get this error.

What version of QlikView you run?

Do you have some patched installed on QlikView server recently?

What is the current version of IE.

Regards

ASHFAQ

[#4]

Hi ASHFAQ,

I am facing this issue since 1 month, possibilities are their that this issue might be present before I noticed it.

We have checked for patches in QV but we don't have any.

The version which we have on the dev as well as on prod server is 11.2 SR2.

The above mentioned issue is with both IE and Ajax plugin.

Please suggest in case of any possible resolution

Regards

Sagar Gupta

[#5]

Hi Vasquez,

Thanks for your response, but I don't think that Trim() function will help because the length of the year field is restricted to 4.

Regards

Sagar Gupta

[ashfaq_haseeb]

Hi,

Can you share a sample to replicate issue.

Regards

ASHFAQ

[qlikpahadi07]

Dear Sagar,

This is weird issue but as you said it's related with Server and once you restart the Production server it works,

try to delete all .PGO and .Shared,.META files and restart the server and see if it works.

[#8]

Hi,

Thanks for your response

I will try this but I have a question, will doing this remove QV license? or are you aware of any sort unseen issue which may come up doing this step? The only reason of being cautious is that the file is on production server.

Regards,

Sagar Gupta

[ashfaq_haseeb]

Hi,

By deleting those files.

you have to re allocate licences and all the user created objects and bookmarks will be deleted.

Take proper backup first.

Regards

ASHFAQ