SendToAll field missing in AD_User model

Create issue
Issue #11 new
redhuan d. oon created an issue

Hi guys, This was reported in google group forum https://groups.google.com/forum/#!topic/idempiere/DbRoDZvUUd0. I test and confirmed this error stack: SEVERE: org.postgresql.util.PSQLException: ERROR: column ad_user.senttoall does not exist Position: 54 org.postgresql.util.PSQLException: ERROR: column ad_user.senttoall does not exist Position: 54 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2182) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1911) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:173) at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:645) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:495) at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:380) at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:1418) at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.compiere.db.StatementProxy.invoke(StatementProxy.java:128) at com.sun.proxy.$Proxy3.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:303)

The SendToAll field is requested in Export2Queue.java but not present in the AD_User model. I checked the migration scripts and there is no such field change also. Please advice.

Comments (3)

  1. redhuan d. oon reporter

    I added in another forum thread of the same issue: https://groups.google.com/forum/#!topic/idempiere/F4FbCR91rhI

    "I analysed it a bit and there is a workaround. Tick the SendAll box to end to all users. This seems OK during limited user base test. I think the new changes done by Eduardo Gil/Angel Lara is to allow POS clients to be user based besides been Location based. This maybe great in a multi POS clients in same location like i seen in Starbucks.

    Also in line with my do not touch the core principle, I would think of a way around extending the AD_User (really abused User model by so many, so many people, so lets make User whole again) by just either using SysConfig with a setting record SendAll or just a new Tab under User to cater solely for POS Users, such as password, pin number, working terms etc.

    WDYT?"

  2. chibsta

    Hi red1,

    Were you able to make any progress with this issue? How would I implement either a sysconfig setting or the "new tab under User"?

    Regards,

    Chibsta

  3. Log in to comment