Support #10758

[SCP ID :##5314##] : M2U - Compose

Added by Zahir Abd Latif over 4 years ago. Updated over 4 years ago.

Status:Closed - End of life cycleStart date:April 28, 2020
Priority:NormalDue date:April 29, 2020
Assignee:Zahir Abd Latif% Done:

100%

Category:-Spent time:1.50 hour
Target version:-

Description

Hi,
Kindly attend below request:

Err when compose email

[4/28/20 17:41:16:903 WIB] 000040c5 SystemOut O [28/04/2020] [17:41:16:903] [ERROR] [IBConfirmComposeMailServices]:527 - Error details : org.hibernate.exception.ConstraintViolationException: could not insert: [net.penril.onlineapps.securedmailbox.domain.MailBox]
...
Caused by: com.ibm.websphere.ce.cm.DuplicateKeyException: One or more values in the INSERT statement, UPDATE statement, or foreign key update caused by a DELETE statement are not valid because the primary key, unique constraint or unique index identified by "1" constrains table "DBO.MAIL_BOX" from having duplicate values for the index key.. SQLCODE=-803, SQLSTATE=23505, DRIVER=3.64.106
...
[4/28/20 17:41:16:906 WIB] 000040c5 SystemOut O [28/04/2020] [17:41:16:905] [ERROR] [IBControllerAction]:538 -
com.ib.common.error.exception.IBServiceException:
at com.ib.common.error.handler.IBErrorHandler.createServiceException(IBErrorHandler.java:148)
at com.ib.enterprise.services.ib117_securedmailbox.IBConfirmComposeMailServices.executeServices(IBConfirmComposeMailServices.java:185)
at com.ib.rib.controller.actions.ib117_securedmailbox.IBConfirmComposeMailAction.execute(IBConfirmComposeMailAction.java:91)

History

#1 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian over 4 years ago

  • Due date set to April 29, 2020
  • Status changed from New - Begin Life Cycle to Development / Work In Progress
  • % Done changed from 0 to 100

I have provided the solution and replied Bella in email:

Reported Problem:
Err when compose email

Root Cause:
MESSAGEID sequence in table MAIL_BOX is lesser than actual record

Solution:
select max(messageid)+1 from dbo.mail_box;
alter table dbo.mail_box alter column messageid restart with (n); --Replace (n) with max oid

#2 Avatar?id=2607&size=24 Updated by Rayvandy Gabbytian over 4 years ago

  • Status changed from Development / Work In Progress to Pending Customer Feedback
  • Assignee changed from Rayvandy Gabbytian to Zahir Abd Latif
  • % Done changed from 100 to 0

#3 Updated by Zahir Abd Latif over 4 years ago

  • Status changed from Pending Customer Feedback to Closed - End of life cycle
  • % Done changed from 0 to 100

Issue closed in SCP.

Also available in: Atom PDF