Support Article
Two phase commit error when commit seed list data into DB table
SA-40180
Summary
User opened created seed list to add data. When user finished adding data and clicked on outside the row, during DB save/commit, an error (“Create new record failed. pxCreateRecord API failed) is thrown
Error Messages
FAIL
Step Status Info
Exception while attempting to start global transaction: code: SQLState: Could not prepare resource 'PegaRULES_prpc
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 = PegaRULES Message:
Steps to Reproduce
- Open created seed list to add data.
- Click on '+' button to add record.
- Save data.
Root Cause
A defect or configuration issue in the operating environment.
The XA driver is needed (and supported) in the weblogic server if the application requires two-phase commit for transactions involving other systems.
Resolution
Make the following change to the operating environment:
Change the PegaRULES data source with Global Transaction Emulation (Logging Last Resource) selected.
Tags:
Published August 26, 2017 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.