1759794 - EPM - General Error: Error in RefreshSheet | SAP Knowledge Base Article

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.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

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 ONE Support launchpad (Login required).

Search for additional results

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