Openbravo Issue Tracking System - Modules | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0015295 | Modules | zz obsolete Apparel Products | public | 2010-11-25 17:57 | 2020-04-13 08:58 |
| Reporter | maite | ||||
| Assigned To | alostale | ||||
| Priority | urgent | Severity | major | Reproducibility | have not tried |
| Status | closed | Resolution | out of date | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | ||||
| Merge Request Status | |||||
| Regression date | |||||
| Regression introduced by commit | |||||
| Regression level | |||||
| Review Assigned To | |||||
| Support ticket | |||||
| OBNetwork customer | |||||
| Regression introduced in release | |||||
| Summary | 0015295: Check «m_product_atsetvaltype_chk» violated when trying to generate/update products | ||||
| Description | Check «m_product_atsetvaltype_chk» violated when trying to generate/update products. | ||||
| Steps To Reproduce | 1. Create values for "Division", "Collection"and "Subcollection" 2. Go to Master Data Management || Product Setup || Attribute || Attribute: set "Size" attribute as isSize=Y set "Color" attribute as isColor=Y 3. General Setup || Enterprise || Enterprise module management || Enterprise module management: apply apparel dataset 4. Master Data Management || Product Technical Specification || Product : create new product and press "Generate/update products" 5. Press "Propose EAN" in the popup and then press "Generate/update products" Error "org.hibernate.exception.GenericJDBCException: could not execute query" is obtained. Having a look at the log you see: [http-8080-1] ERROR org.hibernate.util.JDBCExceptionReporter - Batch entry 0 insert into M_Product (AD_Client_ID, AD_Org_ID, IsActive, Created, CreatedBy, Updated, UpdatedBy, Value, Name, UPC, C_UOM_ID, IsSummary, IsStocked, IsPurchased, IsSold, IsBOM, IsInvoicePrintDetails, IsPickListPrintDetails, IsVerified, M_Product_Category_ID, C_TaxCategory_ID, Discontinued, Processing, ProductType, ImageURL, M_AttributeSet_ID, M_AttributeSetInstance_ID, Ispriceprinted, Costtype, Enforce_Attribute, Calculated, Production, Qtytype, EM_Apparel_Prod_Tech_Spec_ID, M_Product_ID) values (1000000, 0, Y, 2010-11-24 18:52:42.400000 +0100, 100, 2010-11-24 18:52:42.400000 +0100, 100, ppinkL, p - Large - Pink, 1234567800011, 100, N, Y, Y, Y, N, N, N, N, 1000000, 1000000, N, N, I, 800011, FF8081812C797F3F012C798A9F6C005D, FF8081812C7E8205012C7F04138D0116, N, ST, N, N, N, N, 68331524A98B4E77941C04C2F361BDAE, FF8081812C7E8205012C7F0413A00119) was aborted. Call getNextException to see the cause. a3196480 18:52:42 [http-8080-1] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: el nuevo registro para la relación «m_product» viola la restricción check «m_product_atsetvaltype_chk» | ||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2010-11-25 17:57 | maite | New Issue | |||
| 2010-11-25 17:57 | maite | Assigned To | => alostale | ||
| 2020-04-13 08:58 | alostale | Note Added: 0119123 | |||
| 2020-04-13 08:58 | alostale | Status | new => closed | ||
| 2020-04-13 08:58 | alostale | Resolution | open => out of date | ||
| 2022-02-18 04:26 | priyam | Category | Apparel Products => zz obsolete Apparel Products | ||
| Notes | |||||
|
|
|||||
|
|
||||