org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Samebug tips

,
Expert tip

Try downgrading PostgresSQL server to 9.5 or update your PostgresSQL driver to 9.4-1211 with the following command: <postgresql.version>9.4.1211</postgresql.version>

Solutions on the web

via atlassian.com by Unknown author, 1 year ago
via openbravo by gotrunks
, 1 year ago
ERROR: syntax error at or near ")"      \[java\] (CASE WHEN C\_Invoice.AD\_Org\_ID IS NULL THEN '' ELSE  (TO\_CHAR(table2.Name) ) END) AS AD\_Org\_IDR,      \[java\] C\_Invoice.C\_Order\_ID,      \[java\] (CASE WHEN C\_Invoice.C\_Order\_ID IS NULL
via openbravo by nsaleh
, 1 year ago
ERROR: syntax error at or near ")" (CASE WHEN C\_Invoice.AD\_Org\_ID IS NULL THEN '' ELSE (TO\_CHAR(table2.Name) ) END) AS AD\_Org\_IDR,  C\_Invoice.C\_Order\_ID,  (CASE WHEN C\_Invoice.C\_Order\_ID IS NULL THEN '' ELSE (TO\_CHAR(table3
via openbravo by pangeacb
, 1 year ago
ERROR: IN types numeric and character varying cannot be matched      \[exec\]      \[java\] (CASE WHEN AD\_Note.AD\_Client\_ID IS NULL THEN '' ELSE  (TO\_CHAR(table1.Name) ) END) AS AD\_Client\_IDR,
via Google Groups by Enrique Rodríguez Lasterra, 3 months ago
via GitHub by marcalwestf
, 1 year ago
ERROR: column "ad_pinstance_log_id" of relation "ad_pinstance_log" does not exist Position: 48; State=42703; ErrorCode=0
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 9 months ago
Samebug visitor profile picture
Unknown user
Once, 2 days ago
Once, 1 week ago
Once, 1 week ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.