Catching Database errors in Adapter Services

, ,
1

Hi,

Is there anyway to capture the database related errors when we are trying to update the tables thru Adapter Service. e.g. Unique Constraint etc.
If for any reason the SQL does not execute successfully the error I get is “Adapter Service could not execute”.

Can somebody guide me how to get the exact dB error?

Thanks,
Pankaj

2

If it is an IS service, I am pretty confident that if you put a try catch block it should just work fine.

Try block of course will have you database query service. In you catch block put following services:

getLast6Error: pub:flow:getLastError
debugLog:pub:flow:debuglog

These services should catch any error throw during the service…

3

Ravi,

I am aware of this step and have already tried but it does not return the database errors.

Any other thought. :frowning:

Thanks,
Pankaj