Ofbiz Initial setup Errors with seed data in Ofbiz 14.12.

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
4 messages Options
Reply | Threaded
Open this post in threaded view
|

Ofbiz Initial setup Errors with seed data in Ofbiz 14.12.

mandeepmavi
Hi Friends, I am facing some error while doing initial setup using seed data in 14.12. Almost everywhere.
Able to create New-Organization , Facility and Catalog, But not  Product Store, First Customer and Category.

For Category i got error.

The Following Errors Occurred:
Exception thrown while creating the "newEntity" GenericValue: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCategory][categoryName,testCATALOG Promotions(java.lang.String)][createdStamp,2015-05-15 17:52:59.746(java.sql.Timestamp)][createdTxStamp,2015-05-15 17:52:59.623(java.sql.Timestamp)][detailScreen,component://ecommerce/widget/CatalogScreens.xml#categorydetailmatrix(java.lang.String)][lastUpdatedStamp,2015-05-15 17:52:59.746(java.sql.Timestamp)][lastUpdatedTxStamp,2015-05-15 17:52:59.623(java.sql.Timestamp)][productCategoryId,testCATALOG_PROMOTIONS(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(20))) (Error while inserting: [GenericEntity:ProductCategory][categoryName,testCATALOG Promotions(java.lang.String)][createdStamp,2015-05-15 17:52:59.746(java.sql.Timestamp)][createdTxStamp,2015-05-15 17:52:59.623(java.sql.Timestamp)][detailScreen,component://ecommerce/widget/CatalogScreens.xml#categorydetailmatrix(java.lang.String)][lastUpdatedStamp,2015-05-15 17:52:59.746(java.sql.Timestamp)][lastUpdatedTxStamp,2015-05-15 17:52:59.623(java.sql.Timestamp)][productCategoryId,testCATALOG_PROMOTIONS(java.lang.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: value too long for type character varying(20))))
D
Reply | Threaded
Open this post in threaded view
|

Re: Ofbiz Initial setup Errors with seed data in Ofbiz 14.12.

D
Even Trunk is giving same error
Reply | Threaded
Open this post in threaded view
|

Re: Ofbiz Initial setup Errors with seed data in Ofbiz 14.12.

mandeepmavi
Hi Friends,
for initial setup using seed data, its working upto Website , But First Customer is still giving error.


         |E| Request createCustomer caused an error with the following message:
Error:ERROR: Could not complete the Create a PostalAddress for party [file:/C:/h
wca/applications/party/script/org/ofbiz/party/contact/PartyContactMechServices.x
ml#createPartyPostalAddress] process [problem invoking the [createPostalAddress]
 service with the map named [createPostalAddressMap] containing [{postalCode=V1B
7K7, toName=Mandeep  Mavi, countryGeoId=CAN, locale=en_CA, address1=1, stateProv
inceGeoId=Y, address2=null, userLogin=[GenericEntity:UserLogin][createdStamp,201
5-05-16 15:42:53.631(java.sql.Timestamp)][createdTxStamp,2015-05-16 15:42:51.672
(java.sql.Timestamp)][currentPassword,{SHA}6506ccb0642a62259dec9e43d11a44d0f83bd
c6a(java.lang.String)][lastUpdatedStamp,2015-05-16 15:42:53.631(java.sql.Timesta
mp)][lastUpdatedTxStamp,2015-05-16 15:42:51.672(java.sql.Timestamp)][partyId,CUS
T(java.lang.String)][userLoginId,mmavi(java.lang.String)], city=Vancouv
er}]: Outgoing result (in runSync : createPostalAddress) does not match expected
 requirements (The following required parameter is missing: [OUT] [createPostalA
ddress.contactMechId])]
Reply | Threaded
Open this post in threaded view
|

Re: Ofbiz Initial setup Errors with seed data in Ofbiz 14.12.

mandeepmavi
Initial Category setup is giving error with seed data. I am able to create Catalog.

|E| Request createProductCategory caused an error with the following me
ssage: [Exception thrown while creating the "newEntity" GenericValue: org.ofbiz.
entity.GenericEntityException: Error while inserting: [GenericEntity:ProductCate
gory][categoryName,ECATALOG Promotions(java.lang.String)][createdStamp,201
5-05-16 19:26:32.091(java.sql.Timestamp)][createdTxStamp,2015-05-16 19:26:31.962
(java.sql.Timestamp)][detailScreen,component://ecommerce/widget/CatalogScreens.x
ml#categorydetailmatrix(java.lang.String)][lastUpdatedStamp,2015-05-16 19:26:32.
091(java.sql.Timestamp)][lastUpdatedTxStamp,2015-05-16 19:26:31.962(java.sql.Tim
estamp)][productCategoryId,ECATALOG_PROMOTIONS(java.lang.String)][productC
ategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Exception while executing
 the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_CATEGORY_ID, PRODUCT
_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME, DESCRIPTION, LONG_
DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO_IMAGE_URL, DETAIL_
SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP
, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR:
 value too long for type character varying(20))) (Error while inserting: [Generi
cEntity:ProductCategory][categoryName,ECATALOG Promotions(java.lang.String
)][createdStamp,2015-05-16 19:26:32.091(java.sql.Timestamp)][createdTxStamp,2015
-05-16 19:26:31.962(java.sql.Timestamp)][detailScreen,component://ecommerce/widg
et/CatalogScreens.xml#categorydetailmatrix(java.lang.String)][lastUpdatedStamp,2
015-05-16 19:26:32.091(java.sql.Timestamp)][lastUpdatedTxStamp,2015-05-16 19:26:
31.962(java.sql.Timestamp)][productCategoryId,ECATALOG_PROMOTIONS(java.lan
g.String)][productCategoryTypeId,CATALOG_CATEGORY(java.lang.String)] (SQL Except
ion while executing the following:INSERT INTO public.PRODUCT_CATEGORY (PRODUCT_C
ATEGORY_ID, PRODUCT_CATEGORY_TYPE_ID, PRIMARY_PARENT_CATEGORY_ID, CATEGORY_NAME,
 DESCRIPTION, LONG_DESCRIPTION, CATEGORY_IMAGE_URL, LINK_ONE_IMAGE_URL, LINK_TWO
_IMAGE_URL, DETAIL_SCREEN, SHOW_IN_SELECT, LAST_UPDATED_STAMP, LAST_UPDATED_TX_S
TAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?) (ERROR: value too long for type character varying(20))))]