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)))) |
Even Trunk is giving same error
|
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])] |
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))))] |
Free forum by Nabble | Edit this page |