[jira] [Commented] (OFBIZ-10610) New Communications not Entering

[Nicolas Malin (Jira)]

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

Greg Finlayson commented on OFBIZ-10610:
----------------------------------------

This arises out of the entity definition in the xml file incorrectly placing a unique index {color:#333333}COMMEVT_MSG_ID{color} including nulls on the Communication_EVENT table 

> New Communications not Entering
> -------------------------------
>
>                 Key: OFBIZ-10610
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-10610
>             Project: OFBiz
>          Issue Type: Bug
>          Components: party
>    Affects Versions: 16.11.05
>         Environment: using ubuntu front end and MSSQL 2012 database, edge browser on windows 10.
>            Reporter: Greg Finlayson
>            Priority: Major
>
> I cannot enter new communications in the communications screen as the insert fails with the following error:
>  
> The Following Errors Occurred:
> Error calling event: org.apache.ofbiz.webapp.event.EventHandlerException: Service invocation error (Could not commit transaction for service [createCommunicationEvent] call: Roll back error, could not commit transaction, was rolled back instead because of: Failure in create operation for entity [CommunicationEvent]: org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CommunicationEvent][communicationEventId,10031(java.lang.String)][communicationEventTypeId,EMAIL_COMMUNICATION(java.lang.String)][contactListId,null()][contactMechIdFrom,13271(java.lang.String)][contactMechIdTo,14832(java.lang.String)][contactMechTypeId,DOMAIN_NAME(java.lang.String)][content,null()][contentMimeTypeId,text/plain(java.lang.String)][createdStamp,2018-10-21 14:45:04.533(java.sql.Timestamp)][createdTxStamp,2018-10-21 14:45:03.319(java.sql.Timestamp)][datetimeEnded,2018-10-12 00:00:00.0(java.sql.Timestamp)][datetimeStarted,2018-10-12 00:00:00.0(java.sql.Timestamp)][entryDate,2018-10-21 14:45:04.533(java.sql.Timestamp)][lastUpdatedStamp,2018-10-21 14:45:04.533(java.sql.Timestamp)][lastUpdatedTxStamp,2018-10-21 14:45:03.319(java.sql.Timestamp)][messageId,null()][note,null()][parentCommEventId,null()][partyIdFrom,10001(java.lang.String)][partyIdTo,13295(java.lang.String)][reasonEnumId,null()][roleTypeIdFrom,_NA_(java.lang.String)][roleTypeIdTo,_NA_(java.lang.String)][statusId,COM_PENDING(java.lang.String)][subject,Enquiry regarding documents(java.lang.String)] (SQL Exception while executing the following:INSERT INTO dbo.COMMUNICATION_EVENT (COMMUNICATION_EVENT_ID, COMMUNICATION_EVENT_TYPE_ID, ORIG_COMM_EVENT_ID, PARENT_COMM_EVENT_ID, STATUS_ID, CONTACT_MECH_TYPE_ID, CONTACT_MECH_ID_FROM, CONTACT_MECH_ID_TO, ROLE_TYPE_ID_FROM, ROLE_TYPE_ID_TO, PARTY_ID_FROM, PARTY_ID_TO, ENTRY_DATE, DATETIME_STARTED, DATETIME_ENDED, SUBJECT, CONTENT_MIME_TYPE_ID, CONTENT, NOTE, REASON_ENUM_ID, CONTACT_LIST_ID, HEADER_STRING, FROM_STRING, TO_STRING, CC_STRING, BCC_STRING, MESSAGE_ID, LAST_UPDATED_STAMP, LAST_UPDATED_TX_STAMP, CREATED_STAMP, CREATED_TX_STAMP) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (Cannot insert duplicate key row in object 'dbo.COMMUNICATION_EVENT' with unique index 'COMMEVT_MSG_ID'. The duplicate key value is (<NULL>).)). Rolling back transaction.org.apache.ofbiz.entity.GenericEntityException: Error while inserting: [GenericEntity:CommunicationEvent][communicationEventId,10031(java.lang.String)][communicationEventTypeId,EMAIL_COMMUNICATION(java.lang.String)][contactListId,null()][contactMechIdFrom,13271(java.lang.String)][contactMechIdTo,14832(java.lang.String)][contactMechTypeId,DOMAIN_NAME(java.lang.String)][content,null()]

--
This message was sent by Atlassian JIRA
(v7.6.3#76005)