Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Error with Post SQL on Input tool

MonBrazier
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 🙂

2 REPLIES 2
AndrewBanh
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

MonBrazier
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 !

Labels