[
https://issues.apache.org/jira/browse/OFBIZ-10610?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Le Roux closed OFBIZ-10610.
-----------------------------------
Resolution: Abandoned
This works OOTB on trunk demo. I believe it's a MSSQL issue only, w/o solution
provided. Please reopen otherwise
> 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)
