Embedding Dundas Chart Pro Charts in RS

This there a way to integrate the full version of Dundas Chart Pro in RS reports by using the extensibility API?
Including a URL accessed image of a Dundas Chart doesn't cut it if the rendering is to be done by PDF - my experence is showing that the image will be heavily pixelated.
TIA
JeffNot yet. I expect the Yukon version to support extensibility.
see www.sqlreportingservices.net
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
"jbarts" <jbarts@.discussions.microsoft.com> wrote in message
news:A41DEF90-1E42-4C54-9C42-6191E08BA533@.microsoft.com...
> This there a way to integrate the full version of Dundas Chart Pro in RS
reports by using the extensibility API?
> Including a URL accessed image of a Dundas Chart doesn't cut it if the
rendering is to be done by PDF - my experence is showing that the image will
be heavily pixelated.
> TIA
> Jeff

Embedded and distribute MSDE on CD

Hi,

I am trying to find something like a light version of SQL Server 2k to store data for an application that will be distributed through a cd.

Since we also have a web front end for this application when the user is online, we prefer that we can reuse the code for connection on both the cd and the web.

Any idea what will work?

I have come accross MSDE 2k but was not able to find any documentation on the pros and cons for this product regarding its capacity, the type of data it can handle, security, ...

Please give me some pointer.

Thanks very much.

Baoha.http://www.microsoft.com/sql/msde/default.asp hompage and corresponding links for more information.

Emailing results from query

Hi,
I just installed sql05 ent version and set up the DB Mail and ran a test
mail without a problem. I also managed to create a job which would execute a
query. I'd like now the sql server send to several email addresses the
results of the query and here where I'm stuck.
HOWDO you do it?
TIA
Ana
Read about sp_send_dbmail.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test mail without a problem. I
> also managed to create a job which would execute a query. I'd like now the sql server send to
> several email addresses the results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana
|||Hi,
This atricle may be of use:
http://builder.com.com/5100-6388-6164310-2.html#Listing%20B
Dan
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test
> mail without a problem. I also managed to create a job which would execute
> a query. I'd like now the sql server send to several email addresses the
> results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana

Emailing results from query

Hi,
I just installed sql05 ent version and set up the DB Mail and ran a test
mail without a problem. I also managed to create a job which would execute a
query. I'd like now the sql server send to several email addresses the
results of the query and here where I'm stuck.
HOWDO you do it?
TIA
AnaRead about sp_send_dbmail.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test m
ail without a problem. I
> also managed to create a job which would execute a query. I'd like now the
sql server send to
> several email addresses the results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana|||Hi,
This atricle may be of use:
http://builder.com.com/5100-6388-61...tml#Listing%20B
Dan
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test
> mail without a problem. I also managed to create a job which would execute
> a query. I'd like now the sql server send to several email addresses the
> results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana

Emailing results from query

Hi,
I just installed sql05 ent version and set up the DB Mail and ran a test
mail without a problem. I also managed to create a job which would execute a
query. I'd like now the sql server send to several email addresses the
results of the query and here where I'm stuck.
HOWDO you do it?
TIA
AnaRead about sp_send_dbmail.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test mail without a problem. I
> also managed to create a job which would execute a query. I'd like now the sql server send to
> several email addresses the results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana|||Hi,
This atricle may be of use:
http://builder.com.com/5100-6388-6164310-2.html#Listing%20B
--
Dan
"Ana" <ananospam@.yahoo.es> wrote in message
news:E878A2A8-B75A-4040-A252-DE709E44A372@.microsoft.com...
> Hi,
> I just installed sql05 ent version and set up the DB Mail and ran a test
> mail without a problem. I also managed to create a job which would execute
> a query. I'd like now the sql server send to several email addresses the
> results of the query and here where I'm stuck.
> HOWDO you do it?
> TIA
> Ana

EMail Subscription Error

All of a sudden, the e-mail subscriptions for a report quit being sent.

Running Sql 2000

Microsoft SQL Server Reporting Services Version 8.00.743.00

Here is the log error:

aspnet_wp!processing!e40!12/11/2006-08:34:29:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing.
aspnet_wp!processing!e40!12/11/2006-08:34:29:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: An unexpected error occurred in Report Processing.
aspnet_wp!processing!e40!12/11/2006-08:34:29:: e ERROR: Stack trace: at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
aspnet_wp!library!e08!12/11/2006-08:39:10:: i INFO: Call to GetPermissions:/Maximo/PO with Received Date Details
aspnet_wp!chunks!e08!12/11/2006-08:39:10:: i INFO: ### GetReportChunk('CompiledDefinition', Main), chunk was not found! this=00000000-0000-0000-0000-000000000000
aspnet_wp!processing!e08!12/11/2006-08:39:10:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.GetAllDataSources(CatalogItemContext reportContext, GetReportChunk getCompiledDefinitionCallback, SubReportDataSourcesCallback subReportCallback, DataSourceInfoCollection dataSources, Boolean checkIfUsable, Boolean isSurrogatePresent)
Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean checkIfUsable)
Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, Guid reportID, Boolean checkIfUsable)
Microsoft.ReportingServices.Library.RSService.GetAllDataSources(CatalogItemContext reportContext, Boolean checkIfUsable, ReportSnapshot& compiledDefinition)
Microsoft.ReportingServices.Library.RSService._GetProperties(ItemNamespaceEnum itemNamespace, String item, Property[] requestedProperties)
Microsoft.ReportingServices.Library.RSService.GetProperties(ItemNamespaceEnum itemNamespace, String item, Property[] properties)
Microsoft.ReportingServices.WebServer.ReportingService.GetProperties(String Item, Property[] Properties, Property[]& Values)
System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean isBinderDefault, Assembly caller, Boolean verifyAccess)
System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean verifyAccess)
System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
System.Web.Services.Protocols.LogicalMethodInfo.Invoke(Object target, Object[] values)
System.Web.Services.Protocols.WebServiceHandler.Invoke()
System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()
System.Web.Services.Protocols.SyncSessionlessHandler.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.ProcessRequest(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)

Any suggestions? Anyone see this before?

Are you sure that you wanted to attach this logfile extract? You mention subscription problem as an original one. But the logfile extract is taken from UI (Reportmanager) logfile, not from the server logfile: reported by aspnet_wp component and stack starts from System.Web.Hosting.ISAPIRuntime.ProcessRequest. If your problem is related to the subscription that suddenly discontinued to work, please attach the corresponding piece from the reportserver_<date>.logh file.

|||

Ah, thanks for that help. Here is that log:

aspnet_wp!processing!c80!12/12/2006-10:48:06:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing.
aspnet_wp!processing!c80!12/12/2006-10:48:06:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: An unexpected error occurred in Report Processing.
aspnet_wp!processing!c80!12/12/2006-10:48:06:: e ERROR: Stack trace: at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
aspnet_wp!chunks!c80!12/12/2006-10:48:06:: i INFO: ### GetReportChunk('CompiledDefinition', Main), chunk was not found! this=00000000-0000-0000-0000-000000000000
aspnet_wp!processing!c80!12/12/2006-10:48:06:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.GetAllDataSources(CatalogItemContext reportContext, GetReportChunk getCompiledDefinitionCallback, SubReportDataSourcesCallback subReportCallback, DataSourceInfoCollection dataSources, Boolean checkIfUsable, Boolean isSurrogatePresent)
Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean checkIfUsable)
Microsoft.ReportingServices.Library.RSService.ProcessReportParameters(CatalogItemContext reportContext, ReportSnapshot compiledDefintion, ReportSnapshot snapshotData, DataSourceInfoCollection dataSources, ParameterInfoCollection newParameters, DateTime executionTime, Boolean isSnapshot)
Microsoft.ReportingServices.Library.RSService.InternalGetReportParametersForRendering(CatalogItemContext reportContext, Guid reportID, Guid linkID, DateTime historyDate, Int32 executionOption, ReportSnapshot compiledDefinition, ReportSnapshot snapshotData, String savedParametersXml, NameValueCollection values)
Microsoft.ReportingServices.Library.ProcessReportParametersCancelableStep.Execute()
Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
Microsoft.ReportingServices.Library.RSService.GetReportParametersForRendering(CatalogItemContext reportContext, Guid reportID, Guid linkID, DateTime historyDate, Int32 executionOption, ReportSnapshot compiledDefinition, ReportSnapshot snapshotData, String savedParametersXml, NameValueCollection values, JobTypeEnum jobType)
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
Microsoft.ReportingServices.Library.RSService.GetReportParameters(String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
Microsoft.ReportingServices.WebServer.HTMLViewerBase.GetMergedParametersCollection(NameValueCollection userSpecifiedParams)
Microsoft.ReportingServices.WebServer.HTMLViewerBase.GetMergedReportCollections(ParameterInfoCollection& mergedParams, DataSourcePromptCollection& mergedDataSources, Boolean countsOnly)
Microsoft.ReportingServices.WebServer.HTML40Viewer.GetMergedReportCollections(ParameterInfoCollection& mergedParams, DataSourcePromptCollection& mergedDataSources, Boolean countsOnly)
Microsoft.ReportingServices.WebServer.HTML40Viewer.RenderViewer(String reportName, ReportUrl location, NameValueCollection reportParameters, DatasourceCredentialsCollection dataSourceCredentials, NameValueCollection reportServerParameters, NameValueCollection deviceInfo, NameValueCollection clientCapabilities, CreateAndRegisterStream createAndRegisterStream)
Microsoft.ReportingServices.WebServer.HTMLViewerBase.PreRender(RSService service, CatalogItemContext itemContext, CreateAndRegisterStream createAndRegisterStream, Boolean isSnapshot)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem()
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.ProcessRequest(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)

aspnet_wp!processing!c80!12/12/2006-10:48:06:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing.
aspnet_wp!processing!c80!12/12/2006-10:48:06:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: An unexpected error occurred in Report Processing.
aspnet_wp!processing!c80!12/12/2006-10:48:06:: e ERROR: Stack trace: at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
aspnet_wp!library!c80!12/12/2006-10:48:30:: i INFO: Call to RenderFirst( '/Maximo/PO Details' )
aspnet_wp!chunks!c80!12/12/2006-10:48:30:: i INFO: ### GetReportChunk('CompiledDefinition', Main), chunk was not found! this=00000000-0000-0000-0000-000000000000
aspnet_wp!processing!c80!12/12/2006-10:48:30:: a ASSERT: Assertion failed! Call stack:
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.GetAllDataSources(CatalogItemContext reportContext, GetReportChunk getCompiledDefinitionCallback, SubReportDataSourcesCallback subReportCallback, DataSourceInfoCollection dataSources, Boolean checkIfUsable, Boolean isSurrogatePresent)
Microsoft.ReportingServices.Library.RSService.GetAllDataSources(ReportProcessing repProc, CatalogItemContext reportContext, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection thisReportDataSources, Boolean checkIfUsable)
Microsoft.ReportingServices.Library.RSService.ProcessReportParameters(CatalogItemContext reportContext, ReportSnapshot compiledDefintion, ReportSnapshot snapshotData, DataSourceInfoCollection dataSources, ParameterInfoCollection newParameters, DateTime executionTime, Boolean isSnapshot)
Microsoft.ReportingServices.Library.RSService.InternalGetReportParametersForRendering(CatalogItemContext reportContext, Guid reportID, Guid linkID, DateTime historyDate, Int32 executionOption, ReportSnapshot compiledDefinition, ReportSnapshot snapshotData, String savedParametersXml, NameValueCollection values)
Microsoft.ReportingServices.Library.RSService.GetReportParametersForRendering(CatalogItemContext reportContext, Guid reportID, Guid linkID, DateTime historyDate, Int32 executionOption, ReportSnapshot compiledDefinition, ReportSnapshot snapshotData, String savedParametersXml, NameValueCollection values, JobTypeEnum jobType)
Microsoft.ReportingServices.Library.RSService._GetReportParameters(String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
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, JobTypeEnum type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport(HttpResponseStreamFactory streamFactory)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderReport()
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem(ItemType itemType)
Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler.RenderItem()
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.ProcessRequest(HttpWorkerRequest wr)
System.Web.Hosting.ISAPIRuntime.ProcessRequest(IntPtr ecb, Int32 iWRType)

aspnet_wp!processing!c80!12/12/2006-10:48:30:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing., ;
Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: An unexpected error occurred in Report Processing.
aspnet_wp!processing!c80!12/12/2006-10:48:30:: e ERROR: An error has occurred while retrieving datasources for a sub-report. Details: An unexpected error occurred in Report Processing.
aspnet_wp!processing!c80!12/12/2006-10:48:30:: e ERROR: Stack trace: at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Boolean A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f.a(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.Persistence.f..ctor(Stream A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0, ReportItem A_1)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(GetReportChunk A_0)
at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(Report A_0, DataSourceInfoCollection A_1, CatalogItemContext A_2, SubReportDataSourcesCallback A_3, RuntimeDataSourceInfoCollection A_4, Int32 A_5, Boolean A_6, Boolean A_7)
aspnet_wp!library!c80!12/12/2006-10:48:31:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
aspnet_wp!webserver!c80!12/12/2006-10:48:31:: i INFO: Processed report. Report='/Maximo/PO Details', Stream=''
aspnet_wp!library!d4c!12/12/2006-10:49:06:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
aspnet_wp!session!c80!12/12/2006-10:49:38:: i INFO: LoadSnapshot: Item with session: cbm0l1yg4tjjvs55u2wxlp55, reportPath: /Maximo/PO By Material Received Date, userName: BNFLIDAHO\rosesi not found in the database
aspnet_wp!library!c80!12/12/2006-10:49:38:: i INFO: Call to RenderFirst( '/Maximo/PO By Material Received Date' )
aspnet_wp!library!c80!12/12/2006-10:49:39:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.

|||

James,

All attached errors are logged by the web service when you run report via the Report Manager. You can see that by the name of the process that is the first token in the every log entry: aspnet_wp; and by the initial call in the call stack: System.Web.Hosting.ISAPIRuntime.ProcessRequest. Attached errors may be valuable if they are related to the problem you have. They indicate that there is a problem with the retrieving data sources for a sub-report when you try to execute a report via the ReportManager.

For the subscription problem you reported originally you need to take a look on the logfile written by RS windows service. Something like ReportServerService__12_12_2006_13_05_41.log. Sorry , in my previous post I put a wrong name for it. Try to locate the logfile coresponding to the subscription using the timestamp in the logfile name, and then find the errors in the logfile corresponding to the subscription using timestamps within the file.

-Igor

Email delivery not functioning

I am trying to set up automatic email delivery on our production reporting
server which runs on version 1.0 with no service pack. I modified the
RSReportServer.config to make sure the SMTP server specification is correct.
The SQL server job created says it runs successfully. But no email ever
sent out. What could be wrong? And where can I find the log file that
recording this activity? Is it a SQL log?
Same set up has worked on my development machine, which has sp1 installed.
But I want to avoid installing sp1 on production unless I am sure that's the
cause.
-- XuefengLook for the log file name ReportServerService<date>.log file. It should be
located under \Program file\Microsoft Sql Server\ReportingService\Logfiles
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Xuefeng Cao" <xcao@.massmed.org> wrote in message
news:OCgnvE8pEHA.3524@.TK2MSFTNGP15.phx.gbl...
> I am trying to set up automatic email delivery on our production reporting
> server which runs on version 1.0 with no service pack. I modified the
> RSReportServer.config to make sure the SMTP server specification is
correct.
> The SQL server job created says it runs successfully. But no email ever
> sent out. What could be wrong? And where can I find the log file that
> recording this activity? Is it a SQL log?
> Same set up has worked on my development machine, which has sp1 installed.
> But I want to avoid installing sp1 on production unless I am sure that's
the
> cause.
> -- Xuefeng
>