topic QV Reload not finishing in QlikView

QV Reload not finishing

Thu, 14 Aug 2014 13:32:49 GMT

Good morning, as of today...my scripts are getting stuck at the Store QVD statement. The script just hangs and won't finish.

So i decided to run a simple script:

Test:

LOAD * INLINE [

A, B

1, 1

2, 2

3, 3

4, 4

5, 5

];

Store Test Into (qvd);

Drop Table Test;

Even this won't work...it stores the qvd...but with the "close when finished" button checked it still won't finish out..

Any ideas? Is this something local to my machine that's wrong?

Re: Unable to Store QVD's

Anonymous — Thu, 14 Aug 2014 13:42:01 GMT

Try like this

Let vSouce:'C:Users\Desktop\';

Store Test into $(vSource)Test.QVD;

Re: Unable to Store QVD's

Thu, 14 Aug 2014 13:50:38 GMT

Unfortunately, this didn't work. Still the same issue.

I was going to be very confused if this was the fix...as all we are doing was using a variable instead of a filepath.

What is going on ??

Re: Unable to Store QVD's

Thu, 14 Aug 2014 13:51:56 GMT

It does produce the output file..but won't close out the script...

Re: Unable to Store QVD's

giakoum — Thu, 14 Aug 2014 13:53:08 GMT

Is you script as simple as it is here?

Looks to me that QV is creating big synthetic keys, that is why it takes long to close the script window. Are all tables dropped?

Re: Unable to Store QVD's

Thu, 14 Aug 2014 13:55:06 GMT

That's the test script i'm trying to run...it's outputting the file, but won't finish out the script

No clue what's going on...it worked yesterday and for the months before. Restarted computer to see if that might have been the issue...

I'm at such a loss

Re: Unable to Store QVD's

Thu, 14 Aug 2014 13:57:15 GMT

Can you activate the Document Log (Settings -> Document Properties - >Generate Logfile) and attach it. Sames script works fine for me.

Re: Unable to Store QVD's

giakoum — Thu, 14 Aug 2014 13:57:19 GMT

If that is the whole script then I don't know. I tried it and it works for me. QV has that behavior only when constructing a bad data model after reload. Version?

Re: Re: Unable to Store QVD's

Thu, 14 Aug 2014 14:00:30 GMT

Log file attached, thank you sincerely for taking a look! Everything worked fine yesterday..

Re: Re: Unable to Store QVD's

Thu, 14 Aug 2014 14:01:55 GMT

11.20.12354.0 SR6 64 bit edition - personal edition

Trying to sell my organization on buying server edition - this kind of issue makes that difficult...

Re: Re: Unable to Store QVD's

Thu, 14 Aug 2014 14:09:09 GMT

Should I attempt to update my personal edition? I believe there's a newer release out there...

Re: Unable to Store QVD's

Thu, 14 Aug 2014 14:13:19 GMT

Even without the Store statement...

Test:

LOAD * INLINE [

A, B

1, 1

2, 2

3, 3

4, 4

5, 5

];

Script won't even finish out if this is all...

Re: Unable to Store QVD's

Thu, 14 Aug 2014 14:13:40 GMT

Does the script finish when you comment the Store line? Looks like something is not working when QlikView tries to write the file, maybe a good test is to use a different Folder. Is the User Access Contro Active?

Re: Unable to Store QVD's

Thu, 14 Aug 2014 14:18:43 GMT

I did a windows update yesterday....I wonder if this caused any problems?

Re: Unable to Store QVD's

Thu, 14 Aug 2014 14:18:50 GMT

Thats maybe a good idea David as there is nothing wrong with the script below.

Let me know if updating worked for you.

Regards,
Marius

Re: Unable to Store QVD's

giakoum — Thu, 14 Aug 2014 14:20:43 GMT

Try to update to SR7 but this is not normal behavior. This works for everybody else.

Try the same on some other computer not in the domain. maybe there is some new domain restriction causing that.

How long have you been using the personal edition?

Re: Unable to Store QVD's

Thu, 14 Aug 2014 14:22:05 GMT

That sounds strange, was there any .Net Update maybe? Could be good to update / repair the QlikView Installation. Also just installed the latests update but everything looks fine in my installation with SR7

Re: Unable to Store QVD's

Thu, 14 Aug 2014 14:22:36 GMT

Script won't finish even without the store line. What's the user access control?+

Re: Re: Unable to Store QVD's

Thu, 14 Aug 2014 14:24:35 GMT

Thank you for your time Daniel, I did try to repair qlikview but didn't work. these are the updates that happened yesterday...

Re: Unable to Store QVD's

Thu, 14 Aug 2014 14:25:45 GMT

I've been using personal edition for months with no issues. I have never updated personal edition, do you just overwrite it with a new installation from the qv download site?

Will it give me issues, or just act normal after I do the install?