Skip to main content

Duplicate key error in orc_TaskKPIs table

This article explains an issue where a duplicate key error occurs in Task KPIs, preventing data from being saved. It outlines when the error may appear and provides guidance on how to get assistance from Support.

Written by Charnjit Singh Dharival

Overview

When importing data, you may come across the following error message:
​
​Cannot insert duplicate key row in object 'dbo.orc_TaskKPIs with unique index 'IX_orc_TaskKPIs'. The duplicate key value is (11, accbc47d-0ce-4470-a460-7ada66351441, 12804).
​
import command: EXEC [wf].[pr_Merge_taskKPIs]

What to do next

Please contact support, and include the error message you are seeing. We will be happy to help!!

Related Articles
Duplicate key error when saving item attribute values
Error: 'Cannot insert duplicate key row in object dbo.orc_TaskRelations with unique index'
Duplicate key error in affected attribute values
Error: 'Violation of PRIMARY KEY constraint 'PK_orctmp_CustomerOrderItemAttributeValues_RowID'. Cannot insert duplicate key'
Error: 'Cannot insert duplicate key row in object dbo.orc_Tasks with unique index UQ_orc_Tasks'
Did this answer your question?