Error with Post SQL on Input tool

[MonBrazier]

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 🙂

[AndrewBanh]

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

[MonBrazier · Accepted solution]

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 !