** Troubleshooting ** "Violation of PRIMARY KEY constraint ... Cannot insert duplicate key in object" errors when running Consolidations

Troubleshooting

Problem

User runs a consolidation. Afterwards, the user looks inside the 'View Batch Queue'. The relevant batch row is highlighted in red, with the status "Finished with Error". Inside the 'details' section, there is more information.

Symptom

Details Section 12345
Text
The following companies are missing data for the submission...
All companies are reconciled without errors...
There is more then one top group for one or more periods...
15:44:26 Consolidation process is started for group '0801', Period and actuality 1010AC.
15:44:26 Currency conversion is started
Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL erver]Violation of PRIMARY KEY constraint 'PKNC_XDB10'. Cannot insert duplicate key in object 'dbo.xdb10'.

[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.1;10.2.0;10.1.1;10.1;8.5.1;8.5;8.4;8.3","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}},{"Product":{"code":"SSMRTZ","label":"IBM Cognos Controller on Cloud"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":" ","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB76","label":"Data Platform"}}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Tips

Troubleshooting "Violation of PRIMARY KEY constraint ... Cannot insert duplicate key in object" errors when running Consolidations