Pivot Table update failure from PowerPivot - by altID

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


1
0
Sign in
to vote
ID 732496 Comments
Status Closed Workarounds
Type Bug Repros 1
Opened 3/21/2012 5:32:23 PM
Access Restriction Public

Description

A pivot table failed to load from data in PowerPivot (~12M rows of data).  Error report follows.

============================
Error Message:
============================

Exception from HRESULT: 0x800A03EC
----------------------------

----------------------------
The command was canceled. Please press F1 to get the help topic "Excel Window: PowerPivot Field List" for more details. 

============================
Call Stack:
============================


Server stack trace: 


Exception rethrown at [0]: 
   at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   at Microsoft.Office.Interop.Excel.CubeField.set_Orientation(XlPivotFieldOrientation RHS)
   at Microsoft.AnalysisServices.Modeler.FieldList.ExcelInterOpUtil.AddToFields(String cubeFieldName, XlPivotFieldOrientation pivotOrientation, Int32 positionIndex)
----------------------------
   at Microsoft.AnalysisServices.Modeler.FieldList.ExcelInterOpUtil.AddToFields(String cubeFieldName, XlPivotFieldOrientation pivotOrientation, Int32 positionIndex)
   at Microsoft.AnalysisServices.Modeler.FieldList.GeminiPivot.SetFieldOrientation(FieldLocation location, IGeminiColumn column, Int32 positionIndex)
----------------------------
   at Microsoft.AnalysisServices.Modeler.FieldList.GeminiPivot.SetFieldOrientation(FieldLocation location, IGeminiColumn column, Int32 positionIndex)
   at Microsoft.AnalysisServices.Modeler.FieldList.GeminiPivot.AddToFieldList(FieldLocation location, IGeminiColumn column, Int32 positionIndex)
   at Microsoft.AnalysisServices.Modeler.FieldList.GeminiPivot.MoveField(IGeminiColumn column, FieldLocation source, FieldLocation target, Int32 positionIndex)
   at Microsoft.AnalysisServices.Modeler.FieldList.FieldListControl.MoveField(IGeminiColumn field, ItemAreas targetArea, ItemAreas sourceArea, Int32 targetIndex)
   at Microsoft.AnalysisServices.Modeler.FieldList.DropAreaListBox.OnDragDrop(DragEventArgs drgevent)

============================
Sign in to post a comment.
Posted by Microsoft on 9/21/2012 at 11:19 AM
Hello, The problem here is that you probably put a value on rows that contain too many values. Excel cannot handle this and will throw an exception. There is nothing PowerPivot van do in this scenario. Regards, Kasper de Jonge
Posted by Kasper [MSFT] on 5/3/2012 at 9:07 AM
Hello,

The problem here is that you probably put a value on rows that contain too many values. Excel cannot handle this and will throw an exception. There is nothing PowerPivot van do in this scenario.

Regards,
Kasper de Jonge