How can you treat a JDBC error as an error and not a success?

[Elliott2]

So simply I have a custom flow designer action using JDBC Step that inserts data into an Oracle database, when there is an error on this insert, I need the action to be treated as a failure, not a success so I can perform error handling and then access this log shown in the screenshot for that error handling.

 However, the action doesn't have any access to this log as far as I can tell, can someone assist with this?

The best I can seem to do is test total rows = 0 and give a generic error that the insert failed for a nebulous reason, but I would really like to access this log specifically.

[Bhuvan]

@Elliott2 

Uncheck don’t treat as error so that when action fails it will be treated as error and you can use it in error handling.

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[Elliott2]

That's not an option that can be unchecked, unless I'm just unaware of where it is located

[SP22]

Hello @Elliott2,

go to the "Don't treat as error" flag in the Error Evaluation and uncheck that so that the failures are treated as errors. 

Thanks
Santosh.p

[Elliott2]

Already unchecked and this only applies on the error condition I specified with total rows = 0