Allocated Memory Exceeded Error

[#1]

One my report is not working when we try to open from client machine on server (File => Open in Server Option)

All the charts are giving Allocated Memory Exceeded error

But same document if we copy in client machine local drive (C:\) its working fine, even when we work directly in server it's perfectly working

Below are the expressions available in chart

Expression - 1

=Sum({$<[ACTUAL-YEAR]={$(=Only([ACTUAL-YEAR])-1)}>} ACTUAL)

Expression - 2

=Sum({$<[ACTUAL-YEAR]={$(=Only([ACTUAL-YEAR])-1)}>} VAL)

Expression - 3

=Sum({$<[ACTUAL-YEAR]={$(=Only([ACTUAL-YEAR]))}>} ACTUAL)

Expression - 4

=Sum({$<[ACTUAL-YEAR]={$(=Only([ACTUAL-YEAR]))}>} VAL)

Expression - 5

=Sum({$<[ACTUAL-YEAR]={$(=Only([ACTUAL-YEAR]))}>} VAL) - Sum ({$<[ACTUAL-YEAR]={$(=Only([ACTUAL-YEAR]))}>} ACTUAL * STANDARD_COST )

Expression - 6

=(Sum({$<[ACTUAL-YEAR]={$(=Only([ACTUAL-YEAR]))}>} VAL) - Sum ({$<[ACTUAL-YEAR]={$(=Only([ACTUAL-YEAR]))}>} ACTUAL * STANDARD_COST ))

/ Sum({$<[ACTUAL-YEAR]={$(=Only([ACTUAL-YEAR]))}>} VAL)

Expression - 7

=((Sum({$<[ACTUAL-YEAR]={$(=Only([ACTUAL-YEAR]))}>} VAL) - Sum({$<[ACTUAL-YEAR]={$(=Only([ACTUAL-YEAR])-1)}>} VAL))/Sum({$<[ACTUAL-YEAR]={$(=Only([ACTUAL-YEAR])-1)}>} VAL))

Expression - 8

=sum(BudgetQuantity)

Chart is working perfectly when we disable Expression - 8

Number of records in transaction table is around 456K, QVW file size is 8.35 MB,

Also tried checking and UN checking of Ignore calculation Limits

Please advice

[GabrielAraya]

Hi Nasser,

Did you test changing the default values in QVServer Console. In QVServer Console, in the Advanced tab do you have some default values for "Calculated Formulas Max Memory".

Gabriel

[#3]

is BudgetQuantity part of a synthetic key/table? Do you have any synthetic keys/tables in your script? Do a crtl+t to find out. You'll want o be sure you don't have any in order for this to work.

Also, what calculation do you do in order to obtain BudgetQuantity is it just a field being pulled or is it made up of other fields and loaded as an "AS" BudgetQuantity statement?

[#4]

I have tried all these R & D's still its same issue

[avastani]

anyone find a fix for this issue. it happens to be the case in v9.0SR3 server as well. developer opens fine but server on my end has identical issues. no synthetics, no circular, no loosely coupled. in developer the memory consumed is 600KB while a pivot table with 46300+ rows consuming 18MB memory displays just fine.

[r3iuk]

Having the same problem here. Report has just 51,000 rows. I doubled the Memory Allocations on the server, re-started and the report ran ok for a while but then the problem re-appeared. I doubled the memory allocation again (now at 4M for calculations and 8M for sorting) and same thing happened - worked ok for a while then re-appeared.

[r3iuk]

Hopefully I've caught the 'culprit' that was causing my memory exceeded errors - it was a calculated dimension: Year*100 + MonthNum

Instead I put this into the loading script and and used the field directly as the dimension and the error disappeared.

Somewhat bizarre - anyone got any ideas why this could've caused the error?