Question
Exceptions for RDB methods is not getting handled from within PRPC
As a part of our requirement we are dynamically setting the select variables and table names to execute a select query using RDB-List . PRPC is unable to handle Errors or Exceptions if any invalid table names or Columns Names passed as parameter, though exception handling steps are mentioned in the activity.
It is observed from the tracer that the activity is getting terminated as soon as there is an error detected without performing exception steps.
It is not getting handled even when tried to catch the exception using listRDB method engine API method in a java step.
Please find attached the document with screen prints of the exception and the steps followed to fix these.
Please share how these can be addressed with proper exception handling.
Other relevant details -
1. PRPC version - 7.1.9
2. DB vendor - Oracle Database 12c Enterprise Edition Release 12.1.0.2.0
3. Java Version - 1.8.0_112
Thanks,
Arka Bhattacharya
This method updates the pxMethodStatus property. See How to test method results using a transition.
When a {SQLPage:pagename} directive appears as the first line of the SQL code on the Browse tab, a top-level page named pagename is created. If errors occur, properties on that page contain additional error details.
Can you please paste the contents of connect SQL ?
https://community.pega.com/sites/default/files/help_v74/procomhelpmain.htm#methods/rdb-list/rdb-list.htm