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.
<env name="classmap/usemergestatement" value ="false" />
<env name="database/batchupdates" value="-1" />
@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.