Whenever there is deployment (Pega8 application), db requests are failing and we get an application database(DB2 database) failure alert.
When we check the problem in Dynatrace, we see the below reason for failed requests and db statements-
com.ibm.db2.jcc.am.SqlIntegrityConstraintsViolationException/ One or more values in INSERT statement,Update statement or foreign key update caused by a DELETE statement are not valid because the Primary key,unique constraints or unique index identified by **** constrains table 'PEGARULES.PR_ASSEMBLEDCLASSE
Insert into pegarules.pr_assembledclasses
Insert into pegarules.pr_sys_ruleset_index
Insert intopegarules.pr_sys_appcache_dep
Because of the above db statements the failure rate is increasing on the db.
To resolve or fix this issue, please provide a solution for this problem. Thanks