Transaction Rollback not working

[rajesh_khater]

Hi,

In the AP Invoice Before Add event (Event = FormDataEvent, Event Type = Add or Update, Before Action = True), I am starting a transaction.

Then in After Add event, I am deliberately creating a null pointer exception (to test rollback), and in the exception handler, I am rolling back the transaction.

1. void SBO_Application_FormDataEvent(ref SAPbouiCOM.BusinessObjectInfo BusinessObjectInfo, out bool BubbleEvent) 
2. { 
3.     BubbleEvent = true; 
4.     if (BusinessObjectInfo.FormTypeEx == "141" 
5.         && (BusinessObjectInfo.EventType == SAPbouiCOM.BoEventTypes.et_FORM_DATA_ADD || BusinessObjectInfo.EventType == SAPbouiCOM.BoEventTypes.et_FORM_DATA_UPDATE) 
6.         && BusinessObjectInfo.BeforeAction == true) 
7.     { 
8.         oCompany.StartTransaction(); 
9.     } 
10.     if (BusinessObjectInfo.FormTypeEx == "141" 
11.         && (BusinessObjectInfo.EventType == SAPbouiCOM.BoEventTypes.et_FORM_DATA_ADD || BusinessObjectInfo.EventType == SAPbouiCOM.BoEventTypes.et_FORM_DATA_UPDATE) 
12.         && BusinessObjectInfo.BeforeAction == false) 
13.     { 
14.         if (BusinessObjectInfo.ActionSuccess) 
15.         { 
16.             try 
17.             { 
18.                 string nullStr = null; 
19.                 nullStr.Contains("ABCD"); 
20.                 oCompany.EndTransaction(SAPbobsCOM.BoWfTransOpt.wf_Commit); 
21.             } 
22.             catch (Exception ex) 
23.             { 
24.                 oCompany.EndTransaction(SAPbobsCOM.BoWfTransOpt.wf_RollBack); 
25.                 MessageBox.Show(ex.Message); 
26.             } 
27.         } 
28.     } 
29. } 

Still the AP Invoice gets saved in the database. What may be the issue?

Thanks.

I am trying this on 9.1 PL 00.

Can other experts try this code and let me know if they get similar results?

A lot of threads in this forum mention that starting a global transaction in the Before Action, and rolling back in the After Action is treated as a single transaction and should therefore work.

But some thread also suggests that it will not work.

This is urgent.

[maik_delly]

Hi Rajesh,

transaction is for DI API only - meaning only transactions made by DI API can be rolled back. You are trying to roll back something you are not doing, but SBO client.

If you want to stop adding of a document in client you could use transaction notification.

regards,

Maik