Summary:
This article troubleshoots an error that occurs within Report Designer when changes are made due to possible corruption or lack of resources.
Article sections:
Symptoms:
When trying to make changes in Excel, the user receives the following error:
An internal error occurred. Please restart Excel and try again.
System.Runtime.InteropServices.COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC
at System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
at Microsoft.Office.Interop.Excel.Range.get__Default(Object RowIndex, Object ColumnIndex)
at OneStop.ReportPlayer.ExcelHelper.GetCell(Worksheet ws, Int32 row, Int32 column)
at OneStop.ReportDesigner.Mapping.SheetMapping.CreateItem(DefinitionItemType type, Int32 row, Int32 column, Int32 size, Int32 limit)
at OneStop.ReportDesigner.Forms.DefinitionPane._createStorage_Click(Object sender, EventArgs e)
at System.Windows.Forms.Control.OnClick(EventArgs e)
at System.Windows.Forms.Button.OnClick(EventArgs e)
at System.Windows.Forms.Button.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
OSR Version: 5.2.40917.1529
Causes:
This error is a generic error that unfortunately does not provide a lot of information as to what causes it. It could be due to Excel crashing, a corrupted report, or the machine not having enough resources to run Excel/Report Designer, etc.
Often this error occurs by user error, e.g. an end-user chooses Create Storage (instead of Create Group) on the row or column of their template; however, this is not possible by the design of the application - storage can only be created at the cell level.
Resolution:
Due to its generic nature, it is best to submit a ticket to our Support team with details as to what could have potentially changed within your environment, how many users this affects, and what precise steps/actions are taken that produce this error. Video replication would be best, but screenshots with detailed steps work just as well.
Additionally, when submitting a ticket to Support, please provide the Excel version, bitness, etc.
Properties:
Cloud
Private Host