cancel
Showing results for 
Search instead for 
Did you mean: 

ST22 // SYSTEM_NO_ROLL + UNCAUGHT_EXCEPTION

mohsin_m3
Participant
0 Kudos

Hello All,

In BI system lot of ABAP Dumps found in the system.

1) SYSTEM_NO_ROLL

Unable to fulfil request for 268435456 bytes of memory space.

If the error persists, ask your system administrator to check the

following profile parameters:

o ztta/roll_area (1.000.000 - 15.000.000)

Classic roll area per user and internal mode

usual amount of roll area per user and internal mode

o ztta/roll_extension (10.000.000 - 500.000.000)

Amount of memory per user in extended memory (EM)

o abap/heap_area_total (100.000.000 - 1.500.000.000)

Amount of memory (malloc) for all users of an application

server. If several background processes are running on

one server, temporary bottlenecks may occur.

Of course, the amount of memory (in bytes) must also be

available on the machine (main memory or file system swap).

Caution:

The operating system must be set up so that there is also

enough memory for each process. Usually, the maximum address

space is too small.

Ask your hardware manufacturer or your competence center

about this.

In this case, consult your hardware vendor

abap/heap_area_dia: (10.000.000 - 1.000.000.000)

Restriction of memory allocated to the heap with malloc

for each dialog process.

Parameters for background processes:

abap/heap_area_nondia: (10.000.000 - 1.000.000.000)

Restriction of memory allocated to the heap with malloc

for each background process.

Other memory-relevant parameters are:

em/initial_size_MB: (35-1200)

Extended memory area from which all users of an

application server can satisfy their memory requirement.

Note which actions and input led to the error.

2) UNCAUGHT_EXCEPTION

An exception occurred that was not caught.

Error analysis

An exception occurred which is explained in detail below.

The exception, which is assigned to class 'CX_SDB_ORA_PROGRAM_ERROR', was not

caught and

therefore caused a runtime error.

The reason for the exception is:

An error occurred in the program:

The occurrence of the exception is closely related to the occurrence of

a previous exception "CX_SQL_EXCEPTION", which was raised in the program

"CL_SQL_STATEMENT==============CP",

specifically in line 31 of the (include) program

"CL_SQL_STATEMENT==============CM002".

The cause of the exception was:

ORA-04031: unable to allocate 62904 bytes of shared memory ("shared

pool","DBMS_STATS","PL/SQL MPCODE","BAMIMA: Bam Buffer")#ORA-06508: PL/SQL:

could not find program unit being called: "SYS.DBMS_STATS"#ORA-06512: at line 1

...

can you please help me to resolve the issue.

Regards

Mohsin Mulani

Accepted Solutions (0)

Answers (3)

Answers (3)

mohsin_m3
Participant
0 Kudos

After increasing shred pool size issue resolve(dynamic parameter)

Former Member
0 Kudos

hi Mohsim,

Can you share with me how you manage to solve this?

Regards,

Maili

Former Member
0 Kudos

Hello,

This is a typical error in a BW system, caused by big reports and extractions.

Increasing memory parameters is not the best solution for it.

There are SAP Notes that propose alternative solutions.

Examples :

[https://service.sap.com/sap/support/notes/779123|https://service.sap.com/sap/support/notes/779123]

[https://service.sap.com/sap/support/notes/1257455|https://service.sap.com/sap/support/notes/1257455]

I hope these SAP Notes can be a good reference to start analyzing and solving your problem.

Success.

Wim

mohsin_m3
Participant
0 Kudos

Hello,

Today I in BI system lot of UNCAUGHT_EXCEPTION dumps found

An exception occurred which is explained in detail below.

The exception, which is assigned to class 'CX_SDB_ORA_PROGRAM_ERROR', was not

caught and

therefore caused a runtime error.

The reason for the exception is:

An error occurred in the program:

The occurrence of the exception is closely related to the occurrence of

a previous exception "CX_SQL_EXCEPTION", which was raised in the program

"CL_SQL_STATEMENT==============CP",

specifically in line 31 of the (include) program

"CL_SQL_STATEMENT==============CM002".

The cause of the exception was:

ORA-04031: unable to allocate 62904 bytes of shared memory ("shared

pool","DBMS_STATS","PL/SQL MPCODE","BAMIMA: Bam Buffer")#ORA-06508: PL/SQL:

could not find program unit being called: "SYS.DBMS_STATS"#ORA-06512: at line 1

Can u pls help me

Regards

Mohsin M

Former Member
0 Kudos

Hello,

There seems to be a problem with your database statistics, check following SAP Notes :

[https://service.sap.com/sap/support/notes/975948|https://service.sap.com/sap/support/notes/975948]

[https://service.sap.com/sap/support/notes/1417124|https://service.sap.com/sap/support/notes/1417124]

[https://service.sap.com/sap/support/notes/998904|https://service.sap.com/sap/support/notes/998904]

[https://service.sap.com/sap/support/notes/633914|https://service.sap.com/sap/support/notes/633914]

[https://service.sap.com/sap/support/notes/582427|https://service.sap.com/sap/support/notes/582427]

Wim

anindya_bose
Active Contributor
0 Kudos

if you are getting this error during data loading , first thing you can do to ask your BI guys to decrease the data package size from default 50,000 to something like 20,000.

Also check there may be lots of data in PSA which system can not process at one time and thereby throwing memory dumps.

From Basis side you can also check if there is any change of any memory related parameter.

Regards

Anindya

Edited by: Anindya Bose on Mar 16, 2010 7:56 PM