Monday, March 19, 2012

Another subscription problem. Really Need Help

Hi!
I know that there are already many posts about this topic, but I can't find any help on the previous posts.
I'm trying to get subscriptions to work on a development machine, but they won't :(
In email subscriptions if I include the report, it gives me an error saying that there is a configuration problem, but if I don't include it it works.
Maybe it's the same error, but if I try to do a file share subscription, gives me the same error that email with report in it.
I'm trying to put the result of subscription on a shared folder, with permissions to read and write.
Please help, i'm on this problem have already one or more weeks.
Thanks and sorry for my englishRita,
Are you creating your subscriptions in code or through the report manager
UI? When do you get the error, and what is the text of that error from the
report server log file? Do you get it when creating the subscripiton, or
when the subscripiton is processed?
Can you send a copy of the <Delivery> element from the file
RSReportServer.config?
The error for fileshare delivery - did you specify a user name & password
with access permissions to the file share?
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Rita Marchão" <RitaMarcho@.discussions.microsoft.com> wrote in message
news:6FA5375C-2E75-4AFC-A7DB-F97C5EE90907@.microsoft.com...
> Hi!
> I know that there are already many posts about this topic, but I can't
> find any help on the previous posts.
> I'm trying to get subscriptions to work on a development machine, but they
> won't :(
> In email subscriptions if I include the report, it gives me an error
> saying that there is a configuration problem, but if I don't include it it
> works.
> Maybe it's the same error, but if I try to do a file share subscription,
> gives me the same error that email with report in it.
> I'm trying to put the result of subscription on a shared folder, with
> permissions to read and write.
> Please help, i'm on this problem have already one or more weeks.
> Thanks and sorry for my english|||Hi,
i'm creating my subscriptions on report manager page. I receive error when the subscription is processed.
this is my log file:
ReportingServicesService!library!874!06/29/2004-17:24:57:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files, AuthzInitializeContextFromSid: Win32 error: 87;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files
ReportingServicesService!library!874!06/29/2004-17:24:57:: i INFO: Initializing EnableExecutionLogging to 'True' as specified in Server system properties.
ReportingServicesService!emailextension!874!06/29/2004-17:24:57:: Error sending email. Microsoft.ReportingServices.Diagnostics.Utilities.RSException: The Report Server has encountered a configuration error; more details in the log files --> Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The Report Server has encountered a configuration error; more details in the log files
at Microsoft.ReportingServices.Authorization.Native.GetAuthzContextForUser(IntPtr userSid)
at Microsoft.ReportingServices.Authorization.Native.IsAdmin(String userName)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.IsAdmin(String userName, IntPtr userToken)
at Microsoft.ReportingServices.Authorization.WindowsAuthorization.CheckAccess(String userName, IntPtr userToken, Byte[] secDesc, ReportOperation requiredOperation)
at Microsoft.ReportingServices.Library.Security.CheckAccess(ItemType catItemType, Byte[] secDesc, ReportOperation rptOper)
at Microsoft.ReportingServices.Library.RSService._GetReportParameterDefinitionFromCatalog(CatalogItemContext reportContext, String historyID, Boolean forRendering, Guid& reportID, Int32& executionOption, String& savedParametersXml, ReportSnapshot& compiledDefinition, ReportSnapshot& snapshotData, Guid& linkID, DateTime& historyDate)
at Microsoft.ReportingServices.Library.RSService._GetReportParameters(String report, String historyID, Boolean forRendering, NameValueCollection values, DatasourceCredentialsCollection credentials)
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, JobTypeEnum 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)
ReportingServicesService!notification!874!06/29/2004-17:24:57:: Notification 1d6463ab-567b-4f36-8c7c-7e2518502278 completed. Success: False, Status: Failure sending mail: The Report Server has encountered a configuration error; more details in the log files, DeliveryExtension: Report Server Email, Report: Foodmart Sales, Attempt 0
And this is my Delivery field:
<Delivery>
<Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareProvider,ReportingServicesFileShareDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<FileShareConfiguration>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
</FileShareConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">
<MaxRetries>3</MaxRetries>
<SecondsBeforeRetry>900</SecondsBeforeRetry>
<Configuration>
<RSEmailDPConfiguration>
<SMTPServer>TERRA</SMTPServer>
<SMTPServerPort></SMTPServerPort>
<SMTPAccountName></SMTPAccountName>
<SMTPConnectionTimeout></SMTPConnectionTimeout>
<SMTPServerPickupDirectory>C:\RS_FILES</SMTPServerPickupDirectory>
<SMTPUseSSL></SMTPUseSSL>
<SendUsing>1</SendUsing>
<SMTPAuthenticate></SMTPAuthenticate>
<From>rita.marchao@.eb-focus.pt</From>
<EmbeddedRenderFormats>
<RenderingExtension>MHTML</RenderingExtension>
</EmbeddedRenderFormats>
<PrivilegedUserRenderFormats></PrivilegedUserRenderFormats>
<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
</ExcludedRenderFormats>
<SendEmailToUserAlias>True</SendEmailToUserAlias>
<DefaultHostName></DefaultHostName>
<PermittedHosts></PermittedHosts>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="NULL" Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
</Delivery>
And yes, I'm giving the rigth user/password on file share subscription.
Thank you for trying to help.
"Lukasz Pawlowski [MSFT]" wrote:
> Rita,
> Are you creating your subscriptions in code or through the report manager
> UI? When do you get the error, and what is the text of that error from the
> report server log file? Do you get it when creating the subscripiton, or
> when the subscripiton is processed?
> Can you send a copy of the <Delivery> element from the file
> RSReportServer.config?
> The error for fileshare delivery - did you specify a user name & password
> with access permissions to the file share?
> -Lukasz
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Rita Marchão" <RitaMarcho@.discussions.microsoft.com> wrote in message
> news:6FA5375C-2E75-4AFC-A7DB-F97C5EE90907@.microsoft.com...
> > Hi!
> >
> > I know that there are already many posts about this topic, but I can't
> > find any help on the previous posts.
> >
> > I'm trying to get subscriptions to work on a development machine, but they
> > won't :(
> > In email subscriptions if I include the report, it gives me an error
> > saying that there is a configuration problem, but if I don't include it it
> > works.
> >
> > Maybe it's the same error, but if I try to do a file share subscription,
> > gives me the same error that email with report in it.
> >
> > I'm trying to put the result of subscription on a shared folder, with
> > permissions to read and write.
> >
> > Please help, i'm on this problem have already one or more weeks.
> >
> > Thanks and sorry for my english
>
>

No comments:

Post a Comment