Ao executar a aplicação no desktop, a janela DOS que permanece aberta está constantemente dando o erro a seguir:
-----------> MIssue.set_ValueNoCheck: ReleaseNo - Value too long - truncated to length=4 [26]
===========> DB.getSQLValue: SELECT COUNT(1) FROM R_Request WHERE (SalesRep_ID=? OR AD_Role_ID=?) AND Processed='N' AND (DateNextAction IS NULL OR TRUNC(DateNextAction) <= TRUNC(SysDate)) AND (R_Status_ID IS NULL OR R_Status_ID IN (SELECT R_Status_ID FROM R_Status WHERE IsClosed='N')) AND AD_Client_ID=0 AND AD_Org_ID=0 AND R_Request_ID NOT IN ( SELECT Record_ID FROM AD_Private_Access WHERE AD_Table_ID = 417 AND AD_User_ID <> 0 AND IsActive = 'Y' ) [26]
org.postgresql.util.PSQLException: ERRO: funþÒo trunc(timestamp without time zone) nÒo existe
Dica: Nenhuma funþÒo corresponde com o nome e os tipos de argumentos informados. VocÛ precisa adicionar convers§es de tipo explÝcitas.
PosiþÒo: 121; State=42883; ErrorCode=0
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:76)
at sun.reflect.GeneratedMethodAccessor6.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.compiere.db.StatementProxy.invoke(StatementProxy.java:100)
at com.sun.proxy.$Proxy2.executeQuery(Unknown Source)
at org.compiere.util.DB.getSQLValueEx(DB.java:1258)
at org.compiere.util.DB.getSQLValue(DB.java:1301)
at org.compiere.util.DB.getSQLValue(DB.java:2094)
at org.compiere.apps.AMenu.getRequests(AMenu.java:657)
at org.compiere.apps.AMenu.updateInfo(AMenu.java:706)
at org.compiere.apps.AMenu$InfoUpdater.run(AMenu.java:804)
at java.lang.Thread.run(Unknown Source)
Há alguma coisa que eu possa fazer para corrigir isso?
Atenciosamente
Geert Vieira Gosch