[jira] [Comment Edited] (OFBIZ-6070) Create content for product causes exception

[Nicolas Malin (Jira)]

    [ https://issues.apache.org/jira/browse/OFBIZ-6070?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14372786#comment-14372786 ]

Deepak Dixit edited comment on OFBIZ-6070 at 3/21/15 2:58 PM:
--------------------------------------------------------------

Added check to avoid error,
Committed in
Trunk  at r#1668277
R14.12 at r#1668278
R13.07 at r#1668283
R12.04 at r#1668294

ProductContent creation need more refinement, as its try to scale image for each type of image content. And if we select product content type Image then it create plain text content for this. Will create new ticket for this issue.


was (Author: deepak.dixit):
Added check to avoid error, done at r#1668277 in trunk.

ProductContent creation need more refinement, as its try to scale image for each type of image content. And if we select product content type Image then it create plain text content for this. Will create new ticket for this issue.

> Create content for product causes exception
> -------------------------------------------
>
>                 Key: OFBIZ-6070
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-6070
>             Project: OFBiz
>          Issue Type: Bug
>          Components: content
>    Affects Versions: Trunk
>            Reporter: Wai
>            Assignee: Deepak Dixit
>
> Using demo data.
> https://localhost:8443/catalog/control/EditProductContent?productId=CPU-586
> Console output...
> 2015-02-11 11:08:44,547 |http-bio-8443-exec-3 |ServiceEcaCondition           |I| From Field (contentAssocTypeId) is not found in context for createContent, defaulting to null.
> 2015-02-11 11:08:44,557 |http-bio-8443-exec-3 |ServiceEcaRule                |I| For Service ECA [createContent] on [commit] got false for condition: [contentAssocTypeId][is-not-empty][true][String]
> 2015-02-11 11:08:44,564 |http-bio-8443-exec-3 |ServiceEcaCondition           |I| From Field (contentAssocTypeId) is not found in context for createContent, defaulting to null.
> 2015-02-11 11:08:44,565 |http-bio-8443-exec-3 |ServiceEcaRule                |I| For Service ECA [createContent] on [commit] got false for condition: [contentAssocTypeId][is-not-empty][true][String]
> 2015-02-11 11:08:44,566 |http-bio-8443-exec-3 |ServiceEcaCondition           |I| From Field (contentPurposeTypeId) is not found in context for createContent, defaulting to null.
> 2015-02-11 11:08:44,567 |http-bio-8443-exec-3 |ServiceEcaRule                |I| For Service ECA [createContent] on [commit] got false for condition: [contentPurposeTypeId][is-not-empty][true][String]
> 2015-02-11 11:08:44,568 |http-bio-8443-exec-3 |ServiceEcaRule                |I| Running Service ECA Service: createContentAlternativeUrl, triggered by rule on Service: createContent
> 2015-02-11 11:08:44,581 |http-bio-8443-exec-3 |ServiceEcaRule                |I| For Service ECA [createProductContent] on [in-validate] got false for condition: [contentId][is-empty][true][String]
> 2015-02-11 11:08:44,635 |http-bio-8443-exec-3 |GenericDelegator              |E| Failure in create operation for entity [ProductContent]: org.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:ProductContent][contentId,10001(java.lang.String)][createdStamp,2015-02-11 11:08:44.587(java.sql.Timestamp)][createdTxStamp,2015-02-11 11:08:32.59(java.sql.Timestamp)][fromDate,2015-02-11 11:08:23.0(java.sql.Timestamp)][lastUpdatedStamp,2015-02-11 11:08:44.587(java.sql.Timestamp)][lastUpdatedTxStamp,2015-02-11 11:08:32.59(java.sql.Timestamp)][productContentTypeId,XTRA_IMG_E_SMALL(java.lang.String)][productId,CPU-586(java.lang.String)][thruDate,null()] (SQL Exception while executing the following:INSERT INTO PRODUCT_CONTENT (PRODUCT_ID, CONTENT_ID, PRODUCT_CONTENT_TYPE_ID, FROM_DATE, THRU_DATE, PURCHASE_FROM_DATE, PURCHASE_THRU_DATE, USE_COUNT_LIMIT, USE_TIME, USE_TIME_UOM_ID, USE_ROLE_TYPE_ID, SEQUENCE_NUM, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot add or update a child row: a foreign key constraint fails (`ofbiz`.`PRODUCT_CONTENT`, CONSTRAINT `PROD_CNT_TYPE` FOREIGN KEY (`PRODUCT_CONTENT_TYPE_ID`) REFERENCES `PRODUCT_CONTENT_TYPE` (`PRODUCT_CONTENT_TYPE_ID`)))). Rolling back transaction.

--
This message was sent by Atlassian JIRA
(v6.3.4#6332)