Low performance for CAGETSVCCASEASSIGNMENTSBYINTERACTION
SummaryLong database interaction alerts are noted for the activity PEGACA-WORK CAGETSVCCASEASSIGNMENTSBYINTERACTION Step: 8 Circum: 0.
Numerous alerts are seen in the Pega Alerts log.
Error MessagesDatabase operation took more than the threshold of 300 ms: 2,707 ms SQL: SELECT pzPVStream AS "pzPVStream" from PEGADATA.WorkTable WHERE ( CAPARENTID = ? ) AND ( pxObjClass LIKE ? )
Steps to ReproduceView Pega Alert log.
Root CauseA defect in Pegasystems’ code or rules.
ResolutionApplyHFix-31750 to resolve the issue.
Published January 30, 2017 - Updated February 7, 2017