Question
Cognizant Technology Solutions India PVT Ltd
IN
Last activity: 4 Apr 2024 12:28 EDT
Getting PEGARULES.PR_ASSEMBLEDCLASSES Database failure alert.
Whenever there is deployment or save rules(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 iden the db.
To resolve or fix this issue, please provide a solution for this problem. Thanks