SAP Knowledge Base Article - Preview

1759794 - EPM - General Error: Error in RefreshSheet

Symptom

The following EPM - General Error appears when you try to refresh an EPM Add-In report that was created in a prior version of the EPM Add-in:

Error in RefreshSheet

 EPMAddInError.JPG

The following error appears in the Log.glf file:
2012-08-31 10:35:36,950|ERROR|AnalyzerOne|FPMXLClient.AddIn.RefreshSheetWithScan||||||1|Error in RefreshSheet#

The following error appears in the Trace.glf file:
#
2012-08-31 10:35:36,953|ERROR|AnalyzerOne|?.?||||||1|FPMXLClient.Common.FPMXLClientException: Error in RefreshSheet ---> System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
   at System.Collections.Generic.List`1.RemoveAt(Int32 index)
   at FPMXLClient.ReportManagement.AxisOverrideParams.CheckUnicityOfDimension(Boolean hideHierarchies, ReadOnlyCollection`1 dimensionList) in d:\Olympus_100_REL_XLCLIENT\src\FPMXLClient\src\ReportManagement\Functions\FormulaParams.cs:line 913
   at FPMXLClient.ReportManagement.DynamicReport.CheckUnicityOfDimensionByAxe(Boolean hideHierarchies, AxisOverrideParams& axisOverrideForRows, AxisOverrideParams& axisOverrideForColumns) in d:\Olympus_100_REL_XLCLIENT\src\FPMXLClient\src\ReportManagement\Report\DynamicReport.cs:line 6774
   at FPMXLClient.ReportManagement.DynamicReport.OverrideProcesses(Boolean hideHierarchies, Boolean needToUseSheetReportResultForDefinition, Boolean applyOverrideOnRow, Boolean applyOverrideOnColumn, Boolean updateTopLeft, Boolean hasOverrideRequestedOnDimensionOrAxis, Boolean updateOppositeTopLeft) in d:\Olympus_100_REL_XLCLIENT\src\FPMXLClient\src\ReportManagement\Report\DynamicReport.cs:line 2580
   at FPMXLClient.Office.EPMExcelReportManager.LoadReports(IEnumerable`1 dynamicReportIdentifiers, Boolean useScan, Boolean forceScanIfDummyMembers) in d:\Olympus_100_REL_XLCLIENT\src\FPMXLClient\src\Office\EPMExcelReportManager.cs:line 406
   at FPMXLClient.Office.EPMExcelReportManager.DoRefreshAllReports(Boolean executeReport, Boolean useScan) in d:\Olympus_100_REL_XLCLIENT\src\FPMXLClient\src\Office\EPMExcelReportManager.cs:line 1502
   at FPMXLClient.Office.EPMReportManager.RefreshAllReports(Boolean executeReport, Boolean useScan) in d:\Olympus_100_REL_XLCLIENT\src\FPMXLClient\src\Office\EPMReportManager.cs:line 3411
   at FPMXLClient.Office.EPMExcelSheet.RefreshReports(Boolean useScan) in d:\Olympus_100_REL_XLCLIENT\src\FPMXLClient\src\Office\EPMExcelSheet.cs:line 2573
   at FPMXLClient.Office.EPMExcelSheet.RefreshSheet(Boolean useScan, Boolean refreshReports, Boolean refreshCaches, Boolean callToExpand, Boolean callFromBooks) in d:\Olympus_100_REL_XLCLIENT\src\FPMXLClient\src\Office\EPMExcelSheet.cs:line 1782
   --- End of inner exception stack trace ---
   at FPMXLClient.Office.EPMExcelSheet.RefreshSheet(Boolean useScan, Boolean refreshReports, Boolean refreshCaches, Boolean callToExpand, Boolean callFromBooks) in d:\Olympus_100_REL_XLCLIENT\src\FPMXLClient\src\Office\EPMExcelSheet.cs:line 1854
   at FPMXLClient.Office.EPMExcelSheet.RefreshSheetAndSetTime(Boolean useScan, Boolean refreshCaches, Boolean callToExpand, Boolean callFromBooks) in d:\Olympus_100_REL_XLCLIENT\src\FPMXLClient\src\Office\EPMExcelSheet.cs:line 1878
   at FPMXLClient.Office.EPMExcelSheet.DoRefreshDocument(Boolean useScan, Boolean clearApplicationsCache, Boolean callToExpand, Boolean callFromBooks) in d:\Olympus_100_REL_XLCLIENT\src\FPMXLClient\src\Office\EPMExcelSheet.cs:line 1160
   at FPMXLClient.Office.OfficeConnectionContainer.RefreshDocument(Boolean useScan, Boolean clearApplicationsCache, Boolean callToExpand, Boolean callFromBooks) in d:\Olympus_100_REL_XLCLIENT\src\FPMXLClient\src\Office\OfficeConnectionContainer.cs:line 157
   at FPMXLClient.Office.OfficeConnectionContainer.RefreshDocument(Boolean useScan, Boolean clearApplicationsCache) in d:\Olympus_100_REL_XLCLIENT\src\FPMXLClient\src\Office\OfficeConnectionContainer.cs:line 149
   at FPMXLClient.AddIn.RefreshSheetWithScan() in d:\Olympus_100_REL_XLCLIENT\src\FPMXLClient\src\AnalyzerOne\AddIn.cs:line 1574


Read more...

Environment

  • SAP Business Planning and Consolidation 10.x, version for Microsoft
  • SAP Business Planning and Consolidation 10.x, version for SAP NetWeaver

Product

SAP Business Planning and Consolidation 10.0, version for Microsoft ; SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver ; SAP Business Planning and Consolidation 10.1, version for Microsoft ; SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver

Keywords

refreshsheet, refresh sheet, epm add-in, epm addin, epmaddin, EPMAxisOverride, EPMAxisOveride , KBA , defect , reporting , EPM-BPC-NW-EXC , Excel , EPM-XLS , EPM Excel Client , EPM-BPC-MS-EXC , Excel , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.