Hi All

We are using Pega Marketing product V8.3.5 and we recently faced the below two phase commit issue in our sandbox environment. Whereas it did not appear in our other Non-PROD environments.

" Exception while attempting to start global transaction: code:  SQLState: Could not prepare resource 'PegaRULESRAC2_mccmdomain-sb

JDBC driver does not support XA, hence cannot be a participant in two-phase commit. To force this participation, set the GlobalTransactionsProtocol attribute to LoggingLastResource (recommended) or EmulateTwoPhaseCommit for the Data Source = PegaRULESFO Message:"

• This issue, in tracer , was on OBJ-SAVE step. (which has a Write-Now enabled and no commit)

-Non working solution-

As a workaround we did the below setting as per Pega's recommendation, but still the issue persists.

1. Change the PegaRULES data source with Global Transaction Emulation (Logging Last Resource) selected. 2. Emulate Two-Phase Commit is selected for PegaRULES Data Source.

Working Solution

Later, we removed the Write-Now option on OBJ-SAVE method and wrote a commit and it worked.

QUESTION

So the question here is, Is it recommended to have the Obj-Save without Write-Now and Commit in Pega Marketing  (which would be an activity change at baseclass which is referred in many places in the application) and not have the Two-Phase Commit settings done at the server level. Please suggest.