Support Article
Pega Knowledge tag search performance degrades
SA-98929
Summary
Pega Knowledge tag search performance degrades.
Error Messages
PEGA0005 alerts on query: SELECT "PXLINKEDREFFROM" AS "pxLinkedRefFrom" , "PXLINKEDREFTO" AS "pxLinkedRefTo" , "PZINSKEY" AS "pzInsKey" from CPE_BPRMS.pr_link_work_tag WHERE ( "PXLINKEDREFFROM" = ? ) AND ( "PXOBJCLASS" = ? ) *
Steps to Reproduce
Utilize Pega Knowledge tag search.
Root Cause
Logic in Knowledge Management executed the query to filter tags even when a result set was already filtered. This created additional extraneous tag search queries.
Resolution
Apply HFix-59683.
Published February 11, 2020 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.