Learn more about the Alteryx Maveryx Universe recently announced at Inspire 2023!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Error with Post SQL on Input tool

8 - Asteroid

Has anyone had this sort of issue before? I have no idea...


Error: Input Data (1): Executing PostSQL:

"DELETE [this is my table]
WHERE [date_field] < (DateAdd(DD,-5,GETDATE()))"

: [Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The transaction log for database '[database_name]' is full due to 'ACTIVE_TRANSACTION'.


Thanks! Any assistance would be appreciated 🙂

9 - Comet

Hi @MonBrazier 


I believe you can't do a DELETE WHERE statement in Alteryx.


My suggestion would be to use a Connect In-DB tool and then a Filter In-DB to filter out those dates.


@KaneG had a step by step guide on how to do exactly that here.


Hope that helps.


- Andrew

8 - Asteroid

Thanks! I actually solved my issue.  It turns out I was out of space in the SQL Logs on SQL Server.


The DELETE statement works as expected in the post sql part of the input tool 🙂


Thanks !