Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Jeyapirashath Sakthithasan (PIRASHATH88) Virtusa
Virtusa
LK
PIRASHATH88 Member since 2012 4 posts
Virtusa
Posted: Feb 2, 2018
Last activity: Mar 22, 2018
Posted: 2 Feb 2018 2:26 EST
Last activity: 22 Mar 2018 5:25 EDT
Closed

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?

Data Integration System Administration
Posted: 5 years ago
Posted: 2 Feb 2018 14:14 EST
Anuj Kumar Srivastava (Anuj Srivastava) PEGA Client Success Architect
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). 

 

 
Posted: 5 years ago
Posted: 6 Feb 2018 2:10 EST
Jeyapirashath Sakthithasan (PIRASHATH88) Virtusa
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

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice