[Adempiere-trackers] [ adempiere-Bugs-2982496 ] column "processedon" does not exist

[SourceForge.net <no...@so...>]

Bugs item #2982496, was opened at 2010-04-06 06:49
Message generated for change (Settings changed) made by felixmoeller
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=879332&aid=2982496&group_id=176962

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
>Status: Closed
Resolution: Invalid
Priority: 5
Private: No
Submitted By: Bala Chandar (tbalachandar)
Assigned to: Nobody/Anonymous (nobody)
Summary: column "processedon" does not exist

Initial Comment:


hi all,

I notice the following error in Adempiere server.

12:08:13,234 ERROR [STDERR] ===========> AcctProcessor.postSession: SELECT * FROM
 M_InOut WHERE AD_Client_ID=? AND (ProcessedOn IS NULL OR ProcessedOn=0) AND Proc
essed='Y' AND Posted='N' AND IsActive='Y' ORDER BY Created [12]
org.postgresql.util.PSQLException: ERROR: column "processedon" does not exist
  Position: 50; State=42703; ErrorCode=0
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExe
cutorImpl.java:2062)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorI
mpl.java:1795)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.jav
a:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2State
ment.java:479)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJ
dbc2Statement.java:367)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2
Statement.java:271)
        at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewPro
xyPreparedStatement.java:76)
        at sun.reflect.GeneratedMethodAccessor55.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccess
orImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.compiere.db.StatementProxy.invoke(StatementProxy.java:100)
        at $Proxy67.executeQuery(Unknown Source)
        at org.compiere.server.AcctProcessor.postSession(AcctProcessor.java:187)
        at org.compiere.server.AcctProcessor.doWork(AcctProcessor.java:79)
        at org.compiere.server.AdempiereServer.run(AdempiereServer.java:232)


regards 
Balachandar.

----------------------------------------------------------------------

Comment By: Felix Möller (felixmoeller)
Date: 2010-04-06 07:39

Message:
You did not run the migration scripts. The column was added with
https://adempiere.svn.sourceforge.net/svnroot/adempiere/trunk/migration/354a-trunk/postgresql/670_FR2962094_AddProcesssedOnColumn.sql.
You have to run all scripts in the migration folder.

regards
Felix

http://www.catura.de/

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=879332&aid=2982496&group_id=176962