Support #10758
[SCP ID :##5314##] : M2U - Compose
Status: | Closed - End of life cycle | Start date: | April 28, 2020 | |
---|---|---|---|---|
Priority: | Normal | Due 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 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 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.