Qlikview not responding..

[#1]

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

[Gysbert_Wassenaar]

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)?

[#3]

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

[Gysbert_Wassenaar]

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.

[#5]

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

[Anonymous]

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

[#7]

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

thanks

[#8]

Yes, I am using RDP

[Anonymous]

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.

[#10]

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