Question Re: Catch Action not capturing Exception error from SQL Query, when SQL query is unble to create DB connection in Product Lifecycle Management Q&A

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

indiraboga3 — Thu, 19 Nov 2015 14:54:18 GMT

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

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

former_member185280 — Thu, 19 Nov 2015 17:42:18 GMT

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

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

saumya_govil — Fri, 20 Nov 2015 11:29:04 GMT

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