Hi Scott, Thanks for your quick reply. It works fine now. Regards, Mathius Scott Gray <[EMAIL PROTECTED]> 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.
