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

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

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

Nicolas Malin (Jira)
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.

Reply | Threaded
Open this post in threaded view
|

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

Nicolas Malin (Jira)

     [ 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.

Reply | Threaded
Open this post in threaded view
|

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

Nicolas Malin (Jira)
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

> 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.