table for error ?

[Former Member]

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 !!!

[udayabhanupattabhiram_cha · Accepted solution]

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

[Former Member]

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

[Former Member]

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

[udayabhanupattabhiram_cha]

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

[Former Member]

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

[udayabhanupattabhiram_cha]

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

[Former Member]

> 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

[Former Member]

Hi,

IN RSREQDONE --> TABLE FOR FAILURES INFORMAITION

-SHREYA

[former_member188975]

Hi Vince,

You can check table RSMONMESS and also RSERRORLOG.

Hope this helps...