Prologika Forums

Hi,

I have been thinking and tried to find out the reason to why the ReportServer is not able to send the Command Text to DPE, but I was not successfull.

Could you please help me in this and tell me why is this happening?

Thanks,

It's been a while since I worked on a DPE. Does the server return an error.Does it make it to the CommandText property if you debug?

Yes it does reach the CommandText Property but the value="".

After that it jumps to the dispose method and finally it throws NotSupportedException exception from the Cancel Method.

I dont understand what is happening

Hi Teo, here is the stack trace I got from the Log files. Could you please explain me exactly what is going on?

what does this CreateSqlBatch(SemanticModel model, DbConnection dbConnection)  method do?

Query has been compiled successfully.
aspnet_wp!semanticqueryengine!5!5/7/2008-15:30:30:: a ASSERT: System.ArgumentNullException: Value cannot be null.
Parameter name: dbConnection   Call stack:
 Microsoft.ReportingServices.SemanticQueryEngine.SQEAssert.AssertFalseAndThrow(String format, Object[ args) 
 Microsoft.ReportingServices.SemanticQueryEngine.SQEAssert.AssertFalseAndThrow(Exception e) 
 Microsoft.ReportingServices.SemanticQueryEngine.Sql.Oracle.OraSqlSQCommand.CreateSqlBatch(SemanticModel model, DbConnection dbConnection) 
 Microsoft.ReportingServices.SemanticQueryEngine.Sql.SqlSQCommand.Microsoft.ReportingServices.SemanticQueryEngine.ISemanticQueryCommand.SetQuery(SemanticQuery query) 
 Microsoft.ReportingServices.SemanticQueryEngine.SemanticQueryCommandWrapper.ExecuteReader(CommandBehavior behavior) 
 Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeDataSetNode.RunDataSetQuery() 
 Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeReportDataSetNode.FirstPassInit() 
 Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeDataSetNode.FirstPassProcess(Boolean& closeConnWhenFinish) 
 Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeReportDataSetNode.Process() 
 Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeDataSetNode.ProcessConcurrent(Object threadSet) 
 Microsoft.ReportingServices.ReportProcessing.ReportProcessing+ReportRuntimeDataSourceNode.Process() 
 Microsoft.ReportingServices.ReportProcessing.ReportProcessing+RuntimeDataSourceNode.ProcessConcurrent(Object threadSet) 
 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, Boolean isLinkedReport, 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) 

So, you enter soemething but get an empty string in the CommandText property? If this is the case, I have no explanation. The command text should be passed to one of hte connection class constructors. Please debug to make sure.

For past 2 days I am continuously trying to find out the problem area, but not successful yet.

Do we get CommandText in Connection class or Command Class? Is there any other way to find out the Commandtext created by the report server?

Seems its bit confusing what ever I wrote.

What I understand is that the ReportBuilder / ReportServer create the query depending on the selected fields in the report.

What I mean by commandtext created by reportserver is , when the report is ready to execute the Report server must be creating the query and then passing it as CommandText to the DPE.( When I debugged the CommandText Set Property is called but the Value="")

This means that the Report Server is not able to send the query to the DPE.