Discovery Pattern Debug "Status could not be inserted to database"

[kirkr]

I'm attempting to debug a Discovery Pattern Step and all of them give the same error:

Steps were not executed in MID: Status could not be inserted to database, check your permissions and try again!

I'm guessing this is some sort of permission issue, but I cannot find out what to check. There are no log entries on the MID Server logs or the Discovery Pattern Logs to check.

Discovery works just fine and so does connecting to Debug Mode, just not testing ANY step of ANY pattern. Does anyone know what this error means?

[kirkr · Accepted solution]

I put in a ticket with HI and they helped track down the cause.

This issue was listed in the Mid Server Agent log, though it didn't always seem to be consistent on my testing.

Worker-Interactive:PatternDebuggerProbe WARNING *** WARNING *** Can't write because table ACL denies it: sa_debug_session_status

What this ended up meaning was that the create ACL on the sa_debug_session_status table was blocking it. However it was a correct ACL and matched OOTB.

To fix this, toggle the ACL off and then on:

• Set the ACL to active = false
• Save the record
• Set the ACL active = true
• Save the record

Everything works as it should now.