currently i am trying to find out which branch/fork of ADempiere to use for our new company here in Germany. From a technical perspective the iDempiere fork seems to be the most appealing. I know the first released version is still some month away. But being of the curious sort I'd like to see how usable it is in our scenario right now. Also, I'd be glad to contribute back whatever we will learn in the process. I know this is expected and should be unecessary to write. But it feels good to do so anyway.
To get my feet wet I tried to see how far I could get with the iDempiere fork with regard to the german localization. After some struggling I got it running and successfully imported the translations. Now I am stuck at the initial client setup. The first screen fails with an error concerning the chart of accounts file. This is the relevant excerpt from the server log:
- Code: Select all
14:37:54.215===========> DB.executeUpdate: INSERT INTO C_AcctSchema_GL (IntercompanyDueFrom_Acct,UseCurrencyBalancing,C_AcctSchema_ID,IntercompanyDueTo_Acct,CurrencyBalancing_Acct,UseSuspenseBalancing,SuspenseBalancing_Acct,UseSuspenseError,PPVOffset_Acct,CommitmentOffset_Acct,CommitmentOffsetSales_Acct,C_AcctSchema_GL_UU,Updated,AD_Org_ID,CreatedBy,UpdatedBy,Created,IsActive,AD_Client_ID) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) [Setup_f296d1ed-faa7-4679-800f-7bfd7837e3b0] [14]
org.postgresql.util.PSQLException: ERROR: null value in column "retainedearning_acct" violates not-null constraint; State=23502; ErrorCode=0
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeUpdate(AbstractJdbc2Statement.java:334)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
at sun.reflect.GeneratedMethodAccessor42.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:616)
at org.compiere.db.StatementProxy.invoke(StatementProxy.java:125)
at $Proxy0.executeUpdate(Unknown Source)
at org.compiere.util.DB.executeUpdate(DB.java:1027)
at org.compiere.util.DB.executeUpdate(DB.java:992)
at org.compiere.model.PO.doInsert(PO.java:2897)
at org.compiere.model.PO.saveNew(PO.java:2701)
at org.compiere.model.PO.save(PO.java:2070)
at org.compiere.model.MSetup.createAccountingRecord(MSetup.java:797)
at org.compiere.model.MSetup.createAccounting(MSetup.java:588)
at org.adempiere.process.InitialClientSetup.doIt(InitialClientSetup.java:232)
at org.compiere.process.SvrProcess.process(SvrProcess.java:163)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:116)
14:37:54.398===========> DB.saveError: DBExecuteError - ERROR: null value in column "retainedearning_acct" violates not-null constraint [14]
14:37:54.404-----------> MAcctSchemaGL.doInsert: [Setup_f296d1ed-faa7-4679-800f-7bfd7837e3b0]Not inserted - C_AcctSchema_GL [14]
14:37:54.409===========> MSetup.createAccounting: ERROR: null value in column "retainedearning_acct" violates not-null constraint [14]
14:37:54.443===========> InitialClientSetup.process: Fehler beim Einrichten der Buchführung.
Prüfen Sie das Fehlerlog und das Format der verwendeten Datei "Accounting*.csv" - Es dürfen keine doppelten Konten enthalten sein und es müssen alle Standardkonten enthalten sein (auch wenn Sie sie nicht nutzen). [14]
org.adempiere.exceptions.AdempiereException: Fehler beim Einrichten der Buchführung.
Prüfen Sie das Fehlerlog und das Format der verwendeten Datei "Accounting*.csv" - Es dürfen keine doppelten Konten enthalten sein und es müssen alle Standardkonten enthalten sein (auch wenn Sie sie nicht nutzen).
at org.adempiere.process.InitialClientSetup.doIt(InitialClientSetup.java:236)
at org.compiere.process.SvrProcess.process(SvrProcess.java:163)
at org.compiere.process.SvrProcess.startProcess(SvrProcess.java:116)
at org.adempiere.util.ProcessUtil.startJavaProcess(ProcessUtil.java:212)
at org.compiere.apps.AbstractProcessCtl.startProcess(AbstractProcessCtl.java:448)
at org.compiere.apps.AbstractProcessCtl.run(AbstractProcessCtl.java:232)
at org.adempiere.webui.apps.WProcessCtl.process(WProcessCtl.java:156)
at org.adempiere.webui.apps.ProcessDialog$ProcessDialogRunnable.doRun(ProcessDialog.java:774)
at org.adempiere.util.ContextRunnable.run(ContextRunnable.java:38)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
I am a bit stumped here since this has worked without problems with ADempiere 3.70lts. So unless the procedure has changed the might something be wrong here. Has the CSV format of the chart of accounts fild extended by the "retainedearning_acct" or is this a deeper issue? I used this file (the latest version) for testing:
https://bitbucket.org/idempiere/idempie ... _SKR04.csv
One thing I tried was to append "[retainedearning_acct]" as an additional column to the file. But the error returned.
Thanks, Michael