OFBiz › OFBiz - Dev

[jira] Created: (OFBIZ-1713) seeding database error found

_‹ Previous Topic Next Topic _›

Classic

List

Threaded

3 messages Options

Nicolas Malin (Jira)

[jira] Created: (OFBIZ-1713) seeding database error found

seeding database error found
----------------------------

Key: OFBIZ-1713
URL: https://issues.apache.org/jira/browse/OFBIZ-1713
Project: OFBiz
Issue Type: Bug
Affects Versions: SVN trunk
Environment: n/a
Reporter: Yin T
Priority: Trivial

-downloaded the latest ofbiz trunk at Mar 18, 2008.
-ran "ant run-install"
-during the seeding of the database table, I found an error with in the compile log.

[java] 2008-03-17 17:23:25,564 (main) [ DatabaseUtil.java:343:WARN ] Entity [ZipSalesRuleLookup] has no table in the database
[java] 2008-03-17 17:23:26,605 (main) [ DatabaseUtil.java:356:INFO ] Created table [OFBIZ.ZIP_SALES_RULE_LOOKUP]
[java] 2008-03-17 17:23:26,605 (main) [ DatabaseUtil.java:343:WARN ] Entity [ZipSalesTaxLookup] has no table in the database
[java] 2008-03-17 17:23:27,687 (main) [ DatabaseUtil.java:356:INFO ] Created table [OFBIZ.ZIP_SALES_TAX_LOOKUP]
[java] 2008-03-17 17:23:28,178 (main) [ DatabaseUtil.java:2963:INFO ] Created 1 foreign key indices for entity [AccommodationClass]
[java] 2008-03-17 17:23:29,529 (main) [ DatabaseUtil.java:2963:INFO ] Created 3 foreign key indices for entity [AccommodationMap]
[java] 2008-03-17 17:23:30,170 (main) [ DatabaseUtil.java:2963:INFO ] Created 2 foreign key indices for entity [AccommodationSpot]
[java] 2008-03-17 17:23:36,369 (main) [ DatabaseUtil.java:2963:INFO ] Created 16 foreign key indices for entity [AcctgTrans]
[java] 2008-03-17 17:23:36,950 (main) [ DatabaseUtil.java:2963:INFO ] Created 1 foreign key indices for entity [AcctgTransAttribute]
[java] 2008-03-17 17:23:41,226 (main) [ DatabaseUtil.java:2963:INFO ] Created 11 foreign key indices for entity [AcctgTransEntry]
...
[java] 2008-03-17 17:25:08,362 (main) [ DatabaseUtil.java:2963:INFO ] Created 1 foreign key indices for entity [CostComponentTypeAttr]
[java] 2008-03-17 17:25:08,862 (main) [ DatabaseUtil.java:2963:INFO ] Created 1 foreign key indices for entity [CountryCapital]
[java] 2008-03-17 17:25:09,023 (main) [ DatabaseUtil.java:2963:INFO ] Created 1 foreign key indices for entity [CountryTeleCode]
[java] 2008-03-17 17:25:09,353 (main) [ DatabaseUtil.java:2963:INFO ] Created 3 foreign key indices for entity [CreditCard]
[java] 2008-03-17 17:25:13,209 (main) [ DatabaseUtil.java:2953:ERROR] Could not create foreign key indices for entity [CustRequest]: SQL Exception while executing the following:
[java] CREATE INDEX CUST_REQ_CUOM ON OFBIZ.CUST_REQUEST (CURRENCY_UOM_ID)
[java] Error was: java.sql.SQLException: Index 'CUST_REQ_CUOM' already exists in Schema 'OFBIZ'.
[java] 2008-03-17 17:25:13,219 (main) [ DatabaseUtil.java:2963:INFO ] Created 8 foreign key indices for entity [CustRequest]
...

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Nicolas Malin (Jira)

[jira] Assigned: (OFBIZ-1713) seeding database error found

[ https://issues.apache.org/jira/browse/OFBIZ-1713?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacopo Cappellato reassigned OFBIZ-1713:
----------------------------------------

Assignee: Jacopo Cappellato

> seeding database error found
> ----------------------------
>
> Key: OFBIZ-1713
> URL: https://issues.apache.org/jira/browse/OFBIZ-1713
> Project: OFBiz
> Issue Type: Bug
> Affects Versions: SVN trunk
> Environment: n/a
> Reporter: Yin T
> Assignee: Jacopo Cappellato
> Priority: Trivial
>
> -downloaded the latest ofbiz trunk at Mar 18, 2008.
> -ran "ant run-install"
> -during the seeding of the database table, I found an error with in the compile log.
> [java] 2008-03-17 17:23:25,564 (main) [ DatabaseUtil.java:343:WARN ] Entity [ZipSalesRuleLookup] has no table in the database
> [java] 2008-03-17 17:23:26,605 (main) [ DatabaseUtil.java:356:INFO ] Created table [OFBIZ.ZIP_SALES_RULE_LOOKUP]
> [java] 2008-03-17 17:23:26,605 (main) [ DatabaseUtil.java:343:WARN ] Entity [ZipSalesTaxLookup] has no table in the database
> [java] 2008-03-17 17:23:27,687 (main) [ DatabaseUtil.java:356:INFO ] Created table [OFBIZ.ZIP_SALES_TAX_LOOKUP]
> [java] 2008-03-17 17:23:28,178 (main) [ DatabaseUtil.java:2963:INFO ] Created 1 foreign key indices for entity [AccommodationClass]
> [java] 2008-03-17 17:23:29,529 (main) [ DatabaseUtil.java:2963:INFO ] Created 3 foreign key indices for entity [AccommodationMap]
> [java] 2008-03-17 17:23:30,170 (main) [ DatabaseUtil.java:2963:INFO ] Created 2 foreign key indices for entity [AccommodationSpot]
> [java] 2008-03-17 17:23:36,369 (main) [ DatabaseUtil.java:2963:INFO ] Created 16 foreign key indices for entity [AcctgTrans]
> [java] 2008-03-17 17:23:36,950 (main) [ DatabaseUtil.java:2963:INFO ] Created 1 foreign key indices for entity [AcctgTransAttribute]
> [java] 2008-03-17 17:23:41,226 (main) [ DatabaseUtil.java:2963:INFO ] Created 11 foreign key indices for entity [AcctgTransEntry]
> ...
> [java] 2008-03-17 17:25:08,362 (main) [ DatabaseUtil.java:2963:INFO ] Created 1 foreign key indices for entity [CostComponentTypeAttr]
> [java] 2008-03-17 17:25:08,862 (main) [ DatabaseUtil.java:2963:INFO ] Created 1 foreign key indices for entity [CountryCapital]
> [java] 2008-03-17 17:25:09,023 (main) [ DatabaseUtil.java:2963:INFO ] Created 1 foreign key indices for entity [CountryTeleCode]
> [java] 2008-03-17 17:25:09,353 (main) [ DatabaseUtil.java:2963:INFO ] Created 3 foreign key indices for entity [CreditCard]
> [java] 2008-03-17 17:25:13,209 (main) [ DatabaseUtil.java:2953:ERROR] Could not create foreign key indices for entity [CustRequest]: SQL Exception while executing the following:
> [java] CREATE INDEX CUST_REQ_CUOM ON OFBIZ.CUST_REQUEST (CURRENCY_UOM_ID)
> [java] Error was: java.sql.SQLException: Index 'CUST_REQ_CUOM' already exists in Schema 'OFBIZ'.
> [java] 2008-03-17 17:25:13,219 (main) [ DatabaseUtil.java:2963:INFO ] Created 8 foreign key indices for entity [CustRequest]
> ...

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Nicolas Malin (Jira)

[jira] Closed: (OFBIZ-1713) seeding database error found

In reply to this post by Nicolas Malin (Jira)

[ https://issues.apache.org/jira/browse/OFBIZ-1713?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jacopo Cappellato closed OFBIZ-1713.
------------------------------------

Resolution: Fixed

Thanks Yin,

it is fixed in rev. 638415

--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.