SQL Exception when running ant run-install for CREATE INDEX SURVEY on an IBM iSeries

[André Herbst]

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é

[Anne Jessel]

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 <[hidden email]>:

> 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: [phone]
Fax: [phone]
Web: http://www.cohsoft.com.au/
Email: [hidden email]

Bonsai ERP, the all-inclusive ERP system
http://www.bonsaierp.com.au/

[André Herbst]

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 <[hidden email]>:
> > 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é

[Jacques Le Roux]

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" <[hidden email]>

>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 <[hidden email]>:
>> 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: [phone]
> Fax: [phone]
> Web: http://www.cohsoft.com.au/
> Email: [hidden email]
>
> Bonsai ERP, the all-inclusive ERP system
> http://www.bonsaierp.com.au/
>

[Pierre Smits]

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 <[hidden email]>

> 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" <[hidden email]>
>
>  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 <[hidden email]>:
>>
>>> 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: [phone]
>> Fax: [phone]
>> Web: http://www.cohsoft.com.au/
>> Email: [hidden email]
>>
>> Bonsai ERP, the all-inclusive ERP system
>> http://www.bonsaierp.com.au/
>>
>>
>
>

[Jacques Le Roux]

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" <[hidden email]>
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 <[hidden email]>

> 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" <[hidden email]>
>
>  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 <[hidden email]>:
>>
>>> 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: [phone]
>> Fax: [phone]
>> Web: http://www.cohsoft.com.au/
>> Email: [hidden email]
>>
>> Bonsai ERP, the all-inclusive ERP system
>> http://www.bonsaierp.com.au/
>>
>>
>
>