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

Query of history table causing export of RAP to fail

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.

Suggest Edit

Published March 26, 2017 - 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