Troubleshooting
Problem
User clicks 'Maintain - Account Structure - Define'. User highlights an existing account, then presses 'delete' button.
- An error appears.
In addition, if a user runs a 'database optimise' a different error appears.
Symptom
The error varies slightly depending on environment/version.
Example #1 (Controller 10.2.0):

Source: FrangoDirect.AccountD.CheckAFC#ControllerProxyClient
Description: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Cannot create ActiveX component.
at Microsoft.VisualBasic.Interaction.CreateObject(String ProgId, String ServerName)
at Cognos.Controller.ControllerVFPWrapper.ControllerVFP..ctor(String sGuid, String sUser)
at FrAccountBT.AccountT.CheckAFC(String sGuid, String sUser, String sAccount)
at Cognos.Controller.Proxy.CCRWS.AccountT_CheckAFC(String sGuid, String sUser, String sAccount)
--- End of inner exception stack trace ---
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.Direct.AccountD.CheckAFC(String sAccount)
at Cognos.Controller.Forms.Form.frmAccount.DelCheck(String sAccount)
at Cognos.Controller.Forms.Form.frmAccount.DeleteAccount()
Example #2 (Controller 10.4.2):


Source: FrangoDirect.AccountD.CheckAFC#System.Web.Services
Description: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.IndexOutOfRangeException: Index was outside the bounds of the array.
at Cognos.Controller.ControllerVFPWrapper.ODBCHandler.ParseUDL()
at Cognos.Controller.ControllerVFPWrapper.ODBCHandler.GetUDlSetting(String key)
at Cognos.Controller.ControllerVFPWrapper.ODBCHandler.GetSqlUser()
at Cognos.Controller.ControllerVFPWrapper.ODBCHandler.GetDBInfoForVFP(String sGuid, String sUser)
at Cognos.Controller.ControllerVFPWrapper.ControllerVFP..ctor(String sGuid, String sUser)
at FrAccountBT.AccountT.CheckAFC(String sGuid, String sUser, String sAccount)
at Cognos.Controller.Proxy.CCRWS.AccountT_CheckAFC(String sGuid, String sUser, String sAccount)
Description: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.IndexOutOfRangeException: Index was outside the bounds of the array.
at Cognos.Controller.ControllerVFPWrapper.ODBCHandler.ParseUDL()
at Cognos.Controller.ControllerVFPWrapper.ODBCHandler.GetUDlSetting(String key)
at Cognos.Controller.ControllerVFPWrapper.ODBCHandler.GetSqlUser()
at Cognos.Controller.ControllerVFPWrapper.ODBCHandler.GetDBInfoForVFP(String sGuid, String sUser)
at Cognos.Controller.ControllerVFPWrapper.ControllerVFP..ctor(String sGuid, String sUser)
at FrAccountBT.AccountT.CheckAFC(String sGuid, String sUser, String sAccount)
at Cognos.Controller.Proxy.CCRWS.AccountT_CheckAFC(String sGuid, String sUser, String sAccount)
Error when running database optimise: (Controller 10.4.2)
Error occurred when deleting temporary VFP files: VFP dll missing (3)
[{"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
swg21663351