Question
Unable to save declare index in report definition ,it throws error like Save failed-PRRuntimeException
While I have configured Declare index under access tab in Report definition. the properties in declare index rules are not able to add in query tab of RD. Someone please help with this
Declare index rule is created to Refer Single Page property in RD. Thanks in advance.
***Edited by Moderator Rupashree S. to add Capability tags***
Hi @RajeshNalla
When you want to use the index join properties in edit column or edit filter options you need to use the declare join prefix followed by the index table attributes(properties) and do save action only after adding the edit column or edit filter condition else the declare index join will not be reflected in the data access Tab.
Thanks
Prasad
Thank you for the reply I did the same. It works fine for Declare index that I've configured to expose pagelist properties. However, the Declare Index rule which I've configured for Single Page is throwing error Product.Name is the Single Page Property I'm trying to refer Attached the SS for your reference
Hi @RajeshNalla,
You can select the "Alternate Database" option in the Report Definition, but this column was not created/exposed correctly in the Reporting DB. It would have been better if the error messaging in Pega was more informative.
Hi @Koti Raja, Thanks for your reply!! Could you please tell me where I can find the option to select "Alternate Database"?
Hi @RajeshNalla
In Report defintion, Under the Data Access Tab, In General Data Access settings> Data Retrieval Preference Select the check box Use the database default.
Hello @Koti Raja,
The check box is already checked!! :(
Hello @RajeshNalla
If you remove the Product Declare Index, Is it still showing the error?