You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Anne Jessel <an...@cohsoft.com.au> on 2009/09/06 06:29:15 UTC
Re: SQL Exception when running ant run-install for CREATE INDEX
SURVEY on an IBM iSeries
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 <ah...@softmatic.dk>:
> 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: sales@cohsoft.com.au
Bonsai ERP, the all-inclusive ERP system
http://www.bonsaierp.com.au/
Re: SQL Exception when running ant run-install for CREATE INDEX SURVEY on an IBM iSeries
Posted by André Herbst <ah...@softmatic.dk>.
Thanks Anne for your feedback.
Interesting to know that it is not only DB2 giving this error.
I will do some further investigation to see if I can find the reason for the
problem and get back if I find a solution.
-André
On Sunday den 6. September 2009 06:29:15 Anne Jessel wrote:
> 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 <ah...@softmatic.dk>:
> > 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é
Re: SQL Exception when running ant run-install for CREATE INDEX SURVEY on an IBM iSeries
Posted by Jacques Le Roux <ja...@les7arts.com>.
Just tried from a clean (ant clean-all) updated (svn up) Ubuntu 8.04 box to potsgres 8.4 (ant run-install) on Windows XP, no
problems at all.
Jacques
From: "Pierre Smits" <pi...@gmail.com>
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 <ja...@les7arts.com>
> 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" <an...@cohsoft.com.au>
>
> 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 <ah...@softmatic.dk>:
>>
>>> 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: sales@cohsoft.com.au
>>
>> Bonsai ERP, the all-inclusive ERP system
>> http://www.bonsaierp.com.au/
>>
>>
>
>
Re: SQL Exception when running ant run-install for CREATE INDEX
SURVEY on an IBM iSeries
Posted by Pierre Smits <pi...@gmail.com>.
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 <ja...@les7arts.com>
> 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" <an...@cohsoft.com.au>
>
> 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 <ah...@softmatic.dk>:
>>
>>> 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: sales@cohsoft.com.au
>>
>> Bonsai ERP, the all-inclusive ERP system
>> http://www.bonsaierp.com.au/
>>
>>
>
>
Re: SQL Exception when running ant run-install for CREATE INDEX SURVEY on an IBM iSeries
Posted by Jacques Le Roux <ja...@les7arts.com>.
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" <an...@cohsoft.com.au>
>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 <ah...@softmatic.dk>:
>> 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: sales@cohsoft.com.au
>
> Bonsai ERP, the all-inclusive ERP system
> http://www.bonsaierp.com.au/
>