You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ofbiz.apache.org by gil portenseigne <gi...@nereide.fr> on 2009/04/10 17:46:20 UTC
Demo Supplier removed ?
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
Re: Demo Supplier removed ?
Posted by David E Jones <da...@hotwaxmedia.com>.
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