Dynamic SQL: Write Query to log when it fails

[Alt_dp]

I have a workflow that process many campaign information. Sometimes because of data entry issues the workflow fails at dynamic input tool. Is there any way we can write the entire SQL into a log file when it fails? The results workflow shows the error message but doesn't give the exact input data that caused the issue

[jrgo · Accepted solution]

@Alt_dp,

Not a way to output the SQL query that failed that I know of. Without more information about your workflow and the Dynamic Input tools configuration, it’s challenging to suggest possible workaround. 

If you’re using ODBC, there is an option to log the queries in the ODBC Config Manager (not in Alteryx), but this is manually turned on and off.

[Alt_dp]

Thank you jrgo. 

Looks like if i'm using in database tools,  'Dynamic Output In-DB' can write the Query