Erro Função Trunk


#1

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


#2

Qual é a versão do BD que está usando?


#3

versão do postgres:
PostgreSQL 8.4.20 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-17), 64-bit

versão do java:
java version “1.8.0_111”
Java™ SE Runtime Environment (build 1.8.0_111-b14)
Java HotSpot™ 64-Bit Server VM (build 25.111-b14, mixed mode)


#4

Banco de dados (dmp) obtido de bitbucket.org/AdempiereLBR/adem … 610_PG.tgz