Discussion
Pegasystems Inc.
IN
Last activity: 6 Apr 2018 19:26 EDT
pyCommitError.** ** ORA-00904: "INPUTS"."SERVICEID#1":invalid identifier
After upgrading to Pega 7.1 ML 8, on launching application below error encountered.
pyCommitError.** ** ORA-00904: "INPUTS"."SERVICEID#1": invalid identifier
Please help me in resolving this.
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Pegasystems Inc.
US
From Pega 7.1.7, merge/batch is introduced as default mode for saving (deferred/immediate) instances instead of INSERT and UPDATE.
In the same transaction, the instances could be grouped into multiple batches by prepared statements. The process does not necessarily maintain deterministic orders for instances. This could potentially violate execution orders wherever a mandatory order is needed (for example, foreign key constraints).
This issue is resolved through the following local change:(SR-9399)
Disable merge/batch by change the following prconfig settings. This requires to restart PRPC.
< env name="classmap/usemergestatement" value ="false" />
< env name="database/batchupdates" value="-1" />