Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

Support Article

Unable to Skim Ruleset Versions

SA-18536

Summary



User is not able to skim any ruleset version that has more than 100 records, as the Skim wizard stops and throws time out synchronization error.

Error details:
Status: fail
Message: Unable to synchronize on requestor within 120 seconds:
Operator ID: Unauthenticated or not available
Requestor ID: No ID available


Error Messages



Synchronization error, entire node gets into deadlock situation.

Underlying query that caused the slowness:

Database operation took more than the threshold of 500 ms: 369,356 ms    SQL: DELETE FROM RULES.pr_sys_appcache_shortcut  WHERE pzinskey IN (SELECT e.pzinskey FROM RULES.pr_sys_appcache_dep d, RULES.pr_sys_appcache_shortcut e , RULES.pr_sys_app_hierarchy_flat h, RULES.pr_sys_app_hierarchy_flat h2, RULES.pr_sys_app_ruleset_index i, RULES.pr_sys_app_ruleset_index i2 , RULES.pr_sys_class_ancestors c, RULES.pr_sys_class_ancestors c2 WHERE d.pzrulename = ? AND d.pzruletype = ? AND d.pzcacheconfigid = ? AND d.pzexplicitexcludecombined < 2 AND d.pzimplementationkey = e.pzimplementationkey AND e.pzapphash = h2.pztopapphash AND h2.pzapphash = i2.pzapphash AND i2.pzrulesetname = ? AND (i2.pzrulesetversionmajor = -1 OR (i2.pzrulesetversionmajor = ? AND (i2.pzrulesetversionminor = -1 OR i2.pzrulesetversionminor > ? OR (i2.pzrulesetversionminor = ? AND (i2.pzrulesetversionpatch = -1 OR i2.pzrulesetversionpatch >= ?))))) AND h.pztopapphash = h2.pztopapphash AND h.pzapphash = i.pzapphash AND i.pzrulesetname = d.pzrulesetname AND NOT(e.pzruletype = 'Rule-Obj-HTML' AND e.pzrulename like 'PZCSSINCLUDE%') AND NOT(d.pzruletype = 'Rule-Obj-Property' AND e.pzruletype IN ('Rule-Obj-When','Rule-Declare-CaseMatch','Rule-Obj-Model','Rule-Declare-Constraints','Rule-Declare-Trigger','Rule-Declare-Expressions','Rule-Declare-DecisionTree','Rule-Obj-XML','Rule-Access-When','Rule-Obj-Flow','Rule-Obj-Activity','Rule-Obj-MapValue','Rule-Declare-DecisionTable')) AND c.pxleafclassname = e.pzprimarypageclassname AND c.pxucclassname = d.pzappliestoclassname AND c2.pxleafclassname = e.pzprimarypageclassname AND c2.pxclassname = ? AND (c.pxheight > c2.pxheight OR (c.pxheight = c2.pxheight AND ((d.pzrulesetname = ? AND (d.pzrulesetversionmajor = -1 OR (d.pzrulesetversionmajor = ? AND (d.pzrulesetversionminor = -1 OR (d.pzrulesetversionminor < ? OR (d.pzrulesetversionminor = ? AND d.pzrulesetversionpatch = -1 OR d.pzrulesetversionpatch <= ?))))) OR (d.pzrulesetname != ? AND (h.pzappheight > h2.pzappheight OR (h.pzappheight = h2.pzappheight AND i.pzrulesetindex > i2.pzrulesetindex ))))))) UNION ALL SELECT e.pzinskey FROM RULES.pr_sys_appcache_dep d, RULES.pr_sys_appcache_shortcut e , RULES.pr_sys_app_hierarchy_flat h, RULES.pr_sys_app_hierarchy_flat h2, RULES.pr_sys_app_ruleset_index i, RULES.pr_sys_app_ruleset_index i2 , RULES.pr_sys_class_ancestors c, RULES.pr_sys_class_ancestors c2 WHERE d.pzrulename = ? AND d.pzruletype = ? AND d.pzcacheconfigid = ? AND d.pzexplicitexcludecombined >= 2 AND d.pzimplementationkey = e.pzimplementationkey AND e.pzapphash = h2.pztopapphash AND h2.pzapphash = i2.pzapphash AND i2.pzrulesetname = ? AND (i2.pzrulesetversionmajor = -1 OR (i2.pzrulesetversionmajor = ? AND (i2.pzrulesetversionminor = -1 OR i2.pzrulesetversionminor > ? OR (i2.pzrulesetversionminor = ? AND (i2.pzrulesetversionpatch = -1 OR i2.pzrulesetversionpatch >= ?))))) AND h.pztopapphash = h2.pztopapphash AND h.pzapphash = i.pzapphash AND i.pzrulesetname = d.pzrulesetname AND NOT(e.pzruletype = 'Rule-Obj-HTML' AND e.pzrulename like 'PZCSSINCLUDE%') AND NOT(d.pzruletype = 'Rule-Obj-Property' AND e.pzruletype IN ('Rule-Obj-When','Rule-Declare-CaseMatch','Rule-Obj-Model','Rule-Declare-Constraints','Rule-Declare-Trigger','Rule-Declare-Expressions','Rule-Declare-DecisionTree','Rule-Obj-XML','Rule-Access-When','Rule-Obj-Flow','Rule-Obj-Activity','Rule-Obj-MapValue','Rule-Declare-DecisionTable')) AND c.pxleafclassname = d.pzassemblytimeclass AND c.pxucclassname = d.pzappliestoclassname AND c2.pxleafclassname = d.pzassemblytimeclass AND c2.pxclassname = ? AND (c.pxheight > c2.pxheight OR (c.pxheight = c2.pxheight AND ((d.pzrulesetname = ? AND (d.pzrulesetversionmajor = -1 OR (d.pzrulesetversionmajor = ? AND (d.pzrulesetversionminor = -1 OR (d.pzrulesetversionminor < ? OR (d.pzrulesetversionminor = ? AND d.pzrulesetversionpatch = -1 OR d.pzrulesetversionpatch <= ?))))) OR (d.pzrulesetname != ? AND (h.pzappheight > h2.pzappheight OR (h.pzappheight = h2.pzappheight AND i.pzrulesetindex > i2.pzrulesetindex ))))))))


Steps to Reproduce



1. Log into System with Valid DEV User id/Pwd.
2. Select System>Tool>Refactor Rulesets> Skim Ruleset.
3. Select Minor Skim radio button.
4. Select Ruleset.
5. Select a value from Ruleset version drop down 01-01-01 to 01-01-44.
6. Click Submit button, Session gets hung, skims only 8/160 records in database.


Root Cause



A defect or configuration issue in the operating environment: Deletes from cache tables were performing very slowly as part of the skim process.

Resolution



Make the following change to the operating environment:

Complete reorg and runstats on index tables.

 

Suggest Edit

Published January 30, 2016 - Updated October 8, 2020

Did you find this content helpful? Yes No

Have a question? Get answers now.

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

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us