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
>

AspX Page Connection Error using sqlserver

Dear i am using visual studio.net........ when i connect database (in sqlserver) using sqldataAdapter with datagrid in visual basic.net every thing work properly......... but when i use the same in asp.net then i get an error message on the resultant explorer page give below.

Server Error in '/studentData' Application.
------------------------

Login failed for user 'RAMIZSARDAR\ASPNET'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'RAMIZSARDAR\ASPNET'.

Source Error:

Line 85: 'Put user code to initialize the page here
Line 86: Dim ds As New DataSet()
Line 87: SqlDataAdapter1.Fill(ds)
Line 88: DataGrid1.DataSource = ds.Tables(0)
Line 89: DataGrid1.DataBind()

Source File: c:\inetpub\wwwroot\studentData\WebForm1.aspx.vb Line: 87

Stack Trace:

[SqlException: Login failed for user 'RAMIZSARDAR\ASPNET'.]
System.Data.SqlClient.SqlConnection.Open()
System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)
System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
studentData.WebForm1.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\studentData\WebForm1.aspx.vb:87
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()

------------------------
Version Information: Microsoft .NET Framework Version:1.0.3705.0; ASP.NET Version:1.0.3705.0

Plz solve my problem and Reply me on ramiz_ch@.hotmail.com
Plz solve my problem and Reply me on ramiz_ch@.hotmail.com
Plz solve my problem and Reply me on ramiz_ch@.hotmail.com

Ramizwell, yes. if you use the same code in VB.NET/WIndows forms it'll run under the security context of the currently logged-in user. i.e. YOU.

under ASP.NET it runs by default as the ASP.NET guest account, MACHINENAME\ASPNET

you need to add ASPNET to the SQL Server permissions list, OR run ASP.NET as a different user, OR specify a SQL Server auth account in your connection string.

this question has been covered over and over in these forums. try the FAQ, if it's not in there I'll be shocked and amazed.

ASPNET security on my sql server

Dear all

I had a problem connecting to my website (through lan) from other machines in the company here.

I googled some and figured out that I have to change the security settings of aspnet in my sql server express 2005.

I did as suggested and now its working

My question is - what should be the real security settings for aspnet on my sql server ?

Should I really add it to the sysadmin ? (what solved the problem...)

Guy

Security settings depend on your environment. They should by design be the least permissions that allow access, but in your case it would mean configuring a new account just for this purpose and you'd likely not add any additional security in an intranet environment.

Jeff

|||

Hi

Thanks for the reply

I am talking about the real world not the lan

I had the problem on lan and that led me to the question :)

Please tell me what should I do on an Internet case

Guy

|||It still depends on what the website needs to do with SQL Server. What was the problem with the SQL Server connection before you add IIS account (or other account?) to sysadmin role of SQL Server?