‎2006 Oct 06 1:52 PM
Hi.
I want to know that on getting an error session after a session is ran how and what we do of that session and the flat file.
For example, I have 1000 records out of which say 300 records gave me an error in the session.
Then there will be an error session created in SM35.Correct me if I am wrong at any place.
Now my qustion is do we need to change the flat file with only those 300 err records in it now instead of 1000 records and run the session in sm35 again or is there any shortcut method because deleting those too records from the flat file is a bit time consuming.
Thank You
‎2006 Oct 06 1:58 PM
HI,,
Good Question.
Ya for time consuming its better to create the flat file for those 300 records.
then run the program agian to create session and process the session in SM35.
if error records less then 20 its better to run the erorr session in DISPLAY ERRORS ONLY MODE and change the error field values manually.
if answer is useful reward...
Regards,
Kishore.
‎2006 Oct 06 1:58 PM
HI,,
Good Question.
Ya for time consuming its better to create the flat file for those 300 records.
then run the program agian to create session and process the session in SM35.
if error records less then 20 its better to run the erorr session in DISPLAY ERRORS ONLY MODE and change the error field values manually.
if answer is useful reward...
Regards,
Kishore.
‎2006 Oct 06 2:00 PM
Hi subhash,
well... it's hard to work without an example...
But, as a sketch answer, if every transaction has a "key" information that avoids duplicate information when running the 1000 records, then OK. Just run the bdc session as a while, the 300 records will update the system and the other 700 will give an error because the info already exists.
BUT: if there isn't such "key" information (that is, if running the 1000 records could result in duplicities), I'm afraid the only way to solve the problem is edit the flat file and remove the 700 records.
I hope it helped. BR,
Alvaro
‎2006 Oct 06 2:02 PM
If you have a BDC and already have run it with 700 success and 300 error. Next time you run it, it will run for the error ones. I will allow you to rerun it in case a configuration error. In this case you correct the config and run it for the error ones.
You can also run it in error mode that will stop for every error founded, allowing you to correct the error. Or in dialog mode where you will be able to change/add whatever.
If the problem if your source data you'll have to create a new file completing the missing/wrong info, only for those record that have not being processed.
I hope this helps,
Aubin
‎2006 Oct 07 5:39 AM
Hi ,
gOOD QUESTION .
When you process 1000 number of records with session method first thing you are supposed to do is capturing the error records in your program itself .
The captured error records will be available to you in an internal table download the same to a local file now a flat file ready for you with errors correct it and rerun the bdc process .
You can do the same either with call transaction or session .
If you are following this method eveytime you are supposed to choose the error records from the origianl flat file removing them which would be a cumbersome process I hope.
Regards,