Question
Instellars Global Consulting
SG
Last activity: 1 Jun 2022 5:39 EDT
How to export content of external table instance data in Product/RAP file
Hi Pega Team,
I am trying to export content of external table instance data in Product/RAP file but getting below attached issue .
Wanted to confirm can we export external table data in Product/RAP file OR only we can use for internal schema's (PegaDATA and Pega RULES) table's data in Pega ?
Thanks
Coforge DPA
GB
@Giridhar_Metikal Ideally there should not be an issue. Can you share the screenshot of the error you are getting?
Regards
Bhavya
Eclatprime Digital Pvt Ltd
IN
@Bhavya thanks for your response .
This issue we have due to Listview rules and found its Pega product issue ,Please refer the below details
ISSUE : Data Instances were not included in product jar when a Developer included ListView Rule with certain Filter criteria in Product Rule to extract Data Instances. When a listview filter is added to RAP, the instances returned by listview must be packaged by Rule-Admin-Product, but this was not happening if the listview filter did not have pyRuleSet in its fields. When a pyRuleSet is not included in listview, records returned by listview filter will be treated as invalid by export process in InstanceInfo class. To avoid unexpected behavior, .pyRuleSet will now be added to fields of listview filter if it doesn't exist.
url : https://community.pega.com/node/622781
But this issue not resolve in pega 8.3.1
@PDN @PegaTeam Do we have Hotfixes for above mention issue for Pega 8.3.1
Updated: 1 Jun 2022 5:39 EDT
Pegasystems Inc.
GB
I am not sure how you came to the conclusion that the issue you are experiencing is exactly the same as the summary you found in the 7.2.2 Resolved Issues link.
The bug referenced in 7.2.2 Resolved issues you provided is BUG-253572
I looked up this bug and it should already have been fixed in 8.3.1 (as it was resolved in 7.2.2 by adding pyRuleSet to required fields of listview filter if pyRuleset doesn't exist.)
Question:
What steps are you carrying out and what are the symptoms?
What documentation are you following?
Please provide details of the analysis you carried out which made you find this older bug fix.
Did you upgrade from an earlier release, for example 7.1.8?
Can you tell me why you believe you identified the cause as being the one in the Resolved Issues description?
Did you check other forum questions such as below? :
Unable to export table metadata?
PEGA Data from PEGA DB to other DB
Fetch Data from External DB Multiple tables using Joins
I am not sure how you came to the conclusion that the issue you are experiencing is exactly the same as the summary you found in the 7.2.2 Resolved Issues link.
The bug referenced in 7.2.2 Resolved issues you provided is BUG-253572
I looked up this bug and it should already have been fixed in 8.3.1 (as it was resolved in 7.2.2 by adding pyRuleSet to required fields of listview filter if pyRuleset doesn't exist.)
Question:
What steps are you carrying out and what are the symptoms?
What documentation are you following?
Please provide details of the analysis you carried out which made you find this older bug fix.
Did you upgrade from an earlier release, for example 7.1.8?
Can you tell me why you believe you identified the cause as being the one in the Resolved Issues description?
Did you check other forum questions such as below? :
Unable to export table metadata?
PEGA Data from PEGA DB to other DB
Fetch Data from External DB Multiple tables using Joins
When to choose Pega Data table and RDB table?
Fetch data from external table using Report Definition
Difference between internal, external tables
Step to create a class for external database table
You ask: "is it possible to export external table data in a RAP"
Please find the existing documentation abut using Data Types rather than Data Tables. Data tables creation was deprecated from Pega 7.1.7+ onwards and we encourage to use Data Types as a replacement of it, which can be created from Data explorer tab.
Exporting data into a data set
If you still need help please provide clear steps, screenshots and the symptoms you are experiencing