I have a question regarding "Execute Stored Procedure" plug-in. There

samuelr over 11 years ago

I have a question regarding "Execute Stored Procedure" plug-in. There is no output that the plug-in provides for capturing return/error code and error message. I was wondring if anyone had suggestions about the best way to capture this information for the purpose of error handling in Appian....

Discussion posts and replies are publicly visible

0 Tim
Certified Lead Developer
over 11 years ago

If the node fails to execute you will get the standard smart service exceptions. For any errors that occur within the stored procedure you should handle them with exceptions and pass the exception code and message as an out parameter from the stores proc.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jorgea272 over 11 years ago

You should increase your smart service logging to debug (appian_log4j.properties). That should provide you more information on where it is breaking or not functioning as expected.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 anagha_abhyankar over 10 years ago

Hi Samuel, did you find the solution here? I am facing similar issues and would like to implement exception handling in case if the DB is down. There are no pause on error parameters in the Execute Stored proc node like Query DB smart service.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel