I am having the same issue in a multi-tier setup against postgresql 8.3 on ubuntu. Is this a common issue in multi-tier setups? (I don't have the issue when the db resides on the same machine as ofbiz is...
Regards, Pierre 2009/9/12 Jacques Le Roux <[email protected]> > FYI : I do not find this message in the log of run-install on Windows XpSp3 > with Postgres 8.4 > svnversion : 814128 > > Jacques > > From: "Anne Jessel" <[email protected]> > > I see the same message with Postgresql 8.3, running java -jar >> ofbiz.jar -install -readers=seed,seed-initial,ext on a clean database. >> >> Cheers, >> Anne. >> >> 2009/9/6 André Herbst <[email protected]>: >> >>> Hi, >>> >>> I am getting this error when running ant run-install on a clean database >>> schema. >>> >>> 2009-09-05 22:35:43,845 (main) [ DatabaseUtil.java:2929:ERROR] Could not >>> create foreign key indices for entity [WorkEffortSurveyAppl]: SQL >>> Exception >>> while executing the following: >>> CREATE INDEX SURVEY ON OFBIZ.WORK_EFFORT_SURVEY_APPL (SURVEY_ID) >>> Error was: com.ibm.db2.jdbc.app.DB2SQLSyntaxErrorException: SURVEY in >>> OFBIZ of >>> type *FILE already exists. >>> >>> Has anybody else seen this error or is this somehow IBM DB2 related? >>> >>> -André >>> >>> >>> >> >> >> -- >> Coherent Software Australia Pty Ltd >> PO Box 2773 >> Cheltenham Vic 3192 >> Phone: (03) 9585 6788 >> Fax: (03) 9585 1086 >> Web: http://www.cohsoft.com.au/ >> Email: [email protected] >> >> Bonsai ERP, the all-inclusive ERP system >> http://www.bonsaierp.com.au/ >> >> > >
