"Standard Error ... Dynamic SQL generation for the UpdateCommand is not supported ..." 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#ControllerProxyClient
Description: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.ArgumentException: Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information.
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)
at FrCompanyBT.GenCompStrucT.GenKStruc(String sGuid, String sUser, String sConsType, String sFirstPer, Boolean bOnlyManual, Boolean& bErr, Int32& lErr)
at Cognos.Controller.Proxy.CCRWS.GenCompStrucT_GenKStruc(String sGuid, String sUser, String sConsType, String sFirstPer, Boolean bOnlyManual, Boolean& bErr, Int32& lErr)
--- End of inner exception stack trace ---

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

Operating system(s):
Windows

Document number:
257047

Modified date:
08 May 2025

UID

swg21698644

IBM Support

Tips