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
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.0, version for Microsoft
- SAP Business Planning and Consolidation 10.1, version for Microsoft
- SAP Business Planning and Consolidation 10.0, version for SAP NetWeaver
- SAP Business Planning and Consolidation 10.1, version for SAP NetWeaver
Product
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.