You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by "Yin T (JIRA)" <ji...@apache.org> on 2008/03/18 16:15:24 UTC
[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.
[jira] Closed: (OFBIZ-1713) seeding database error found
Posted by "Jacopo Cappellato (JIRA)" <ji...@apache.org>.
[ 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
> 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.
[jira] Assigned: (OFBIZ-1713) seeding database error found
Posted by "Jacopo Cappellato (JIRA)" <ji...@apache.org>.
[ 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.