Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
5 replies
Subscribers
5 subscribers
Views
2901 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Integrations
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!...
OriginalPostID-130336
OriginalPostID-130336
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