Erro criar empresa nova - Ajuda

[Herrera]

Boa tarde,

Estou utilizando o 3.6.LTS, PGSQL LBR 360, JDK6, SO windows 7, Postgre 8.4.
Ao criar nova empresa aparece o seguinte erro ** Create client failed.

Como posso resolver ?

Abraço

[ralexsander]

Verifique o LOG do Console do Eclipse.

Se estiver rodando direto da aplicação pegue o LOG por: Ferramentas > Preferência > Log > Salvar

[Herrera]

** 2012-12-20 18:32:54.571 Adempiere Log (CLogFile) ***
18:32:54.569 Adempiere.startup: ADempiere® Release 3.6.0LTS_2010-06-14 -Smart Suite ERP,CRM and SCM- © 1999-2010 ADempiere®; Implementation: ${ADEMPIERE_VERSION} 20121220-1611 - ${ADEMPIERE_VENDOR}
18:32:54.596 Ini.loadProperties: C:\Adempiere\Adempiere.properties #34
-----------> EMail.setFrom: you @ company.org: javax.mail.internet.AddressException: Local address contains control or whitespace in string you @ company.org'' -----------> EMail.addTo: you @ company.org: javax.mail.internet.AddressException: Local address contains control or whitespace in stringyou @ company.org’’
-----------> EMail.isValid: From is invalid=null
-----------> EMail.isValid: From is invalid=null
-----------> MClient.sendEMail: Could NOT Send Email: Server started: ? to you @ company.org: Invalid Data (System)
-----------> MIssue.set_ValueNoCheck: ReleaseNo - Value too long - truncated to length=4
===========> Env.getContextAsDate: No value for: #Date
-----------> MIssue.set_ValueNoCheck: ReleaseNo - Value too long - truncated to length=4 [11]
===========> Doc_BankStatement.post: Resubmit - Cannot lock C_BankStatement_ID=100, Force=false,RePost=false [11]
-----------> Env.verifyLanguage: Not System Language=Language=[Polski,Locale=pl_PL,AD_Language=pl_PL,DatePattern=DD-MM-YYYY,DecimalPoint=false] - Set to Base Language en_US [12]
-----------> EMail.setFrom: you @ company.org: javax.mail.internet.AddressException: Local address contains control or whitespace in string you @ company.org'' [13] -----------> EMail.addTo: admin @ gardenworld.com: javax.mail.internet.AddressException: Local address contains control or whitespace in stringadmin @ gardenworld.com’’ [13]
-----------> EMail.isValid: From is invalid=null [13]
-----------> EMail.isValid: From is invalid=null [13]
-----------> MClient.sendEmailNow: Could NOT Send Email: Alerta de Inatividade: Solicitação 10000002 to admin @ gardenworld.com: Invalid Data (GardenWorld) [13]
-----------> MPInstancePara.set_Value: Info - Value too long - truncated to length=60 [12]
-----------> MIssue.set_ValueNoCheck: ReleaseNo - Value too long - truncated to length=4 [12]
===========> MOrgInfo.load: [Setup_7be9ec26-f9ef-4067-bb70-02e012be8b72] - AD_Org_ID=2000007, SQL=SELECT AD_Client_ID,(SELECT AD_Language FROM AD_Client c WHERE AD_OrgInfo.AD_Client_ID = c.AD_Client_ID) AS AD_Language,AD_Org_ID,AD_OrgType_ID,C_Calendar_ID,C_Location_ID,ContactName,Created,CreatedBy,DropShip_Warehouse_ID,DUNS,EMail,Fax,IsActive,lbr_CCM,lbr_CNAE,lbr_CNPJ,LBR_DC_Org_ID,LBR_DC_WS_ID,LBR_DocPrint_ID,lbr_Fantasia,lbr_IE,lbr_Interest,lbr_LegalEntity,lbr_NFeEnv,lbr_Suframa,LBR_Tax_ID,Logo_ID,M_Warehouse_ID,OSEB_ContatoNFe,Parent_Org_ID,Phone,Phone2,ReceiptFooterMsg,Supervisor_ID,TaxID,TransferBank_ID,TransferCashBook_ID,Updated,UpdatedBy FROM AD_OrgInfo WHERE AD_Org_ID=? [12]
org.postgresql.util.PSQLException: ERRO: coluna “oseb_contatonfe” não existe
Posição: 424; State=42703; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2062)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1795)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:367)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:271)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeQuery(NewProxyPreparedStatement.java:76)
at sun.reflect.GeneratedMethodAccessor57.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.compiere.db.StatementProxy.invoke(StatementProxy.java:100)
at $Proxy67.executeQuery(Unknown Source)
at org.compiere.model.PO.load(PO.java:1340)
at org.compiere.model.PO.saveNew(PO.java:2736)
at org.compiere.model.PO.save(PO.java:2082)
at org.compiere.model.PO.saveEx(PO.java:2166)
at org.compiere.model.MOrg.afterSave(MOrg.java:150)
at org.compiere.model.PO.saveFinish(PO.java:2196)
at org.compiere.model.PO.saveNew(PO.java:2757)
at org.compiere.model.PO.save(PO.java:2082)
at org.compiere.model.MSetup.createClient(MSetup.java:177)

-----------> MIssue.set_ValueNoCheck: ReleaseNo - Value too long - truncated to length=4 [12]
===========> MOrgInfo.saveNew: [Setup_7be9ec26-f9ef-4067-bb70-02e012be8b72] - reloading [12]
-----------> MOrg.saveFinish: afterSave [12]
org.adempiere.exceptions.AdempiereException: SaveError
at org.compiere.model.PO.saveEx(PO.java:2173)
at org.compiere.model.MOrg.afterSave(MOrg.java:150)
at org.compiere.model.PO.saveFinish(PO.java:2196)
at org.compiere.model.PO.saveNew(PO.java:2757)
at org.compiere.model.PO.save(PO.java:2082)
at org.compiere.model.MSetup.createClient(MSetup.java:177)
at org.adempiere.process.InitialClientSetup.doIt(InitialClientSetup.java:218)
at org.compiere.process.SvrProcess.process(SvrProcess.java:147)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:105)
at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:160)
at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:105)
at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:649)
at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:394)
at org.compiere.apps.ProcessCtl.process(ProcessCtl.java:210)

-----------> MIssue.set_ValueNoCheck: ReleaseNo - Value too long - truncated to length=4 [12]
===========> MSetup.createClient: Organization NOT created [12]
-----------> MIssue.set_ValueNoCheck: ReleaseNo - Value too long - truncated to length=4 [12]
===========> InitialClientSetup.process: Create client failed [12]
org.adempiere.exceptions.AdempiereException: Create client failed
at org.adempiere.process.InitialClientSetup.doIt(InitialClientSetup.java:221)
at org.compiere.process.SvrProcess.process(SvrProcess.java:147)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:105)
at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:160)
at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:105)
at org.compiere.apps.ProcessCtl.startProcess(ProcessCtl.java:649)
at org.compiere.apps.ProcessCtl.run(ProcessCtl.java:394)
at org.compiere.apps.ProcessCtl.process(ProcessCtl.java:210)
at org.adempiere.webui.apps.ProcessDialog.runProcess(ProcessDialog.java:313)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.zkoss.zk.ui.impl.EventProcessor.process0(EventProcessor.java:209)
at org.zkoss.zk.ui.impl.EventProcessor.process(EventProcessor.java:141)
at org.zkoss.zk.ui.impl.EventProcessingThreadImpl.process0(EventProcessingThreadImpl.java:519)
at org.zkoss.zk.ui.impl.EventProcessingThreadImpl.run(EventProcessingThreadImpl.java:446)

[ralexsander]

Importação da planilha de contas não funciona

Sim, o TRUNC funciona (apesar de achar estranho usar com data) mas o problema nesta query é o sysdate, até onde sei só é válido no Oracle. Alterei esta parte do SQL para ficar compativel com o postgres (usei now() ao invés de sysdate) e rodei de novo, mas agora dá um ERRO: coluna “oseb_contatonfe” não existe.