topic Re: Qlikview not responding.. in QlikView

Qlikview not responding..

Fri, 29 Apr 2016 16:06:08 GMT

Namaste All,

I am facing a weird problem, when i try to execute a file which is connected to MS sql server database, m qlikview client edition(licensed) is not responding. I have installed qlikview client edition on windows server 2008 machine along with qlikview server.

below is the image of error.. just to show you..........

But, I am able to run another file, which is connected to INSQL database, and this file is executing successfully..

I put the two files in the same folder location.

The difference between the two files is, The file which is not working, creates a qvd file with the script in it and stores the data in it.

can anyone, please tell me possible reasons for it.. I can explain in more if I am not clear here

Thanks

Ganesh

Re: Qlikview not responding..

Gysbert_Wassenaar — Fri, 29 Apr 2016 16:12:15 GMT

The difference between the two files is, The file which is not working, creates a qvd file with the script in it and stores the data in it.

Is that the only difference? The two databases contain exactly the same data and both qvw files contain exactly the same script (apart from the database connection and store command)?

Re: Qlikview not responding..

Fri, 29 Apr 2016 16:24:27 GMT

No.. Two databases contain completely different data and columns i would say..

as one is INSQL and the other is SQL ..

but before, I was able to see the log file generated, and i observed the error at the creating qvd file

but now, it just getting freezed and not responding at all, leaving no log file

The below shown was the error i was getting before, but now, no logfile is getting generated.

Thanks

Re: Qlikview not responding..

Gysbert_Wassenaar — Fri, 29 Apr 2016 16:29:51 GMT

The qvd file is locked. Possibly because you killed a process that was writing to it. Remove the lock or the file and you should be able to write to it again.

If the databases are completely different and your workbooks load different data then possibly the non-responsive document is calculating a costly join or synthetic keys. Use the debugger to load a small number of records and check the resulting data model.

Re: Qlikview not responding..

Fri, 29 Apr 2016 16:37:00 GMT

hi, could you explain me..

1. actually i dont have any section access implemented on my file,, what are the reasons for qvd file to get locked?

how to remove the lock?

2. debugger in qlikview doesnt work when we connect to odbc,, it is a bug in qlikview it seems.. I never used debug in qlikview when i conenct to odbc.

and the same file, which is not working on my server os.. is working fine on my desktop..

Thanks

Re: Qlikview not responding..

Anonymous — Fri, 29 Apr 2016 16:39:35 GMT

Also are you using RDP ?

That can sometimes have screen painting issues leading to an empty Script Execution Progress window, despite the fact it is running ok it looks like it is not working. Clicking things make it display "Not Responding". Killing it can leave zombie qv.exe processes and residual locks on files, like you had with your qvd.

Try taking your hand off the mouse, start the reload with <Ctrl>R and don't touch the mouse until things start getting shown in the Script Execution Progress window

Re: Qlikview not responding..

Fri, 29 Apr 2016 16:42:12 GMT

oh god.. this is the first time, I heard of a problem.. will try this

thanks

Re: Qlikview not responding..

Fri, 29 Apr 2016 16:45:17 GMT

Yes, I am using RDP

Re: Qlikview not responding..

Anonymous — Fri, 29 Apr 2016 16:55:58 GMT

Don't get me wrong. I think RDP is great and use it all the time. Just be aware of the odd screen painting quirk.

There again your issue may be something completely different.

Re: Qlikview not responding..

Tue, 03 May 2016 08:34:27 GMT

Hi Bill

How r u?

Still I am unable to run my file,,

I tried the way to do uit, but still I couldn't

and more over, I would like to upload the document on qlikview server and schedule the reload every two minutes.. so, please give me another solution so that my file run on qlikview server alsp

as i said earlier, that file is reloading successfully, from another drive, but I am unable to reload the same file when i copy it in c drive.

Thanks

Ganesh