Cannot insert duplicate key row in object 'dbo.WMSERVICE_MIN_MAX' with unique index 'IDX_SVC_MINMAX_

,
1

Hi All,

When we changed logging mode to Asynchronous we are getting below errors in server logs:

[WmAuditingSC.queue.2406E] AuditQueueWorker for queue ‘Service Queue’ failed to log event to destination ‘ServiceDBDest’; reason ‘[SoftwareAG][SQLServer JDBC Driver][SQLServer]Cannot insert duplicate key row in object ‘dbo.WMSERVICE_MIN_MAX’ with unique index ‘IDX_SVC_MINMAX_CTX’. The duplicate key value is (b7d00610-869a-1c76-b2e1-99df6c8d75d2).’; stack trace follows

[WmAuditingSC.destination.1122E] Destination ‘ServiceDBDest’ caught unexpected Throwable logging audit event: [SoftwareAG][SQLServer JDBC Driver][SQLServer]Cannot insert duplicate key row in object ‘dbo.WMSERVICE_MIN_MAX’ with unique index ‘IDX_SVC_MINMAX_CTX’. The duplicate key value is (b7d00610-869a-1c76-b2e1-99df6c8d75d2)

Could you please help me how we can avoid/fix this error ?

Thanks in advance
Regards Miki

2

Hi All,

Could you please help me how we can avoid/fix this error ?

Thanks
Miki

3

Install the latest DCC fixes for your IS and test.

4

Hi Mahesh,

we did that but still we are getting the same error.

we have applied the DC fix 14 . in that we have not executed the archive script only after from that all we have updated.

Thanks
Miki