INSERT query works in draft/debug but not in published agent

Support
1

Hi everyone. I’m running into some unexpected behavior with the Query App Database block and wanted to check if I might be missing something.

I’m using a very simple INSERT query:

INSERT INTO MyTable (txt_date, txt_source)
VALUES ({{currentDate}}, 'Manual Run')

This works as expected when I run the agent in draft mode or through the debugger. However, when I run the published agent, no row gets inserted into the table.

What’s confusing is that the debug logs still show: “1 row(s) affected)”.

Has anyone seen something similar or know what might be causing this? Not sure if I’m overlooking something simple or if this could be a bug.

Thanks in advance!