When i click on document action or any workflow i got this error org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block

[Sherif Abou-Klila]

Hello,
Kindly i need your support as when i click on document action then select complete
it throws the below exception

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

On eclipse


Mar 01, 2016 3:26:11 AM org.compiere.wf.MWFActivity run
WARNING: Cause
org.postgresql.util.PSQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:645)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:495)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:380)
    at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1418)
    at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.compiere.db.StatementProxy.invoke(StatementProxy.java:128)
    at com.sun.proxy.$Proxy3.executeQuery(Unknown Source)
    at org.compiere.model.Query.createResultSet(Query.java:785)
    at org.compiere.model.Query.firstOnly(Query.java:342)
    at org.compiere.model.MRefList.get(MRefList.java:61)
    at org.compiere.model.PO.set_Value(PO.java:884)
    at org.compiere.model.PO.set_Value(PO.java:728)
    at org.compiere.model.PO.set_Value(PO.java:694)
    at org.compiere.model.X_C_Order.setDocStatus(X_C_Order.java:1070)
    at org.compiere.process.DocumentEngine.prepareIt(DocumentEngine.java:429)
    at org.compiere.process.DocumentEngine.processIt(DocumentEngine.java:297)
    at org.compiere.process.DocumentEngine.processIt(DocumentEngine.java:275)
    at org.compiere.model.MOrder.processIt(MOrder.java:1203)
    at org.compiere.wf.MWFActivity.performWork(MWFActivity.java:1009)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:874)
    at org.compiere.wf.MWFProcess.startNext(MWFProcess.java:373)
    at org.compiere.wf.MWFProcess.checkActivities(MWFProcess.java:283)
    at org.compiere.wf.MWFActivity.setWFState(MWFActivity.java:277)
    at org.compiere.wf.MWFActivity.run(MWFActivity.java:891)
    at org.compiere.wf.MWFProcess.startWork(MWFProcess.java:505)
    at org.compiere.wf.MWorkflow.start(MWorkflow.java:687)
    at org.adempiere.util.ProcessUtil.startWorkFlow(ProcessUtil.java:313)
    at org.compiere.apps.AbstractProcessCtl.startWorkflow(AbstractProcessCtl.java:391)
    at org.compiere.apps.AbstractProcessCtl.run(AbstractProcessCtl.java:209)
    at org.adempiere.webui.apps.WProcessCtl.process(WProcessCtl.java:197)
    at org.adempiere.webui.apps.AbstractProcessDialog$ProcessDialogRunnable.doRun(AbstractProcessDialog.java:1054)
    at org.adempiere.util.ContextRunnable.run(ContextRunnable.java:38)
    at org.adempiere.webui.apps.DesktopRunnable.run(DesktopRunnable.java:40)
    at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
    at java.util.concurrent.FutureTask.run(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)
    at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)

[Patric]

Hello,

we had sporadically the same error on our system.
After a reboot of the server, the error disappear.
So I restart our server every day in the night.

Regards

Patric
(Hans Auler GmbH)

[redhuan d. oon]

This looks like a bug if its a common order your are processing. Please can you explain your steps to replicate this error? Did you do any code modification?