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 <[EMAIL PROTECTED]> 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.
