on 03-16-2010 2:05 PM
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
After increasing shred pool size issue resolve(dynamic parameter)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.