topic Re: QV document save - not responding in QlikView

QV document save - not responding

settu_periasamy — Tue, 10 Mar 2015 06:01:01 GMT

Hi All,

I have the 4 GB QVW file. Script reload is working fine.

But when i try to save that, It takes very long time, and it shows not responding.

I tried the below methods:

i) removed the hidden tabs.

ii) removed the conditional display charts.

iii) saving compression as None.

But it is not working for me.

How can we rectify this? Anybody have suggestion?

Regards,

Settu

Re: QV document save - not responding

tamilarasu — Wed, 11 Mar 2015 01:58:26 GMT

Hi Settu,

Try to save the file without data and see whether the file is saving correctly.

Kind Regards,

Tamil

Re: QV document save - not responding

settu_periasamy — Wed, 11 Mar 2015 05:12:11 GMT

It is not working tamil. Reload is working perfectly. But the saving document only having the problem.

Anybody have an idea?

Re: QV document save - not responding

Wed, 11 Mar 2015 05:26:25 GMT

Hi Settu,

If you can save large data, must and should having the high Processor and RAM(Min Processor 4 GHz and RAM 4GB). First see my suggestion.

Regards,

Krish

Re: QV document save - not responding

prma7799 — Wed, 11 Mar 2015 05:36:38 GMT

Please Check

http://community.qlik.com/message/189260#189260

Thanks

Re: QV document save - not responding

PrashantSangle — Wed, 11 Mar 2015 05:44:12 GMT

Hi,

can you tell us below

How much time it will take to save??

How much time it will take reload??

Regards,

Re: QV document save - not responding

settu_periasamy — Wed, 11 Mar 2015 06:48:12 GMT

Hi,

Reload time is just 10 Minutes.

Not able to measure the saving time (i have been waiting for 9 hours, and i cancelled it using the task manager).

My colleague waited for 19 hours, but not completed.

i tried the methods,

i) "open document without data" -> Reload the data

ii) Removed all the objects and paste the from another file.

But not able to save. 😞

Regards,

Settu

Re: QV document save - not responding

settu_periasamy — Wed, 11 Mar 2015 06:51:03 GMT

Hi Prashantbi,

I already checked it. not able resolve.

Thanks,

Regards,

Settu P

Re: QV document save - not responding

PrashantSangle — Wed, 11 Mar 2015 06:56:53 GMT

Hi,

Does it contain any synthetic Key or circular loop??

also do insted of full reload do limited load with 10 to 100 lines.

and then check its save time.

also if possible post data model of report

Regards

Re: QV document save - not responding

agni_gold — Wed, 11 Mar 2015 07:02:18 GMT

Try this and then save . It will work

If it is not worked then please reply .

Thanks .

Re: QV document save - not responding

settu_periasamy — Wed, 11 Mar 2015 07:04:24 GMT

Hi Max,

Let me try your suggestions. Data model doesn't have synthetic key/ circular loop. it is loading very quickly.

can you clarify the below .

i) two pivot table shows the memory is 46 MB and 27 MB. Already i hide it using the show conditional in the layout tab.

One more info,

i have the binary load in the starting. Not able to load the limited lines.

Thanks,

Regards,

Settu P

Re: QV document save - not responding

settu_periasamy — Wed, 11 Mar 2015 07:05:40 GMT

Hi Agniesh,

Thanks. Already i tried this. But not working for me. My document is around 4 GB.

Re: QV document save - not responding

Wed, 11 Mar 2015 07:16:58 GMT

Hi Settu,

If you can save large data, must and should having the high Processor and RAM(Min Processor 4 GHz and RAM 4GB). First see my suggestion.

Regards,

Krish

Re: QV document save - not responding

agni_gold — Wed, 11 Mar 2015 07:17:03 GMT

Have u tried data reduction ?

Re: QV document save - not responding

settu_periasamy — Wed, 11 Mar 2015 07:24:51 GMT

Hi Krishnama,

This document is even not able to save in the production server which is very higher level processor and RAM. There are many large document compare with this( > 4 GB file size).

Regards,

Settu P

Re: QV document save - not responding

settu_periasamy — Wed, 11 Mar 2015 07:54:49 GMT

Yes agnivesh. i tried that.

can you tell me, is that problem for pivot table, (one chart is taking the memory 46 MB and one more is 27 MB)

Re: QV document save - not responding

agni_gold — Wed, 11 Mar 2015 08:02:59 GMT

Yes it is totaly depend on your expression , that you have written behind charts , if expressions are bulky in nature then it may be the problem.

Re: QV document save - not responding

jagan — Wed, 11 Mar 2015 08:06:54 GMT

HI,

Try like this

Create a new sheet and placing in empty sheet try to save it.

Reduce the file size and try to save it? (Just for checking whether able to save)

Is your file having Section Access? If yes remove that script and try to save it.

Regards,

Jagan.

Re: QV document save - not responding

settu_periasamy — Thu, 12 Mar 2015 08:30:55 GMT

Hi Jagan,

i tried the above 3 options which you suggested. 3rd one (removed the Section Access) is worked for one time one.

Then again i opened the file, and reload it. But not able to save it.

Regards,

Settu P

Re: QV document save - not responding

trdandamudi — Thu, 12 Mar 2015 10:10:59 GMT

You said you are using Binary load, but are you able to reload and save the original .qvw file ?