|
helixpoint
Constraint Violating Yak Guru
291 Posts |
 Posted - 2011-04-28 : 10:38:49
|
| I get this error:The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available. (rsReportNotReady)I tried...with no luck:ALTER DATABASE ReportServerTempDB SET ALLOW_SNAPSHOT_ISOLATION OFF; and ALTER DATABASE ReportServer SET ALLOW_SNAPSHOT_ISOLATION OFF;Here is the log:t 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.RenderPageContent() at Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()library!ReportServer_0-26!fbc!04/28/2011-09:43:05:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportNotReadyException: , Microsoft.ReportingServices.Diagnostics.Utilities.ReportNotReadyException: The selected report is not ready for viewing. The report is still being rendered or a report snapshot is not available.;library!ReportServer_0-26!c60!04/28/2011-09:43:15:: i INFO: RenderFromSession('/Megans_Law/RptFlierByMuni')webserver!ReportServer_0-26!c60!04/28/2011-09:43:15:: i INFO: Processed report. Report='/Megans_Law/RptFlierByMuni', Stream=''library!ReportServer_0-26!c60!04/28/2011-09:43:18:: i INFO: RenderForNewSession('/Megans_Law/RptFlierByMuni')webserver!ReportServer_0-26!c60!04/28/2011-09:43:19:: i INFO: Processed report. Report='/Megans_Law/RptFlierByMuni', Stream=''library!ReportServer_0-26!c60!04/28/2011-09:43:49:: i INFO: RenderForNewSession('/Megans_Law/RptFlierByMuni')webserver!ReportServer_0-26!c60!04/28/2011-09:43:49:: i INFO: Processed report. Report='/Megans_Law/RptFlierByMuni', Stream=''library!ReportServer_0-26!fbc!04/28/2011-09:43:55:: i INFO: RenderForNewSession('/Megans_Law/FlierControl')reportrendering!ReportServer_0-26!fbc!04/28/2011-09:43:57:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException: , Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException: An error occurred during rendering of the report. ---> Microsoft.ReportingServices.OnDemandReportRendering.ReportRenderingException: An error occurred during rendering of the report. ---> System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.ReportingServices.ReportIntermediateFormat.TextBox.GetTextBoxImpl(OnDemandProcessingContext context) at Microsoft.ReportingServices.ReportIntermediateFormat.TablixMember.ResetTextBoxImpls(OnDemandProcessingContext context) at Microsoft.ReportingServices.OnDemandReportRendering.DataRegionMemberCollection`1.Microsoft.ReportingServices.OnDemandReportRendering.IDataRegionMemberCollection.SetNewContext() at Microsoft.ReportingServices.OnDemandReportRendering.MemberHierarchy`1.SetNewContext() at Microsoft.ReportingServices.OnDemandReportRendering.Tablix.SetNewContextChildren() at Microsoft.ReportingServices.OnDemandReportRendering.ReportItem.SetNewContext() at Microsoft.ReportingServices.OnDemandReportRendering.DataRegion.SetNewContext() at Microsoft.ReportingServices.OnDemandReportRendering.ReportItemCollection.SetNewContext() at Microsoft.ReportingServices.OnDemandReportRendering.ReportSection.SetNewContext() at Microsoft.ReportingServices.OnDemandReportRendering.ReportSectionCollection.SetNewContext() at Microsoft.ReportingServices.OnDemandReportRendering.Report.SetNewContext() at Microsoft.ReportingServices.OnDemandReportRendering.ReportItem.SetNewContext() at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.SetNewContext() at Microsoft.ReportingServices.OnDemandReportRendering.TablixCell.SetNewContext() at Microsoft.ReportingServices.OnDemandReportRendering.DataRegionMember.SetCellsNewContext() at Microsoft.ReportingServices.OnDemandReportRendering.TablixMember.SetNewContext(Boolean fromMoveNext) at Microsoft.ReportingServices.OnDemandReportRendering.InternalTablixMember.SetNewContext(Boolean fromMoveNext) at Microsoft.ReportingServices.OnDemandReportRendering.DataRegionMemberCollection`1.Microsoft.ReportingServices.OnDemandReportRendering.IDataRegionMemberCollection.SetNewContext() at Microsoft.ReportingServices.OnDemandReportRendering.MemberHierarchy`1.SetNewContext() at Microsoft.ReportingServices.OnDemandReportRendering.Tablix.SetNewContextChildren() at Microsoft.ReportingServices.OnDemandReportRendering.ReportItem.SetNewContext() at Microsoft.ReportingServices.OnDemandReportRendering.DataRegion.SetNewContext() at Microsoft.ReportingServices.OnDemandReportRendering.ReportItemCollection.SetNewContext() at Microsoft.ReportingServices.OnDemandReportRendering.ReportSection.SetNewContext() at Microsoft.ReportingServices.OnDemandReportRendering.ReportSectionCollection.SetNewContext() at Microsoft.ReportingServices.OnDemandReportRendering.Report.SetNewContext() at Microsoft.ReportingServices.OnDemandReportRendering.ReportItem.SetNewContext() at Microsoft.ReportingServices.OnDemandReportRendering.SubReport.SetNewContext() at Microsoft.ReportingServices.OnDemandReportRendering.TablixCell.SetNewContext() at Microsoft.ReportingServices.OnDemandReportRendering.DataRegionMember.SetCellsNewContext() at Microsoft.ReportingServices.OnDemandReportRendering.TablixMember.SetNewContext(Boolean fromMoveNext) at Microsoft.ReportingServices.OnDemandReportRendering.InternalTablixMember.SetNewContext(Boolean fromMoveNext) at Microsoft.ReportingServices.OnDemandReportRendering.DataRegionMemberCollection`1.Microsoft.ReportingServices.OnDemandReportRendering.IDataRegionMemberCollection.SetNewContext() at Microsoft.ReportingServices.OnDemandReportRendering.DataRegionMember.SetNewContext(Boolean fromMoveNext) at Microsoft.ReportingServices.OnDemandReportRendering.TablixMember.SetNewContext(Boolean fromMoveNext) at Microsoft.ReportingServices.OnDemandReportRendering.InternalTablixMember.SetNewContext(Boolean fromMoveNext) at Microsoft.ReportingServices.OnDemandReportRendering.InternalTablixDynamicMemberInstance.SetInstanceIndex(Int32 index) at Microsoft.ReportingServices.Rendering.SPBProcessing.Tablix.SetTablixMembersInstanceIndex(TablixMemberCollection rowMembers, Int32 level, List`1 instanceState) at Microsoft.ReportingServices.Rendering.SPBProcessing.PageItemContainer.CreateChildrenFromPaginationState(ReportItemCollection childrenDef, PageContext pageContext, PageItemContainerHelper itemHelper, Boolean isSimple) 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.PaginateReport(Int32 startPage, Int32 endPage) at Microsoft.ReportingServices.Rendering.SPBProcessing.SPBProcessing.UpdateRenderProperties(Hashtable& renderProperties) at Microsoft.ReportingServices.Rendering.HtmlRenderer.ServerRenderer.UpdateRenderProperties(Hashtable& renderProperties) at Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension.InternalRender(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, Hashtable& renderProperties, CreateAndRegisterStream createAndRegisterStream) at Microsoft.ReportingServices.Rendering.HtmlRenderer.RenderingExtensionBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, Hashtable& renderProperties, CreateAndRegisterStream createAndRegisterStream) --- End of inner exception stack trace --- at Microsoft.ReportingServices.Rendering.HtmlRenderer.RenderingExtensionBase.Render(Report report, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, Hashtable& renderProperties, CreateAndRegisterStream createAndRegisterStream) at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension newRenderer, DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, IChunkFactory metaDataChunkFactory, IChunkFactory yukonCompiledDefinition) --- End of inner exception stack trace ---;DaveHelixpoint Web Developmenthttp://www.helixpoint.com |
|
The selected report is not ready for viewing.