Violation of PRIMARY KEY constraint 'PK_OFS' Error while making REST API call on Automic

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

When attempting to make an API call, receiving below  error

"Violation of PRIMARY KEY constraint 'PK_OFS'. Cannot insert duplicate key in object 'dbo.OFS'."

API call

POST http://*********:8088/ae/api/v1/12/repositories/pull [400 Bad Request, 282B, 8ms]

 
{
  "code" : 45106,
  "error" : "The request is invalid and cannot be processed by the Automation Engine.",
  "details" : "No detail information available."
}

Errors on the REST log:

U00003434 Server routine  'RepositoriesResource' on the rest logs.

U00045015 The previous error was caused by 'com.microsoft.sqlserver.jdbc.SQLServerException: "Violation of PRIMARY KEY constraint 'PK_OFS'. Cannot insert duplicate key in object 'dbo.OFS'. The duplicate key value is (1033008)."' at 'com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError():217'.

U00003620 Routine 'com.automic.rest.provider.BaseExceptionMapper' forces trace because of error.

Environment

AE V 24.2

Cause

Defect

Resolution

This issue is identified as a defect on the product, and the fix is expected to be published in a future release of AE V 24.4

For fix release date details, contact Broadcom Support.

Additional Information

DE174963