Troubleshooting
Problem
User clicks 'Maintain - Forms Define'. User selects an existing Free Form. User clicks 'X' to send it to Excel. Inside Excel, the user makes a change (for example, modifies an account) so that there are now two rows assigned to the same account number in a form. By design, Controller displays a message (telling the user that two cells reference the same account), then it asks if the user wants to reopen the form. - If the user chooses 'Yes' then it works OK (but all the changes are lost) - If the user chooses 'No' then (instead of returning the user to the form, so that they can fix the double reference to the accounts) an error appears. Excel may appear to have 'hung' (unable to click any cells).
Symptom
Triggering the Error:
Standard Error
Source: Microsoft.Office.Interop.Excel
Description: Exception from HRESULT: 0x800A03EC
at Cognos.Controller.Common.RaiseExceptionCli.RaiseException(Exception ex)
at Cognos.Controller.ControllerForms12.clsForms.ReopenWorkbook(String sForm, String sType, String sFileExtension)
at Cognos.Controller.ControllerForms12.clsForms.SaveLayout(Boolean bContinueOnFailedValidation, Boolean bUserActivated, Boolean bFromClose, Boolean bValidate, Boolean bFromProcessLayout, String& sFileExt)
at Cognos.Controller.ControllerForms12.clsForms.XLWBev_BeforeSave(Workbook& Wb, Boolean SaveAsUi, Boolean& Cancel, Boolean FileFormatChanged)
Exception from HRESULT: 0x800A03EC
User originally sees this:
- "There are duplicate parameters in cells xx and yy"
User clicks 'No' to this:
- "FDF_TEST.xlsx is already open. Reopening will cause any changes you made to be discarded. Do you want to reopen FDP_TEST.xlsx?"
Error message:
The error varies depending on whether the end user is a Windows administrator (or not) on the client device.
Windows Administrator:
Standard Error
Source: Microsoft.Office.Interop.Excel
Description: Exception from HRESULT: 0x800A03EC
at Cognos.Controller.Common.RaiseExceptionCli.RaiseException(Exception ex)
at Cognos.Controller.ControllerForms12.clsForms.ReopenWorkbook(String sForm, String sType, String sFileExtension)
at Cognos.Controller.ControllerForms12.clsForms.SaveLayout(Boolean bContinueOnFailedValidation, Boolean bUserActivated, Boolean bFromClose, Boolean bValidate, Boolean bFromProcessLayout, String& sFileExt)
at Cognos.Controller.ControllerForms12.clsForms.XLWBev_BeforeSave(Workbook& Wb, Boolean SaveAsUi, Boolean& Cancel, Boolean FileFormatChanged)
Standard (non-admin) Windows User:
Exception from HRESULT: 0x800A03EC
[{"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
Modified date:
08 May 2025
UID
swg21988024