org.postgresql.util.PSQLException: ERROR: column c.costingmethod does not exist; State=42703; ErrorCode=0

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

  1. ,
    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>

  2. ,
    via stackoverflow.com by Unknown author

    Upgrade the database driver to the latest and check.

    <dependency>
    <groupId>org.postgresql</groupId>
    <artifactId>postgresql</artifactId>
    <version>9.3-1101-jdbc41</version>
</dependency>

    Replace version with the latest driver version.

Solutions on the web

via Google Groups by HellBoy, 1 year ago
ERROR: column c.costingmethod does not exist; State=42703; ErrorCode=0
via adempiere by gabrielke
, 2 years ago
ERROR: column rt.ad\_window\_id does not exist; State=42703; ErrorCode=0
via adempiere by ivanceras
, 2 years ago
ERROR: column rt.ad\_window\_id does not exist; State=42703; ErrorCode=0
via adempiere by bma99
, 2 years ago
ERROR: syntax error at or near ""limit""   Position: 501; State=42601; ErrorCode=0
via adempiere by frerod
, 2 years ago
ERROR: transacci¾n abortada, las ¾rdenes serßn ignoradas hasta el fin de bloque de transacci¾n; State=25P02; ErrorCode=0
via adempiere by edwinhaq
, 2 years ago
ERROR: no existe la función get\_sysconfig(unknown, unknown, numeric, integer)   Hint: Ninguna función coincide en el nombre y tipos de argumentos. Puede desear agregar conversión explícita de tipos.   Position: 138; State=42883; ErrorCode=0 
org.postgresql.util.PSQLException: ERROR: column c.costingmethod
does not exist; State=42703; ErrorCode=0	at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1548)	at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1316)	at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:191)	at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:452)	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:351)	at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:255)	at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)	at sun.reflect.GeneratedMethodAccessor1.invoke(Unknown Source)	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)	at java.lang.reflect.Method.invoke(Method.java:597)	at org.compiere.db.StatementProxy.invoke(StatementProxy.java:100)	at $Proxy0.executeQuery(Unknown Source)	at org.compiere.model.MCost.getCurrentCostLayers(MCost.java:154)	at org.compiere.model.MCost.getCurrentCostLayers(MCost.java:271)	at org.compiere.model.ProductCost.getProductCostsLayers(ProductCost.java:694)	at org.adempiere.engine.FifoLifoCostingMethod.calculate(FifoLifoCostingMethod.java:56)	at org.adempiere.engine.FifoLifoCostingMethod.getCalculatedCosts(FifoLifoCostingMethod.java:68)	at org.adempiere.engine.AbstractCostingMethod.createCostDetails(AbstractCostingMethod.java:80)	at org.adempiere.engine.FifoLifoCostingMethod.processCostDetail(FifoLifoCostingMethod.java:123)	at org.adempiere.engine.FifoLifoCostingMethod.process(FifoLifoCostingMethod.java:100)	at org.adempiere.engine.CostEngine.createCostDetail(CostEngine.java:417)