topic Re: how to debug transaction posting to database? in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/how-to-debug-transaction-posting-to-database/m-p/11340494#M1920550 <HTML><HEAD></HEAD><BODY><P>You might try to activate SQL trace with ST05 and check where DB access is done.</P><P>Peter</P></BODY></HTML> Mon, 02 Nov 2015 12:53:33 GMT Peter_Inotai 2015-11-02T12:53:33Z how to debug transaction posting to database? https://community.sap.com/t5/application-development-and-automation-discussions/how-to-debug-transaction-posting-to-database/m-p/11340489#M1920545 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>&nbsp;&nbsp; I have a requirement to find where in a transaction the data is actually reflected into the database, ideally i need to find the insert/update statements that update the db table after all the processing is done, i have tried to breakpoint at statement insert dbtab or update dbtab and got nothing, i also tried the debugger scripts that should stop at change of db table and got nothing as well, is there any way i can find the part of code that actually does the updating in the database?</P></BODY></HTML> Mon, 02 Nov 2015 12:10:25 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-debug-transaction-posting-to-database/m-p/11340489#M1920545 Abdelrahman-Elshafei 2015-11-02T12:10:25Z Re: how to debug transaction posting to database? https://community.sap.com/t5/application-development-and-automation-discussions/how-to-debug-transaction-posting-to-database/m-p/11340490#M1920546 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt;">Did you activate the debug in update task (*)</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Regards,</SPAN></P><P><SPAN style="font-size: 10pt;">Raymond</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">(*) <SPAN style="font-family: 'Times New Roman','serif';"><A href="http://help.sap.com/saphelp_nw73ehp1/helpdata/en/49/1aa66f87041903e10000000a42189c/content.htm?current_toc=/en/64/d255cb986147f3a7bad0a000d88174/plain.htm&amp;show_children=true"><SPAN lang="EN-US" style="color: blue;">ABAP Test and Analysis Tools</SPAN></A></SPAN><SPAN style="font-family: 'Times New Roman','serif';"> : </SPAN><SPAN style="font-family: 'Times New Roman','serif';"><A href="http://help.sap.com/saphelp_nw73ehp1/helpdata/en/49/2170194ab514cde10000000a42189b/content.htm?frameset=/en/7b/8f8115c62847f493e69bef6e78ba81/frameset.htm&amp;current_toc=/en/64/d255cb986147f3a7bad0a000d88174/plain.htm&amp;node_id=266&amp;show_children=false"><SPAN lang="EN-US" style="color: blue;">Debugger</SPAN></A></SPAN><SPAN lang="EN-US" style="font-family: 'Times New Roman','serif';">, </SPAN><SPAN style="font-family: 'Times New Roman','serif';"><A href="http://help.sap.com/saphelp_nw73ehp1/helpdata/en/49/250c884d7216b5e10000000a42189d/content.htm?frameset=/en/7b/8f8115c62847f493e69bef6e78ba81/frameset.htm&amp;current_toc=/en/64/d255cb986147f3a7bad0a000d88174/plain.htm&amp;node_id=267&amp;show_children=false"><SPAN lang="EN-US" style="color: blue;">New ABAP Debugger</SPAN></A></SPAN><SPAN lang="EN-US" style="font-family: 'Times New Roman','serif';">, </SPAN><SPAN style="font-family: 'Times New Roman','serif';"><A href="http://help.sap.com/saphelp_nw73ehp1/helpdata/en/7b/8f8115c62847f493e69bef6e78ba81/content.htm?frameset=/en/7b/8f8115c62847f493e69bef6e78ba81/frameset.htm&amp;current_toc=/en/64/d255cb986147f3a7bad0a000d88174/plain.htm&amp;node_id=274"><SPAN lang="EN-US" style="color: blue;">Settings</SPAN></A></SPAN></SPAN><SPAN style="font-size: 10pt; font-family: 'Times New Roman','serif';">.</SPAN></P></BODY></HTML> Mon, 02 Nov 2015 12:28:21 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-debug-transaction-posting-to-database/m-p/11340490#M1920546 RaymondGiuseppi 2015-11-02T12:28:21Z Re: how to debug transaction posting to database? https://community.sap.com/t5/application-development-and-automation-discussions/how-to-debug-transaction-posting-to-database/m-p/11340491#M1920547 <HTML><HEAD></HEAD><BODY><P>yes tried it and it shows me code that occurs after commiting and during the update task itself not the actual sql statements that caused the update</P></BODY></HTML> Mon, 02 Nov 2015 12:37:23 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-debug-transaction-posting-to-database/m-p/11340491#M1920547 Abdelrahman-Elshafei 2015-11-02T12:37:23Z Re: how to debug transaction posting to database? https://community.sap.com/t5/application-development-and-automation-discussions/how-to-debug-transaction-posting-to-database/m-p/11340492#M1920548 <HTML><HEAD></HEAD><BODY><P>Hi AAS,</P><P>&nbsp;&nbsp;&nbsp; Let us know for which transaction you need the analysis, so that people can analyse and suggest some ideas.</P><P></P><P>Regards,</P><P>Surendra Gupta. </P></BODY></HTML> Mon, 02 Nov 2015 12:44:42 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-debug-transaction-posting-to-database/m-p/11340492#M1920548 Former Member 2015-11-02T12:44:42Z Re: how to debug transaction posting to database? https://community.sap.com/t5/application-development-and-automation-discussions/how-to-debug-transaction-posting-to-database/m-p/11340493#M1920549 <HTML><HEAD></HEAD><BODY><P>NL10N in the IS-H industry</P></BODY></HTML> Mon, 02 Nov 2015 12:50:40 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-debug-transaction-posting-to-database/m-p/11340493#M1920549 Abdelrahman-Elshafei 2015-11-02T12:50:40Z Re: how to debug transaction posting to database? https://community.sap.com/t5/application-development-and-automation-discussions/how-to-debug-transaction-posting-to-database/m-p/11340494#M1920550 <HTML><HEAD></HEAD><BODY><P>You might try to activate SQL trace with ST05 and check where DB access is done.</P><P>Peter</P></BODY></HTML> Mon, 02 Nov 2015 12:53:33 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-debug-transaction-posting-to-database/m-p/11340494#M1920550 Peter_Inotai 2015-11-02T12:53:33Z Re: how to debug transaction posting to database? https://community.sap.com/t5/application-development-and-automation-discussions/how-to-debug-transaction-posting-to-database/m-p/11340495#M1920551 <HTML><HEAD></HEAD><BODY><PRE><CODE> <P>during the update task itself not the actual sql statements</P> </CODE></PRE><P>very strange, usually database update are processed during execution of some update task FM, are you sure, if yes provide more information.</P></BODY></HTML> Mon, 02 Nov 2015 13:01:54 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-debug-transaction-posting-to-database/m-p/11340495#M1920551 RaymondGiuseppi 2015-11-02T13:01:54Z Re: how to debug transaction posting to database? https://community.sap.com/t5/application-development-and-automation-discussions/how-to-debug-transaction-posting-to-database/m-p/11340496#M1920552 <HTML><HEAD></HEAD><BODY><P>Thank you guys i was able to find the function by causing the update work process to crash by terminating the debugger during the update process and then checking tcode SM14 which contains info about the crashed update processes including the update function module that was executing</P></BODY></HTML> Mon, 02 Nov 2015 13:45:52 GMT https://community.sap.com/t5/application-development-and-automation-discussions/how-to-debug-transaction-posting-to-database/m-p/11340496#M1920552 Abdelrahman-Elshafei 2015-11-02T13:45:52Z