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
- 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>
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
via adempiere by gabrielke
, 2 years agovia adempiere by ivanceras
, 2 years agovia adempiere by bma99
, 2 years agovia adempiere by frerod
, 2 years agovia adempiere by edwinhaq
, 2 years agoorg.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)