async_network_io wait during replication

I have re-initialize some subscription. After generated snapshot successfully, the synchronization view showing 'The process is running and is waiting for a response from the server.' and I found the replication process is under 'async_network_io wait'. The job has run for more than 8 hrs. Any idea to improve it? Thanks in advaise.

Are you running the sync agent (like merge agent/distribution agent) in continuous mode? If yes, it will show running forever, although the submitted transactions/commands have been replicated, agent job is just keeping waiting for next actions.

Thanks

-Yunjing

|||Yes, in continuous mode. But the replication hadn't completed in 8 hrs. Any idea? Thanks|||

If an continuous sync complete for a session, its current history log usually shows something like "No replicated transactions are available" and sync job is still showing as running.

As for your case, could you open sqlmonitor to check the current status for the job, is it still running or fail already? If it's running, what's the current history shown? Does the history get updated every a few minutes?

-Yunjing

ASSERT: Assertion failed!

Dear ALL,
I have this problem during view report in Report Manager (I m using CTP Sept
Cut for my SQL 2005 now). And, i can't find out what is this error about.
w3wp!processing!1!10/26/2005-12:01:48:: a ASSERT: Assertion failed! Call
stack
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+PageSectionContext.GetTableCellProperties(Int32 cellIndex)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+PageSectionContext.IsParentVisible()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.AddPageTextbox(ProcessingContext
processingContext, TextBox textbox, TextBoxInstance textboxInstance,
TextBoxInstanceInfo textboxInstanceInfo, Object value)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateTextBoxInstance(TextBox
textBox, ProcessingContext processingContext, Int32 index, IScope
containingScope)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstance(ReportItem
reportItem, Boolean setupEnvironment, Int32 index)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance
collectionInstance, ReportItemCollection reportItemsDef)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableDetailObj.CreateInstance()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeDetailObj.CreateInstances(ReportItemInstance
riInstance, IList instanceList, RenderingPagesRangesList pagesList)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableDetailObj.CreateInstances(ReportItemInstance
riInstance, IList instanceList, RenderingPagesRangesList pagesList)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableGroupLeafObj.CreateInstance()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.Traverse(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.TraverseAllLeafNodes(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupRootObj.CreateInstances(ReportItemInstance
riInstance, IList instanceList, RenderingPagesRangesList pagesList)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableGroupLeafObj.CreateInstance()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.Traverse(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.TraverseAllLeafNodes(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupRootObj.CreateInstances(ReportItemInstance
riInstance, IList instanceList, RenderingPagesRangesList pagesList)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableObj.CreateInstances(ReportItemInstance
riInstance, IList instanceList, RenderingPagesRangesList pagesList)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstance(ReportItem
reportItem, Boolean setupEnvironment, Int32 index)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance
collectionInstance, ReportItemCollection reportItemsDef)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance
collectionInstance, Boolean ignorePageBreaks, Boolean ignoreInstances)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableObj.CreateRowInstances(ProcessingContext
processingContext, RuntimeRICollectionList rowRICols, TableRowInstance[]
rowInstances, Boolean repeatOnNewPages, Boolean enterGrouping)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableGroupLeafObj.CreateInstance()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.Traverse(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.TraverseAllLeafNodes(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances()
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages operation)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages operation, Boolean ascending)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupRootObj.CreateInstances(ReportItemInstance
riInstance, IList instanceList, RenderingPagesRangesList pagesList)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableObj.CreateInstances(ReportItemInstance
riInstance, IList instanceList, RenderingPagesRangesList pagesList)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstance(ReportItem
reportItem, Boolean setupEnvironment, Int32 index)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance
collectionInstance, ReportItemCollection reportItemsDef)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+Merge.CreateInstances(ParameterInfoCollection parameters, Boolean noRows)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing+Merge.Process(ParameterInfoCollection parameters, Boolean mergeTran)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report report, ProcessingContext pc, ProcessingContext context)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report
report, ProcessingContext pc, Boolean snapshotProcessing, Boolean
processWithCachedData, GetReportChunk getChunkCallback, ErrorContext
errorContext, DateTime executionTime, CreateReportChunk cacheDataCallback,
ProcessingContext& context)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension
renderer, DateTime executionTimeStamp, GetReportChunk
getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc,
CreateReportChunk cacheDataCallback, Boolean& dataCached)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime
executionTimeStamp, GetReportChunk getCompiledDefinitionCallback,
ProcessingContext pc, RenderingContext rc)
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
reportContext, ItemProperties properties, ParameterInfoCollection
effectiveParameters, Guid reportId, ClientRequest session, String
description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection
thisReportDataSources, Boolean cachingRequested, Warning[]& warnings,
ReportSnapshot& resultSnapshotData, DateTime& executionDateTime,
RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
usedUserProfile)
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
rs, CatalogItemContext reportContext, ClientRequest session, JobType type,
Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]&
secondaryStreamNames)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation operation)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext context)
System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously)
System.Web.HttpApplication.ResumeSteps(Exception error)
System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext context, AsyncCallback cb, Object extraData)
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
w3wp!library!1!10/26/2005-12:01:48:: e ERROR: Throwing
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details., un-named assertion fired for component processing;
Info:
Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
An internal error occurred on the report server. See the error log for more
details.
Please help
NickyThis is a known issue in CTP September. Your report has a table with another
table inside that has table detail rows. The detail rows of that inner table
are causing the issue. The fix is available in SQL Server 2005 RTM.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Nicky" <Nicky@.discussions.microsoft.com> wrote in message
news:5A957A04-9D69-4C9D-9D5F-CB95FA802D2C@.microsoft.com...
> Dear ALL,
> I have this problem during view report in Report Manager (I m using CTP
> Sept
> Cut for my SQL 2005 now). And, i can't find out what is this error about.
> w3wp!processing!1!10/26/2005-12:01:48:: a ASSERT: Assertion failed! Call
> stack:
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+PageSectionContext.GetTableCellProperties(Int32
> cellIndex)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+PageSectionContext.IsParentVisible()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.AddPageTextbox(ProcessingContext
> processingContext, TextBox textbox, TextBoxInstance textboxInstance,
> TextBoxInstanceInfo textboxInstanceInfo, Object value)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateTextBoxInstance(TextBox
> textBox, ProcessingContext processingContext, Int32 index, IScope
> containingScope)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstance(ReportItem
> reportItem, Boolean setupEnvironment, Int32 index)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance
> collectionInstance, ReportItemCollection reportItemsDef)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableDetailObj.CreateInstance()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeDetailObj.CreateInstances(ReportItemInstance
> riInstance, IList instanceList, RenderingPagesRangesList pagesList)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableDetailObj.CreateInstances(ReportItemInstance
> riInstance, IList instanceList, RenderingPagesRangesList pagesList)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableGroupLeafObj.CreateInstance()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.Traverse(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.TraverseAllLeafNodes(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupRootObj.CreateInstances(ReportItemInstance
> riInstance, IList instanceList, RenderingPagesRangesList pagesList)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableGroupLeafObj.CreateInstance()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.Traverse(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.TraverseAllLeafNodes(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupRootObj.CreateInstances(ReportItemInstance
> riInstance, IList instanceList, RenderingPagesRangesList pagesList)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableObj.CreateInstances(ReportItemInstance
> riInstance, IList instanceList, RenderingPagesRangesList pagesList)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstance(ReportItem
> reportItem, Boolean setupEnvironment, Int32 index)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance
> collectionInstance, ReportItemCollection reportItemsDef)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance
> collectionInstance, Boolean ignorePageBreaks, Boolean ignoreInstances)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableObj.CreateRowInstances(ProcessingContext
> processingContext, RuntimeRICollectionList rowRICols, TableRowInstance[]
> rowInstances, Boolean repeatOnNewPages, Boolean enterGrouping)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableGroupLeafObj.CreateInstance()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.Traverse(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupLeafObj.TraverseAllLeafNodes(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.CreateInstances()
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeHierarchyObj.Microsoft.ReportingServices.ReportProcessing.ReportProcessing.IHierarchyObj.Traverse(ProcessingStages
> operation)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNodeTuple.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+BTreeNode.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupingObj.Traverse(ProcessingStages
> operation, Boolean ascending)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeGroupRootObj.CreateInstances(ReportItemInstance
> riInstance, IList instanceList, RenderingPagesRangesList pagesList)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeTableObj.CreateInstances(ReportItemInstance
> riInstance, IList instanceList, RenderingPagesRangesList pagesList)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstance(ReportItem
> reportItem, Boolean setupEnvironment, Int32 index)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeRICollection.CreateInstances(ReportItemColInstance
> collectionInstance, ReportItemCollection reportItemsDef)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+Merge.CreateInstances(ParameterInfoCollection
> parameters, Boolean noRows)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing+Merge.Process(ParameterInfoCollection
> parameters, Boolean mergeTran)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report
> report, ProcessingContext pc, ProcessingContext context)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report
> report, ProcessingContext pc, Boolean snapshotProcessing, Boolean
> processWithCachedData, GetReportChunk getChunkCallback, ErrorContext
> errorContext, DateTime executionTime, CreateReportChunk cacheDataCallback,
> ProcessingContext& context)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(IRenderingExtension
> renderer, DateTime executionTimeStamp, GetReportChunk
> getCompiledDefinitionCallback, ProcessingContext pc, RenderingContext rc,
> CreateReportChunk cacheDataCallback, Boolean& dataCached)
> Microsoft.ReportingServices.ReportProcessing.ReportProcessing.RenderReport(DateTime
> executionTimeStamp, GetReportChunk getCompiledDefinitionCallback,
> ProcessingContext pc, RenderingContext rc)
> Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
> reportContext, ItemProperties properties, ParameterInfoCollection
> effectiveParameters, Guid reportId, ClientRequest session, String
> description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection
> thisReportDataSources, Boolean cachingRequested, Warning[]& warnings,
> ReportSnapshot& resultSnapshotData, DateTime& executionDateTime,
> RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
> usedUserProfile)
> Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters)
> Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
> reportContext, ClientRequest session, Warning[]& warnings,
> ParameterInfoCollection& effectiveParameters, String[]&
> secondaryStreamNames)
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
> Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
> Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService
> rs, CatalogItemContext reportContext, ClientRequest session, JobType type,
> Warning[]& warnings, ParameterInfoCollection& effectiveParameters,
> String[]&
> secondaryStreamNames)
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory
> streamFactory)
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.DoStreamedOperation(StreamedOperation
> operation)
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType
> itemType)
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPageContent()
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderPage()
> Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.ProcessRequest(HttpContext
> context)
> System.Web.HttpApplication+CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
> System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
> completedSynchronously)
> System.Web.HttpApplication.ResumeSteps(Exception error)
> System.Web.HttpApplication.System.Web.IHttpAsyncHandler.BeginProcessRequest(HttpContext
> context, AsyncCallback cb, Object extraData)
> System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
> System.Web.HttpRuntime.ProcessRequestNoDemand(HttpWorkerRequest wr)
> System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)
> w3wp!library!1!10/26/2005-12:01:48:: e ERROR: Throwing
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details., un-named assertion fired for component processing;
> Info:
> Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException:
> An internal error occurred on the report server. See the error log for
> more
> details.
> Please help
> Nicky
>

ASP.NET Authentication for SQL Reporting

Anyone have any good examples on how to have an ASP.NET page login to the ReportingServer to view a report without passing the authentication onto the user?

I've been attempting to use the LogonUser method in the reporting web service but I'm not having any luck. I keep getting "Unauthorized" errors... Doh!

Thanks,my app had its own set of users and my requirement was that once the user logs into the app he shouldnt have to login to report server again to view a report..so I just copied the code from login.aspx in the Pages folder and in a sep aspx page and do both the authentications in the same page and after the authentication redirect to my app instead of folder.aspx...so when the user requests a report he is not prompted for the user name..dont know what you are trying to do is similar to what I did.|||Yea, that's what I'm talking about. However, the reports are protected via IIS, so I've been trying to use the LogonUser method of the ReportingService webservice but I haven't had any luck.|||

Can you share your code?

The code to log in the web service in vb is below

rs.Credentials =New NetworkCredential("user name", "password", "domain")

Additional info can be found athttp://devx.icpconline.com/Default.aspx?PageContentID=19&tabid=147