Prazados,
instalei o ADempiere em um Mac OS, está rodando a princípio OK, mas ao tentar efetuar o processo de Criar uma Nova Empresa descrito em adempierelbr.wikispaces.com/Criar+Nova+Empresa, recebo o erro Create client failed.
Coloquei o arquivo AccountingBR.csv na pasta ADempiere/data/import e selecionei no campo indicado.
Alguma idéia da causa?
Algumas pistas:
Quando fiz o restore da base, notei os seguintes erros na janela do terminal:
[code]Import Adempiere_pg.dmp
ERROR: schema “sqlj” does not exist
NOTICE: schema “adempiere” does not exist
psql:/Applications/Adempiere/Adempiere/data/ExpDat.dmp:25: ERROR: syntax error at or near “PROCEDURAL”
LINE 1: CREATE OR REPLACE PROCEDURAL LANGUAGE plpgsql;
^
[/code]
E quando rodei o RUN_Server2.sh também deu diversos erros.
ERROR [STDERR] *** 2011-02-21 17:42:24.139 Adempiere Log (ConsoleHandler) ***
ERROR [STDERR] 17:42:24.175 Ini.loadProperties: /Applications/Adempiere/Adempiere/Adempiere.properties #33
ERROR [STDERR] -----------> EMail.setFrom: you @ company.org: javax.mail.internet.AddressException: Local address contains control or whitespace in string ``you @ company.org''
ERROR [STDERR] -----------> EMail.isValid: From is invalid=null
ERROR [STDERR] -----------> MClient.sendEMail: Could NOT Send Email: Server started: ? to you @ company.org: Invalid Data (System)
ERROR [STDERR] ===========> Env.getContextAsDate: No value for: #Date
ERROR [STDERR] -----------> MIssue.set_ValueNoCheck: ReleaseNo - Value too long - truncated to length=4
ERROR [STDERR] log4j:ERROR A "org.jboss.logging.appender.FileAppender" object is not assignable to a "org.apache.log4j.Appender" variable.
ERROR [STDERR] log4j:ERROR The class "org.apache.log4j.Appender" was loaded by
ERROR [STDERR] log4j:ERROR [WebappClassLoader
delegate: false
repositories:
/WEB-INF/classes/
----------> Parent Classloader:
java.net.FactoryURLClassLoader@7e5e5f92
] whereas object of type
ERROR [STDERR] log4j:ERROR "org.jboss.logging.appender.FileAppender" was loaded by [org.jboss.system.server.NoAnnotationURLClassLoader@1aa8c488].
ERROR [STDERR] log4j:ERROR Could not instantiate appender named "FILE".
ERROR [STDERR] ===========> Query.firstOnly: 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_OrgType_ID,AD_Org_ID,C_Calendar_ID,C_Location_ID,ContactName,Created,CreatedBy,DUNS,DropShip_Warehouse_ID,EMail,Fax,IsActive,LBR_DC_Org_ID,LBR_DC_WS_ID,LBR_DocPrint_ID,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,lbr_CCM,lbr_CNAE,lbr_CNPJ,lbr_Fantasia,lbr_IE,lbr_Interest,lbr_LegalEntity,lbr_NFeEnv,lbr_Suframa FROM AD_OrgInfo WHERE (AD_Org_ID=?) [11]
org.postgresql.util.PSQLException: ERROR: column "oseb_contatonfe" does not exist
Position: 326; 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.Query.createResultSet(Query.java:722)
at org.compiere.model.Query.firstOnly(Query.java:303)
at org.compiere.model.MOrgInfo.get(MOrgInfo.java:66)
at org.compiere.model.MPeriod.getC_Calendar_ID(MPeriod.java:747)
at org.compiere.model.MPeriod.get(MPeriod.java:106)
at org.compiere.acct.Doc.setPeriod(Doc.java:1122)
at org.compiere.acct.Doc.isPeriodOpen(Doc.java:1151)
at org.compiere.acct.Doc.postLogic(Doc.java:755)
at org.compiere.acct.Doc.post(Doc.java:643)
at org.compiere.server.AcctProcessor.postSession(AcctProcessor.java:202)
at org.compiere.server.AcctProcessor.doWork(AcctProcessor.java:79)
at org.compiere.server.AdempiereServer.run(AdempiereServer.java:232)
ERROR [STDERR] -----------> MIssue.set_ValueNoCheck: ReleaseNo - Value too long - truncated to length=4 [11]
Aparece várias (umas 50) vezes o erro:
org.postgresql.util.PSQLException: ERROR: column “oseb_contatonfe” does not exist
E no final o script pendura após a linha:
ERROR [STDERR] -----------> MClient.createEMail: No To address: MUser[0,Name=null,EMailUserID=null] [13]
E aí tenho que matar a janela do terminal. Mas consigo rodar o client e a versão web, só dá erro ao criar a empresa.
Ambiente:
Mac OS X 10.6.6
Java 1.6.0_22
Postgres 8.4
ADempiere 360LTS com customização LBR