Posted: 30 Nov 2020 11:49 EST Last activity: 9 Dec 2020 12:58 EST
Exception raise and error handling with SQL Stored Procedure (SQL Server)
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?