Question Re: table for error ? in Technology Q&A

table for error ?

Former Member — Fri, 12 May 2006 13:53:12 GMT

Hi,

I would know in which table is stored the errors about a loading ?

In RSLDPSEL are informations about infopackage, but not about errors...

Thank you four your help !!!

Re: table for error ?

Former Member — Fri, 12 May 2006 13:55:45 GMT

Hi Vince,

You can check table RSMONMESS and also RSERRORLOG.

Hope this helps...

Re: table for error ?

Former Member — Fri, 12 May 2006 13:56:47 GMT

Hi,

IN RSREQDONE --> TABLE FOR FAILURES INFORMAITION

-SHREYA

Re: table for error ?

udayabhanupattabhiram_cha — Fri, 12 May 2006 13:59:12 GMT

Hi Vince:

BW Table - RSREQDONE has most of the useful information on Load Status. It will tell you status (including colors Green, Yellow or Red), but not the 'type' of Error.

To read the table, use need the Request Number that start with 'REQU_******'. This is available in Manage screen for both Cubes & ODS.

Is that what you are looking for?

Ram Chamarthy

Re: table for error ?

Former Member — Fri, 12 May 2006 14:31:59 GMT

> BW Table - RSREQDONE has most of the useful

> information on Load Status. It will tell you status

> (including colors Green, Yellow or Red), but not the

> 'type' of Error.

In fact, it's the 'type' of Error that I want to obtain !!! i.e. the table which stores these errors ?

The tables given (RSMONMESS...) don't store the errors of Loading

Re: table for error ?

udayabhanupattabhiram_cha — Fri, 12 May 2006 15:12:17 GMT

Hi Vince:

I am afraid I cannot help you on that one. Some time ago, I did try to find solution to a similar problem. My conclusion is: When it comes to Error Messages, SAP doesn't store them in 1 table. It uses a combination of Cluster Tables and Message tables. Now, all the Messages are in Message Tables. What SAP does is: Picks the type of Error Message, adds additional information to it and shows it to you using Cluster Table. These cluster tables are not very easy to read. It requires good ABAP Code.

Ram Chamarthy

Re: table for error ?

Former Member — Fri, 12 May 2006 15:33:54 GMT

Ok, thank you for your help Ram,

I've got another question : where can is the name of these Message Tables? because, i'm going to try to do this ABAP code !!!!!

good week end guys

Re: table for error ?

udayabhanupattabhiram_cha — Fri, 12 May 2006 16:21:20 GMT

Hi Vince:

T100 is where SAP has its messages.

In this table, look for Messages with SPRSL = 'E'. These are English.

While you are there, whenever you see '&' sign, that is where SAP can insert its own text when it shows you the Error Message.

Message # Text

718 - File & does not exist

Here, SAP calls this message and inserts the name of the File name in the place of '&'.

Now, the name of Flat File is what I guess is stored in Cluster Tables.

VARI is another Cluster Table. Play with this table so see how you can extract the data.

I don't know if that is exactly what SAP does.

Good luck

Ram Chamarthy

Re: table for error ?

Former Member — Sat, 13 May 2006 04:42:06 GMT

Hi,

Here:

you can find a code that shows all error messages for records failed during a load.

See there all the tables that you need.

Best regards,

Eugene

Re: table for error ?

Former Member — Sat, 13 May 2006 08:27:09 GMT

Hi,

For the messages you can use the table T100 with the message class (MSGID field) and message number (MSGNO field)..

Goto T-code SE91 look at the description of the error. MSGV1 - MSGV4 parameters in the mentioned table will give you parameters of the message.

I recall using RSMONMESS for a case where we generated the error message in the monitor, and used the table because sometimes there were 'millions' of errors...

-Shreya