‎2006 Nov 14 11:44 AM
Hi All,
In session method if we update 1000 records, 50 records were found error. then these 50 recodrs should be collected in a seperate flat file.. is it possible with session method? ( call transation method should not be used) if so... give the solution.
Thanks in Advance.
Ranjith
‎2006 Nov 14 11:48 AM
‎2006 Nov 14 11:51 AM
Hello,
If you do not 'Keep Session', then the data for the processed records would be automatically deleted on successful processing of the session retaining only the session data with respect to the transactions with errors. you can directly .conv file from the appl server.
Hope this helps
Regards, Murugesh AS
‎2006 Nov 14 11:51 AM
hi ranjith reddy,
it is possible. while session while be executed. in that time all error frecords can be displayed in ms35 error log. using ws_download we can dowload that record and display that records in flat file...............
‎2006 Nov 14 11:52 AM
U can only rectify the errors only after viewing the logs generated by the session processing. Click onto the error session, click onto analyze session. After u will do this, correct your data and u have to create session once again and process it.
‎2006 Nov 14 11:57 AM
Hi Vibha Deshmukh ,
Thanks for u r Quick response. but is it possible to check 'sy-subrc' after BDC_INSERT fm and collect the error records in a flat file dynamically.
Ranjith
‎2006 Nov 14 11:59 AM
if u are running the session in foreground then u can make changes ..else u shld make changes after the session is processed
‎2006 Nov 14 12:03 PM
Hi santosh pabboju ,
Can you please explain in briefly how it is possible.
Ranjith
‎2006 Nov 14 11:53 AM
Hi
The system'll create a session error with only the transactions failed and you can run it again.
If you want to check which transaction u should che the log file generated by session, see the program RSBDC_ANALYSE.
But the problem can be how to match the transaction failed with the record of original file.
Max
‎2006 Nov 14 11:54 AM
‎2006 Nov 14 11:58 AM
Hi ,
u cannot create a separate file
Goto transaction sm35
check the session which is processed and click on log and then click on analyse session to view the error and then run the session again .
‎2006 Nov 14 12:02 PM
Hi Ranjith,
The session method doesnot return SY-SUBRC.So u can't do that.
U can rectify the errors after viewing the logs generated by the session processing.
regards,
nagaraj
‎2006 Nov 14 12:15 PM
Hi...
The error details can be retrived using the database tables;
APQI and APQD...
these tables stores the complete details about the log which occurred in the session method..
check these tables.. it has the QUEUE id.. logs etc..
Regards
kothai