Close popover
Joubert Alves Brito Junior (Joubritojr)
Parana Banco
Analista de Sistemas
Parana Banco
Joubritojr Member since 2020 1 post
Parana Banco
Posted: November 30, 2020
Last activity: December 9, 2020

Exception raise and error handling with SQL Stored Procedure (SQL Server)

Hi all,

We've been having difficulty on Pega being able to get the exception thrown during an execution of an stored procedure using SQL connect.

We've already ran some tests using Obj methods, RDB methods as well. The stored procedure call works fine, however the problem is whenever we have an exception during the execution (for example, a duplicate key insertion attempt) Pega is not able to catch the error so we can perform the proper exception handling.

Is there any best practices or recommended approach to handle exception when we have a transactional call of an stored procedure which is inserting data in some Customer Data tables on the DB Server?

Pega Platform 8.4.2 Data Integration Java and Activities Technology Services System Architect