Showing posts with label rserrorreadingnextdatarow. Show all posts
Showing posts with label rserrorreadingnextdatarow. Show all posts

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

    I have a user who is getting an error when trying to pull up any report on
    Reporting Services. All other users are having no problem. His error is
    the following...
    An error has occurred during report processing. (rsProcessingAborted) Get
    Online Help
    Cannot read the next data row for the data set Main.
    (rsErrorReadingNextDataRow) Get Online Help
    Arithmetic overflow error converting expression to data type datetime.
    The funny thing is if he tries the same reports in the FireFox browser, it
    works. I have search Google for "rsErrorReadingNextDataRow" and I get zero
    results. Any ideas what this could be?
    JoshuaThis error is from the data provider when we call Read() on the DataReader.
    What data provider are you using? Does the query work outside of the report?
    Fang Wang (MSFT)
    Microsoft SQL Server Reporting Services
    This posting is provided "AS IS" with no warranties, and confers no rights.
    "Josh" <bucket@.oskwarek.com> wrote in message
    news:%231oE0ILcEHA.644@.tk2msftngp13.phx.gbl...
    > I have a user who is getting an error when trying to pull up any report on
    > Reporting Services. All other users are having no problem. His error is
    > the following...
    > An error has occurred during report processing. (rsProcessingAborted) Get
    > Online Help
    > Cannot read the next data row for the data set Main.
    > (rsErrorReadingNextDataRow) Get Online Help
    > Arithmetic overflow error converting expression to data type datetime.
    > The funny thing is if he tries the same reports in the FireFox browser, it
    > works. I have search Google for "rsErrorReadingNextDataRow" and I get
    zero
    > results. Any ideas what this could be?
    > Joshua
    >|||The back end database is SQL Server. The report works for everyone in the
    company who runs it except for this one user.
    -Joshua
    "Fang Wang (MSFT)" <fangw@.microsoft.com> wrote in message
    news:OxMhOyRcEHA.556@.tk2msftngp13.phx.gbl...
    > This error is from the data provider when we call Read() on the
    DataReader.
    > What data provider are you using? Does the query work outside of the
    report?
    > Fang Wang (MSFT)
    > Microsoft SQL Server Reporting Services
    > This posting is provided "AS IS" with no warranties, and confers no
    rights.
    > "Josh" <bucket@.oskwarek.com> wrote in message
    > news:%231oE0ILcEHA.644@.tk2msftngp13.phx.gbl...
    > > I have a user who is getting an error when trying to pull up any report
    on
    > > Reporting Services. All other users are having no problem. His error
    is
    > > the following...
    > >
    > > An error has occurred during report processing. (rsProcessingAborted)
    Get
    > > Online Help
    > > Cannot read the next data row for the data set Main.
    > > (rsErrorReadingNextDataRow) Get Online Help
    > > Arithmetic overflow error converting expression to data type datetime.
    > >
    > > The funny thing is if he tries the same reports in the FireFox browser,
    it
    > > works. I have search Google for "rsErrorReadingNextDataRow" and I get
    > zero
    > > results. Any ideas what this could be?
    > >
    > > Joshua
    > >
    > >
    >|||Any help, please?
    -Josh
    "Josh" <bucket@.oskwarek.com> wrote in message
    news:eAekbI0cEHA.3420@.TK2MSFTNGP12.phx.gbl...
    > The back end database is SQL Server. The report works for everyone in the
    > company who runs it except for this one user.
    > -Joshua
    >
    > "Fang Wang (MSFT)" <fangw@.microsoft.com> wrote in message
    > news:OxMhOyRcEHA.556@.tk2msftngp13.phx.gbl...
    > > This error is from the data provider when we call Read() on the
    > DataReader.
    > > What data provider are you using? Does the query work outside of the
    > report?
    > >
    > > Fang Wang (MSFT)
    > > Microsoft SQL Server Reporting Services
    > >
    > > This posting is provided "AS IS" with no warranties, and confers no
    > rights.
    > >
    > > "Josh" <bucket@.oskwarek.com> wrote in message
    > > news:%231oE0ILcEHA.644@.tk2msftngp13.phx.gbl...
    > > > I have a user who is getting an error when trying to pull up any
    report
    > on
    > > > Reporting Services. All other users are having no problem. His error
    > is
    > > > the following...
    > > >
    > > > An error has occurred during report processing. (rsProcessingAborted)
    > Get
    > > > Online Help
    > > > Cannot read the next data row for the data set Main.
    > > > (rsErrorReadingNextDataRow) Get Online Help
    > > > Arithmetic overflow error converting expression to data type datetime.
    > > >
    > > > The funny thing is if he tries the same reports in the FireFox
    browser,
    > it
    > > > works. I have search Google for "rsErrorReadingNextDataRow" and I get
    > > zero
    > > > results. Any ideas what this could be?
    > > >
    > > > Joshua
    > > >
    > > >
    > >
    > >
    >|||Pretty please?
    "Josh" <bucket@.oskwarek.com> wrote in message
    news:ODs2Ug9cEHA.2544@.TK2MSFTNGP10.phx.gbl...
    > Any help, please?
    > -Josh
    > "Josh" <bucket@.oskwarek.com> wrote in message
    > news:eAekbI0cEHA.3420@.TK2MSFTNGP12.phx.gbl...
    > > The back end database is SQL Server. The report works for everyone in
    the
    > > company who runs it except for this one user.
    > >
    > > -Joshua
    > >
    > >
    > > "Fang Wang (MSFT)" <fangw@.microsoft.com> wrote in message
    > > news:OxMhOyRcEHA.556@.tk2msftngp13.phx.gbl...
    > > > This error is from the data provider when we call Read() on the
    > > DataReader.
    > > > What data provider are you using? Does the query work outside of the
    > > report?
    > > >
    > > > Fang Wang (MSFT)
    > > > Microsoft SQL Server Reporting Services
    > > >
    > > > This posting is provided "AS IS" with no warranties, and confers no
    > > rights.
    > > >
    > > > "Josh" <bucket@.oskwarek.com> wrote in message
    > > > news:%231oE0ILcEHA.644@.tk2msftngp13.phx.gbl...
    > > > > I have a user who is getting an error when trying to pull up any
    > report
    > > on
    > > > > Reporting Services. All other users are having no problem. His
    error
    > > is
    > > > > the following...
    > > > >
    > > > > An error has occurred during report processing.
    (rsProcessingAborted)
    > > Get
    > > > > Online Help
    > > > > Cannot read the next data row for the data set Main.
    > > > > (rsErrorReadingNextDataRow) Get Online Help
    > > > > Arithmetic overflow error converting expression to data type
    datetime.
    > > > >
    > > > > The funny thing is if he tries the same reports in the FireFox
    > browser,
    > > it
    > > > > works. I have search Google for "rsErrorReadingNextDataRow" and I
    get
    > > > zero
    > > > > results. Any ideas what this could be?
    > > > >
    > > > > Joshua
    > > > >
    > > > >
    > > >
    > > >
    > >
    > >
    >

    rsErrorReadingNextDataRow

    Hi,
    I'm getting the below error with my reports.
    Any help is appretiated much.
    Thanks...
    An error has occurred during report processing. (rsProcessingAborted) Get
    Online Help
    Cannot read the next data row for the data set DataSet1.
    (rsErrorReadingNextDataRow) Get Online Help
    A severe error occurred on the current command. The results, if any, should
    be discarded.I am having this issue too. Did you resolve this?
    "eralper" wrote:
    > Hi,
    > I'm getting the below error with my reports.
    > Any help is appretiated much.
    > Thanks...
    > An error has occurred during report processing. (rsProcessingAborted) Get
    > Online Help
    > Cannot read the next data row for the data set DataSet1.
    > (rsErrorReadingNextDataRow) Get Online Help
    > A severe error occurred on the current command. The results, if any, should
    > be discarded.
    >
    >|||Hi,
    I was using Linked Servers for the data source of the reports. And
    dynamically changing the database server name and database name by passing
    these values as parameters.
    On some of the servers I was using "." to map the database server to itself.
    I changed the passed value "." to database server name for the database
    server name parameter.
    This change worked.
    http://www.kodyaz.com/ShowPost.aspx?PostID=52#52
    Eralper
    http://www.kodyaz.com
    "Kmistic" wrote:
    > I am having this issue too. Did you resolve this?
    > "eralper" wrote:
    > > Hi,
    > >
    > > I'm getting the below error with my reports.
    > > Any help is appretiated much.
    > > Thanks...
    > >
    > > An error has occurred during report processing. (rsProcessingAborted) Get
    > > Online Help
    > > Cannot read the next data row for the data set DataSet1.
    > > (rsErrorReadingNextDataRow) Get Online Help
    > > A severe error occurred on the current command. The results, if any, should
    > > be discarded.
    > >
    > >
    > >|||Thanks for replying. i am not using linked servers i am actually getting
    this error from reporting services.
    "eralper" wrote:
    > Hi,
    > I was using Linked Servers for the data source of the reports. And
    > dynamically changing the database server name and database name by passing
    > these values as parameters.
    > On some of the servers I was using "." to map the database server to itself.
    > I changed the passed value "." to database server name for the database
    > server name parameter.
    > This change worked.
    > http://www.kodyaz.com/ShowPost.aspx?PostID=52#52
    > Eralper
    > http://www.kodyaz.com
    >
    > "Kmistic" wrote:
    > > I am having this issue too. Did you resolve this?
    > >
    > > "eralper" wrote:
    > >
    > > > Hi,
    > > >
    > > > I'm getting the below error with my reports.
    > > > Any help is appretiated much.
    > > > Thanks...
    > > >
    > > > An error has occurred during report processing. (rsProcessingAborted) Get
    > > > Online Help
    > > > Cannot read the next data row for the data set DataSet1.
    > > > (rsErrorReadingNextDataRow) Get Online Help
    > > > A severe error occurred on the current command. The results, if any, should
    > > > be discarded.
    > > >
    > > >
    > > >|||I would like to mention that this error only happens when non-adminstrators
    try to view the report. I have the dataset being generated by a stored
    procedure that executes a dtspackage using xp_cmdshell. When i take the
    xp_cmdshell command out of the stored procedure it works fine. I pass the
    xp_cmdshell the dtsrun command using sa and its password. I don't understand
    what else i might need to do to enable the none admins to work.
    "Kmistic" wrote:
    > Thanks for replying. i am not using linked servers i am actually getting
    > this error from reporting services.
    > "eralper" wrote:
    > > Hi,
    > >
    > > I was using Linked Servers for the data source of the reports. And
    > > dynamically changing the database server name and database name by passing
    > > these values as parameters.
    > >
    > > On some of the servers I was using "." to map the database server to itself.
    > > I changed the passed value "." to database server name for the database
    > > server name parameter.
    > >
    > > This change worked.
    > >
    > > http://www.kodyaz.com/ShowPost.aspx?PostID=52#52
    > >
    > > Eralper
    > > http://www.kodyaz.com
    > >
    > >
    > >
    > > "Kmistic" wrote:
    > >
    > > > I am having this issue too. Did you resolve this?
    > > >
    > > > "eralper" wrote:
    > > >
    > > > > Hi,
    > > > >
    > > > > I'm getting the below error with my reports.
    > > > > Any help is appretiated much.
    > > > > Thanks...
    > > > >
    > > > > An error has occurred during report processing. (rsProcessingAborted) Get
    > > > > Online Help
    > > > > Cannot read the next data row for the data set DataSet1.
    > > > > (rsErrorReadingNextDataRow) Get Online Help
    > > > > A severe error occurred on the current command. The results, if any, should
    > > > > be discarded.
    > > > >
    > > > >
    > > > >|||Hi,
    I was successfully running the report from VS.Net but it was failing when I
    deploy it onto the report server. Do you have a similar behavior?
    "Kmistic" wrote:
    > Thanks for replying. i am not using linked servers i am actually getting
    > this error from reporting services.
    > "eralper" wrote:
    > > Hi,
    > >
    > > I was using Linked Servers for the data source of the reports. And
    > > dynamically changing the database server name and database name by passing
    > > these values as parameters.
    > >
    > > On some of the servers I was using "." to map the database server to itself.
    > > I changed the passed value "." to database server name for the database
    > > server name parameter.
    > >
    > > This change worked.
    > >
    > > http://www.kodyaz.com/ShowPost.aspx?PostID=52#52
    > >
    > > Eralper
    > > http://www.kodyaz.com
    > >
    > >
    > >
    > > "Kmistic" wrote:
    > >
    > > > I am having this issue too. Did you resolve this?
    > > >
    > > > "eralper" wrote:
    > > >
    > > > > Hi,
    > > > >
    > > > > I'm getting the below error with my reports.
    > > > > Any help is appretiated much.
    > > > > Thanks...
    > > > >
    > > > > An error has occurred during report processing. (rsProcessingAborted) Get
    > > > > Online Help
    > > > > Cannot read the next data row for the data set DataSet1.
    > > > > (rsErrorReadingNextDataRow) Get Online Help
    > > > > A severe error occurred on the current command. The results, if any, should
    > > > > be discarded.
    > > > >
    > > > >
    > > > >|||hi
    i am getting error msg in sqlservice report
    cannot read the next data row for the data set dataset1 in sql reporting service
    i need a solloution for this proble
    From http://www.developmentnow.com/g/115_2005_1_0_0_455079/rsErrorReadingNextDataRow.ht
    Posted via DevelopmentNow.com Group
    http://www.developmentnow.com|||I am also getting this error intermittenly on some reports. It is text query not a stored procedure and sometimes it works for the same user. The database and table being queried have high activity. Could this be a colision or exclusive lock? Since it's intermittent it is hard to troubleshoot
    From http://www.developmentnow.com/g/115_2005_1_0_0_455079/rsErrorReadingNextDataRow.h
    Posted via DevelopmentNow.com Group
    http://www.developmentnow.comsql