Demo Supplier removed ?

[Gil Portenseigne]

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

[David E Jones-3]

Sorry about that, it should be fixed in SVN rev 764074.

-David


On Apr 10, 2009, at 9:46 AM, gil portenseigne wrote:

> 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