twahch - 2005-10-14

Could anyone tell me how to avoid this?
PostgreSQL =>SELECT COUNT(*) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR convert(date,DateNextAction) <= convert(date,CURRENT_TIMESTAMP)) AND AD_Client_ID=11<= <SELECT COUNT(*) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction) <= TRUNC(SysDate)) AND AD_Client_ID=11>
===========> AMenu.getRequests: getRequests [102]
java.sql.SQLException: ERROR: column "date" does not exist; State=42703; ErrorCode=0
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:389)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:330)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:240)
    at sun.reflect.GeneratedMethodAccessor11.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)
    at org.postgresql.ds.common.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:467)
    at $Proxy1.executeQuery(Unknown Source)
    at org.compiere.util.CPreparedStatement.executeQuery(CPreparedStatement.java:99)
    at org.compiere.apps.AMenu.getRequests(AMenu.java:475)
    at org.compiere.apps.AMenu.updateInfo(AMenu.java:531)
    at org.compiere.apps.AMenuStartItem.run(AMenuStartItem.java:181)

PostgreSQL =>SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y'<= <SELECT t.TableName, c.ColumnName,c.AD_Reference_ID,c.IsMandatory,c.IsUpdateable,c.DefaultValue,e.Name,e.Description, c.AD_Column_ID, c.IsKey,c.IsParent, c.AD_Reference_Value_ID, vr.Code, c.FieldLength, c.ValueMin, c.ValueMax, c.IsTranslated, t.AccessLevel, c.ColumnSQL FROM AD_Table t INNER JOIN AD_Column c ON (t.AD_Table_ID=c.AD_Table_ID) LEFT OUTER JOIN AD_Val_Rule vr ON (c.AD_Val_Rule_ID=vr.AD_Val_Rule_ID) INNER JOIN AD_Element e  ON (c.AD_Element_ID=e.AD_Element_ID) WHERE t.AD_Table_ID=? AND c.IsActive='Y'>
===========> MSequence.nextID: org.postgresql.util.PSQLException: This statement does not declare an OUT parameter.  Use '{' ?= call ... '}' to declare one. [11]
===========> MShipper.saveNew: No NextID (-1) [11]
===========> MTable.saveError: AccessNotDeleteable -  [11]
===========> MSequence.nextID: org.postgresql.util.PSQLException: This statement does not declare an OUT parameter.  Use '{' ?= call ... '}' to declare one. [11]
===========> MShipper.saveNew: No NextID (-1) [11]
===========> MTable.saveError: AccessNotDeleteable -  [11]
===========> MSequence.nextID: org.postgresql.util.PSQLException: This statement does not declare an OUT parameter.  Use '{' ?= call ... '}' to declare one. [11]
===========> MShipper.saveNew: No NextID (-1) [11]
===========> MTable.saveError: AccessNotDeleteable -  [11]