Troubleshooting
Problem
User tries to add a new user account inside Controller, but receives an error #1, User then tries to run the 'User Rights and Security Group Reports' report. User gets error #2.
Symptom
Error #1
Information
Standard Error
Number: 5
Source:
ControllerProxyClient:FrangoClient.clsRightsCache.InsertRecords.FrangoClient.cls Users.Insert:
FrangoClient.frmUserAndInstallationRights.SaveUser:FrangoClient.
frmUserAndInstallationRights.Ifile_DoSave
Description: System.WebServices.Protocols.SoapException: Server was unable to process request. --->
System.Runtime.InteropServices.COMException (0x80004005): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=, >, >= or when the subquery is used as an expression.
at FrMiscST.MedlemSetTClass.InsertRecords(String sGuid, Recordset rdRecord, String sUser, Int32 LLocale)
at Cognos.Controller.Proxy.CCRWS.MedlemSetT_InsertRecords(String sGuid, DataSet rsRecord, String sUser, Int32 LLocale)
--- End of inner exception stack trace ---
OK
Error #2
IBM Cognos 8 Controller
Unhandled exception has occurred in a component in your application. If you click continue, the application will ignore this error
and attempt to continue.
Argument 'Number' is not a valid value.
Details Continue
Information
Standard Error
Number: 5
Source:
ControllerProxyClient:FrangoClient.clsRightsCache.InsertRecords.FrangoClient.cls Users.Insert:
FrangoClient.frmUserAndInstallationRights.SaveUser:FrangoClient.
frmUserAndInstallationRights.Ifile_DoSave
Description: System.WebServices.Protocols.SoapException: Server was unable to process request. --->
System.Runtime.InteropServices.COMException (0x80004005): Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <=, >, >= or when the subquery is used as an expression.
at FrMiscST.MedlemSetTClass.InsertRecords(String sGuid, Recordset rdRecord, String sUser, Int32 LLocale)
at Cognos.Controller.Proxy.CCRWS.MedlemSetT_InsertRecords(String sGuid, DataSet rsRecord, String sUser, Int32 LLocale)
--- End of inner exception stack trace ---
OK
Error #2
IBM Cognos 8 Controller
Unhandled exception has occurred in a component in your application. If you click continue, the application will ignore this error
and attempt to continue.
Argument 'Number' is not a valid value.
Details Continue
[{"Product":{"code":"SS9S6B","label":"IBM Cognos Controller"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Component":"Controller","Platform":[{"code":"PF033","label":"Windows"}],"Version":"Controller (Frango) 8.2","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.
Historical Number
1036592
Was this topic helpful?
Document Information
Modified date:
08 May 2025
UID
swg21347429