BODS: How to show status as error in SAP Data Service Management Console after exception is handled

[former_member593418]

Below shows the script written in Catch Block(CAPTCH_EXCEPTION), that used to captured and handled exception, by sending out mail notification to support team.

Below image showed that batch job in row 1, with status = Success, in case, exception has been handled.

How can status of batch job execution show as "Error" (rather than "Success") in SAP Data Service Management Console, after exception is handled in catch block inside batch job?

It should show status "Error" (rather than "Succcess"), even after exception is handled, so that Admin that monitor on this web page, can easily know which batch job are failed.

[former_member593418]

Additional statement as below, is added to script "HANDLE_EXCEPTION" inside block "CAPTCH_EXCEPTION", to rethrow original exception.

#Rethrow exception
raise_exception(error_message());

[former_member187605 · Accepted solution]

Call raise_exception or raise_exception_ext built-in function as last statement in the catch script.