Idempiere Unicenta POS Sync

[Brian Karemba]

Hi,

I have setup Unicenta POS (from: https://bitbucket.org/ghintech/unicenta/downloads), Apache ActiveMQ and Idempiere 4.1 on an Ubuntu VM and I am getting the error:

** org.postgresql.util.PSQLException: ERROR: column ad_user.senttoall does not exist Position: 55. The full stacktrace in the server is:

23:34:32.558===========> Export2Queue.process: org.postgresql.util.PSQLException: ERROR: column ad_user.senttoall does not exist

  Position: 55 [97]

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)

when I try to with the parameters in the image attached.

Is there a script I need to run to update the database?

Regards,

Brian.