#2472 3.6.0 "processedon" does not exist in c_AllocationLine

[David García]

I have downloaded the last versión. and I have installed with the database dump included in the distribution. But in the server i get the next output
I have read a similar post, but in this case, it isn't a migration problem.

17:40:22,467 ERROR [STDERR] ===========> AcctProcessor.postSession: SELECT * FROM C_AllocationLine WHERE AD_Client_ID=? AND (ProcessedOn IS NULL OR ProcessedOn=0) AND Processed='Y' AND Posted='N' AND IsActive='Y' ORDER BY Created [12]
org.postgresql.util.PSQLException: ERROR: column "processedon" does not exist
Position: 59; State=42703; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at sun.reflect.GeneratedMethodAccessor107.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
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)

[Virginia Correa]

Hi Everyone

I am facing the same problem, has anyone answer or fix the problem?

Thanks in advance

Virginia Correa

[Carlos Ruiz]

Hi David / Virginia

Can you please post the output of this query:

select c.ad_column_id, c.created, c.updated, c.entitytype
from ad_table t join ad_column c on t.AD_TABLE_ID=c.ad_table_id
where t.tablename = 'C_AllocationLine' and c.columnname = 'Posted'

Regards,

Carlos Ruiz

[Virginia Correa]

Hi Carlos , sorry for my delay to anwser, we found the problem, but we dont know why a column was created , but thanks anyway for your support.
Lets be in contact
Thanks again

[Carlos Ruiz]

Hi Virginia,

> but we dont know why a column was created

Exactly,I'm suspicious as this is happening to other people out there - so I think there must be some extension or patch published somewhere creating wrongly that column.

Regards,

Carlos Ruiz

[harold]

Saludos,

Virginia puedes comentar la solución que encontraste... a mi me esta ocurriendo el mismo problema

[Juan Carlos Vasquez García]

Hi, I had the same problem but I got the answer from this topic:

http://sourceforge.net/projects/adempiere/forums/forum/610548/topic/4096447

According with Carlos Ruiz and Angelo this error is because the C_AllocationLine table have the "Posted" column, which it's not loger necessary, and for some reason from the Table window someone click on "Create columns from DB" button.

So, the partial solution is delete "Posted" column from data dictionary, the final one is delete column from data dictionary and db.

Best regards.

Juan C Vasq