PostgreSQL Error SQLState 25P02

[wilsonn]

The end of my workflow consists of adding data to a database table. I was able to successfully add to one table, but now I am running into an error when I am trying other tables. Each table has its own workflow.

This is the error:

Error: Output Data (4): Error SQLPrepare: [Simba][PostgreSQL] (30) Error occurred while trying to execute a query: [SQLState 25P02] ERROR: current transaction is aborted, commands ignored until end of transaction block

[geraldo]

@wilsonn

Do you have the Use AMP engine activated?

[apathetichell]

What I see online is that this is pointing to an earlier error wihch wasn't correctly flagged/rolled back. I'd look at the syntax I was using to batch - and set my odbc driver to collect logs to see what I'm sending in and if it makes sense. 

https://stackoverflow.com/questions/53539691/getting-sql-state-25p02-while-trying-to-update-a-table-...

[wilsonn]

I am still fairly new to Alteryx.

[wilsonn]

Should it be activated or not? I tried both for the workflow and I got the same error. It is strange the error only occurred when I used the Formula Tool.

[wilsonn · Accepted solution]

The issue for this error related to the data type from the input data to the data type on the database.