ReportProcessing.RenderingObjectModelException

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

ReportProcessing.RenderingObjectModelException

Author

Topic

Shinkars
Starting Member

1 Post

Posted - 2011-08-31 : 12:10:14

"Microsoft.ReportingServices.ReportProcessing.RenderingObjectModelException: The value '2' is invalid. Valid values are between '0' and '2'.(rrRenderingError)"

Hi Expertise,

When I try to render the attached Rdl2005 file having a CustomReportItem and a Matrix inside a List on RS2008 (64-bit SQL Server 2008 R2 SP1 (10.50.2500.0.)), I get “The value '2' is invalid. Valid values are between '0' and '2'.(rrRenderingError)” error.

However, if I render the same template on RS2005 (SQL Server 2005 SP3 (9.00.5000.00)), the template gets rendered successfully and I could see the expected result.

Furthermore, I also tried rendering the same template after installing the following cumulative packages for SQL Server 2008 R2 SP 1
• Build 10.50.2769.0 (Cumulative update package)
• Build 10.50.2772.0 (Cumulative update package)

Still got the same issue.

Note that in all above cases (either 2005 or 2008); I have used the same database and the same table.

Script to create the Table
-----------------------------------
CREATE TABLE [dbo].[Data7Rows](
[ID] [nvarchar](255) NULL,
[VALUE] [nvarchar](255) NULL
) ON [PRIMARY]

Data for which the issue comes –
--------------------------------------------
ID VALUE
0049963b-c127-4817-9159-e36223e53a63 Value1
0eed2b27-902a-4b10-9473-2566250586c7 Value1
0f3adee0-cf66-4c0d-86c6-1297205e7e12 Value1
11c7204e-26c6-40cd-9ad2-ed6ebe1b9c5a Value1
132ef8ad-3170-4d33-81e6-a9ce1b2091e6 Value2
b46950e8-2632-440b-8343-d660dc2474cf Value3
b46950e8-2632-440b-8343-d660dc2474cf Value1

It seems if a Matrix spans across pages and the same template contains a custom report item, the renderer throws this exception. Can somebody tell me the root cause of this issue?

After investigating more on it, I have observed that if I remove the expression (<Value>=Globals!ExecutionTime</Value>) from Textbox report item under PageFooter section, the template gets rendered successfully.

But then if I directly go to the last page, I could see the same problem, whereas if I navigate all the pages sequentially, then the rendering happens successfully.

The execution log (attached) shows Yukon engine is used for report processing but at the same time renderer shows behavior of OnDemandRendering (Kilimanjaro) engine. Which is very much confusing?

So, is it a known issue that if a template contains a Matrix and a Custom report item and also the page footer section contains any expression, the RS2008 renderer throws rrRenderingError?
If it is so, is there any work around for that?

RDL file
--------
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition">
<DataSources>
<DataSource Name="DataSource1">
<rd:DataSourceID>3632324a-0762-4e95-8caf-ce2bc1eeb1dc</rd:DataSourceID>
<DataSourceReference>DataSource1</DataSourceReference>
</DataSource>
</DataSources>
<DataSets>
<DataSet Name="DataSet1">
<Fields>
<Field Name="ID">
<rd:TypeName>System.String</rd:TypeName>
<DataField>ID</DataField>
</Field>
<Field Name="VALUE">
<rd:TypeName>System.String</rd:TypeName>
<DataField>VALUE</DataField>
</Field>
</Fields>
<Query>
<DataSourceName>DataSource1</DataSourceName>
<CommandText>select ID,VALUE from Data7Rows
</CommandText>
</Query>
</DataSet>
</DataSets>
<Body>
<ReportItems>
<List Name="List1">
<DataSetName>DataSet1</DataSetName>
<Grouping Name="Details_Group">
<GroupExpressions>
<GroupExpression>=Fields!ID.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<ReportItems>
<Matrix Name="Matrix_Matrix11">
<Top>1in</Top>
<Left>19pt</Left>
<Height>2in</Height>
<Width>7in</Width>
<DataSetName>DataSet1</DataSetName>
<Corner>
<ReportItems>
<Textbox Name="Textbox_39">
<ZIndex>7</ZIndex>
<Value />
<CanGrow>true</CanGrow>
</Textbox>
</ReportItems>
</Corner>
<ColumnGroupings>
<ColumnGrouping>
<Height>0.25in</Height>
<DynamicColumns>
<Grouping Name="Grouping_15">
<GroupExpressions>
<GroupExpression>=1</GroupExpression>
</GroupExpressions>
</Grouping>
<ReportItems>
<Textbox Name="Textbox_38">
<ZIndex>6</ZIndex>
<Value>=1</Value>
<CanGrow>true</CanGrow>
</Textbox>
</ReportItems>
</DynamicColumns>
</ColumnGrouping>
</ColumnGroupings>
<RowGroupings>
<RowGrouping>
<Width>0.75in</Width>
<DynamicRows>
<Grouping Name="Grouping_13">
<GroupExpressions>
<GroupExpression>=Fields!VALUE.Value</GroupExpression>
</GroupExpressions>
</Grouping>
<ReportItems>
<Textbox Name="Textbox_34">
<ZIndex>5</ZIndex>
<Value>=1</Value>
<CanGrow>false</CanGrow>
</Textbox>
</ReportItems>
</DynamicRows>
</RowGrouping>
<RowGrouping>
<Width>1.5in</Width>
<DynamicRows>
<Grouping Name="Grouping_14">
<GroupExpressions>
<GroupExpression>=1</GroupExpression>
</GroupExpressions>
</Grouping>
<ReportItems>
<Textbox Name="Textbox_35">
<ZIndex>4</ZIndex>
<Value>=1</Value>
<CanGrow>true</CanGrow>
</Textbox>
</ReportItems>
</DynamicRows>
</RowGrouping>
<RowGrouping>
<Width>0.625in</Width>
<StaticRows>
<StaticRow>
<ReportItems>
<Textbox Name="Textbox_36">
<ZIndex>3</ZIndex>
<Value>XValue</Value>
<CanGrow>true</CanGrow>
</Textbox>
</ReportItems>
</StaticRow>
<StaticRow>
<ReportItems>
<Textbox Name="Textbox_37">
<ZIndex>1</ZIndex>
<Value>YValue</Value>
<CanGrow>true</CanGrow>
</Textbox>
</ReportItems>
</StaticRow>
</StaticRows>
</RowGrouping>
</RowGroupings>
<MatrixRows>
<MatrixRow>
<Height>0.25in</Height>
<MatrixCells>
<MatrixCell>
<ReportItems>
<Textbox Name="Textbox_40">
<ZIndex>2</ZIndex>
<Value>=1</Value>
<CanGrow>true</CanGrow>
</Textbox>
</ReportItems>
</MatrixCell>
</MatrixCells>
</MatrixRow>
<MatrixRow>
<Height>0.25in</Height>
<MatrixCells>
<MatrixCell>
<ReportItems>
<Textbox Name="Textbox_41">
<Value>=1</Value>
<CanGrow>true</CanGrow>
</Textbox>
</ReportItems>
</MatrixCell>
</MatrixCells>
</MatrixRow>
</MatrixRows>
<MatrixColumns>
<MatrixColumn>
<Width>0.875in</Width>
</MatrixColumn>
</MatrixColumns>
</Matrix>
<CustomReportItem Name="Plot131">
<Top>1.522in</Top>
<Left>0.263in</Left>
<Height>3.542in</Height>
<Width>5.549in</Width>
<CustomProperties>
<CustomProperty>
<Name>Axislabel</Name>
<Value />
</CustomProperty>
</CustomProperties>
<Type>Plot</Type>
<CustomData>
<DataSetName>DataSet1</DataSetName>
<DataColumnGroupings>
<DataGroupings>
<DataGrouping>
<Static>true</Static>
</DataGrouping>
</DataGroupings>
</DataColumnGroupings>
<DataRowGroupings>
<DataGroupings>
<DataGrouping>
<Grouping Name="Grouping_16">
<GroupExpressions>
<GroupExpression>
</GroupExpression>
</GroupExpressions>
</Grouping>
</DataGrouping>
</DataGroupings>
</DataRowGroupings>
<DataRows>
<DataRow>
<DataCell>
<DataValue>
<Name>Label</Name>
<Value />
</DataValue>
</DataCell>
</DataRow>
</DataRows>
</CustomData>
</CustomReportItem>
</ReportItems>
</List>
</ReportItems>
<Height>5.134in</Height>
</Body>
<Width>7.286in</Width>
<PageHeader>
<Height>0.847in</Height>
<PrintOnFirstPage>true</PrintOnFirstPage>
<PrintOnLastPage>true</PrintOnLastPage>
<ReportItems>
<Textbox Name="Textbox_1">
<Height>0.75cm</Height>
<Width>7.286in</Width>
<Value>Report</Value>
</Textbox>
</ReportItems>
</PageHeader>
<PageFooter>
<Height>0.75cm</Height>
<PrintOnFirstPage>true</PrintOnFirstPage>
<PrintOnLastPage>true</PrintOnLastPage>
<ReportItems>
<Textbox Name="Textbox_time">
<Top>0cm</Top>
<Left>6.105in</Left>
<Height>0.75cm</Height>
<Width>3cm</Width>
<ZIndex>2</ZIndex>
<Value>=Globals!ExecutionTime</Value>
</Textbox>
</ReportItems>
</PageFooter>
<PageHeight>11.69in</PageHeight>
<PageWidth>8.27in</PageWidth>
<Language>en-US</Language>
</Report>

------

Log trace
---------
library!ReportServer_0-2!b30!08/31/2011-16:31:42:: Using folder C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER2008\Reporting Services\RSTempFiles for temporary files.
reportrendering!ReportServer_0-2!b30!08/31/2011-16:31:43:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.RenderingObjectModelException: , Microsoft.ReportingServices.ReportProcessing.RenderingObjectModelException: The value '2' is invalid. Valid values are between '0' and '2'.;
library!ReportServer_0-2!b30!08/31/2011-16:31:43:: w WARN: Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The value '2' is invalid. Valid values are between '0' and '2'. ---> Microsoft.ReportingServices.ReportProcessing.RenderingObjectModelException: The value '2' is invalid. Valid values are between '0' and '2'.

at Microsoft.ReportingServices.ReportRendering.MatrixCellCollection.get_Item(Int32 row, Int32 column)
at Microsoft.ReportingServices.OnDemandReportRendering.ShimMatrixCell.get_CachedRenderReportItem()
at Microsoft.ReportingServices.OnDemandReportRendering.ShimMatrixCell.get_CellContents()
at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix..ctor(Tablix source, PageContext pageContext, Boolean createForRepeat)
at Microsoft.ReportingServices.Rendering.SPBProcessing.PageItem.Create(ReportItem source, PageContext pageContext, Boolean tablixCellParent, Boolean createForRepeat)
at Microsoft.ReportingServices.Rendering.SPBProcessing.PageItemContainer.CreateChildren(ReportItemCollection childrenDef, PageContext pageContext, Double parentWidth, Double parentHeight, Boolean isSimple)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Rectangle.CalculatePage(RPLWriter rplWriter, PageItemHelper lastPageInfo, PageContext pageContext, PageItem[] siblings, RepeatWithItem[] repeatWithItems, Double parentTopInPage, Double& parentPageHeight, Interactivity interactivity)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix.TablixContext.CalculateDetailCell(PageItem topItem, Int32 colIndex, Boolean collect, PageContext pageContext)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix.TablixContext.AddDetailCell(TablixCell cellDef, Int32 colIndex, Double cellColDefWidth, Double cellCellDefHeight, Boolean fullOnPage, Boolean collect, Boolean& partialItem)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix.CreateDetailCell(Tablix tablix, TablixMember colMemberParent, Int32 colGridIndex, TablixContext context)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix.CreateColumnMemberChildren(Tablix tablix, TablixMember colMemberParent, Int32 defTreeLevel, Boolean parentBorderHeader, Int32 parentRowIndex, Int32 parentColIndex, TablixContext context, Boolean createDetail, LevelInfo& parentLevelInfo)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix.CreateColumnMemberChildren(Tablix tablix, TablixMember colMemberParent, Int32 defTreeLevel, Boolean parentBorderHeader, Int32 parentRowIndex, Int32 parentColIndex, TablixContext context, Boolean createDetail, LevelInfo& parentLevelInfo)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix.CreateRowMemberChildren(Tablix tablix, TablixMember rowMemberParent, InnerToggleState parentToggleState, Int32 defTreeLevel, Boolean parentBorderHeader, Int32 parentRowIndex, Int32 parentColIndex, Int32 level, TablixContext context, Boolean& advanceRow, LevelInfo& parentLevelInfo, List`1& ignoreTotals, Boolean keepTogether)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix.CreateRowMemberChildren(Tablix tablix, TablixMember rowMemberParent, InnerToggleState parentToggleState, Int32 defTreeLevel, Boolean parentBorderHeader, Int32 parentRowIndex, Int32 parentColIndex, Int32 level, TablixContext context, Boolean& advanceRow, LevelInfo& parentLevelInfo, List`1& ignoreTotals, Boolean keepTogether)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix.CreateTablixItems(Tablix tablix, TablixContext context)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix.CalculatePage(RPLWriter rplWriter, PageItemHelper lastPageInfo, PageContext pageContext, PageItem[] siblings, RepeatWithItem[] repeatWithItems, Double parentTopInPage, Double& parentPageHeight, Interactivity interactivity)
at Microsoft.ReportingServices.Rendering.SPBProcessing.ReportBody.CalculatePage(RPLWriter rplWriter, PageItemHelper lastPageInfo, PageContext pageContext, PageItem[] siblings, RepeatWithItem[] repeatWithItems, Double parentTopInPage, Double& parentPageHeight, Interactivity interactivity)
at Microsoft.ReportingServices.Rendering.SPBProcessing.ReportSection.CalculatePage(RPLWriter rplWriter, Int32 page, Int32 totalPages, Int32 regionPageNumber, Int32 regionTotalPages, Boolean firstSectionOnPage, Boolean lastSection, Interactivity interactivity, Double heightToBeUsed, PageItemHelper& lastBodyInfo, Boolean& delayedHeader, Boolean& delayedFooter, Boolean& lastSectionOnPage)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Report.NextPage(RPLWriter rplWriter, ReportSectionHelper& lastPageInfo, Int32 page, Int32 totalPages, Interactivity interactivity, Boolean hasPaginationChunk)
at Microsoft.ReportingServices.Rendering.SPBProcessing.SPBProcessing.GetReportNextPage(Stream& stream, Boolean collectPageBookmarks)
at Microsoft.ReportingServices.Rendering.SPBProcessing.SPBProcessing.GetNextPage(Stream outputStream, Boolean collectPageBookmarks)
at Microsoft.ReportingServices.Rendering.SPBProcessing.SPBProcessing.GetNextPage(Stream outputStream)
at Microsoft.ReportingServices.Rendering.RPLRendering.RPLRenderer.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, Hashtable& renderProperties, CreateAndRegisterStream createAndRegisterStream)

--- End of inner exception stack trace ---

at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.HandleRenderingException(ReportRenderingException rex)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension newRenderer, DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory metaDataChunkFactory, IChunkFactory yukonCompiledDefinition)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory yukonCompiledDefinition)
at Microsoft.ReportingServices.Library.RenderLive.CallProcessingAndRendering(ProcessingContext pc, RenderingContext rc, OnDemandProcessingResult& result)
at Microsoft.ReportingServices.Library.RenderStrategyBase.ExecuteStrategy(OnDemandProcessingResult& processingResult)
webserver!ReportServer_0-2!b30!08/31/2011-16:31:43:: e ERROR: Reporting Services error Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The value '2' is invalid. Valid values are between '0' and '2'. ---> Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The value '2' is invalid. Valid values are between '0' and '2'. ---> Microsoft.ReportingServices.ReportProcessing.RenderingObjectModelException: The value '2' is invalid. Valid values are between '0' and '2'.

at Microsoft.ReportingServices.ReportRendering.MatrixCellCollection.get_Item(Int32 row, Int32 column)
at Microsoft.ReportingServices.OnDemandReportRendering.ShimMatrixCell.get_CachedRenderReportItem()
at Microsoft.ReportingServices.OnDemandReportRendering.ShimMatrixCell.get_CellContents()
at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix..ctor(Tablix source, PageContext pageContext, Boolean createForRepeat)
at Microsoft.ReportingServices.Rendering.SPBProcessing.PageItem.Create(ReportItem source, PageContext pageContext, Boolean tablixCellParent, Boolean createForRepeat)
at Microsoft.ReportingServices.Rendering.SPBProcessing.PageItemContainer.CreateChildren(ReportItemCollection childrenDef, PageContext pageContext, Double parentWidth, Double parentHeight, Boolean isSimple)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Rectangle.CalculatePage(RPLWriter rplWriter, PageItemHelper lastPageInfo, PageContext pageContext, PageItem[] siblings, RepeatWithItem[] repeatWithItems, Double parentTopInPage, Double& parentPageHeight, Interactivity interactivity)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix.TablixContext.CalculateDetailCell(PageItem topItem, Int32 colIndex, Boolean collect, PageContext pageContext)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix.TablixContext.AddDetailCell(TablixCell cellDef, Int32 colIndex, Double cellColDefWidth, Double cellCellDefHeight, Boolean fullOnPage, Boolean collect, Boolean& partialItem)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix.CreateDetailCell(Tablix tablix, TablixMember colMemberParent, Int32 colGridIndex, TablixContext context)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix.CreateColumnMemberChildren(Tablix tablix, TablixMember colMemberParent, Int32 defTreeLevel, Boolean parentBorderHeader, Int32 parentRowIndex, Int32 parentColIndex, TablixContext context, Boolean createDetail, LevelInfo& parentLevelInfo)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix.CreateColumnMemberChildren(Tablix tablix, TablixMember colMemberParent, Int32 defTreeLevel, Boolean parentBorderHeader, Int32 parentRowIndex, Int32 parentColIndex, TablixContext context, Boolean createDetail, LevelInfo& parentLevelInfo)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix.CreateRowMemberChildren(Tablix tablix, TablixMember rowMemberParent, InnerToggleState parentToggleState, Int32 defTreeLevel, Boolean parentBorderHeader, Int32 parentRowIndex, Int32 parentColIndex, Int32 level, TablixContext context, Boolean& advanceRow, LevelInfo& parentLevelInfo, List`1& ignoreTotals, Boolean keepTogether)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix.CreateRowMemberChildren(Tablix tablix, TablixMember rowMemberParent, InnerToggleState parentToggleState, Int32 defTreeLevel, Boolean parentBorderHeader, Int32 parentRowIndex, Int32 parentColIndex, Int32 level, TablixContext context, Boolean& advanceRow, LevelInfo& parentLevelInfo, List`1& ignoreTotals, Boolean keepTogether)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix.CreateTablixItems(Tablix tablix, TablixContext context)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix.CalculatePage(RPLWriter rplWriter, PageItemHelper lastPageInfo, PageContext pageContext, PageItem[] siblings, RepeatWithItem[] repeatWithItems, Double parentTopInPage, Double& parentPageHeight, Interactivity interactivity)
at Microsoft.ReportingServices.Rendering.SPBProcessing.ReportBody.CalculatePage(RPLWriter rplWriter, PageItemHelper lastPageInfo, PageContext pageContext, PageItem[] siblings, RepeatWithItem[] repeatWithItems, Double parentTopInPage, Double& parentPageHeight, Interactivity interactivity)
at Microsoft.ReportingServices.Rendering.SPBProcessing.ReportSection.CalculatePage(RPLWriter rplWriter, Int32 page, Int32 totalPages, Int32 regionPageNumber, Int32 regionTotalPages, Boolean firstSectionOnPage, Boolean lastSection, Interactivity interactivity, Double heightToBeUsed, PageItemHelper& lastBodyInfo, Boolean& delayedHeader, Boolean& delayedFooter, Boolean& lastSectionOnPage)
at Microsoft.ReportingServices.Rendering.SPBProcessing.Report.NextPage(RPLWriter rplWriter, ReportSectionHelper& lastPageInfo, Int32 page, Int32 totalPages, Interactivity interactivity, Boolean hasPaginationChunk)
at Microsoft.ReportingServices.Rendering.SPBProcessing.SPBProcessing.GetReportNextPage(Stream& stream, Boolean collectPageBookmarks)
at Microsoft.ReportingServices.Rendering.SPBProcessing.SPBProcessing.GetNextPage(Stream outputStream, Boolean collectPageBookmarks)
at Microsoft.ReportingServices.Rendering.SPBProcessing.SPBProcessing.GetNextPage(Stream outputStream)
at Microsoft.ReportingServices.Rendering.RPLRendering.RPLRenderer.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, Hashtable& renderProperties, CreateAndRegisterStream createAndRegisterStream)

--- End of inner exception stack trace ---
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.HandleRenderingException(ReportRenderingException rex)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension newRenderer, DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory metaDataChunkFactory, IChunkFactory yukonCompiledDefinition)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory yukonCompiledDefinition)
at Microsoft.ReportingServices.Library.RenderLive.CallProcessingAndRendering(ProcessingContext pc, RenderingContext rc, OnDemandProcessingResult& result)
at Microsoft.ReportingServices.Library.RenderStrategyBase.ExecuteStrategy(OnDemandProcessingResult& processingResult)
at Microsoft.ReportingServices.Library.ReportExecutionBase.InternalExecuteReport()
at Microsoft.ReportingServices.Library.ReportExecutionBase.Execute()
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()

--- End of inner exception stack trace ---
at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
at Microsoft.ReportingServices.Library.ExecutionDisposerProxy.ExecuteReport()
at Microsoft.ReportingServices.Library.RenderReportAction.PerformExecution()
at Microsoft.ReportingServices.Library.RenderReportAction.Render()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()

--

-------

Execution log

ExecutionId RequestType Format Parameters ReportAction TimeStart TimeEnd TimeDataRetrieval TimeProcessing TimeRendering Source Status ByteCount RowCount
jrrhis3uvirnws55vwxa1545 Interactive RPL NULL Render 31:41.2 31:43.8 482 732 1185 Live rrRenderingError 0 14
With Additional Info
<AdditionalInfo>
<ProcessingEngine>1</ProcessingEngine>
<ScalabilityTime>
<Pagination>0</Pagination>
<Processing>0</Processing>
</ScalabilityTime>
<EstimatedMemoryUsageKB>
<Pagination>0</Pagination>
<Processing>0</Processing>
</EstimatedMemoryUsageKB>
<DataExtension>
<SQL>1</SQL>
</DataExtension>
</AdditionalInfo>

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources