Luca Bertozzo - 2005-05-11

Hi all,

I coped to install compiere libero on win32 PGSQL 8.0.2, but can't complete initial client setup.

excerpt from log:

-------------------------------
===========> DB.saveError: DBExecuteError - ERROR: insert or update on table "ad_preference" violates foreign key constraint "ad_preference_client" [13]
-------------------------------
===========> MSetup.createPreference: Preference NOT inserted - C_Country_ID [13]
-------------------------------
===========> MSequence.getNextID: M_Warehouse - ERROR: current transaction is aborted, commands ignored until end of transaction block [13]
java.sql.SQLException: ERROR: current transaction is aborted, commands ignored until end of transaction block; State=25P02; ErrorCode=0
    at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1471)
    at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1256)
    at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:175)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:388)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:329)
    at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:239)
    at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:324)
    at org.postgresql.ds.common.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:467)
    at $Proxy1.executeQuery(Unknown Source)
    at org.compiere.model.MSequence.getNextID(MSequence.java:94)
    at org.compiere.util.DB.getNextID(DB.java:1186)
    at org.compiere.model.PO.saveNew(PO.java:1753)
    at org.compiere.model.PO.save(PO.java:1462)
    at org.compiere.model.MSetup.createEntities(MSetup.java:1116)
    at org.compiere.apps.form.VSetup.run(VSetup.java:435)
    at org.compiere.apps.form.FormFrame$2.run(FormFrame.java:334)