You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by Mathius Allo <mg...@yahoo.com> on 2007/06/22 08:12:03 UTC

"ant run-install " failed to install demo & seed data

Hi All,
   
  Just got the latest ofbiz yesterday from svn "co https://svn.apache.org/repos/asf/ofbiz/trunk ofbiz"
   
  What I did:
  1. cleaned up mysql database by creating a new schema & user/password
  2. updated entityengine.xml to use localmysql & set add-missing-on-start="false"
  3. tried to install demo & seed data by running "ant run-install" but could not make it work. I noticed that there is no table created under my schema.
   
  Previously I don't have such issue. Only with the latest OfBiz from SVN that I encountered this. I have looked at the instruction on how to run OfBiz 
   
  I have tried the following sequence few times but the problem persist:
  1. ant clean
  2. ant run-install 
   
  Are there any other changes required with the latest version of OfBiz?
   
  I have searched the Forum but nobody seems to have similar issue previously.
   
   
  Below is what I noticed in the console:
   
  [I noticed a number warnings]
   
       [java] 2007-06-22 13:39:23,703 (main) [    ModelViewEntity.java:461:WARN ] Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: statusDelay of view-entity ExampleStatusDetail
     [java] 2007-06-22 13:39:23,796 (main) [    ModelViewEntity.java:625:INFO ] Throwing out field alias in view entity InventoryItemAndLocation because one already exists with the alias name [facilityId] and field name [PR(Product).facilityId], existing field name is [II.facilityId]
     [java] 2007-06-22 13:39:23,796 (main) [    ModelViewEntity.java:625:INFO ] Throwing out field alias in view entity InventoryItemAndLocation because one already exists with the alias name [comments] and field name [PR(Product).comments], existing field name is [II.comments]
     [java] 2007-06-22 13:39:23,843 (main) [    ModelViewEntity.java:461:WARN ] Conversion for complex-alias needs to be implemented for cache and in-memory eval stuff to work correctly, will not work for alias: quantityOrdered of view-entity OrderItemQuantityReportGroupByItem
   
  [It is checking database]
  
     [java] 2007-06-22 13:39:24,437 (main) [   GenericDelegator.java:182:INFO ] Doing database check as requested in entityengine.xml with addMissing=false
     [java] 2007-06-22 13:39:24,812 (main) [       DatabaseUtil.java:760:INFO ] Database Product Name is MySQL
     [java] 2007-06-22 13:39:24,828 (main) [       DatabaseUtil.java:761:INFO ] Database Product Version is 5.0.17-nt
     [java] 2007-06-22 13:39:24,828 (main) [       DatabaseUtil.java:769:INFO ] Database Driver Name is MySQL-AB JDBC Driver
     [java] 2007-06-22 13:39:24,828 (main) [       DatabaseUtil.java:770:INFO ] Database Driver Version is mysql-connector-java-3.1.12 ( $Date: 2005-11-17 15:53:48 +0100 (Thu, 17 Nov 2005) $, $Revision$ )
   
  [Getting table info and give warnings:]
  
     [java] 2007-06-22 13:39:24,843 (main) [       DatabaseUtil.java:853:INFO ] Getting Table Info From Database
     [java] 2007-06-22 13:39:24,843 (main) [       DatabaseUtil.java:351:WARN ] Entity [AcctgTrans]has no table in the database
     [java] 2007-06-22 13:39:24,843 (main) [       DatabaseUtil.java:351:WARN ] Entity [AcctgTransAttribute] has no table in the database
     [java] 2007-06-22 13:39:24,843 (main) [       DatabaseUtil.java:351:WARN ] Entity [AcctgTransEntry] has no table in the database
   
   
  [Register Dispatcher]
   
  
     [java] 2007-06-22 13:39:25,437 (main) [  ServiceDispatcher.java:166:INFO ] Registered dispatcher: entity-default
     [java] 2007-06-22 13:39:25,500 (main) [ ModelServiceReader.java:208:INFO ] Loaded 47 Service definitions from file:/C:/MyAppl/OfBiz/framework/common/servicedef/services.xml
     [java] 2007-06-22 13:39:25,531 (main) [ ModelServiceReader.java:208:INFO ] Loaded 28 Service definitions from file:/C:/MyAppl/OfBiz/framework/common/servicedef/services_test.xml
   
  [It is loading data]
  
     [java] 2007-06-22 13:39:27,171 (main) [EntityDataLoadContainer.java:253:INFO ] =-=-=-=-=-=-= Doing a data load with the following files:
     [java] 2007-06-22 13:39:27,187 (main) [EntityDataLoadContainer.java:257:INFO ] file:/C:/MyAppl/OfBiz/framework/security/data/SecurityData.xml
     [java] 2007-06-22 13:39:27,187 (main) [EntityDataLoadContainer.java:257:INFO ] file:/C:/MyAppl/OfBiz/framework/common/data/CommonSecurityData.xml
   
  [Start loading data but failed causing transaction rollback]
  
     [java] 2007-06-22 13:39:27,250 (main) [EntityDataLoadContainer.java:260:INFO ] =-=-=-=-=-=-= Starting the data load...
     [java] 2007-06-22 13:39:27,265 (main) [    EntitySaxReader.java:195:INFO ] Beginning import from URL: file:/C:/MyAppl/OfBiz/framework/security/data/SecurityData.xml
     [java] 2007-06-22 13:39:27,281 (main) [    EntitySaxReader.java:233:INFO ] Transaction Timeoutset to 2 hours (7200 seconds)
     [java] 2007-06-22 13:39:27,296 (main) [   GenericDelegator.java:1131:ERROR]
     [java] ---- exception report ----------------------------------------------------------
     [java] Failure in storeAll operation: org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM SECURITY_GROUP WHERE GROUP_ID=? (Table 'ofbiz.security_group' doesn't exist). Rolling back transaction.
     [java] Exception: org.ofbiz.entity.GenericDataSourceException
     [java] Message: SQL Exception while executing the following:SELECT DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP FROM SECURITY_GROUP WHERE GROUP_ID=? (Table 'ofbiz.security_group' doesn't exist)
   
  Regards,
  Mathius Allo


 
---------------------------------
No need to miss a message. Get email on-the-go 
with Yahoo! Mail for Mobile. Get started.

Re: "ant run-install " failed to install demo & seed dat

Posted by Mathius Allo <mg...@yahoo.com>.
Hi Scott,
   
  Thanks for your quick reply.
   
  It works fine now.

  Regards,
  Mathius
  
Scott Gray <le...@gmail.com> wrote:
  Hi Mathius

set add-missing-on-start="false"

This tells ofbiz not to add missing tables change it to true and it should
work fine.

Regards
Scott

On 22/06/07, Mathius Allo wrote:
>
> Hi All,
>
> Just got the latest ofbiz yesterday from svn "co
> https://svn.apache.org/repos/asf/ofbiz/trunk ofbiz"
>
> What I did:
> 1. cleaned up mysql database by creating a new schema & user/password
> 2. updated entityengine.xml to use localmysql & set
> add-missing-on-start="false"
> 3. tried to install demo & seed data by running "ant run-install" but
> could not make it work. I noticed that there is no table created under my
> schema.
>
> Previously I don't have such issue. Only with the latest OfBiz from SVN
> that I encountered this. I have looked at the instruction on how to run
> OfBiz
>
> I have tried the following sequence few times but the problem persist:
> 1. ant clean
> 2. ant run-install
>
> Are there any other changes required with the latest version of OfBiz?
>
> I have searched the Forum but nobody seems to have similar issue
> previously.
>
>
> Below is what I noticed in the console:
>
> [I noticed a number warnings]
>
> [java] 2007-06-22 13:39:23,703 (main) [ ModelViewEntity.java:461:WARN
> ] Conversion for complex-alias needs to be implemented for cache and
> in-memory eval stuff to work correctly, will not work for alias: statusDelay
> of view-entity ExampleStatusDetail
> [java] 2007-06-22 13:39:23,796 (main) [ ModelViewEntity.java:625:INFO
> ] Throwing out field alias in view entity InventoryItemAndLocation because
> one already exists with the alias name [facilityId] and field name
> [PR(Product).facilityId], existing field name is [II.facilityId]
> [java] 2007-06-22 13:39:23,796 (main) [ ModelViewEntity.java:625:INFO
> ] Throwing out field alias in view entity InventoryItemAndLocation because
> one already exists with the alias name [comments] and field name
> [PR(Product).comments], existing field name is [II.comments]
> [java] 2007-06-22 13:39:23,843 (main) [ ModelViewEntity.java:461:WARN
> ] Conversion for complex-alias needs to be implemented for cache and
> in-memory eval stuff to work correctly, will not work for alias:
> quantityOrdered of view-entity OrderItemQuantityReportGroupByItem
>
> [It is checking database]
>
> [java] 2007-06-22 13:39:24,437 (main) [ GenericDelegator.java:182:INFO
> ] Doing database check as requested in entityengine.xml with
> addMissing=false
> [java] 2007-06-22 13:39:24,812 (main) [ DatabaseUtil.java:760:INFO
> ] Database Product Name is MySQL
> [java] 2007-06-22 13:39:24,828 (main) [ DatabaseUtil.java:761:INFO
> ] Database Product Version is 5.0.17-nt
> [java] 2007-06-22 13:39:24,828 (main) [ DatabaseUtil.java:769:INFO
> ] Database Driver Name is MySQL-AB JDBC Driver
> [java] 2007-06-22 13:39:24,828 (main) [ DatabaseUtil.java:770:INFO
> ] Database Driver Version is mysql-connector-java-3.1.12 ( $Date:
> 2005-11-17 15:53:48 +0100 (Thu, 17 Nov 2005) $, $Revision$ )
>
> [Getting table info and give warnings:]
>
> [java] 2007-06-22 13:39:24,843 (main) [ DatabaseUtil.java:853:INFO
> ] Getting Table Info From Database
> [java] 2007-06-22 13:39:24,843 (main) [ DatabaseUtil.java:351:WARN
> ] Entity [AcctgTrans]has no table in the database
> [java] 2007-06-22 13:39:24,843 (main) [ DatabaseUtil.java:351:WARN
> ] Entity [AcctgTransAttribute] has no table in the database
> [java] 2007-06-22 13:39:24,843 (main) [ DatabaseUtil.java:351:WARN
> ] Entity [AcctgTransEntry] has no table in the database
>
>
> [Register Dispatcher]
>
>
> [java] 2007-06-22 13:39:25,437 (main) [ ServiceDispatcher.java:166:INFO
> ] Registered dispatcher: entity-default
> [java] 2007-06-22 13:39:25,500 (main) [ ModelServiceReader.java:208:INFO
> ] Loaded 47 Service definitions from
> file:/C:/MyAppl/OfBiz/framework/common/servicedef/services.xml
> [java] 2007-06-22 13:39:25,531 (main) [ ModelServiceReader.java:208:INFO
> ] Loaded 28 Service definitions from
> file:/C:/MyAppl/OfBiz/framework/common/servicedef/services_test.xml
>
> [It is loading data]
>
> [java] 2007-06-22 13:39:27,171 (main) [EntityDataLoadContainer.java:253:INFO
> ] =-=-=-=-=-=-= Doing a data load with the following files:
> [java] 2007-06-22 13:39:27,187 (main) [EntityDataLoadContainer.java:257:INFO
> ] file:/C:/MyAppl/OfBiz/framework/security/data/SecurityData.xml
> [java] 2007-06-22 13:39:27,187 (main) [EntityDataLoadContainer.java:257:INFO
> ] file:/C:/MyAppl/OfBiz/framework/common/data/CommonSecurityData.xml
>
> [Start loading data but failed causing transaction rollback]
>
> [java] 2007-06-22 13:39:27,250 (main) [EntityDataLoadContainer.java:260:INFO
> ] =-=-=-=-=-=-= Starting the data load...
> [java] 2007-06-22 13:39:27,265 (main) [ EntitySaxReader.java:195:INFO
> ] Beginning import from URL:
> file:/C:/MyAppl/OfBiz/framework/security/data/SecurityData.xml
> [java] 2007-06-22 13:39:27,281 (main) [ EntitySaxReader.java:233:INFO
> ] Transaction Timeoutset to 2 hours (7200 seconds)
> [java] 2007-06-22 13:39:27,296 (main) [ GenericDelegator.java
> :1131:ERROR]
> [java] ---- exception report
> ----------------------------------------------------------
> [java] Failure in storeAll operation:
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
> the following:SELECT DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP FROM SECURITY_GROUP WHERE GROUP_ID=? (Table
> 'ofbiz.security_group' doesn't exist). Rolling back transaction.
> [java] Exception: org.ofbiz.entity.GenericDataSourceException
> [java] Message: SQL Exception while executing the following:SELECT
> DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
> CREATED_TX_STAMP FROM SECURITY_GROUP WHERE GROUP_ID=? (Table '
> ofbiz.security_group' doesn't exist)
>
> Regards,
> Mathius Allo
>
>
>
> ---------------------------------
> No need to miss a message. Get email on-the-go
> with Yahoo! Mail for Mobile. Get started.


       
---------------------------------
Get the Yahoo! toolbar and be alerted to new email wherever you're surfing.

Re: "ant run-install " failed to install demo & seed dat

Posted by Scott Gray <le...@gmail.com>.
Hi Mathius

set add-missing-on-start="false"

This tells ofbiz not to add missing tables change it to true and it should
work fine.

Regards
Scott

On 22/06/07, Mathius Allo <mg...@yahoo.com> wrote:
>
> Hi All,
>
>   Just got the latest ofbiz yesterday from svn "co
> https://svn.apache.org/repos/asf/ofbiz/trunk ofbiz"
>
>   What I did:
>   1. cleaned up mysql database by creating a new schema & user/password
>   2. updated entityengine.xml to use localmysql & set
> add-missing-on-start="false"
>   3. tried to install demo & seed data by running "ant run-install" but
> could not make it work. I noticed that there is no table created under my
> schema.
>
>   Previously I don't have such issue. Only with the latest OfBiz from SVN
> that I encountered this. I have looked at the instruction on how to run
> OfBiz
>
>   I have tried the following sequence few times but the problem persist:
>   1. ant clean
>   2. ant run-install
>
>   Are there any other changes required with the latest version of OfBiz?
>
>   I have searched the Forum but nobody seems to have similar issue
> previously.
>
>
>   Below is what I noticed in the console:
>
>   [I noticed a number warnings]
>
>        [java] 2007-06-22 13:39:23,703 (main) [    ModelViewEntity.java:461:WARN
> ] Conversion for complex-alias needs to be implemented for cache and
> in-memory eval stuff to work correctly, will not work for alias: statusDelay
> of view-entity ExampleStatusDetail
>      [java] 2007-06-22 13:39:23,796 (main) [    ModelViewEntity.java:625:INFO
> ] Throwing out field alias in view entity InventoryItemAndLocation because
> one already exists with the alias name [facilityId] and field name
> [PR(Product).facilityId], existing field name is [II.facilityId]
>      [java] 2007-06-22 13:39:23,796 (main) [    ModelViewEntity.java:625:INFO
> ] Throwing out field alias in view entity InventoryItemAndLocation because
> one already exists with the alias name [comments] and field name
> [PR(Product).comments], existing field name is [II.comments]
>      [java] 2007-06-22 13:39:23,843 (main) [    ModelViewEntity.java:461:WARN
> ] Conversion for complex-alias needs to be implemented for cache and
> in-memory eval stuff to work correctly, will not work for alias:
> quantityOrdered of view-entity OrderItemQuantityReportGroupByItem
>
>   [It is checking database]
>
>      [java] 2007-06-22 13:39:24,437 (main) [   GenericDelegator.java:182:INFO
> ] Doing database check as requested in entityengine.xml with
> addMissing=false
>      [java] 2007-06-22 13:39:24,812 (main) [       DatabaseUtil.java:760:INFO
> ] Database Product Name is MySQL
>      [java] 2007-06-22 13:39:24,828 (main) [       DatabaseUtil.java:761:INFO
> ] Database Product Version is 5.0.17-nt
>      [java] 2007-06-22 13:39:24,828 (main) [       DatabaseUtil.java:769:INFO
> ] Database Driver Name is MySQL-AB JDBC Driver
>      [java] 2007-06-22 13:39:24,828 (main) [       DatabaseUtil.java:770:INFO
> ] Database Driver Version is mysql-connector-java-3.1.12 ( $Date:
> 2005-11-17 15:53:48 +0100 (Thu, 17 Nov 2005) $, $Revision$ )
>
>   [Getting table info and give warnings:]
>
>      [java] 2007-06-22 13:39:24,843 (main) [       DatabaseUtil.java:853:INFO
> ] Getting Table Info From Database
>      [java] 2007-06-22 13:39:24,843 (main) [       DatabaseUtil.java:351:WARN
> ] Entity [AcctgTrans]has no table in the database
>      [java] 2007-06-22 13:39:24,843 (main) [       DatabaseUtil.java:351:WARN
> ] Entity [AcctgTransAttribute] has no table in the database
>      [java] 2007-06-22 13:39:24,843 (main) [       DatabaseUtil.java:351:WARN
> ] Entity [AcctgTransEntry] has no table in the database
>
>
>   [Register Dispatcher]
>
>
>      [java] 2007-06-22 13:39:25,437 (main) [  ServiceDispatcher.java:166:INFO
> ] Registered dispatcher: entity-default
>      [java] 2007-06-22 13:39:25,500 (main) [ ModelServiceReader.java:208:INFO
> ] Loaded 47 Service definitions from
> file:/C:/MyAppl/OfBiz/framework/common/servicedef/services.xml
>      [java] 2007-06-22 13:39:25,531 (main) [ ModelServiceReader.java:208:INFO
> ] Loaded 28 Service definitions from
> file:/C:/MyAppl/OfBiz/framework/common/servicedef/services_test.xml
>
>   [It is loading data]
>
>      [java] 2007-06-22 13:39:27,171 (main) [EntityDataLoadContainer.java:253:INFO
> ] =-=-=-=-=-=-= Doing a data load with the following files:
>      [java] 2007-06-22 13:39:27,187 (main) [EntityDataLoadContainer.java:257:INFO
> ] file:/C:/MyAppl/OfBiz/framework/security/data/SecurityData.xml
>      [java] 2007-06-22 13:39:27,187 (main) [EntityDataLoadContainer.java:257:INFO
> ] file:/C:/MyAppl/OfBiz/framework/common/data/CommonSecurityData.xml
>
>   [Start loading data but failed causing transaction rollback]
>
>      [java] 2007-06-22 13:39:27,250 (main) [EntityDataLoadContainer.java:260:INFO
> ] =-=-=-=-=-=-= Starting the data load...
>      [java] 2007-06-22 13:39:27,265 (main) [    EntitySaxReader.java:195:INFO
> ] Beginning import from URL:
> file:/C:/MyAppl/OfBiz/framework/security/data/SecurityData.xml
>      [java] 2007-06-22 13:39:27,281 (main) [    EntitySaxReader.java:233:INFO
> ] Transaction Timeoutset to 2 hours (7200 seconds)
>      [java] 2007-06-22 13:39:27,296 (main) [   GenericDelegator.java
> :1131:ERROR]
>      [java] ---- exception report
> ----------------------------------------------------------
>      [java] Failure in storeAll operation:
> org.ofbiz.entity.GenericDataSourceException: SQL Exception while executing
> the following:SELECT DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP,
> CREATED_STAMP, CREATED_TX_STAMP FROM SECURITY_GROUP WHERE GROUP_ID=? (Table
> 'ofbiz.security_group' doesn't exist). Rolling back transaction.
>      [java] Exception: org.ofbiz.entity.GenericDataSourceException
>      [java] Message: SQL Exception while executing the following:SELECT
> DESCRIPTION, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP,
> CREATED_TX_STAMP FROM SECURITY_GROUP WHERE GROUP_ID=? (Table '
> ofbiz.security_group' doesn't exist)
>
>   Regards,
>   Mathius Allo
>
>
>
> ---------------------------------
> No need to miss a message. Get email on-the-go
> with Yahoo! Mail for Mobile. Get started.