"Cannot insert duplicate key row in object 'dbo.#Ff83998f' with unique index 'IDX_#Ff83998f'. The duplicate key value is (-1, -1)." when using "Calculate Ownership Relations"

Troubleshooting

Problem

User clicks "Maintain - Company Structure - Calculate Ownership Relations". User clicks 'Run'. An error appears. This only occurs when the settings inside 'Consolidation Types - Define' is set to 'Automatic'. In other words, if the end user clicks "Maintain - Company Structure - Consolidation Types - Define", and then chooses the relevant code (for example "LE") and changes it to 'Manual', then it works OK.

Symptom

Standard Error
Number: 5
Source: FrangoDirect.GenCompStrucD.GenKStruc#System.Web.Services
Description: Server was unable to process request. ---> The statement has been terminated.
Cannot insert duplicate key row in object 'dbo.#Ff83998f' with unique index 'IDX_#Ff83998f'. The duplicate key value is (-1, -1).
at Microsoft.VisualBasic.ErrObject.Raise(Int32 Number, Object Source, Object Description, Object HelpFile, Object HelpContext)
at Cognos.Controller.Common.RaiseErrCli.RaiseError(Int32 lErrNo, String sErrSource, String sErrDesc, String sErrHelpFile, Int32 lErrHelpContext)
at Cognos.Controller.Common.RaiseErrCli.RaiseError(Int32 lErrNo, String sErrSource, String sErrDesc)
at Cognos.Controller.Direct.GenCompStrucD.GenKStruc(String sConsTyp, String sFirstPer, Boolean bOnlyManual, Boolean& bErr, Int64& lErr)
at Cognos.Controller.Forms.Form.frmGenCompStruc.DoGenKStruc(GenCompStrucD oGenCompStruct, String sConsType, String sFirstPer, Boolean bOnlyManual, Boolean& bErr, Int64& lErr)
at Cognos.Controller.Forms.Form.frmGenCompStruc.IRun_DoRun()

[{"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","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.

Was this topic helpful?

Document Information

More support for:
IBM Cognos Controller

Software version:
10.2.1

Operating system(s):
Windows

Document number:
529119

Modified date:
08 May 2025

UID

swg21959694

IBM Support

Tips