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.x, version for Microsoft
- SAP Business Planning and Consolidation 10.x, 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.
SAP Knowledge Base Article - Preview