Question
Connect SQL rule exists and is available. But at runtime RulenotFoundException in RDB-List method call
Hi All,
it's in the job scheduler rule.
I have an existing Connect-SQL rule and it's available as well. I called this Connect-Sql rule from activity using RDB-List method. The code is checked in successfully and in lower environments it's executing successfully.
But when it comes to PROD it's giving the following exception
ERROR - Error in RDB-List com.pega.pegarules.pub.database.BadInputException: could not find RDB rule. Please find the attached screenshot of the exception.
Interestingly, almost same another Connect-Sql in another activity was executed successfully.
When i executed in private edit or branched ruleset in PRD envi it's picking up the connect-sql rule.
Kindly suggest how to fix this weird issue in pega.
Hi @RajaKullaiahD16662217: There is no concreate reason for this. It may happen because of many reasons. Please help to perform the below debugging.
- Is the activity getting called from background process agent? If so please check access group pointed to advanced agent / JS. It should have access to the version. Same in case if this issue is happening for a specific user group.
- Please check if the class instance is deployed to the target env
- Please check the context of execution (using tracer) to make sure rule is getting executed in right context
- Use revalidate and save to revalidate the rule (activity and Connect SQL) and check if any errors
Worst case if this is because of cache, you may need to restart node.
Thanks.