Solved

Roll back transaction in Integration

  • 8 August 2022
  • 1 reply
  • 118 views
H
Rank
Userlevel 5
Badge +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

 

icon

Best answer by thilinaweliwita 10 August 2022, 15:48

View original

1 reply

T
Rank
Userlevel 3
Badge +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


Terms & ConditionsCookie settings