SA-35023

Summary

Exporting a Rule-Admin-Product for an application. When the export is run a query of a history table with 1 million rows is being executed causing the export to hang. Need to understand why this query is getting executed and how to exclude it.

Error Messages

Not Applicable

Steps to Reproduce

1. Create an Rule-Admin-Product of an application.
2. Observe that it is querying work history table.

Root Cause

A defect or configuration issue in the operating environment

Resolution

Here’s the explanation for the reported behavior:

https://pdn.pega.com/sites/pdn.pega.com/files/help_v722/procomhelpmain.htm#rule-/rule-admin-/rule-admin-product/contents.htm

From the help: Include data types Optional: Select if you want to include the instances of the custom data types (classes) that are associated with this application. The data types are exported whether they are associated with a ruleset in the application or not.

In the Rule-Admin-Product rule that is being extracted under "Applications to Include" is yourApplication with the "Include data types" box checked. By checking this box you have opted to include instances of the Data classes that are listed on yourApplication rule's "Classes and Data" tab. On the Application rule yourApplication is the history class which is why the query is running and trying to include those instances.

To not include instances of this history class in your RAP file you need to either update the application rule to not include this history class or uncheck the Include Data Types checkbox in the product rule.