Support Article

Low performance for CAGETSVCCASEASSIGNMENTSBYINTERACTION

SA-33019

Summary



Long 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 Messages



Database 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 Reproduce



View Pega Alert log.


Root Cause



A defect in Pegasystems’ code or rules.

Resolution



ApplyHFix-31750 to resolve the issue.

Published January 30, 2017 - Updated February 7, 2017

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.