Skip to main content
Solved

Roll back transaction in Integration

  • August 8, 2022
  • 1 reply
  • 152 views

Forum|alt.badge.img+13

Hi Experts,

There is a requirement from customer that they need to rollback the entire transaction if any issue occurs during the transaction.

 

Example - Inbound integration

Create task/place/request

Issue occurred during place creation. 

Roll back task, request also with the place entity rollback process

 

They need to rollback whole parent/child creation/update if any issue is occurred during the inbound integration phase.

Any idea about this?

 

Thanks and regards,

Hasara

 

Best answer by thilinaweliwita

Hi @Hasara Dinu ,

When there is an error occurred in inbound integration, the parent and child records gets rolled back. 
When there is any error occurs in tasks, it should roll back the request record (assuming request is getting created with the same integration).
However, it will not rollback records in the associated tables. As an example, since place has an associative relationship, it would not rollback the 
place record even if an error occurs in task/request. The modification occurs on the place table will be executed on a different transaction. 

View original

Forum|alt.badge.img+6

Hi @Hasara Dinu ,

When there is an error occurred in inbound integration, the parent and child records gets rolled back. 
When there is any error occurs in tasks, it should roll back the request record (assuming request is getting created with the same integration).
However, it will not rollback records in the associated tables. As an example, since place has an associative relationship, it would not rollback the 
place record even if an error occurs in task/request. The modification occurs on the place table will be executed on a different transaction. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings