You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@ofbiz.apache.org by "Wai (JIRA)" <ji...@apache.org> on 2017/03/01 17:13:45 UTC
[jira] [Commented] (OFBIZ-9237) order entry initial screen does not
show productStore
[ https://issues.apache.org/jira/browse/OFBIZ-9237?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15890579#comment-15890579 ]
Wai commented on OFBIZ-9237:
----------------------------
The problem is that the demo data is not fully loaded due to a foreign constraint issue...
2017-03-01 10:09:59,797 |main |GenericDelegator |E| Failure in create operation for entity [PartyContactMech]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:PartyContactMech][contactMechId,9020(java.lang.String)][createdStamp,2017-03-01 10:09:59.795(java.sql.Timestamp)][createdTxStamp,2017-03-01 10:09:59.783(java.sql.Timestamp)][fromDate,2000-01-01 10:01:48.933(java.sql.Timestamp)][lastUpdatedStamp,2017-03-01 10:09:59.795(java.sql.Timestamp)][lastUpdatedTxStamp,2017-03-01 10:09:59.783(java.sql.Timestamp)][partyId,DemoEmployee(java.lang.String)][roleTypeId,EMPLOYEE(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PARTY_CONTACT_MECH (PARTY_ID, CONTACT_MECH_ID, FROM_DATE, THRU_DATE, ROLE_TYPE_ID, ALLOW_SOLICITATION, EXTENSION, VERIFIED, COMMENTS, YEARS_WITH_CONTACT_MECH, MONTHS_WITH_CONTACT_MECH, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "party_contact_mech" violates foreign key constraint "party_cmech_cmech"
Detail: Key (contact_mech_id)=(9020) is not present in table "contact_mech".)). Rolling back transaction.
2017-03-01 10:09:59,797 |main |TransactionUtil |W| Calling transaction setRollbackOnly; this stack trace shows where this is happening:
java.lang.Exception: Failure in create operation for entity [PartyContactMech]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:PartyContactMech][contactMechId,9020(java.lang.String)][createdStamp,2017-03-01 10:09:59.795(java.sql.Timestamp)][createdTxStamp,2017-03-01 10:09:59.783(java.sql.Timestamp)][fromDate,2000-01-01 10:01:48.933(java.sql.Timestamp)][lastUpdatedStamp,2017-03-01 10:09:59.795(java.sql.Timestamp)][lastUpdatedTxStamp,2017-03-01 10:09:59.783(java.sql.Timestamp)][partyId,DemoEmployee(java.lang.String)][roleTypeId,EMPLOYEE(java.lang.String)] (SQL Exception while executing the following:INSERT INTO public.PARTY_CONTACT_MECH (PARTY_ID, CONTACT_MECH_ID, FROM_DATE, THRU_DATE, ROLE_TYPE_ID, ALLOW_SOLICITATION, EXTENSION, VERIFIED, COMMENTS, YEARS_WITH_CONTACT_MECH, MONTHS_WITH_CONTACT_MECH, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ERROR: insert or update on table "party_contact_mech" violates foreign key constraint "party_cmech_cmech"
Detail: Key (contact_mech_id)=(9020) is not present in table "contact_mech".)). Rolling back transaction.
> order entry initial screen does not show productStore
> -----------------------------------------------------
>
> Key: OFBIZ-9237
> URL: https://issues.apache.org/jira/browse/OFBIZ-9237
> Project: OFBiz
> Issue Type: Bug
> Components: order
> Affects Versions: Trunk
> Reporter: Wai
>
> -using demo data
> -use https://localhost:8443/ordermgr/control/orderentry
> notice productStore is empty
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)