I've added a "exception flow" by adding a Exception rule on the Qu

scotte over 9 years ago

I've added a "exception flow" by adding a Exception rule on the Query Database smart service. I setup a Rule that checks the "output" data field AC!jdbc_error_flag = True. So if there is a DB error the documentation says that field is set to True, then it should flow in the direction of the exception. This is not happening. Can you not put a Exception on a Query Database Smart service and if not does anyone know how to catch a exception here and take a different flow? Thanks!...

Discussion posts and replies are publicly visible

Parents

0 jorgea272 over 9 years ago

I don't think you can use an AC on your exception because by the time that node gets to the output part, the node has completed so there would be nothing to exception. The exception works when the node is active (before the output gets set). What you could do is have a rule node that is triggered on the change of a PV. So if the JDBC error flag is true, set that PV as true, then have that rule node trigger on that PV to take whatever action you're looking for. You may also need to evaluate that jdbc_error PV after the completion of the query database smart service.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 jorgea272 over 9 years ago

I don't think you can use an AC on your exception because by the time that node gets to the output part, the node has completed so there would be nothing to exception. The exception works when the node is active (before the output gets set). What you could do is have a rule node that is triggered on the change of a PV. So if the JDBC error flag is true, set that PV as true, then have that rule node trigger on that PV to take whatever action you're looking for. You may also need to evaluate that jdbc_error PV after the completion of the query database smart service.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data