SYSTEM_NO_ROLL

[Former Member]

I am trying to import a query in ORACLE OBIEE from SAP BEX,, but I am ending up with a error SYSTEM_NO_ROLL and error description is (Each transacition requires some main memory space to process applicaiton data. If the operating system cannot provide any more space, the trasaction is terminated).

well, I consulted my basis team to increase the memory,, but as the users for this report are very less and they cannot allot much space and they confirmed thats not right way to do as there is enough memory allocated already..

Can some please advise me if we can fix this in some other way.

with regards,

Sunil reddy. K

Edited by: Sunil KReddy on Aug 28, 2009 4:57 AM

[Former Member]

Hi Sunil,

for a 4gb ram

check

abap/heap_area_dia = 2gb

abap/heap_area_nondia = 2gb

abap/heap_area_total = 4gb

ztta/roll_extension = give the max (4gb)

ztta/roll_area = 3gb

ztta/roll_extension_dia=

ztta/roll_extension _nondia

also check the paging memory

thanks,

Vijay