[jira] Created: (OFBIZ-1399) Cannot create a category for a catalog
Locked
[jira] Created: (OFBIZ-1399) Cannot create a category for a catalog
 
|
Cannot create a category for a catalog
-------------------------------------- Key: OFBIZ-1399 URL: https://issues.apache.org/jira/browse/OFBIZ-1399 Project: OFBiz Issue Type: Bug Components: framework Affects Versions: SVN trunk Environment: OpenSuse 10.3 Eclipse3.3 SVN trunk sources downloaded on Nov 12,2007 java version "1.6.0_03" Java(TM) SE Runtime Environment (build 1.6.0_03-b05) Java HotSpot(TM) Client VM (build 1.6.0_03-b05, mixed mode) Reporter: Yin T goto https://localhost:8443/catalog/control/main click "Catalog" menuitem in application bar. create new catalog. associated new catalog with "OFBiz E-Commerce Store" create new product category Received the following error message on the page... The Following Errors Occurred: ERROR: Could not complete the Add Category To ProdCatalog [file:/home/wt5/wteclipse-workspace/ofbiz/applications/product/script/org/ofbiz/product/catalog/CatalogServices.xml#addProductCategoryToProdCatalog] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ProdCatalogCategory][createdStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][createdTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][fromDate,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][prodCatalogCategoryTypeId,PCCT_ADMIN_ALLW(java.lang.String)][prodCatalogId,wt-catalog1-id(java.lang.String)][productCategoryId,wt-catalog1-category1-id(java.lang.String)][sequenceNum,null()][thruDate,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PROD_CATALOG_CATEGORY (PROD_CATALOG_ID, PRODUCT_CATEGORY_ID, PROD_CATALOG_CATEGORY_TYPE_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'wt-catalog1-category1-id' to length 20.))] -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-1399) Cannot create a category for a catalog
|
|
[ https://issues.apache.org/jira/browse/OFBIZ-1399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12541908 ] Walter Vaughan commented on OFBIZ-1399: --------------------------------------- You already identifed the problem... it's in your category name. There is a limit the the length of the category name... I belive 20 characters from your error message <...> A truncation error was encountered trying to shrink VARCHAR 'wt-catalog1-category1-id' to length 20 <..> Fixable, but not a bug. > Cannot create a category for a catalog > -------------------------------------- > > Key: OFBIZ-1399 > URL: https://issues.apache.org/jira/browse/OFBIZ-1399 > Project: OFBiz > Issue Type: Bug > Components: framework > Affects Versions: SVN trunk > Environment: OpenSuse 10.3 > Eclipse3.3 > SVN trunk sources downloaded on Nov 12,2007 > java version "1.6.0_03" > Java(TM) SE Runtime Environment (build 1.6.0_03-b05) > Java HotSpot(TM) Client VM (build 1.6.0_03-b05, mixed mode) > Reporter: Yin T > > goto https://localhost:8443/catalog/control/main > click "Catalog" menuitem in application bar. > create new catalog. > associated new catalog with "OFBiz E-Commerce Store" > create new product category > Received the following error message on the page... > The Following Errors Occurred: > ERROR: Could not complete the Add Category To ProdCatalog [file:/home/wt5/wteclipse-workspace/ofbiz/applications/product/script/org/ofbiz/product/catalog/CatalogServices.xml#addProductCategoryToProdCatalog] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ProdCatalogCategory][createdStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][createdTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][fromDate,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][prodCatalogCategoryTypeId,PCCT_ADMIN_ALLW(java.lang.String)][prodCatalogId,wt-catalog1-id(java.lang.String)][productCategoryId,wt-catalog1-category1-id(java.lang.String)][sequenceNum,null()][thruDate,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PROD_CATALOG_CATEGORY (PROD_CATALOG_ID, PRODUCT_CATEGORY_ID, PROD_CATALOG_CATEGORY_TYPE_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'wt-catalog1-category1-id' to length 20.))] -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
Re: [jira] Created: (OFBIZ-1399) Cannot create a category for a catalog
|
|
In reply to this post by Nicolas Malin (Jira)
the length of the
<field-type-def type="id-ne" sql-type="VARCHAR(20)" java-type="String"><validate method="isNotEmpty" /></field-type-def> is defined in the field type for each dB. it is best not to change this unless you know you db and how it would effect other fields in the entity. however this is not a bug Yin T (JIRA) sent the following on 11/12/2007 10:43 AM: > Cannot create a category for a catalog > -------------------------------------- > > Key: OFBIZ-1399 > URL: https://issues.apache.org/jira/browse/OFBIZ-1399 > Project: OFBiz > Issue Type: Bug > Components: framework > Affects Versions: SVN trunk > Environment: OpenSuse 10.3 > Eclipse3.3 > SVN trunk sources downloaded on Nov 12,2007 > > java version "1.6.0_03" > Java(TM) SE Runtime Environment (build 1.6.0_03-b05) > Java HotSpot(TM) Client VM (build 1.6.0_03-b05, mixed mode) > > > Reporter: Yin T > > > goto https://localhost:8443/catalog/control/main > > click "Catalog" menuitem in application bar. > create new catalog. > associated new catalog with "OFBiz E-Commerce Store" > create new product category > > Received the following error message on the page... > > The Following Errors Occurred: > > ERROR: Could not complete the Add Category To ProdCatalog [file:/home/wt5/wteclipse-workspace/ofbiz/applications/product/script/org/ofbiz/product/catalog/CatalogServices.xml#addProductCategoryToProdCatalog] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ProdCatalogCategory][createdStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][createdTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][fromDate,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][prodCatalogCategoryTypeId,PCCT_ADMIN_ALLW(java.lang.String)][prodCatalogId,wt-catalog1-id(java.lang.String)][productCategoryId,wt-catalog1-category1-id(java.lang.String)][sequenceNum,null()][thruDate,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PROD_CATALOG_CATEGORY (PROD_CATALOG_ID, PRODUCT_CATEGORY_ID, PROD_CATALOG_CATEGORY_TYPE_ID, FROM_DATE, THRU > > |
[jira] Commented: (OFBIZ-1399) Cannot create a category for a catalog
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12541965 ] Yin T commented on OFBIZ-1399: ------------------------------ I tried to use a different category name that is much shorter than 20 characters. It is still giving me an error message. When I try to create a new category with a shorter category id, error message is shown following... The Following Errors Occurred: ERROR: Could not complete the Add Category To ProdCatalog [file:/C:/Documents%20and%20Settings/wt/My%20Documents/MyEclipse/workspace/ofbiz/applications/product/script/org/ofbiz/product/catalog/CatalogServices.xml#addProductCategoryToProdCatalog] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ProdCatalogCategory][createdStamp,2007-11-12 17:11:58.62(java.sql.Timestamp)][createdTxStamp,2007-11-12 17:11:58.549(java.sql.Timestamp)][fromDate,2007-11-12 17:11:58.62(java.sql.Timestamp)][lastUpdatedStamp,2007-11-12 17:11:58.62(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-12 17:11:58.549(java.sql.Timestamp)][prodCatalogCategoryTypeId,PCCT_ADMIN_ALLW(java.lang.String)][prodCatalogId,wt-catalog1-id(java.lang.String)][productCategoryId,wtcatg1_id(java.lang.String)][sequenceNum,null()][thruDate,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PROD_CATALOG_CATEGORY (PROD_CATALOG_ID, PRODUCT_CATEGORY_ID, PROD_CATALOG_CATEGORY_TYPE_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (INSERT on table 'PROD_CATALOG_CATEGORY' caused a violation of foreign key constraint 'PROD_CC_CATEGORY' for key (wtcatg1_id). The statement has been rolled back.))] > Cannot create a category for a catalog > -------------------------------------- > > Key: OFBIZ-1399 > URL: https://issues.apache.org/jira/browse/OFBIZ-1399 > Project: OFBiz > Issue Type: Bug > Components: framework > Affects Versions: SVN trunk > Environment: OpenSuse 10.3 > Eclipse3.3 > SVN trunk sources downloaded on Nov 12,2007 > java version "1.6.0_03" > Java(TM) SE Runtime Environment (build 1.6.0_03-b05) > Java HotSpot(TM) Client VM (build 1.6.0_03-b05, mixed mode) > Reporter: Yin T > > goto https://localhost:8443/catalog/control/main > click "Catalog" menuitem in application bar. > create new catalog. > associated new catalog with "OFBiz E-Commerce Store" > create new product category > Received the following error message on the page... > The Following Errors Occurred: > ERROR: Could not complete the Add Category To ProdCatalog [file:/home/wt5/wteclipse-workspace/ofbiz/applications/product/script/org/ofbiz/product/catalog/CatalogServices.xml#addProductCategoryToProdCatalog] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ProdCatalogCategory][createdStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][createdTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][fromDate,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][prodCatalogCategoryTypeId,PCCT_ADMIN_ALLW(java.lang.String)][prodCatalogId,wt-catalog1-id(java.lang.String)][productCategoryId,wt-catalog1-category1-id(java.lang.String)][sequenceNum,null()][thruDate,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PROD_CATALOG_CATEGORY (PROD_CATALOG_ID, PRODUCT_CATEGORY_ID, PROD_CATALOG_CATEGORY_TYPE_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'wt-catalog1-category1-id' to length 20.))] -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
Re: [jira] Commented: (OFBIZ-1399) Cannot create a category for a catalog
|
|
there error does not deal with length issures. again this not a bug.
https://localhost:8443/webtools/control/ViewRelations?entityName=ProdCatalogCategory see the FK PROD_CC_CATEGORY. Yin T (JIRA) sent the following on 11/12/2007 2:29 PM: > [ https://issues.apache.org/jira/browse/OFBIZ-1399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12541965 ] > > Yin T commented on OFBIZ-1399: > ------------------------------ > > I tried to use a different category name that is much shorter than 20 characters. It is still giving me an error message. > When I try to create a new category with a shorter category id, error message is shown following... > > The Following Errors Occurred: > > ERROR: Could not complete the Add Category To ProdCatalog [file:/C:/Documents%20and%20Settings/wt/My%20Documents/MyEclipse/workspace/ofbiz/applications/product/script/org/ofbiz/product/catalog/CatalogServices.xml#addProductCategoryToProdCatalog] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ProdCatalogCategory][createdStamp,2007-11-12 17:11:58.62(java.sql.Timestamp)][createdTxStamp,2007-11-12 17:11:58.549(java.sql.Timestamp)][fromDate,2007-11-12 17:11:58.62(java.sql.Timestamp)][lastUpdatedStamp,2007-11-12 17:11:58.62(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-12 17:11:58.549(java.sql.Timestamp)][prodCatalogCategoryTypeId,PCCT_ADMIN_ALLW(java.lang.String)][prodCatalogId,wt-catalog1-id(java.lang.String)][productCategoryId,wtcatg1_id(java.lang.String)][sequenceNum,null()][thruDate,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PROD_CATALOG_CATEGORY (PROD_CATALOG_ID, PRODUCT_CATEGORY_ID, PROD_CATALOG_CATEGORY_ > > >> Cannot create a category for a catalog >> -------------------------------------- >> >> Key: OFBIZ-1399 >> URL: https://issues.apache.org/jira/browse/OFBIZ-1399 >> Project: OFBiz >> Issue Type: Bug >> Components: framework >> Affects Versions: SVN trunk >> Environment: OpenSuse 10.3 >> Eclipse3.3 >> SVN trunk sources downloaded on Nov 12,2007 >> java version "1.6.0_03" >> Java(TM) SE Runtime Environment (build 1.6.0_03-b05) >> Java HotSpot(TM) Client VM (build 1.6.0_03-b05, mixed mode) >> Reporter: Yin T >> >> goto https://localhost:8443/catalog/control/main >> click "Catalog" menuitem in application bar. >> create new catalog. >> associated new catalog with "OFBiz E-Commerce Store" >> create new product category >> Received the following error message on the page... >> The Following Errors Occurred: >> ERROR: Could not complete the Add Category To ProdCatalog [file:/home/wt5/wteclipse-workspace/ofbiz/applications/product/script/org/ofbiz/product/catalog/CatalogServices.xml#addProductCategoryToProdCatalog] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ProdCatalogCategory][createdStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][createdTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][fromDate,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][prodCatalogCategoryTypeId,PCCT_ADMIN_ALLW(java.lang.String)][prodCatalogId,wt-catalog1-id(java.lang.String)][productCategoryId,wt-catalog1-category1-id(java.lang.String)][sequenceNum,null()][thruDate,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PROD_CATALOG_CATEGORY (PROD_CATALOG_ID, PRODUCT_CATEGORY_ID, PROD_CATALOG_CATEGORY_TYPE_ID, FROM_DATE, THR > |
[jira] Closed: (OFBIZ-1399) Cannot create a category for a catalog
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1399?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Le Roux closed OFBIZ-1399. ---------------------------------- Resolution: Invalid Fix Version/s: SVN trunk Assignee: Jacques Le Roux As BJ already answered "caused a violation of foreign key constraint" is not a bug. Are you using special characters ? Please use user ML for such issues which are obiously not bugs (ok, when 1st saw entity engine eror messages are not so obvious) > Cannot create a category for a catalog > -------------------------------------- > > Key: OFBIZ-1399 > URL: https://issues.apache.org/jira/browse/OFBIZ-1399 > Project: OFBiz > Issue Type: Bug > Components: framework > Affects Versions: SVN trunk > Environment: OpenSuse 10.3 > Eclipse3.3 > SVN trunk sources downloaded on Nov 12,2007 > java version "1.6.0_03" > Java(TM) SE Runtime Environment (build 1.6.0_03-b05) > Java HotSpot(TM) Client VM (build 1.6.0_03-b05, mixed mode) > Reporter: Yin T > Assignee: Jacques Le Roux > Fix For: SVN trunk > > > goto https://localhost:8443/catalog/control/main > click "Catalog" menuitem in application bar. > create new catalog. > associated new catalog with "OFBiz E-Commerce Store" > create new product category > Received the following error message on the page... > The Following Errors Occurred: > ERROR: Could not complete the Add Category To ProdCatalog [file:/home/wt5/wteclipse-workspace/ofbiz/applications/product/script/org/ofbiz/product/catalog/CatalogServices.xml#addProductCategoryToProdCatalog] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ProdCatalogCategory][createdStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][createdTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][fromDate,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][prodCatalogCategoryTypeId,PCCT_ADMIN_ALLW(java.lang.String)][prodCatalogId,wt-catalog1-id(java.lang.String)][productCategoryId,wt-catalog1-category1-id(java.lang.String)][sequenceNum,null()][thruDate,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PROD_CATALOG_CATEGORY (PROD_CATALOG_ID, PRODUCT_CATEGORY_ID, PROD_CATALOG_CATEGORY_TYPE_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'wt-catalog1-category1-id' to length 20.))] -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-1399) Cannot create a category for a catalog
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12542185 ] Scott Gray commented on OFBIZ-1399: ----------------------------------- Hi Jacques There is probably a small bug in that we should set the maxlength attribute to 20 for the field that takes the category id. > Cannot create a category for a catalog > -------------------------------------- > > Key: OFBIZ-1399 > URL: https://issues.apache.org/jira/browse/OFBIZ-1399 > Project: OFBiz > Issue Type: Bug > Components: framework > Affects Versions: SVN trunk > Environment: OpenSuse 10.3 > Eclipse3.3 > SVN trunk sources downloaded on Nov 12,2007 > java version "1.6.0_03" > Java(TM) SE Runtime Environment (build 1.6.0_03-b05) > Java HotSpot(TM) Client VM (build 1.6.0_03-b05, mixed mode) > Reporter: Yin T > Assignee: Jacques Le Roux > Fix For: SVN trunk > > > goto https://localhost:8443/catalog/control/main > click "Catalog" menuitem in application bar. > create new catalog. > associated new catalog with "OFBiz E-Commerce Store" > create new product category > Received the following error message on the page... > The Following Errors Occurred: > ERROR: Could not complete the Add Category To ProdCatalog [file:/home/wt5/wteclipse-workspace/ofbiz/applications/product/script/org/ofbiz/product/catalog/CatalogServices.xml#addProductCategoryToProdCatalog] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ProdCatalogCategory][createdStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][createdTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][fromDate,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][prodCatalogCategoryTypeId,PCCT_ADMIN_ALLW(java.lang.String)][prodCatalogId,wt-catalog1-id(java.lang.String)][productCategoryId,wt-catalog1-category1-id(java.lang.String)][sequenceNum,null()][thruDate,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PROD_CATALOG_CATEGORY (PROD_CATALOG_ID, PRODUCT_CATEGORY_ID, PROD_CATALOG_CATEGORY_TYPE_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'wt-catalog1-category1-id' to length 20.))] -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Reopened: (OFBIZ-1399) Cannot create a category for a catalog
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1399?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Jacques Le Roux reopened OFBIZ-1399: ------------------------------------ OK Scott, and sorry Yin : my apologies > Cannot create a category for a catalog > -------------------------------------- > > Key: OFBIZ-1399 > URL: https://issues.apache.org/jira/browse/OFBIZ-1399 > Project: OFBiz > Issue Type: Bug > Components: framework > Affects Versions: SVN trunk > Environment: OpenSuse 10.3 > Eclipse3.3 > SVN trunk sources downloaded on Nov 12,2007 > java version "1.6.0_03" > Java(TM) SE Runtime Environment (build 1.6.0_03-b05) > Java HotSpot(TM) Client VM (build 1.6.0_03-b05, mixed mode) > Reporter: Yin T > Assignee: Jacques Le Roux > Fix For: SVN trunk > > > goto https://localhost:8443/catalog/control/main > click "Catalog" menuitem in application bar. > create new catalog. > associated new catalog with "OFBiz E-Commerce Store" > create new product category > Received the following error message on the page... > The Following Errors Occurred: > ERROR: Could not complete the Add Category To ProdCatalog [file:/home/wt5/wteclipse-workspace/ofbiz/applications/product/script/org/ofbiz/product/catalog/CatalogServices.xml#addProductCategoryToProdCatalog] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ProdCatalogCategory][createdStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][createdTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][fromDate,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][prodCatalogCategoryTypeId,PCCT_ADMIN_ALLW(java.lang.String)][prodCatalogId,wt-catalog1-id(java.lang.String)][productCategoryId,wt-catalog1-category1-id(java.lang.String)][sequenceNum,null()][thruDate,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PROD_CATALOG_CATEGORY (PROD_CATALOG_ID, PRODUCT_CATEGORY_ID, PROD_CATALOG_CATEGORY_TYPE_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'wt-catalog1-category1-id' to length 20.))] -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Closed: (OFBIZ-1399) Cannot create a category for a catalog
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1399?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Scott Gray closed OFBIZ-1399. ----------------------------- Resolution: Invalid Ok sorry, I just had a look at this and it's just a user error. Yin, the form you are using is for creating an association between the Catalog and an _existing_ Category, not for creating a new Category that's why you are getting errors. > Cannot create a category for a catalog > -------------------------------------- > > Key: OFBIZ-1399 > URL: https://issues.apache.org/jira/browse/OFBIZ-1399 > Project: OFBiz > Issue Type: Bug > Components: framework > Affects Versions: SVN trunk > Environment: OpenSuse 10.3 > Eclipse3.3 > SVN trunk sources downloaded on Nov 12,2007 > java version "1.6.0_03" > Java(TM) SE Runtime Environment (build 1.6.0_03-b05) > Java HotSpot(TM) Client VM (build 1.6.0_03-b05, mixed mode) > Reporter: Yin T > Assignee: Jacques Le Roux > Fix For: SVN trunk > > > goto https://localhost:8443/catalog/control/main > click "Catalog" menuitem in application bar. > create new catalog. > associated new catalog with "OFBiz E-Commerce Store" > create new product category > Received the following error message on the page... > The Following Errors Occurred: > ERROR: Could not complete the Add Category To ProdCatalog [file:/home/wt5/wteclipse-workspace/ofbiz/applications/product/script/org/ofbiz/product/catalog/CatalogServices.xml#addProductCategoryToProdCatalog] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ProdCatalogCategory][createdStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][createdTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][fromDate,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][prodCatalogCategoryTypeId,PCCT_ADMIN_ALLW(java.lang.String)][prodCatalogId,wt-catalog1-id(java.lang.String)][productCategoryId,wt-catalog1-category1-id(java.lang.String)][sequenceNum,null()][thruDate,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PROD_CATALOG_CATEGORY (PROD_CATALOG_ID, PRODUCT_CATEGORY_ID, PROD_CATALOG_CATEGORY_TYPE_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'wt-catalog1-category1-id' to length 20.))] -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-1399) Cannot create a category for a catalog
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12542975 ] Scott Gray commented on OFBIZ-1399: ----------------------------------- In rev. 595582, this scenario will now return a user friendly error message > Cannot create a category for a catalog > -------------------------------------- > > Key: OFBIZ-1399 > URL: https://issues.apache.org/jira/browse/OFBIZ-1399 > Project: OFBiz > Issue Type: Bug > Components: framework > Affects Versions: SVN trunk > Environment: OpenSuse 10.3 > Eclipse3.3 > SVN trunk sources downloaded on Nov 12,2007 > java version "1.6.0_03" > Java(TM) SE Runtime Environment (build 1.6.0_03-b05) > Java HotSpot(TM) Client VM (build 1.6.0_03-b05, mixed mode) > Reporter: Yin T > Assignee: Jacques Le Roux > Fix For: SVN trunk > > > goto https://localhost:8443/catalog/control/main > click "Catalog" menuitem in application bar. > create new catalog. > associated new catalog with "OFBiz E-Commerce Store" > create new product category > Received the following error message on the page... > The Following Errors Occurred: > ERROR: Could not complete the Add Category To ProdCatalog [file:/home/wt5/wteclipse-workspace/ofbiz/applications/product/script/org/ofbiz/product/catalog/CatalogServices.xml#addProductCategoryToProdCatalog] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ProdCatalogCategory][createdStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][createdTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][fromDate,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][prodCatalogCategoryTypeId,PCCT_ADMIN_ALLW(java.lang.String)][prodCatalogId,wt-catalog1-id(java.lang.String)][productCategoryId,wt-catalog1-category1-id(java.lang.String)][sequenceNum,null()][thruDate,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PROD_CATALOG_CATEGORY (PROD_CATALOG_ID, PRODUCT_CATEGORY_ID, PROD_CATALOG_CATEGORY_TYPE_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'wt-catalog1-category1-id' to length 20.))] -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-1399) Cannot create a category for a catalog
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12543124 ] Yin T commented on OFBIZ-1399: ------------------------------ Just a comment on this issue. I'm new to this project and that's how I stumbled on this issue. As a suggestion, would it not be more user friendly if the application did not present a "create" button when it is not supposed to be used in this context. Thanks > Cannot create a category for a catalog > -------------------------------------- > > Key: OFBIZ-1399 > URL: https://issues.apache.org/jira/browse/OFBIZ-1399 > Project: OFBiz > Issue Type: Bug > Components: framework > Affects Versions: SVN trunk > Environment: OpenSuse 10.3 > Eclipse3.3 > SVN trunk sources downloaded on Nov 12,2007 > java version "1.6.0_03" > Java(TM) SE Runtime Environment (build 1.6.0_03-b05) > Java HotSpot(TM) Client VM (build 1.6.0_03-b05, mixed mode) > Reporter: Yin T > Assignee: Jacques Le Roux > Fix For: SVN trunk > > > goto https://localhost:8443/catalog/control/main > click "Catalog" menuitem in application bar. > create new catalog. > associated new catalog with "OFBiz E-Commerce Store" > create new product category > Received the following error message on the page... > The Following Errors Occurred: > ERROR: Could not complete the Add Category To ProdCatalog [file:/home/wt5/wteclipse-workspace/ofbiz/applications/product/script/org/ofbiz/product/catalog/CatalogServices.xml#addProductCategoryToProdCatalog] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ProdCatalogCategory][createdStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][createdTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][fromDate,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][prodCatalogCategoryTypeId,PCCT_ADMIN_ALLW(java.lang.String)][prodCatalogId,wt-catalog1-id(java.lang.String)][productCategoryId,wt-catalog1-category1-id(java.lang.String)][sequenceNum,null()][thruDate,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PROD_CATALOG_CATEGORY (PROD_CATALOG_ID, PRODUCT_CATEGORY_ID, PROD_CATALOG_CATEGORY_TYPE_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'wt-catalog1-category1-id' to length 20.))] -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-1399) Cannot create a category for a catalog
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12543235 ] BJ Freeman commented on OFBIZ-1399: ----------------------------------- one of the comments I made when I first started using this application is buttons that can not be used untill something else is done should be greyed out. it is a major project to go through and apply logic to the buttons. > Cannot create a category for a catalog > -------------------------------------- > > Key: OFBIZ-1399 > URL: https://issues.apache.org/jira/browse/OFBIZ-1399 > Project: OFBiz > Issue Type: Bug > Components: framework > Affects Versions: SVN trunk > Environment: OpenSuse 10.3 > Eclipse3.3 > SVN trunk sources downloaded on Nov 12,2007 > java version "1.6.0_03" > Java(TM) SE Runtime Environment (build 1.6.0_03-b05) > Java HotSpot(TM) Client VM (build 1.6.0_03-b05, mixed mode) > Reporter: Yin T > Assignee: Jacques Le Roux > Fix For: SVN trunk > > > goto https://localhost:8443/catalog/control/main > click "Catalog" menuitem in application bar. > create new catalog. > associated new catalog with "OFBiz E-Commerce Store" > create new product category > Received the following error message on the page... > The Following Errors Occurred: > ERROR: Could not complete the Add Category To ProdCatalog [file:/home/wt5/wteclipse-workspace/ofbiz/applications/product/script/org/ofbiz/product/catalog/CatalogServices.xml#addProductCategoryToProdCatalog] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ProdCatalogCategory][createdStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][createdTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][fromDate,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][prodCatalogCategoryTypeId,PCCT_ADMIN_ALLW(java.lang.String)][prodCatalogId,wt-catalog1-id(java.lang.String)][productCategoryId,wt-catalog1-category1-id(java.lang.String)][sequenceNum,null()][thruDate,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PROD_CATALOG_CATEGORY (PROD_CATALOG_ID, PRODUCT_CATEGORY_ID, PROD_CATALOG_CATEGORY_TYPE_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'wt-catalog1-category1-id' to length 20.))] -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-1399) Cannot create a category for a catalog
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12543387 ] Jacques Le Roux commented on OFBIZ-1399: ---------------------------------------- Hi BJ, Yin Feel free to open a generalised Jira issue for this (as suggested by BJ) > Cannot create a category for a catalog > -------------------------------------- > > Key: OFBIZ-1399 > URL: https://issues.apache.org/jira/browse/OFBIZ-1399 > Project: OFBiz > Issue Type: Bug > Components: framework > Affects Versions: SVN trunk > Environment: OpenSuse 10.3 > Eclipse3.3 > SVN trunk sources downloaded on Nov 12,2007 > java version "1.6.0_03" > Java(TM) SE Runtime Environment (build 1.6.0_03-b05) > Java HotSpot(TM) Client VM (build 1.6.0_03-b05, mixed mode) > Reporter: Yin T > Assignee: Jacques Le Roux > Fix For: SVN trunk > > > goto https://localhost:8443/catalog/control/main > click "Catalog" menuitem in application bar. > create new catalog. > associated new catalog with "OFBiz E-Commerce Store" > create new product category > Received the following error message on the page... > The Following Errors Occurred: > ERROR: Could not complete the Add Category To ProdCatalog [file:/home/wt5/wteclipse-workspace/ofbiz/applications/product/script/org/ofbiz/product/catalog/CatalogServices.xml#addProductCategoryToProdCatalog] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ProdCatalogCategory][createdStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][createdTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][fromDate,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][prodCatalogCategoryTypeId,PCCT_ADMIN_ALLW(java.lang.String)][prodCatalogId,wt-catalog1-id(java.lang.String)][productCategoryId,wt-catalog1-category1-id(java.lang.String)][sequenceNum,null()][thruDate,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PROD_CATALOG_CATEGORY (PROD_CATALOG_ID, PRODUCT_CATEGORY_ID, PROD_CATALOG_CATEGORY_TYPE_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'wt-catalog1-category1-id' to length 20.))] -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-1399) Cannot create a category for a catalog
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12543389 ] Scott Gray commented on OFBIZ-1399: ----------------------------------- The button actually says "Add" not "Create", and the fact that there is a lookup button next to the id field implies that the category must already exist. This is really just a matter of a new user getting used to how the system works. > Cannot create a category for a catalog > -------------------------------------- > > Key: OFBIZ-1399 > URL: https://issues.apache.org/jira/browse/OFBIZ-1399 > Project: OFBiz > Issue Type: Bug > Components: framework > Affects Versions: SVN trunk > Environment: OpenSuse 10.3 > Eclipse3.3 > SVN trunk sources downloaded on Nov 12,2007 > java version "1.6.0_03" > Java(TM) SE Runtime Environment (build 1.6.0_03-b05) > Java HotSpot(TM) Client VM (build 1.6.0_03-b05, mixed mode) > Reporter: Yin T > Assignee: Jacques Le Roux > Fix For: SVN trunk > > > goto https://localhost:8443/catalog/control/main > click "Catalog" menuitem in application bar. > create new catalog. > associated new catalog with "OFBiz E-Commerce Store" > create new product category > Received the following error message on the page... > The Following Errors Occurred: > ERROR: Could not complete the Add Category To ProdCatalog [file:/home/wt5/wteclipse-workspace/ofbiz/applications/product/script/org/ofbiz/product/catalog/CatalogServices.xml#addProductCategoryToProdCatalog] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ProdCatalogCategory][createdStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][createdTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][fromDate,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][prodCatalogCategoryTypeId,PCCT_ADMIN_ALLW(java.lang.String)][prodCatalogId,wt-catalog1-id(java.lang.String)][productCategoryId,wt-catalog1-category1-id(java.lang.String)][sequenceNum,null()][thruDate,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PROD_CATALOG_CATEGORY (PROD_CATALOG_ID, PRODUCT_CATEGORY_ID, PROD_CATALOG_CATEGORY_TYPE_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'wt-catalog1-category1-id' to length 20.))] -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-1399) Cannot create a category for a catalog
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12543406 ] BJ Freeman commented on OFBIZ-1399: ----------------------------------- Yes, I have dealt years with programmers that say let do it this way even though it is not really clear to the end user. The key word is Intuitive. From a user that does not have all this wonderful programming back ground. As a note, I took me months to figure out what all the meant and I don't consider myself a slouch in using programs. > Cannot create a category for a catalog > -------------------------------------- > > Key: OFBIZ-1399 > URL: https://issues.apache.org/jira/browse/OFBIZ-1399 > Project: OFBiz > Issue Type: Bug > Components: framework > Affects Versions: SVN trunk > Environment: OpenSuse 10.3 > Eclipse3.3 > SVN trunk sources downloaded on Nov 12,2007 > java version "1.6.0_03" > Java(TM) SE Runtime Environment (build 1.6.0_03-b05) > Java HotSpot(TM) Client VM (build 1.6.0_03-b05, mixed mode) > Reporter: Yin T > Assignee: Jacques Le Roux > Fix For: SVN trunk > > > goto https://localhost:8443/catalog/control/main > click "Catalog" menuitem in application bar. > create new catalog. > associated new catalog with "OFBiz E-Commerce Store" > create new product category > Received the following error message on the page... > The Following Errors Occurred: > ERROR: Could not complete the Add Category To ProdCatalog [file:/home/wt5/wteclipse-workspace/ofbiz/applications/product/script/org/ofbiz/product/catalog/CatalogServices.xml#addProductCategoryToProdCatalog] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ProdCatalogCategory][createdStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][createdTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][fromDate,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][prodCatalogCategoryTypeId,PCCT_ADMIN_ALLW(java.lang.String)][prodCatalogId,wt-catalog1-id(java.lang.String)][productCategoryId,wt-catalog1-category1-id(java.lang.String)][sequenceNum,null()][thruDate,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PROD_CATALOG_CATEGORY (PROD_CATALOG_ID, PRODUCT_CATEGORY_ID, PROD_CATALOG_CATEGORY_TYPE_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'wt-catalog1-category1-id' to length 20.))] -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
[jira] Commented: (OFBIZ-1399) Cannot create a category for a catalog
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12543426 ] Jacques Le Roux commented on OFBIZ-1399: ---------------------------------------- I agree with both of you : 1. It's counter intuitive at first sight 2. As soon as you are familiar with concepts there are no longer any problems (sometimes it takes 2 or even more tries to get it) Remember the 1st time you used a keyboard ? ;o) Anyway, creating an intuitive UI for an ERP is something we can call a challenge ! The better should be to create a clear list of needs with solutions (like not only prev. and next buttons for list but 1st, last, pages list, etc.) Then why not discussing around best ideas, a challenge, I told you ... We are here to stay ! > Cannot create a category for a catalog > -------------------------------------- > > Key: OFBIZ-1399 > URL: https://issues.apache.org/jira/browse/OFBIZ-1399 > Project: OFBiz > Issue Type: Bug > Components: framework > Affects Versions: SVN trunk > Environment: OpenSuse 10.3 > Eclipse3.3 > SVN trunk sources downloaded on Nov 12,2007 > java version "1.6.0_03" > Java(TM) SE Runtime Environment (build 1.6.0_03-b05) > Java HotSpot(TM) Client VM (build 1.6.0_03-b05, mixed mode) > Reporter: Yin T > Assignee: Jacques Le Roux > Fix For: SVN trunk > > > goto https://localhost:8443/catalog/control/main > click "Catalog" menuitem in application bar. > create new catalog. > associated new catalog with "OFBiz E-Commerce Store" > create new product category > Received the following error message on the page... > The Following Errors Occurred: > ERROR: Could not complete the Add Category To ProdCatalog [file:/home/wt5/wteclipse-workspace/ofbiz/applications/product/script/org/ofbiz/product/catalog/CatalogServices.xml#addProductCategoryToProdCatalog] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ProdCatalogCategory][createdStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][createdTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][fromDate,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][prodCatalogCategoryTypeId,PCCT_ADMIN_ALLW(java.lang.String)][prodCatalogId,wt-catalog1-id(java.lang.String)][productCategoryId,wt-catalog1-category1-id(java.lang.String)][sequenceNum,null()][thruDate,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PROD_CATALOG_CATEGORY (PROD_CATALOG_ID, PRODUCT_CATEGORY_ID, PROD_CATALOG_CATEGORY_TYPE_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'wt-catalog1-category1-id' to length 20.))] -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
Re: [jira] Commented: (OFBIZ-1399) Cannot create a category for a catalog
|
|
How about a place do work out best practices for UI enhancement.
Not so much to implement but to have the hooks necessary for those that want to differnt UI. Like we have tool tips. maybe a condition to show UI components in different states. Jacques Le Roux (JIRA) sent the following on 11/18/2007 2:24 PM: > [ https://issues.apache.org/jira/browse/OFBIZ-1399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12543426 ] > > Jacques Le Roux commented on OFBIZ-1399: > ---------------------------------------- > > I agree with both of you : > > 1. It's counter intuitive at first sight > 2. As soon as you are familiar with concepts there are no longer any problems (sometimes it takes 2 or even more tries to get it) > > Remember the 1st time you used a keyboard ? ;o) > > Anyway, creating an intuitive UI for an ERP is something we can call a challenge ! > > The better should be to create a clear list of needs with solutions (like not only prev. and next buttons for list but 1st, last, pages list, etc.) > Then why not discussing around best ideas, a challenge, I told you ... We are here to stay ! > >> Cannot create a category for a catalog >> -------------------------------------- >> >> Key: OFBIZ-1399 >> URL: https://issues.apache.org/jira/browse/OFBIZ-1399 >> Project: OFBiz >> Issue Type: Bug >> Components: framework >> Affects Versions: SVN trunk >> Environment: OpenSuse 10.3 >> Eclipse3.3 >> SVN trunk sources downloaded on Nov 12,2007 >> java version "1.6.0_03" >> Java(TM) SE Runtime Environment (build 1.6.0_03-b05) >> Java HotSpot(TM) Client VM (build 1.6.0_03-b05, mixed mode) >> Reporter: Yin T >> Assignee: Jacques Le Roux >> Fix For: SVN trunk >> >> >> goto https://localhost:8443/catalog/control/main >> click "Catalog" menuitem in application bar. >> create new catalog. >> associated new catalog with "OFBiz E-Commerce Store" >> create new product category >> Received the following error message on the page... >> The Following Errors Occurred: >> ERROR: Could not complete the Add Category To ProdCatalog [file:/home/wt5/wteclipse-workspace/ofbiz/applications/product/script/org/ofbiz/product/catalog/CatalogServices.xml#addProductCategoryToProdCatalog] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ProdCatalogCategory][createdStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][createdTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][fromDate,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][prodCatalogCategoryTypeId,PCCT_ADMIN_ALLW(java.lang.String)][prodCatalogId,wt-catalog1-id(java.lang.String)][productCategoryId,wt-catalog1-category1-id(java.lang.String)][sequenceNum,null()][thruDate,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PROD_CATALOG_CATEGORY (PROD_CATALOG_ID, PRODUCT_CATEGORY_ID, PROD_CATALOG_CATEGORY_TYPE_ID, FROM_DATE, THR > |
RE: [jira] Commented: (OFBIZ-1399) Cannot create a category for a catalog
|
|
For the short term, I have found that reading the Data Model book helps me
to understand the UI. Longer term, I don't know if there is anything similar in the java framework we could use, but I have had success in the past using the C# field validation events. It at least gave clear error messages when there was something wrong with the user input. That said, I haven't delved into the ofbiz UI much. My 2c. C -----Original Message----- From: BJ Freeman [mailto:[hidden email]] Sent: Sunday, November 18, 2007 4:56 PM To: [hidden email] Subject: Re: [jira] Commented: (OFBIZ-1399) Cannot create a category for a catalog How about a place do work out best practices for UI enhancement. Not so much to implement but to have the hooks necessary for those that want to differnt UI. Like we have tool tips. maybe a condition to show UI components in different states. Jacques Le Roux (JIRA) sent the following on 11/18/2007 2:24 PM: > [ https://issues.apache.org/jira/browse/OFBIZ-1399?page=com.atlassian.jira.plu gin.system.issuetabpanels:comment-tabpanel#action_12543426 ] > > Jacques Le Roux commented on OFBIZ-1399: > ---------------------------------------- > > I agree with both of you : > > 1. It's counter intuitive at first sight > 2. As soon as you are familiar with concepts there are no longer any problems (sometimes it takes 2 or even more tries to get it) > > Remember the 1st time you used a keyboard ? ;o) > > Anyway, creating an intuitive UI for an ERP is something we can call a challenge ! > > The better should be to create a clear list of needs with solutions (like not only prev. and next buttons for list but 1st, last, pages list, etc.) > Then why not discussing around best ideas, a challenge, I told you ... We are here to stay ! > >> Cannot create a category for a catalog >> -------------------------------------- >> >> Key: OFBIZ-1399 >> URL: https://issues.apache.org/jira/browse/OFBIZ-1399 >> Project: OFBiz >> Issue Type: Bug >> Components: framework >> Affects Versions: SVN trunk >> Environment: OpenSuse 10.3 >> Eclipse3.3 >> SVN trunk sources downloaded on Nov 12,2007 >> java version "1.6.0_03" >> Java(TM) SE Runtime Environment (build 1.6.0_03-b05) >> Java HotSpot(TM) Client VM (build 1.6.0_03-b05, mixed mode) >> Reporter: Yin T >> Assignee: Jacques Le Roux >> Fix For: SVN trunk >> >> >> goto https://localhost:8443/catalog/control/main >> click "Catalog" menuitem in application bar. >> create new catalog. >> associated new catalog with "OFBiz E-Commerce Store" >> create new product category >> Received the following error message on the page... >> The Following Errors Occurred: >> ERROR: Could not complete the Add Category To ProdCatalog biz/product/catalog/CatalogServices.xml#addProductCategoryToProdCatalog] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ProdCatalogCategory][createdStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][createdTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][fromDate,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][prodCatalogCategoryTypeId,PCCT_ADMIN_ALLW(j ava.lang.String)][prodCatalogId,wt-catalog1-id(java.lang.String)][productCat egoryId,wt-catalog1-category1-id(java.lang.String)][sequenceNum,null()][thru Date,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PROD_CATALOG_CATEGORY (PROD_CATALOG_ID, PRODUCT_CATEGORY_ID, PROD_CATALOG_CATEGORY_TYPE_ID, FROM_DATE, THR U_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'wt-catalog1-category1-id' to length 20.))] > |
[jira] Commented: (OFBIZ-1399) Cannot create a category for a catalog
|
|
In reply to this post by Nicolas Malin (Jira)
[ https://issues.apache.org/jira/browse/OFBIZ-1399?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12543485 ] David E. Jones commented on OFBIZ-1399: --------------------------------------- There are certainly lots of little things that can be done to improve the user experience. In this case if a user didn't understand that they were creating a link between the catalog and the category, then a message saying that the category didn't exist wouldn't make any sense to the user. There's no way around it: for generic user interfaces like most of those in OFBiz you have to know a bit about what you are doing in order to get things done. It is certainly possible to create user interfaces that guide the user through a process, but you have to have the process defined first! For most processes automated with OFBiz that means narrowing down to a certain role and operation that is part of a coordinated set of roles for a certain type of organization. If you only have one organization to worry about this is easy, but for OFBiz in general we don't have that luxury, so it's hard to get that sort of efficient UI into the project. This is the dilemma that we face... There are more specific solutions for certain roles and processes in the specialpurpose components, but in the general application components we are trying to keep things pretty generic in order to avoid huge confusion due to a large number of custom UIs that are irrelevant or bad practices for various user organizations. > Cannot create a category for a catalog > -------------------------------------- > > Key: OFBIZ-1399 > URL: https://issues.apache.org/jira/browse/OFBIZ-1399 > Project: OFBiz > Issue Type: Bug > Components: framework > Affects Versions: SVN trunk > Environment: OpenSuse 10.3 > Eclipse3.3 > SVN trunk sources downloaded on Nov 12,2007 > java version "1.6.0_03" > Java(TM) SE Runtime Environment (build 1.6.0_03-b05) > Java HotSpot(TM) Client VM (build 1.6.0_03-b05, mixed mode) > Reporter: Yin T > Assignee: Jacques Le Roux > Fix For: SVN trunk > > > goto https://localhost:8443/catalog/control/main > click "Catalog" menuitem in application bar. > create new catalog. > associated new catalog with "OFBiz E-Commerce Store" > create new product category > Received the following error message on the page... > The Following Errors Occurred: > ERROR: Could not complete the Add Category To ProdCatalog [file:/home/wt5/wteclipse-workspace/ofbiz/applications/product/script/org/ofbiz/product/catalog/CatalogServices.xml#addProductCategoryToProdCatalog] process [problem creating the newEntity value: Error while inserting: [GenericEntity:ProdCatalogCategory][createdStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][createdTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][fromDate,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedStamp,2007-11-12 13:24:12.924(java.sql.Timestamp)][lastUpdatedTxStamp,2007-11-12 13:24:12.78(java.sql.Timestamp)][prodCatalogCategoryTypeId,PCCT_ADMIN_ALLW(java.lang.String)][prodCatalogId,wt-catalog1-id(java.lang.String)][productCategoryId,wt-catalog1-category1-id(java.lang.String)][sequenceNum,null()][thruDate,null()] (SQL Exception while executing the following:INSERT INTO OFBIZ.PROD_CATALOG_CATEGORY (PROD_CATALOG_ID, PRODUCT_CATEGORY_ID, PROD_CATALOG_CATEGORY_TYPE_ID, FROM_DATE, THRU_DATE, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (A truncation error was encountered trying to shrink VARCHAR 'wt-catalog1-category1-id' to length 20.))] -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online. |
«
Return to OFBiz - Dev
|
1 view|%1 views
| Free forum by Nabble | Edit this page |