Question

2
Replies
452
Views
Chinna Kumar (Chinna)
Mindtree Ltd

Mindtree Ltd
IN
Chinna Member since 2018 10 posts
Mindtree Ltd
Posted: July 15, 2019
Last activity: July 31, 2019
Posted: 15 Jul 2019 2:37 EDT
Last activity: 31 Jul 2019 17:17 EDT
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.