Trying to identify which records in the %SYS.Audit table are fails.

Eg, as user "WORKER", I run an attempted a grant, the terminal returns:

SQL> GRANT SELECT ON newschema.patients TO COORDINATOR
[S1000][Iris ODBC][State : S1000][Native Code 112]
[libirisodbc35.so]
[SQLCODE: <-112>:<Access violation>]
[Location: <ServerLoop>]
[%msg: <User WORKER does not have required privileges to grant the privilege(s)>]
[ISQL]ERROR: Could not SQLExecute
 

but the record in the audit table gives

0 2
0 93
Question
Andrew Neilson · Sep 12
Routing ACKS.

I'm trying to get an ACK routed to a different process in our Test environment and here is the router setup:

I have a rule in the target router to send to an operation.

 

 

The problem I'm running into is that the HL7 ACK coming back is marked as "Discarded", so it's not even getting to the second router.

0 4
0 107