Question Re: SM21 Error Logs - Need Help in Technology Q&A

SM21 Error Logs - Need Help

MaheshKumar — Thu, 21 Jul 2011 07:33:24 GMT

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

Re: SM21 Error Logs - Need Help

Former Member — Thu, 21 Jul 2011 07:42:10 GMT

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

Re: SM21 Error Logs - Need Help

jay_b2 — Thu, 21 Jul 2011 07:50:53 GMT

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.

Re: SM21 Error Logs - Need Help

JPReyes — Thu, 21 Jul 2011 08:18:51 GMT

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

Regards

Juan

Re: SM21 Error Logs - Need Help

MaheshKumar — Thu, 21 Jul 2011 09:24:32 GMT

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.

Re: SM21 Error Logs - Need Help

JPReyes — Thu, 21 Jul 2011 09:47:59 GMT

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

Regards

Juan

Re: SM21 Error Logs - Need Help

MaheshKumar — Thu, 21 Jul 2011 10:07:44 GMT

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

Re: SM21 Error Logs - Need Help

Former Member — Thu, 21 Jul 2011 11:21:38 GMT

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

Re: SM21 Error Logs - Need Help

MaheshKumar — Thu, 21 Jul 2011 13:37:30 GMT

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

Re: SM21 Error Logs - Need Help

Former Member — Thu, 21 Jul 2011 15:58:18 GMT

hi,

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

This is just a network disconnection.

Regards,

Olivier

Re: SM21 Error Logs - Need Help

Former Member — Fri, 22 Jul 2011 04:56:14 GMT

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.

Re: SM21 Error Logs - Need Help

Former Member — Sat, 23 Jul 2011 05:47:53 GMT

Hi Mahesh,

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

Thanks,

Siva Kumar