RS and HTTPS: huge

Showing posts with label huge. 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& 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& 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&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsProcessingAborted&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&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&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsErrorReadingNextDataRow&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&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,

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>

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.

Friday, March 23, 2012

RS2005: Excel huge file size

I have an issue with exporting RS2005 reports to Excel:
1) The exported fie size is disproportional to the rowset size - ~7000
records weigh 45 MB, whilst a CSV version of the same report weighs 7MB.
2) RS exports to Excel with a redundant blank A column on the left and 4
rows that hold the report caption. Is there anyway to configure RS not to
export with these rows and columns, so it'll start directly with my data?
We have SSRS Version 9.00.1399.00 with SQL Server 2000 - 8.00.818Offirh wrote:
> I have an issue with exporting RS2005 reports to Excel:
> 1) The exported fie size is disproportional to the rowset size - ~7000
> records weigh 45 MB, whilst a CSV version of the same report weighs 7MB.
> 2) RS exports to Excel with a redundant blank A column on the left and 4
> rows that hold the report caption. Is there anyway to configure RS not to
> export with these rows and columns, so it'll start directly with my data?
> We have SSRS Version 9.00.1399.00 with SQL Server 2000 - 8.00.818
The best way to minimize file size when exporting to excel is to remove
as much formatting from the report design as possible. Remove any
borders, colors, etc. Still, SSRS will apply some formatting to the
resulting export and make it very difficult to match the more efficient
CSV export, (which is your best workaround IMO).
Ghost columns can be very difficult to remove completely, however,
paying attention to the left and right boundaries of your controls in
relation to other controls on your report can help.
For example, if you have a textbox at the top of your report holding a
report title, and then a table beneath which contains detail records,
making sure that the left and right sides of the textbox control align
vertically with the table control, or column boundaries in the table
control will minimize the occurrence of Ghost columns in the excel
export.
Basically, SSRS seems to evaluate each control boundary, and will
define all columns necessary to bound each control's right and left
side, (often merging columns as well which makes things a real mess
when you try to sort data in the spreadsheet).
SoftArtisans has a nice product call OfficeWriter that helps eliminate
the problem altogether. OfficeWriter allows you to define DataSets in
SSRS, and then use Excel to define where you want the data from the
datasets to land. This bypasses SSRS doing the formatting of the Excel
spreadsheet, which results in several desirable outcomes:
1) The memory drawdown on your SSRS box is drastically reduced when
the report is being run. Excel exports take a lot of memory to
complete!
2) The resulting file size is reduced because none of the formatting
codes are generated by SSRS which balloon the excel file size.
3) You bypass all the other formatting problems with merged
columns/rows
4) You get to use all the native Excel functionality in the resulting
report, including custom macros, etc.
But, it's not free!
Philip|||One other design point. You should not use textboxes at all. If you have a
textbox at the top of your report and then a table the user will not be able
to sort the data because of merged columns issue in Excel. I add extra
header rows to my table and put the report title there.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"PhilipL" <pal@.philiplee.com> wrote in message
news:1158092129.378116.36300@.b28g2000cwb.googlegroups.com...
> Offirh wrote:
>> I have an issue with exporting RS2005 reports to Excel:
>> 1) The exported fie size is disproportional to the rowset size - ~7000
>> records weigh 45 MB, whilst a CSV version of the same report weighs 7MB.
>> 2) RS exports to Excel with a redundant blank A column on the left and 4
>> rows that hold the report caption. Is there anyway to configure RS not to
>> export with these rows and columns, so it'll start directly with my data?
>> We have SSRS Version 9.00.1399.00 with SQL Server 2000 - 8.00.818
> The best way to minimize file size when exporting to excel is to remove
> as much formatting from the report design as possible. Remove any
> borders, colors, etc. Still, SSRS will apply some formatting to the
> resulting export and make it very difficult to match the more efficient
> CSV export, (which is your best workaround IMO).
> Ghost columns can be very difficult to remove completely, however,
> paying attention to the left and right boundaries of your controls in
> relation to other controls on your report can help.
> For example, if you have a textbox at the top of your report holding a
> report title, and then a table beneath which contains detail records,
> making sure that the left and right sides of the textbox control align
> vertically with the table control, or column boundaries in the table
> control will minimize the occurrence of Ghost columns in the excel
> export.
> Basically, SSRS seems to evaluate each control boundary, and will
> define all columns necessary to bound each control's right and left
> side, (often merging columns as well which makes things a real mess
> when you try to sort data in the spreadsheet).
> SoftArtisans has a nice product call OfficeWriter that helps eliminate
> the problem altogether. OfficeWriter allows you to define DataSets in
> SSRS, and then use Excel to define where you want the data from the
> datasets to land. This bypasses SSRS doing the formatting of the Excel
> spreadsheet, which results in several desirable outcomes:
> 1) The memory drawdown on your SSRS box is drastically reduced when
> the report is being run. Excel exports take a lot of memory to
> complete!
> 2) The resulting file size is reduced because none of the formatting
> codes are generated by SSRS which balloon the excel file size.
> 3) You bypass all the other formatting problems with merged
> columns/rows
> 4) You get to use all the native Excel functionality in the resulting
> report, including custom macros, etc.
> But, it's not free!
> Philip
>sql

Wednesday, March 28, 2012

rsErrorReadingNextDataRow ?

rsErrorReadingNextDataRow ?

Friday, March 23, 2012

RS2005: Excel huge file size

RS and HTTPS

Blog Archive

About Me