Greg Finlayson created OFBIZ-10610:
--------------------------------------
Summary: 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
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)
