Hi,

We are trying to configure a subscription to e-mail the "Remaining Work" report daily to a specified email account.

We are running the RTM version of TFS and have not modified the RDL's in any way.

The Remaining Work report displays fine when accessed via the URL. http://server/Reports/Pages/Report.aspx?ItemPath=%2fTFS+Management%2fRemaining+Work

The Reporting Service Log (\Program Files\Microsoft SQL Server\MSSQL.3\LogFiles) file shows the following exception when the subscription's scheduled time comes:

ReportingServicesService!library!a!08/11/2006-12:02:05:: i INFO: Call to RenderFirst( '/TFS Management/Remaining Work' )
ReportingServicesService!processing!a!08/11/2006-12:02:05:: e ERROR: Throwing Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Exception of type 'Microsoft.ReportingServices.ReportProcessing.ReportProcessingException' was thrown., ;
 Info: Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: Exception of type 'Microsoft.ReportingServices.ReportProcessing.ReportProcessingException' was thrown.
ReportingServicesService!library!a!08/11/2006-12:02:05:: i INFO: Initializing EnableExecutionLogging to 'True'  as specified in Server system properties.
ReportingServicesService!emailextension!a!08/11/2006-12:02:05:: Error sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Language expression for the report ??ody??has a user profile dependency. ---> Microsoft.ReportingServices.ReportProcessing.ReportProcessingException: The Language expression for the report ??ody??has a user profile dependency.
   at Microsoft.ReportingServices.ReportProcessing.ReportRuntime.RegisterRuntimeErrorInExpression(VariantResult& result, Exception e, IErrorContext iErrorContext, Boolean isError)
   at Microsoft.ReportingServices.ReportProcessing.ReportRuntime.EvaluateReportLanguageExpression(Report report, CultureInfo& language)
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.Merge.EvaluateAndSetReportLanguage()
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.Merge.Process(ParameterInfoCollection parameters, Boolean mergeTran)
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report report, ProcessingContext pc, ProcessingContext context)
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessReport(Report report, ProcessingContext pc, Boolean snapshotProcessing, Boolean processWithCachedData, GetReportChunk getChunkCallback, ErrorContext errorContext, DateTime executionTime, CreateReportChunk cacheDataCallback, ProcessingContext& context)
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessAndRenderReport(IRenderingExtension renderer, Boolean snapshotProcessing, DateTime executionTimeStamp, ProcessingContext pc, RenderingContext rc, GetReportChunk getReportChunkCallback, GetReportChunk getDataCallback)
   at Microsoft.ReportingServices.ReportProcessing.ReportProcessing.ProcessAndRenderSnapshot(ProcessingContext pc, RenderingContext rc, GetReportChunk getReportChunkCallback)
   at Microsoft.ReportingServices.Library.RSService.RenderAsSnapshotNoCache(CatalogItemContext reportContext, Guid reportId, DateTime executionDate, DateTime expirationDate, ClientRequest session, ReportSnapshot snapshotData, String description, RenderingResult& result, Boolean& transientRefcountNeedsDecreasing)
   at Microsoft.ReportingServices.Library.RSService.RenderAsSnapshot(CatalogItemContext reportContext, Guid reportId, DateTime executionDate, DateTime expirationDate, ClientRequest session, ReportSnapshot snapshotData, String description, Boolean foundInCache, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
   at Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters)
   at Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext reportContext, ClientRequest session, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
   at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.Execute()
   at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
   --- End of inner exception stack trace ---
   at Microsoft.ReportingServices.Diagnostics.CancelablePhaseBase.ExecuteWrapper()
   at Microsoft.ReportingServices.Library.RenderFirstCancelableStep.RenderFirst(RSService rs, CatalogItemContext reportContext, ClientRequest session, JobType type, Warning[]& warnings, ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
   at Microsoft.ReportingServices.Library.ReportImpl.Render(String renderFormat, String deviceInfo)
   at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.ConstructMessageBody(IMessage message, Notification notification, SubscriptionData data)
   at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.CreateMessage(Notification notification)
   at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)

The bottom of the Remaining Work RDL includes the following line:

  <Language>=User!Language</Language>

the "Microsoft SQL Server (Reporting Services)" service is configured using services.msc to log on as DOMAIN\User because BUILTIN\Network Service does not have permission to access active directory.

Any help is appreciated. Regards,

Grant

Can anybody help with this?

Is it possible to setup email subscriptions to TFS reports?

Hi Grant,

I apologize for the delay. Can you please detail the steps you used to setup the subscription?

Thanks,

Mauli

Hi Grant,

I have found out the answer: At subscription time report processing does not have access to the user profile information. Any expression like User!... will cause ?œhas a user profile dependency??error.

For reports that you want to subscribe to, you can take out the following tag: