Hi, While testing ofbiz, i found out that the Demo Supplier was removed...
I haven't seen anything about this removal which occured several hours ago... So i looked for an error in the log of my "ant run-install" and found that : 009-04-10 15:10:09,959 (main) [ EntitySaxReader.java:217:INFO ] Beginning import from URL: file:/home/lazorus/Ofbiz_workspace/ofbiz/applications/order/data/OrderTypeData.xml 2009-04-10 15:10:09,968 (main) [ EntitySaxReader.java:255:INFO ] Transaction Timeout set to 2 hours (7200 seconds) 2009-04-10 15:10:11,880 (main) [ GenericDelegator.java:812:ERROR] ---- exception report ---------------------------------------------------------- Failure in create operation for entity [WebSite]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:WebSite][createdStamp,2009-04-10 15:10:11.825(java.sql.Timestamp)][createdTxStamp,2009-04-10 15:10:09.96(java.sql.Timestamp)][lastUpdatedStamp,2009-04-10 15:10:11.825(java.sql.Timestamp)][lastUpdatedTxStamp,2009-04-10 15:10:09.96(java.sql.Timestamp)][productStoreId,9000(java.lang.String)] [siteName,Order Entry Web Site(java.lang.String)] [visualThemeSetId,BACKOFFICE(java.lang.String)] [webSiteId,OrderEntry(java.lang.String)] (SQL Exception while executing the following:INSERT INTO OFBIZ.WEB_SITE (WEB_SITE_ID, SITE_NAME, HTTP_HOST, HTTP_PORT, HTTPS_HOST, HTTPS_PORT, ENABLE_HTTPS, STANDARD_CONTENT_PREFIX, SECURE_CONTENT_PREFIX, COOKIE_DOMAIN, VISUAL_THEME_SET_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP, PRODUCT_STORE_ID, ALLOW_PRODUCT_STORE_CHANGE) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'WEB_SITE' caused a violation of foreign key constraint 'WEB_SITE_PRDS' for key (9000). The statement has been rolled back.)). Rolling back transaction. Exception: org.ofbiz.entity.GenericEntityException Indeed i look in : ofbiz/trunk/applications/order/data/OrderTypeData.xml And find the problem with the key 9000 creating the foreign key violation : <WebSite webSiteId="OrderEntry" siteName="Order Entry Web Site" productStoreId="9000" visualThemeSetId="BACKOFFICE"/> This one create a violation because it is inserted in the database before the productStore Table during the run-install (verified in log). I don't have enough experience in ofbiz to propose something... Waiting for your reactions, thanks, gil
