I have a PerformancePoint grid from which users can drillthrough into records in the underlying cube. The cube itself imposes no limit on the number of records returned by drillthrough. The server has a limit of 10,000 drillthrough
records. The Analysis Services build is 10.0.2531.0 In any event, the drillthrough itself
always works, but when the number of records is large (say, 6000 or so), users receive the following error when attempting to export the results to excel:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: The AdomdDataReader object is not positioned at a valid row.
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
[InvalidOperationException: The AdomdDataReader object is not positioned at a valid row.]
Microsoft.AnalysisServices.AdomdClient.AdomdDataReader.InternalGetValue(Int32 ordinal) +423
Microsoft.AnalysisServices.AdomdClient.AdomdDataReader.GetString(Int32 ordinal) +7
View Complete Post