Pega 8.6: Post upgrade existing SQL query results in pyCommitError

General
, ,
1

FAIL

Step Status Info

Problem saving instance of class : code: -907 SQLState: 27000 Message: An attempt was made to modify the target table, “ABC”, of the MERGE statement by constraint or trigger “RESET_CASECOUNT_INSERT”.. SQLCODE=-907, SQLSTATE=27000, DRIVER=4.26.14

Instead of INSERT and UPDATE statements in PRPC 6, Pega 8.6 is now generating MERGE statements which displays pyCommitError in many places in the system after upgrade.

The other article suggest to edit prconfig file. But how to maintain in DSS. Means what should be the configuration of DSS.

Related article: Post upgrade existing SQL query results in pyCommitError | Pega




2

@Yasmin Tarannum
Below is the DSS setting for the prconfig you are looking for:

Owing Ruleset: Pega-Engine

Setting purpose: prconfig/classmap/usemergestatement/default

Value: false

3

@VikashK99

Hi Vikash,

Thanks for the answer. After adding the DSS setting and later restarting the server, the query is working fine.

Now I am able to get the INSERT query for new addition.

Thanks again :slight_smile:

4

@Yasmin Tarannum Shutting off merge is NOT something that you should be doing or at least not doing without serious consideration and testing. You are shutting it off for your entire environment and it will have a significant performance impact that you need to be thinking about. That article was written for 7.1.7 with regards to an issue with foreign keys and there are other options in later versions of pega to deal with issues like that. You need to consider context when looking at solutions.