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.
Published January 30, 2016 - Updated October 8, 2020
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.