Troubleshooting
Problem
User clicks "Group - Consolidate with status". User chooses selections, and clicks 'Run'. An error appears. Problem only affects some consolidations. For example, the problem may only affect one group.
Symptom
Batch queue error:
Finished with Error
Connectivity error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint 'PKNC_XDB15'. Cannot insert duplicate key in object 'cognos.xdb15'
Screen error, if the batch queue is disabled:
Standard Error
Number: 5
Source: ControllerProxyClient
Description: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: The statement has been terminated.
String or binary data would be truncated.
at Microsoft.VisualBasic.ErrObject.Raise(Int32 Number, Object Source, Object Description, Object HelpFile, Object HelpContext)
at ControllerServerCommon.RaiseErrSrv.RaiseError(String sUser, Int32 lErrNo, String sErrSource, String sErrDesc, String sErrHelpFile, Int32 lErrHelpContext)...
Contents of "logvfp.log" file (located on the Controller application server):
- COGNOS CONTROLLER Technical log - Consolidation modules
***** Date: 2015/03/19 Time: 15:49:38 *****
Call Stack:
1 - PROCEDURE MAIN.RUNKONSOL C:\PROGRAM FILES\IBM\COGNOS\CCR_64\SERVER\LIBS\FRANGOLIB.VCT - Line 86
2 - PROCEDURE KONSOLPS KONSOLPS.FXP - Line 424
3 - PROCEDURE ICMAINS ICMAINS.FXP - Line 201
4 - PROCEDURE UPDATEXDB ICMAINS.FXP - Line 3747
5 - FEVENTUPDS.FXP - Line 190
6 - FPSQL.FXP - Line 331
7 - PROCEDURE INSSQLXDB FPSQL.FXP - Line 402
8 - PROCEDURE FSQLERR FSQLERR.FXP - Line 88
Program statement: Not available, c:\program files\ibm\cognos\ccr_64\server\progs\fsqlerr.prg not found
Error number: 2005
Message text: Connectivity error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Violation of PRIMARY KEY constraint 'PKNC_XDB15'. Cannot insert duplicate key in object 'cognos.xdb15'.
[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"10.2.0","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
Modified date:
08 May 2025
UID
swg21699843