Discussion1Replies741Views KavithaJ9007 Member since 2015 3 posts BB&T Posted: 4 years agoLast activity: 4 years 7 months ago Closed Database Transaction handlingHi,I am trying to insert data into 3 different DB tables in a single transaction using obj-save. If the transaction fails I would like to rollback the entire transaction. Can someone explain how this can be done?ThanksKavitha Data Integration ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion. Posted: 4 years agoUpdated: 4 years agopedel PEGA replied to KavithaJ9007In the transition of each Obj-Save step check for "StepStatusFail" and Exception. Also do this for your "Commit" step >> assuming << you are not calling this Activity within a flow. If in a flow, do NOT use Commit. If an error is detected, jump to a step that does: Rollback. You can also set a Page-Message which will prevent the page from being persisted. Pega maintains a "Deferred List" so does not auto-commit each Obj-Save. If however you are using Connect SQL to write to these 3 (external?) tables, that is an entirely different situation. If so, investigate the use of CMT (Container Managed Transactions). Note: there is a "Distributed Transactions" chapter within the 7.1 Lead System Architect Pega Academy course.