Question
Virtusa
LK
Last activity: 22 Mar 2018 5:25 EDT
Foreign key constraint violation from the database and thus failing to commit the transaction
We did below changes to disable merge or batch processing and restart the server.
<env name="classmap/usemergestatement" value ="false" />
<env name="database/batchupdates" value="-1" />
But when analyze the tracer still "Add Batch" Queries executed and geting the error message.
The MERGE statement conflicted with the FOREIGN KEY constraint "FK02_.........". The conflict occurred in database "<<Database>>", table "<<tablename>>".
Can anyone give a solution to the issue?
Pegasystems Inc.
IN
Hi
Please, could you verify the support article if you are using the correct version of JDBC driver in your system and the database to which the instance is being saved is a supported version of one of our five standard database platforms (MSSQL, DB2 z/OS, DB2 LUW, Postgres, or Oracle).
Virtusa
LK
Hi,
Please find the details
| Database Product Name | Microsoft SQL Server |
| Database Product Version | 11.00.5343 |
| Driver Name | Microsoft JDBC Driver 4.0 for SQL Server |
| Driver Version | 4.0.2206.100 |