database error handling

[airspan]

Hello, 

I'm using Stored Procedure schema in order to record test results to my MS SQL server database and everything works OK. My stored procedures, are using RAISERROR to send  an error message, in case of some exception occurred. The question is ...Is it possible to catch such messages in TestStand ? 

Thanks

[rleonard3]

Hi airspan,

Are you looking for something like this: https://www.ni.com/docs/en-US/bundle/teststand/page/override-sfps-runtime-error.html

This shows how to use the SequenceFilePostStepRuntimeError Engine callback to handle errors.

[airspan]

Yes, I have implemented the custom SequenceFilePostStepRuntimeError callback. It works OK if an error raised from some step in my sequence.

But unfortunately it cannot catch RAISERROR messages coming from SQL stored procedures...

[Chase.E]

Is that a custom error the database creates and throws from inside of it?

[airspan]

Yes, this a custom error which throws from SQL stored procedure. Actually, I've  discovered that LogToDatabase callback handles such messages and my next challenge is how to redirect them to my GUI...