Catch Action not capturing Exception error from SQL Query, when SQL query is unble to create DB connection

[indiraboga3]

Hi All,

When the SQL Query action is unable to create a connection to database and throwing error, the catch action block is not capturing the error and keeps the transaction running. It logged an error “Cannot create a connection to the database”, but it did NOT throw an action error. We are on 14.0 SP05.

Please if share you suggestion.

this has been already disscussed in the below link

[saumya_govil]

Hello Indira,

I had a requirement in a project to check if the connection to the database is up and then perform the DB operations. I used a work around to make a call like 'select count(*) from dual' to check the connection and if it returned an error and/or exception I terminated the transaction writing the error to the logs etc. I am on a different MII version, but suppose the same technique might work for you as well.

Regards,

Saumya

[former_member185280]

I see the same behavior in a 14.0 sp4 patch5 system. It may be a bug so if you can't find any related SAP notes you should submit a ticket with SAP.

Regards,
Christian