Question

2
Replies
441
Views
Chinna Member since 2018 9 posts
Mindtree Ltd
Posted: 1 year ago
Last activity: 1 year 1 month ago
Closed

Query Timeout - pyDefaultCaseMatch

Unable to find duplicate case because query is timing out even though optimized properties are used in must match and weighted conditions.

Query:

SELECT "PC0"."pyID" AS "pyID" , "PC0"."pyStatusWork" AS "pyStatusWork" , "PC0"."pxCreateDateTime" AS "pxCreateDateTime" , PegaDATA.pr_read_decimal_from_stream('.pxMatchScore', "PC0".pzInsKey, "PC0".pzPVStream) AS "pxMatchScore" , "PC0"."XYZ" AS "XYZ" , "PC0"."pzInsKey" AS "pzInsKey" FROM PegaDATA.pc_AS_Work "PC0" WHERE ( "PC0"."pzInsKey" <> ? AND UPPER("PC0"."XYZ") = ? AND UPPER("PC0"."pyStatusWork") <> ? ) AND "PC0"."pxObjClass" = ? ORDER BY 4 ASC

Error: There was a problem getting a list: code: 0 SQLState: HY008 Message: The query has timed out.

Any suggestions?

Low-Code App Development Data Integration Java and Activities System Administration Reporting
Moderation Team has archived post
Share this page LinkedIn