none
Erro em disparo automático de relatórios por assinatura SSRS 2008 R2 RRS feed

  • Pergunta

  • Bom dia comunidade.

    Estou com um problema em uma assinatura (Subscription) de report que temos em um ambiente Microsoft SQL Server 2008 R2. 

    A Subscription dispara um report para cada filial, contendo nada mais do que uma planilha em formato Excel com os dados das vendas de um determinado produto. Foi observado que na mesma assinatura unidades em que as vendas não são tão expressivas recebem seu relatório normalmente, já as unidades em que o volume de vendas contidas na planilha bera os 6 MB de registros, não recebem o seu relatório e o erro abaixo é registrado no Log:

    #Registro de Log (Drive:\Microsoft SQL Server\MSRS10_50.INST\Reporting Services\LogFiles):

    <Header>
     <Product>Microsoft SQL Server Reporting Services Version 2009.0100.4266.00 ((KJ_SP2_QFE-CU).120926-1658 )</Product>
     <Locale>Portuguese (Brazil)</Locale>
     <TimeZone>E. South America Daylight Time</TimeZone>
     <Path>Drive:\Microsoft SQL Server\MSRS10_50.INST\Reporting Services\Logfiles\ReportServerService__10_31_2016_09_48_22.log</Path>
     <SystemName>Server</SystemName>
     <OSName>Microsoft Windows NT 6.1.7601 Service Pack 1</OSName>
     <OSVersion>6.1.7601</OSVersion>
     <ProcessID>1019668</ProcessID>
     <Virtualization>Hypervisor</Virtualization>
    </Header>


    cache!WindowsService_9!f7ffc!10/31/2016-10:15:14:: v VERBOSE: Found key in cache: __RenderedSnapshotResult__:/Duarte/Exemplo - TESTE EMAIL GRUPO&cb86bba4-ded0-457a-9686-c3c89ba89d66&:unidade:9999&:Format:MHTML&:Exemplo - TESTE EMAIL GRUPO_style
    cache!WindowsService_9!f7ffc!10/31/2016-10:15:14:: v VERBOSE: Image from cache : /Duarte/Exemplo - TESTE EMAIL GRUPO
    emailextension!WindowsService_9!f7ffc!10/31/2016-10:15:22:: e ERROR: Error sending email. System.Runtime.InteropServices.COMException (0x80040211): The message could not be sent to the Mail Server. The transport error code was 0x800ccc6d. The server response was 552 5.3.4 Message size exceeds fixed maximum message size

      at ReportingServicesCDOInterop.MessageClass.Send()
      at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
    library!WindowsService_9!f7ffc!10/31/2016-10:15:22:: Data Driven Notification for activation id b426f7ee-214b-402d-8900-d6ae6a64c105 was saved.
    library!WindowsService_9!f7ffc!10/31/2016-10:15:22:: Status: Failure sending mail: The message could not be sent to the Mail Server. The transport error code was 0x800ccc6d. The server response was 552 5.3.4 Message size exceeds fixed maximum message size




    Informações adicionais:

    1) Validadas as configurações do Mail Server afim de descartar alguma parametrização que limitasse o tráfego de e-mais de tamanhos semalhantes (+-6MB);

    2) Executado o report manualmente, gerando o arquivo excel com grande quantidade de registros (em torno de 6 MB), anexando a um e-mail e disparando para o mesmo destinatário que apresentava falha no envio através da assinatura. Desta forma, o mesmo report chega sem problemas no destinatário, descartando assim uma "falha" no Mail Server;

    3) Inclusas apenas unidades em que o anexo chegava até 2MB e para as mesmas o report foi enviado com sucesso através da assinatura;

    4) A lista de destinatários e unidades é resgatada através de um conjunto de dados;

    5) Aparentemente, o erro está relacionado ao tamanho do arquivo anexado ao e-mail da assinatura;

    6) O disparo não é realizado atraves de uma conta autenticada;

    7) Mail Server Utilizado: MS Exchange Server 2010 V14.3;

    8) Configurações do Reporting Services:

    #ReportingServicesService.exe.config (Em: Drive:\Microsoft SQL Server\MSRS10_50.Inst\Reporting Services\ReportServer\bin):

    <configuration>
     <configSections>
    <section name="RStrace" type="Microsoft.ReportingServices.Diagnostics.RSTraceSectionHandler,Microsoft.ReportingServices.Diagnostics" />
     </configSections>
     <system.diagnostics>
    <switches>
     <add name="DefaultTraceSwitch" value="4" />
    </switches>
     </system.diagnostics>
     <RStrace>
    <add name="FileName" value="ReportServerService_" />
    <add name="FileSizeLimitMb" value="32" />
    <add name="KeepFilesForDays" value="14" />
    <add name="Prefix" value="appdomain, tid, time" />
    <add name="TraceListeners" value="file" />
    <add name="TraceFileMode" value="unique" />
    <add name="Components" value="all:4" />
     </RStrace>
     <runtime>
    <alwaysFlowImpersonationPolicy enabled="true"/>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
     <dependentAssembly>
    <assemblyIdentity name="Microsoft.ReportingServices.Interfaces"
    publicKeyToken="89845dcd8080cc91"
    culture="neutral" />
    <bindingRedirect oldVersion="8.0.242.0"
    newVersion="10.0.0.0"/>
    <bindingRedirect oldVersion="9.0.242.0"
    newVersion="10.0.0.0"/>
     </dependentAssembly>
     <dependentAssembly>
    <assemblyIdentity name="Microsoft.ReportingServices.ProcessingCore" 
    publicKeyToken="89845dcd8080cc91" 
    culture="neutral" />
    <bindingRedirect oldVersion="9.0.242.0" 
    newVersion="10.0.0.0"/>
     </dependentAssembly>
    </assemblyBinding>
    <gcServer enabled="true" />
     </runtime>
    </configuration>


    #rsreportserver.config (Em: Drive:\Microsoft SQL Server\MSRS10_50.Inst\Reporting Services\ReportServer):

    <Configuration>

    <ConnectionType>Default</ConnectionType>
    <LogonUser></LogonUser>
    <LogonDomain></LogonDomain>
    <LogonCred></LogonCred>
    <InstanceId>MSRS10_50.Inst</InstanceId>
    <InstallationID>{XXX}</InstallationID>
    <Add Key="SecureConnectionLevel" Value="0"/>
    <Add Key="CleanupCycleMinutes" Value="10"/>
    <Add Key="MaxActiveReqForOneUser" Value="20"/>
    <Add Key="DatabaseQueryTimeout" Value="120"/>
    <Add Key="RunningRequestsScavengerCycle" Value="60"/>
    <Add Key="RunningRequestsDbCycle" Value="120"/>
    <Add Key="RunningRequestsAge" Value="30"/>
    <Add Key="MaxScheduleWait" Value="5"/>
    <Add Key="DisplayErrorLink" Value="true"/>
    <Add Key="WebServiceUseFileShareStorage" Value="false"/>
    <!--  <Add Key="ProcessTimeout" Value="150" /> -->
    <!--  <Add Key="ProcessTimeoutGcExtension" Value="120" /> -->
    <!--  <Add Key="WatsonFlags" Value="0x0430" /> full dump-->
    <!--  <Add Key="WatsonFlags" Value="0x0428" /> minidump -->
    <!--  <Add Key="WatsonFlags" Value="0x0002" /> no dump-->
    <Add Key="WatsonFlags" Value="0x0428"/>
    <Add Key="WatsonDumpOnExceptions" Value="Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException"/>
    <Add Key="WatsonDumpExcludeIfContainsExceptions" Value="System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException,Microsoft.SharePoint.SPException"/>
    <URLReservations>
    <Application>
    <Name>ReportServerWebService</Name>
    <VirtualDirectory>ReportServer</VirtualDirectory>
    <URLs>
    <URL>
    <UrlString>http://+:80</UrlString>
    <AccountSid>?</AccountSid>
    <AccountName>domain\AccountName</AccountName>
    </URL>
    </URLs>
    </Application>
    <Application>
    <Name>ReportManager</Name>
    <VirtualDirectory>Reports</VirtualDirectory>
    <URLs>
    <URL>
    <UrlString>http://+:80</UrlString>
    <AccountSid>AccountSid</AccountSid>
    <AccountName>domain\AccountName</AccountName>
    </URL>
    </URLs>
    </Application>
    </URLReservations>
    <Authentication>
    <AuthenticationTypes>
    <RSWindowsNTLM/>
    </AuthenticationTypes>
    <RSWindowsExtendedProtectionLevel>Off</RSWindowsExtendedProtectionLevel>
    <RSWindowsExtendedProtectionScenario>Proxy</RSWindowsExtendedProtectionScenario>
    <EnableAuthPersistence>true</EnableAuthPersistence>
    </Authentication>
    <Service>
    <IsSchedulingService>True</IsSchedulingService>
    <IsNotificationService>True</IsNotificationService>
    <IsEventService>True</IsEventService>
    <PollingInterval>10</PollingInterval>
    <WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage>
    <MemorySafetyMargin>80</MemorySafetyMargin>
    <MemoryThreshold>90</MemoryThreshold>
    <RecycleTime>720</RecycleTime>
    <MaxAppDomainUnloadTime>30</MaxAppDomainUnloadTime>
    <MaxQueueThreads>0</MaxQueueThreads>
    <UrlRoot>http://xpto/reportserver</UrlRoot>
    <UnattendedExecutionAccount>
    <UserName></UserName>
    <Password></Password>
    <Domain></Domain>
    </UnattendedExecutionAccount>
    <PolicyLevel>rssrvpolicy.config</PolicyLevel>
    <IsWebServiceEnabled>True</IsWebServiceEnabled>
    <IsReportManagerEnabled>True</IsReportManagerEnabled>
    <FileShareStorageLocation>
    <Path>
    </Path>
    </FileShareStorageLocation>
    </Service>
    <UI>
    <ReportServerUrl>
    </ReportServerUrl>
    <PageCountMode>Estimate</PageCountMode>
    </UI>
    <Extensions>
    <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>
    <RenderingExtension>RGDI</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>Smtp.domain</SMTPServer>
    <SMTPServerPort>
    </SMTPServerPort>
    <SMTPAccountName>
    </SMTPAccountName>
    <SMTPConnectionTimeout>
    </SMTPConnectionTimeout>
    <SMTPServerPickupDirectory>
    </SMTPServerPickupDirectory>
    <SMTPUseSSL>
    </SMTPUseSSL>
    <SendUsing>2</SendUsing>
    <SMTPAuthenticate>
    </SMTPAuthenticate>
    <From>email@domain</From>
    <EmbeddedRenderFormats>
    <RenderingExtension>MHTML</RenderingExtension>
    </EmbeddedRenderFormats>
    <PrivilegedUserRenderFormats>
    </PrivilegedUserRenderFormats>
    <ExcludedRenderFormats>
    <RenderingExtension>HTMLOWC</RenderingExtension>
    <RenderingExtension>NULL</RenderingExtension>
    <RenderingExtension>RGDI</RenderingExtension>
    </ExcludedRenderFormats>
    <SendEmailToUserAlias>True</SendEmailToUserAlias>
    <DefaultHostName>
    </DefaultHostName>
    <PermittedHosts>
    </PermittedHosts>
    </RSEmailDPConfiguration>
    </Configuration>
    </Extension>
    <Extension Name="Report Server DocumentLibrary" Type="Microsoft.ReportingServices.SharePoint.SharePointDeliveryExtension.DocumentLibraryProvider,ReportingServicesSharePointDeliveryExtension">
    <MaxRetries>3</MaxRetries>
    <SecondsBeforeRetry>900</SecondsBeforeRetry>
    <Configuration>
    <DocumentLibraryConfiguration>
    <ExcludedRenderFormats>
    <RenderingExtension>HTMLOWC</RenderingExtension>
    <RenderingExtension>NULL</RenderingExtension>
    <RenderingExtension>RGDI</RenderingExtension>
    </ExcludedRenderFormats>
    </DocumentLibraryConfiguration>
    </Configuration>
    </Extension>
    <Extension Name="NULL" Type="Microsoft.ReportingServices.NullDeliveryProvider.NullProvider,ReportingServicesNullDeliveryProvider"/>
    </Delivery>
    <DeliveryUI>
    <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider">
    <DefaultDeliveryExtension>True</DefaultDeliveryExtension>
    <Configuration>
    <RSEmailDPConfiguration>
    <DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
    </RSEmailDPConfiguration>
    </Configuration>
    </Extension>
    <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider"/>
    </DeliveryUI>
    <Render>
    <Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.DataRenderer.XmlDataReport,Microsoft.ReportingServices.DataRendering"/>
    <Extension Name="NULL" Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/>
    <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering"/>
    <Extension Name="ATOM" Type="Microsoft.ReportingServices.Rendering.DataRenderer.AtomDataReport,Microsoft.ReportingServices.DataRendering" Visible="false"/>
    <Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PDFRenderer,Microsoft.ReportingServices.ImageRendering"/>
    <Extension Name="RGDI" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.RGDIRenderer,Microsoft.ReportingServices.ImageRendering" Visible="false"/>
    <Extension Name="HTML4.0" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>
    <Extension Name="MHTML" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering"/>
    <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/>
    <Extension Name="RPL" Type="Microsoft.ReportingServices.Rendering.RPLRendering.RPLRenderer,Microsoft.ReportingServices.RPLRendering" Visible="false" LogAllExecutionRequests="false"/>
    <Extension Name="IMAGE" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRenderer,Microsoft.ReportingServices.ImageRendering"/>
    <Extension Name="WORD" Type="Microsoft.ReportingServices.Rendering.WordRenderer.WordDocumentRenderer,Microsoft.ReportingServices.WordRendering"/>
    </Render>
    <Data>
    <Extension Name="SQL" Type="Microsoft.ReportingServices.DataExtensions.SqlConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
    <Extension Name="SQLAZURE" Type="Microsoft.ReportingServices.DataExtensions.SqlAzureConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
    <Extension Name="SQLPDW" Type="Microsoft.ReportingServices.DataExtensions.SqlDwConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
    <Extension Name="OLEDB" Type="Microsoft.ReportingServices.DataExtensions.OleDbConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
    <Extension Name="OLEDB-MD" Type="Microsoft.ReportingServices.DataExtensions.AdoMdConnection,Microsoft.ReportingServices.DataExtensions"/>
    <Extension Name="ORACLE" Type="Microsoft.ReportingServices.DataExtensions.OracleClientConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
    <Extension Name="ODBC" Type="Microsoft.ReportingServices.DataExtensions.OdbcConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
    <Extension Name="XML" Type="Microsoft.ReportingServices.DataExtensions.XmlDPConnection,Microsoft.ReportingServices.DataExtensions"/>
    <Extension Name="SHAREPOINTLIST" Type="Microsoft.ReportingServices.DataExtensions.SharePointList.SPListConnection,Microsoft.ReportingServices.DataExtensions"/>
    <Extension Name="SAPBW" Type="Microsoft.ReportingServices.DataExtensions.SapBw.SapBwConnection,Microsoft.ReportingServices.DataExtensions.SapBw"/>
    <Extension Name="ESSBASE" Type="Microsoft.ReportingServices.DataExtensions.Essbase.EssbaseConnection,Microsoft.ReportingServices.DataExtensions.Essbase"/>
    <Extension Name="TERADATA" Type="Microsoft.ReportingServices.DataExtensions.TeradataConnectionWrapper,Microsoft.ReportingServices.DataExtensions"/>
    </Data>
    <SemanticQuery>
    <Extension Name="SQL" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MSSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">
    <Configuration>
    <EnableMathOpCasting>False</EnableMathOpCasting>
    </Configuration>
    </Extension>
    <Extension Name="SQLAZURE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MSSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">
    <Configuration>
    <EnableMathOpCasting>False</EnableMathOpCasting>
    </Configuration>
    </Extension>
    <Extension Name="SQLPDW" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQLADW.MSSqlAdwSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">
    <Configuration>
    <EnableMathOpCasting>False</EnableMathOpCasting>
    </Configuration>
    </Extension>
    <Extension Name="ORACLE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Oracle.OraSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">
    <Configuration>
    <EnableMathOpCasting>True</EnableMathOpCasting>
    <DisableNO_MERGEInLeftOuters>False</DisableNO_MERGEInLeftOuters>
    <EnableUnistr>False</EnableUnistr>
    <DisableTSTruncation>False</DisableTSTruncation>
    </Configuration>
    </Extension>
    <Extension Name="TERADATA" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Teradata.TdSqlSQCommand,Microsoft.ReportingServices.SemanticQueryEngine">
    <Configuration>
    <EnableMathOpCasting>True</EnableMathOpCasting>
    <ReplaceFunctionName>oREPLACE</ReplaceFunctionName>
    </Configuration>
    </Extension>
    <Extension Name="OLEDB-MD" Type="Microsoft.AnalysisServices.Modeling.QueryExecution.ASSemanticQueryCommand,Microsoft.AnalysisServices.Modeling"/>
    </SemanticQuery>
    <ModelGeneration>
    <Extension Name="SQL" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MsSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/>
    <Extension Name="SQLAZURE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.MSSQL.MsSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/>
    <Extension Name="ORACLE" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Oracle.OraSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/>
    <Extension Name="TERADATA" Type="Microsoft.ReportingServices.SemanticQueryEngine.Sql.Teradata.TdSqlModelGenerator,Microsoft.ReportingServices.SemanticQueryEngine"/>
    <Extension Name="OLEDB-MD" Type="Microsoft.AnalysisServices.Modeling.Generation.ModelGeneratorExtention,Microsoft.AnalysisServices.Modeling"/>
    </ModelGeneration>
    <Security>
    <Extension Name="Windows" Type="Microsoft.ReportingServices.Authorization.WindowsAuthorization, Microsoft.ReportingServices.Authorization"/>
    </Security>
    <Authentication>
    <Extension Name="Windows" Type="Microsoft.ReportingServices.Authentication.WindowsAuthentication, Microsoft.ReportingServices.Authorization"/>
    </Authentication>
    <EventProcessing>
    <Extension Name="SnapShot Extension" Type="Microsoft.ReportingServices.Library.HistorySnapShotCreatedHandler,ReportingServicesLibrary">
    <Event>
    <Type>ReportHistorySnapshotCreated</Type>
    </Event>
    </Extension>
    <Extension Name="Timed Subscription Extension" Type="Microsoft.ReportingServices.Library.TimedSubscriptionHandler,ReportingServicesLibrary">
    <Event>
    <Type>TimedSubscription</Type>
    </Event>
    </Extension>
    <Extension Name="Cache Refresh Plan Extension" Type="Microsoft.ReportingServices.Library.CacheRefreshPlanHandler,ReportingServicesLibrary">
    <Event>
    <Type>RefreshCache</Type>
    </Event>
    </Extension>
    <Extension Name="Cache Update Extension" Type="Microsoft.ReportingServices.Library.ReportExecutionSnapshotUpdateEventHandler,ReportingServicesLibrary">
    <Event>
    <Type>SnapshotUpdated</Type>
    </Event>
    </Extension>
    </EventProcessing>
    </Extensions>
    <MapTileServerConfiguration>
    <MaxConnections>2</MaxConnections>
    <Timeout>10</Timeout>
    <AppID>(Default)</AppID>
    <CacheLevel>Default</CacheLevel>
    </MapTileServerConfiguration>
    </Configuration>



    Desde já agradeço.

    Att. 




    segunda-feira, 31 de outubro de 2016 17:44

Todas as Respostas