PostgreSQL Error SQLState 25P02

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

Error Message

Output

Help

Database Connection

Accepted answers

wilsonn

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

All comments

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-with-data-from-another

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

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703