on 09-17-2012 6:31 AM
Hi experts,
we are getting following error in sm21 logs."BS0 Memory Overflow in Buffer Synchronization"
log in the below. i check WP the trace file not get any thing. and read 565057 note.
Please proived me the Proper sol.
*SAP ECC 5.0 Oracle 10G on Linux.
*
******************************************************************************************************************************************************************************
Time Instance Ty. Nr Cl. User Tcod MNo Text
Date : 14.09.12
01:29:49 SAPECCDB BTC 046 002 BHACCUSR BS0 Memory Overflow in Buffer Synchronization
etails
ecording at local and central time........................ 14.09.2012 01:29:49
ask................ 26746 / Background Processor No. 46
ser................ BHACCUSR
lient.............. 002
erminal............
ession............. 1
ransaction code....
rogram name........ ZAU00006
roblem class....... K SAP Web AS Problem
evelopment class... SBAC
odule name......... dbsync
ine................ 3761
able name..........
ield name..........
ocumentation for system log message BS 0 :
A memory overflow in the buffer synchronization
occurs in production systems extremely rarely. It is
usually caused by a transaction that has changed a large number
of buffered objects.
If an overflow occurs the affected buffers are reset on external
application servers. The possible causes of the overflow are
logged in the associated trace file. In most cases the cause is
buffered tables. You should consider whether these tables really
need to be buffered, that is whether the number of read accesses
far outweighs the number of write accesses. It may be best to shorten
the database transaction by using quicker, consecutive
COMMIT commands.
echnical details
ile................ 005827
osition............ 0000024840
ntry type.......... h ( Database Error (Non-SQL) )
essage ID.......... BS 0
ariable parts...... dbsync 3761
***************************************************************************************************************************************************************************
Regards,
vivek
Hi Vivek,
What type of tables are assoicated with the errors?
IF many of those tables are master data tables, you should consider
to debuffer them as outlined in note 803958.
803958 Debuffering BW master data tables
Please see the following for more info:
SAP Note #550784 - Changing the buffering of InfoObject tables
SAP Note #480710 - Maximum size of table buffers
Hope this is of help.
Best regards,
Paul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Vivek,
Thats very unusual, aside from BW tables I can only see a general note
565057 - Buffer synchronization
which indicates that the issue might occur if the mentioned tables are changed/updated very frequently within a single transaction. I would not expect this behaviour on tables USR02 ,USR10.
Do you know what programs/batch jobs triggered the SM21 error?
regards,
Paul
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.