ABHATTCHRYA Member since 2010 11 posts
Cognizant Technolgy Solutions
Posted: 2 years ago
Last activity: 2 years 3 months ago

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

3. Java Version - 1.8.0_112


Arka Bhattacharya

Low-Code App Development Data Integration Java and Activities Data Integration
Moderation Team has archived post
Share this page LinkedIn