Hello.

Whenever we handle a ticket, assign to a technician, update status, suspend the ticket, we get this popup "Error occurred while adding history details".

No history whatsoever is saved in the "history" tab, regarding all activities about tickets.

Server hasn't been rebooted in 2 months, but free disk space is ok.

The culprit seems to be in here:

[***long java exception***]

...
[10:26:04:962]|[01-05-2024]|[com.manageengine.servicedesk.utils.TechnicianTimerUtil]|[INFO]|[73]: ALL TECHNICIAN MARKING ENTRIES HAVE BEEN CLOSED FOR WORKORDER 96|
[10:26:04:992]|[01-05-2024]|[com.manageengine.sdpod.v3api.utils.workorder.WorkOrderAPIUtil]|[INFO]|[73]: Inside removeInvalidFieldsAndTransformBean method|
[10:26:04:992]|[01-05-2024]|[com.manageengine.servicedesk.workorder.util.WorkOrderValidationUtil]|[INFO]|[73]: Inside validateTemplateFields method|
[10:26:04:992]|[01-05-2024]|[com.manageengine.sdpod.v3api.listener.EntityListenerUtil]|[INFO]|[73]: Going to call After DB Listener : class com.manageengine.sdpod.v3api.listener.WorkOrderListener for UPDATE|
[10:26:04:992]|[01-05-2024]|[com.manageengine.sdpod.v3api.listener.WorkOrderListener]|[INFO]|[73]: Inside WorkOrderListener afterDBEvent|
[10:26:05:022]|[01-05-2024]|[com.manageengine.sdpod.v3api.utils.workorder.WorkOrderAPIUtil]|[INFO]|[73]: Inside removeInvalidFieldsAndTransformBean method|
[10:26:05:022]|[01-05-2024]|[com.manageengine.servicedesk.workorder.util.WorkOrderValidationUtil]|[INFO]|[73]: Inside validateTemplateFields method|
[10:26:05:022]|[01-05-2024]|[com.manageengine.sdpod.v3api.utils.workorder.WorkOrderAPIUtil]|[INFO]|[73]: Module :  request .Operation : UPDATE. WorkOrder Id : 96. User Id : 303. Message : Inside post update event | Invocation Class : com.manageengine.sdpod.v3api.utils.workorder.WorkOrderUpdateAPIUtil|
[10:26:05:032]|[01-05-2024]|[com.adventnet.db.adapter.postgres.PostgresExceptionSorter]|[SEVERE]|[73]: Returning [true] from isDBAlive method ErrorCode: 0 SqlState: 23505|
[10:26:05:032]|[01-05-2024]|[com.adventnet.db.adapter.BaseExceptionSorter]|[SEVERE]|[73]: SQLState :: [23505], Error Code:: [0]|
[10:26:05:032]|[01-05-2024]|[com.adventnet.db.adapter.BaseExceptionSorter]|[SEVERE]|[73]: Returning [true] from isDBAlive method|
[10:26:05:032]|[01-05-2024]|[com.zoho.cp.Txn]|[SEVERE]|[73]: Txn rollback occurs|
[10:26:05:032]|[01-05-2024]|[com.manageengine.sdpod.v3api.utils.workorder.WorkOrderAPIUtil]|[SEVERE]|[73]: Module :  request .Operation : UPDATE. WorkOrder Id : 96. User Id : 303. Message : Exception occured while adding history. | Invocation Class : com.manageengine.sdpod.v3api.utils.workorder.WorkOrderUpdateAPIUtil|
[10:26:05:032]|[01-05-2024]|[SYSERR]|[INFO]|[73]: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO WorkOrderHistory (HISTORYID,WORKORDERID,OPERATIONOWNERID,OPERATIONTIME,DESCRIPTION,OPERATION) VALUES (274,96,303,1704446764922,NULL,'CLOSE') was aborted: ERROR: duplicate key value violates unique constraint "workorderhistory_pk"
  Detail: Key (historyid)=(274) already exists.  Call getNextException to see other errors in the batch.|
[10:26:05:032]|[01-05-2024]|[SYSERR]|[INFO]|[73]:     at com.adventnet.db.adapter.postgres.PostgresDBAdapter.maskMessage(PostgresDBAdapter.java:1859)|

History used to work correctly up to a few weeks ago. Database is the integrated PGSQL.

Ideas?

Thank you.