Wednesday, March 28, 2012

rsErrorReadingNextDataRow ?

Hello,

I am using an scheduled report...
and directly apply a snapshot...
After a long time (it's a huge report) I got this error: rsErrorReadingNextDataRow !
I am using a datasource with stored credentials to my analysis services 2005 !

Kind regards.

Stack Trace:

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD> <script language="JScript" type="text/Javascript" src="/Reports/js/ReportingServices.js"></script>

<TITLE>Report Manager</TITLE>
<link href="/Reports/styles/ReportingServices.css"type="text/css" rel="stylesheet">
<META Name="Generator" CONTENT="Microsoft SQL Server Report Manager 9.00.2047.00">
<META Name="Report Server" CONTENT="http://localhost/ReportServer">
<META Name="HTTP Status" CONTENT="400">
<META Name="ProductLocaleID" CONTENT="">
<META Name="CountryLocaleID" CONTENT="">
<META Name="StackTrace" CONTENT="System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An error has occurred during report processing. > Microsoft.ReportingServices.Diagnostics.Utilities.RSException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ProcessingAbortedException: An error has occurred during report processing. > Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Cannot read the next data row for the data set Navision_Analysis. > Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: File system error: The record ID is incorrect. Physical file: . Logical file: .
at Microsoft.AnalysisServices.AdomdClient.AdomdDataReader.SequentialReadXmlValue(Int32 ordinal)
at Microsoft.AnalysisServices.AdomdClient.AdomdDataReader.GetRowXmlValues(Object[] xmlValues)
at Microsoft.AnalysisServices.AdomdClient.AdomdDataReader.InternalRead()
at Microsoft.AnalysisServices.AdomdClient.AdomdDataReader.Read()
at Microsoft.ReportingServices.DataExtensions.AdoMdDataReader.Read()
at Microsoft.ReportingServices.DataExtensions.MappingDataReader.GetNextRow()
End of inner exception stack trace
at Microsoft.ReportingServices.DataExtensions.MappingDataReader.GetNextRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.GetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.FirstPassGetNextDetailRow()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPass()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.FirstPassProcess(Boolean&amp; closeConnWhenFinish)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeReportDataSetNode.Process()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RuntimeDataSetNode.ProcessConcurrent(Object threadSet)
End of inner exception stack trace
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessingContext.AbortHelper.ThrowAbortException(Int32 reportUniqueName)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessingContext.CheckAndThrowIfAborted()
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.Merge.Process(ParameterInfoCollection parameters, Boolean mergeTran)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report report, ProcessingContext pc, ProcessingContext context)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report report, ProcessingContext pc, Boolean snapshotProcessing, Boolean processWithCachedData, GetReportChunk getChunkCallback, ErrorContext errorContext, DateTime executionTime, CreateReportChunk cacheDataCallback, ProcessingContext&amp; context)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.CreateSnapshot(DateTime executionTimeStamp, GetReportChunk getChunkCallback, ProcessingContext pc)
at Microsoft.ReportingServices.Library.CreateSnapshotExecutor.CallProcessing(Boolean unattended, Boolean permanent)
at Microsoft.ReportingServices.Library.CreateSnapshotExecutor.CreateSnapshot(Boolean unattended, Boolean permanent)
at Microsoft.ReportingServices.Library.RSService.InternalUpdateSnapshot(String reportPath)
at Microsoft.ReportingServices.Library.UpdateExecutionSnapshotCancelableStep.Execute()
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
End of inner exception stack trace
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at Microsoft.ReportingServices.Library.RSService.CancelableUpdateSnapshot(String reportPath, JobType type)
at Microsoft.ReportingServices.Library.RSService.UpdateSnapshot(Guid batchId, String reportPath, JobType type)
at Microsoft.ReportingServices.WebServer.ReportingService2005.UpdateReportExecutionSnapshot(String Report)
End of inner exception stack trace
at Microsoft.ReportingServices.WebServer.ReportingService2005.UpdateReportExecutionSnapshot(String Report)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.UpdateReportExecutionSnapshot(String Report)
at Microsoft.SqlServer.ReportingServices2005.RSConnection.UpdateReportExecutionSnapshot(String Report)
at Microsoft.ReportingServices.UI.ReportExecutionOptionsControl.SaveStateToServer()
at Microsoft.ReportingServices.UI.ReportExecutionOptionsControl.ApplyChanges()
at Microsoft.ReportingServices.UI.ExecutionProperties.ApplyChanges()
at Microsoft.ReportingServices.UI.BaseApplyPage.ApplyBtn_Click(Object sender, EventArgs e)
at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
at Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)">
</HEAD>
<BODY style="margin:0px;" class="msrs-normal" onload=""><form name="ui_form" method="POST" action="Error.aspx" id="ui_form" enctype="multipart/form-data">
<div>
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwUENTM4MQ9kFgICAQ9kFgICAw9kFgJmD2QWAmYPZBYCZg9kFgRmDxYCHgdWaXNpYmxlaGQCAQ9kFgJmD2QWAmYPZBYCZg9kFgJmD2QWAgICD2QWAgICD2QWAmYPZBYCZg8WAh8AaGRkDX9poy1X20358cQWXj5DJqJca60=" />
</div>
<span><table width="100%" class="msrs-normal" cellpadding="0" cellspacing="0" height="100%">
<tr id="ui_sharedArea">
<td valign="top"><table width="100%" class="msrs-normal" cellpadding="0" cellspacing="0">
<tr>
<td valign="middle" width="76px" nowrap="nowrap"><font size="0"><br></font><img src="/Reports/images/blank.gif" height="1" width="12" border="0" /><img src="/Reports/images/48error.jpg" height="48" width="48" alt="Error" /><img src="/Reports/images/blank.gif" height="1" width="12" border="0" /><font size="0"><br></font><img src="/Reports/images/blank.gif" height="8" width="1" border="0" /></td>
<td valign="middle"><div class="msrs-uppertitle">SQL Server Reporting Services</div><div class="msrs-normal"></div><div class="msrs-lowertitle">Error</div></td>
<td valign="top" width="0" align="right"><font size="0"><br></font><img src="/Reports/images/blank.gif" height="8" width="1" border="0" /><div><span></span><img src="/Reports/images/blank.gif" height="1" width="5" border="0" /></div></td>
</tr>
</table>
</td>
</tr>
<tr id="ui_tabStrip">
<td valign="top"><table width="100%" class="msrs-normal" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" colspan="3" class="msrs-sectionline"><img src="/Reports/images/blank.gif" height="4" width="1" border="0" /></td>
</tr>
<tr>
<td valign="top" colspan="3" class="msrs-thinPageBorder"><img src="/Reports/images/blank.gif" height="4" width="1" border="0" /></td>
</tr>
</table>
</td>
</tr>
<tr>
<td valign="top" height="100%"><table width="100%" class="msrs-contentFrame" cellpadding="0" cellspacing="0" height="100%">
<tr>
<td valign="top" width="10"><img src="/Reports/images/blank.gif" height="0" width="10" /></td>
<td valign="top" height="100%"><span><table width="100%" class="msrs-normal" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"><img src="/Reports/images/blank.gif" height="8" width="1" border="0" /></td>
</tr>
<tr>
<td valign="top" class="msrs-normal"><span><table width="100%" class="msrs-normal" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" colspan="2" class="msrs-normal">An error has occurred during report processing. (rsProcessingAborted) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsProcessingAborted&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=9.00.2047.00" target="_blank">Get Online Help</a><table width="100%" class="msrs-normal" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" width="25"><img src="/Reports/images/blank.gif" height="0" width="25" /></td>
<td valign="top" colspan="2" class="msrs-normal">Cannot read the next data row for the data set Navision_Analysis. (rsErrorReadingNextDataRow) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&amp;EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&amp;EvtID=rsErrorReadingNextDataRow&amp;ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&amp;ProdVer=9.00.2047.00" target="_blank">Get Online Help</a></td>
</tr>
<tr>
<td valign="top" width="25"><img src="/Reports/images/blank.gif" height="0" width="25" /></td>
<td valign="top" colspan="2" class="msrs-normal">File system error: The record ID is incorrect. Physical file: . Logical file: .</td>
</tr>
</table>
</td>
</tr>
</table>
</span></td>
</tr>
<tr>
<td valign="top"><img src="/Reports/images/blank.gif" height="8" width="1" border="0" /></td>
</tr>
<tr>
<td valign="top"><img src="/Reports/images/blank.gif" height="8" width="1" border="0" /></td>
</tr>
<tr>
<td valign="top"><a href="/Reports/Pages/Folder.aspx">Home</a></td>
</tr>
</table>
</span></td>
<td valign="top" width="10"><img src="/Reports/images/blank.gif" height="0" width="10" /></td>
</tr>
</table>
</td>
</tr>
</table>
</span></form></BODY></HTML>

hello,

I have a similar problem, in scheduled report and also in running the report within VS2005.

the error message is:

cannot read the next data row for the data set xxx
File system error: The record ID is incorrect. Physical file: .Logical file: .

found any solution on this ?

|||

I have done exactly the same way as John as specified in the link below.

http://blogs.msdn.com/jgalla/archive/2006/10/11/session-timeout-during-execution.aspx

this made my report run longer time, but with

  • An error has occurred during report processing.
  • Cannot read the next data row for the data set xxxxx.
  • Invalid attempt to NextResult when reader is closed.
  • Please explain and suggest me a solution.
    • Posted by rodshapedasdc at 7:52 AM
    Labels: , , , , , , , , , , , , , ,

    No comments:

    Post a Comment

    Subscribe to: Post Comments (Atom)