SM21 Error Logs - Need Help

[MaheshKumar]

Hi All,

In SM21 log im getting following logs frequently. I made some research on errors but couldnt find exact reason and resolution. I will be thankful if any one can tell me the reason and resolution,

Operating system call recv failed (error no. 232 )

Operating system call recv failed (error no. 238 )

Signal 11 received by operating system

Run-time error "DBIF_REPO_SQL_ERROR" occurred

Thanks in advance

[Former Member]

Hi Mahesh,

Please have a look at WP trace file, you would find some clue there.

Thanks,

Siva Kumar

[MaheshKumar]

My Error log..

18:13:29 DIA 002 900 120205 R4 7 Delete session 001 after error 061

18:36:39 DP Q0 I Operating system call recv failed (error no. 232 )

18:36:39 DP Q0 4 Connection to user 4702 (SAPSYS ), terminal 101 (Kuntal-eng-s) lost

18:55:00 DP Q0 I Operating system call recv failed (error no. 232 )

18:55:00 DP Q0 4 Connection to user 4719 (120205 ), terminal 79 (Kuntal-eng-s) lost

19:07:06 DP Q0 4 Connection to user 4714 (140805 ), terminal 97 (sudhir ) lost

19:08:23 DIA 002 900 120215 R4 7 Delete session 001 after error 061

Name for errno number ECONNRESET

[Former Member]

hi,

This last message has nothing to do with the first one.

This is just a network disconnection.

Regards,

Olivier

[Former Member]

Mahesh,

The logs you see is related to your system internal process. In SM21 we can find User session, Run Time errors, Transaction Cancelled etc. As per the High priority we have to check, Dumps, Backgroud Jobs, Database Oracle statements.

If your error is repeated continuosly, check if related specifically with OS, DB, SAP then go to respective transactions for further analysis.

Thank You,

S.K.

[MaheshKumar]

Hi All.

Thanks for ur valuable efforts and time.

On different application servers im getting these errors frequently.

Coming to database error i have a dump in st22

Error analysis

An R/3 System process was terminated by an operating system signal.

-

Possible reasons for this are:

1. Internal system error.

2. Process was terminated externally (by the system administrator).

-

How to correct the error

The R/3 System work directory (e.g. /usr/sap/c11/D00/work ) often

contains a file called 'core'.

Save this file under another name.

Run-time error "DBIF_REPO_SQL_ERROR" occurred

Details

Recording at local and central time........................ 21.07.2011 12:09:44

Task...... Process User...... Terminal Session TCode Program Cl Problem cl Package

19241 Dialog work process No. 005 19061 SUNILPAR 1 ZV048 ZSD_DIV_CUST_PROD_SALE_RET_DE3 T Transaction Problem SABP

Further details for this message type

Module nam Line Error text

abload5 0251 db_info

Documentation for system log message AB 0 :

The specified runtime error has occurred in the system.

Documentation for system log message BY 0 :

Access to the database system has returned an SQL code indicating that

the operation could not be performed correctly by the database system.

This system log entry shows the database text for the SQL error that

has occurred. It supplements the preceding system log entry, which

shows the SQL code, the table name and the SQL function where the error

has occurred.

[JPReyes]

What are you system details?... theres quite a few notes about problems with certain kernels... have you upgraded your kernel recently?

Regards

Juan

[MaheshKumar]

No... dint updated my kerenel....mine is eccc on HP-UX.

[Former Member]

Hi,

In the short dump you will find the extract of abap code with the problem.

This will show you the abap sql request. Then you will be able to check this request.

When we get this kind of error in our ECC6 system, most often, this an abap report where a user has the very bad idea to do a copy and paste from Excel inside a field of the selection screen.

The abap request seems simple : select * from table where x in memtable.

But when you look at the number of entries in the internal table (memetable) you find thousands of entries.

So when abap SQL is translated into native SQL, the where clause would contain thousands of parameters which is too much for the database.

The same kind of problem happens also with Abap queries.

For this kind of error the only solution is to educate the users.

Regards,

Olivier

[JPReyes]

Does it happen ramdomly?... do you have a distributed installation?.... more info needed

Regards

Juan

[Former Member]

Hi,

Check for the DBIF_REPO_SQL_ERROR error in ST22 tcode as well.

You would get detailed information about the cause for this error and possible solutions.

This usually is due to connection to database lost.

Regards,

Srikishan

[jay_b2]

Check for failed updates and locks..

If there are many such messages, you'll need to check the connectivity... if its just one, you might be fine to ignore it.