QV document save - not responding

[settu_periasamy]

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

[settu_periasamy]

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

[settu_periasamy]

Hi Agniesh,

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

[#4]

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

[agni_gold]

Have u tried data reduction ?

[settu_periasamy]

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

[settu_periasamy]

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)

[agni_gold]

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.

[jagan]

HI,

Try like this

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

or

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

or

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

Regards,

Jagan.

[settu_periasamy]

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

[trdandamudi]

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