org.postgresql.util.PSQLException: ERROR: column ad_user.senttoall does not exist Position: 55; State=42703; ErrorCode=0


Samebug tips

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>


7 months ago
Expert tip

Solutions on the web

Solution icon of googlegroups
via Google Groups by Brian Karemba, 9 months ago
ERROR: column ad_user.senttoall does not exist Position: 55; State=42703; ErrorCode=0

Solution icon of googlegroups
via Google Groups by Eric Kingston, 2 months ago
ERROR: column r.ismasterrole does not exist Position: 300; State=42703; ErrorCode=0

Solution icon of github
ERROR: column "warehouse" does not exist Position: 24; State=42703; ErrorCode=0

Solution icon of github
ERROR: column "ad_pinstance_log_id" of relation "ad_pinstance_log" does not exist Position: 48; State=42703; ErrorCode=0

Solution icon of googlegroups
via Google Groups by Michael Gendrala, 2 months ago
ERROR: column ol.m_warehouse_id does not exist Position: 223; State=42703; ErrorCode=0

Solution icon of sourceforge
via adempiere by fazal2009
, 1 year ago
ERROR: column "processedon" does not exist   Position: 59; State=42703; ErrorCode=0

Solution icon of github
via GitHub by naalaka
, 2 weeks ago
ERROR: column "salt" does not exist Position: 8; State=42703; ErrorCode=0

Solution icon of github
via GitHub by e-Evolution
, 1 year ago
ERROR: column "isignoremigration" does not exist Position: 258; State=42703; ErrorCode=0

Solution icon of github
via GitHub by e-Evolution
, 9 months ago
ERROR: column ol.qty does not exist Position: 785; State=42703; ErrorCode=0

Solution icon of github
ERROR: column "processed" does not exist Position: 44; State=42703; ErrorCode=0

Stack trace

org.postgresql.util.PSQLException: ERROR: column ad_user.senttoall does not 
exist

  Position: 55; State=42703; ErrorCode=0
	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2455)
	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2155)
	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:288)
	at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:430)
	at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:356)
	at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:168)
	at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:116)
	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:353)
	at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:498)
	at org.compiere.db.StatementProxy.invoke(StatementProxy.java:128)
	at com.sun.proxy.$Proxy4.executeQuery(Unknown Source)
	at org.compiere.model.Query.createResultSet(Query.java:785)
	at org.compiere.model.Query.aggregate(Query.java:494)
	at org.compiere.model.Query.aggregate(Query.java:450)
	at org.compiere.model.Query.count(Query.java:555)
	at org.adempiere.process.Export2Queue.doIt(Export2Queue.java:307)
	at org.compiere.process.SvrProcess.process(SvrProcess.java:198)
	at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:144)
	at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:172)
	at org.compiere.apps.AbstractProcessCtl.startProcess(AbstractProcessCtl.java:466)
	at org.compiere.apps.AbstractProcessCtl.run(AbstractProcessCtl.java:234)

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Once, 4 months ago
11 times, 1 week ago
2 times, 4 months ago
4 times, 10 months ago
98 more bugmates