Hi @Brian_Foody ,
We'll need more information. Can you show us the config of the tools, or can you provide the workflow? (no data required)
M.
Thanks M. Attaching an anonymized version of the In_DB input config & the out from the 'dynamic Output In-DB' tool I used to analyze the issue.
I am using a multifield IN statement to filter on a large number of IDs in the SQL query. What I have noticed is when I reduce the number of Org IDs in the query, the error disappears. I'm wondering if there is some limitation on the number of arguments that the In-DB connection can handle...curiously when I try the same query in the regular Input Data tool it works just fine...
Is the With command in your SQL query? You can't use CTE (With) in In-DB - but yes, they do work just fine in regular Input Data...