Session Logs

[Former Member]

Hi,

I m loading thousands of info records via BDC session thru LSMW.

I got large no of transactions failed so is there any way in Logs that i can view exactly the failed records, so that i can rectify the error.

I guess may be it has something to with Index no but not sure how.

Thanks & Regards,

Ankur

[RichHeilman]

The only way to view the logs is via SM35. The index number can correspond to the record number of your file. You can re-run the job, it will only do the records that ended in error. You can make the appropriate changes on the fly.

Regards,

Rich Heilman

[Former Member]

Thanks,

So thru logs can i goto exact recorset to rectify it ?

Thanks & Regards,

Ankur

[Former Member]

You need to rerun the SM35 session in online mode or 'errors only' mode to stop at the error field and correct it.

But, since you mentioned that there are a lot of errors, correcting it this way may be very tedious. Instead I suggest you find out what caused majority of the errors. If it is something like vendor not found or material not found then you can create them and rerun the session in background mode to process the errored ones. But if the failure is in your input data itself, then you may need to get a subset of the file with only the error records.

Which object/method are you using in LSMW to create inforecords?

Srinivas

[RichHeilman]

In SM35, select the job, and say process. This time, it will only do the records that had an error. Make sure that you run it in the foreground. This will allow you to fix the problem at run-time.

Regards,

Rich Heilman

[Former Member]

Hi,

I m using RM06IBI0 for posting.

1 more thing that error are braodly under following categories :

1. material not found

2. vendor 0020000143 is blocked for purchase organisation 3201 .

3. make an entry in all fields

and 1 more peculiar error that

"4. info record already exists" .

and strange thing is this is first time loading so i m wondering how is it giving such error.

But I would like to concentrate more on

"make an entry in all fields" and

"info record already exists" .

For that i need exact record as there are numerous record with other errors .

Any ideas ?

Thanks & Reagrds,

Ankur

[RichHeilman]

Depending on the error, you can act according when re-running the session. If it needs more data, then you can enter it, if it already exists, then you can just F3 and it will continue to the next record. At this point, its really too late to clean up your upload file. You can, but I think that it would be more work.

Regards,

Rich Heilman

[Former Member]

Let us take each error.

1. Material not found.

Are you sure that the material you entered should exist?

Is the material extended to the corresponding purchasing view?

Once you correct this, you can rerun the session in SM35 and all these errors should be cleared out. If your material is wrong, then you have no option but to correct it online while processing the session.

2. Vendor blocked...

This should be easy. Unblock the vendor and rerun the session. All such errors will be cleared.

3. Make an entry in all fields.

This will be tough. Check your input to see if you are providing all the required information.

4. Info record already exists.

Are you using external numbering for inforecords? If so, check if you are repeating the numbers.

Another reason could be that the system doesn't allow you to create an inforecord for the same vendor, same material in the same purchasing area. Check your input to see if this is happening.

Srinivas

[Former Member]

Ankur,

"Info record exists" can happen if you have duplicate record in your input file ( Material, Vendor, Purchase Org. ).

On the other hand you can download session log from SM35 into an "XLS" format, so that you can easily manipulate and report on errors (statistics on each type of errors).

Cheers,

Sanjeev

PS : As per our protocol you can not reward me points, because we belong to the same company.

[Former Member]

Hi Sanjeev,

i alredy have that excel sheet which contains errors but the issue again is that i need to be more concerned about the errors of "make an entry in the field" &

"info records already exists" which are very below in the error list.

so i need to process those particular records, but if i run session in error mode than it would take long time.

Is index no is of any use in this case.

Thanks & Regards,

Ankur

[Former Member]

Hi Ankur,

How many such errors ("make an entry in the field") do you have ? if it is in the range of 20-30 you can note down the data e.g. material, vendor etc (from session details in SM35) and extract data for those records again or from LSMW you can cut the file to include only those records and run the load again.

Cheers,

Sanjeev

[Former Member]

If u r getting an index of the log, u can see it in transaction SLG1.