none
Not able to generate reports from application (via dot net) which are deployed in DB Server RRS feed

  • Question

  • Hi All,

    While accessing the report from application calling dot net  service from DB server .Getting below error.

    Error:

    xxxx Exception Information
    ---------------------------------------------------------------------------------------------------
    Timestamp: 11/6/2019 9:17:45 AM

    Tracing to LogSource 'General' failed. Processing for other sources will continue. See summary information below for more information. Should this problem persist, stop the service and check the configuration file(s) for possible error(s) in the configuration of the categories and sinks.


    Summary for Enterprise Library Distributor Service:
    ======================================
    --> 
    Message: 
    Timestamp: 11/6/2019 9:17:45 AM
    Message: An exception of type: xxx.xx.Framework.Error.PortalException occured and was caught.
    ---------------------------------------------------------------------------------------------------
    11/06/2019 09:17:45
    Type : xx.xxx.Framework.Error.PortalException
    Message : Unable to generate report: Unable to render report: Unable to connect to the remote server
    Unable to render report: Unable to connect to the remote server
    Unable to render report: Unable to connect to the remote server
    Unable to render report: Unable to connect to the remote server

    Source (Library) : xx.xxx.Framework.Reporting
    Target Site (Method) : System.Collections.Generic.IEnumerable`1[SLB.EMS.Framework.Reporting.Entities.SectionFileName] GenerateFiles(SLB.EMS.Framework.Reporting.Entities.GenerationRequest)
    Stack Trace :    at xxx.xxx.Framework.Reporting.Services.GenerationService.GenerateFiles(GenerationRequest request)
       at xxx.xxx.Framework.Reporting.Services.GenerationService.Generate()
       at xx.xxx.Portal.Domain.Business.Reporting.GenerationBusinessLogic.GenerateReport(IPortalDbContext context, ReportRequest reportRequest, String fileFormatExtension)
       at xxx.xxx.Portal.Domain.Business.Reporting.GenerationBusinessLogic.CreateReport(IPortalDbContext context, User user, ReportRequest reportRequest, String fileFormatExtension)
       at xxxx.Portal.Services.ReportGenerationService.<>c__DisplayClass2.<GenerateReport>b__0()
       at xxxx..Framework.Error.Error.Handle(Action method, Action`2 handler, Boundary boundary)
    Correlation ID: 5dd21894-31e8-43f0-9a02-d6c0a0f42009
    Severity: Error
    Portal Project ID : 88164

    Inner Exception Details
    ---------------------------------------------------------------------------------------------------
    Inner Exception Message : Unable to generate report: Unable to render report: Unable to connect to the remote server
    Unable to render report: Unable to connect to the remote server
    Unable to render report: Unable to connect to the remote server
    Unable to render report: Unable to connect to the remote server

    Inner Exception Stack Trace : 

    Additional Information
    ---------------------------------------------------------------------------------------------------
    Thread Identity : DIR\xxxx
    Windows Identity : DIR\xxx-adminqa

    Category: General
    Priority: 40
    EventId: 9999
    Severity: Error
    Title:
    Machine: xxxxxx
    App Domain: /LM/W3SVC/3/ROOT-1-132175041787317761
    ProcessId: 1916
    Process Name: c:\windows\system32\inetsrv\w3wp.exe
    Thread Name: 
    Win32 ThreadId:7908
    Extended Properties: 
    --> MachineName: xxxxxx
    --> TimeStamp: 11/6/2019 9:17:45 AM
    --> FullName: Microsoft.Practices.EnterpriseLibrary.Logging, Version=6.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
    --> AppDomainName: /LM/W3SVC/3/ROOT-1-132175041787317761
    --> WindowsIdentity: DIR\xxxxxx-adminqa

    Exception Information Details:
    ======================================
    Exception Type: System.Net.Mail.SmtpException
    StatusCode: TransactionFailed
    Message: Transaction failed. The server response was: 5.7.1 <xxxxxx.earaa1308.gcp.xx.com[xx.xxx.xxx.xx]>: Client host rejected: Access denied
    Data: System.Collections.ListDictionaryInternal
    TargetSite: Boolean CheckResponse(System.Net.Mail.SmtpStatusCode, System.String)
    HelpLink: NULL
    Source: System
    HResult: -2146233088

    StackTrace Information Details: 
    ======================================
       at System.Net.Mail.RecipientCommand.CheckResponse(SmtpStatusCode statusCode, String response)
       at System.Net.Mail.SmtpTransport.SendMail(MailAddress sender, MailAddressCollection recipients, String deliveryNotify, Boolean allowUnicode, SmtpFailedRecipientException& exception)
       at System.Net.Mail.SmtpClient.Send(MailMessage message)
       at Microsoft.Practices.EnterpriseLibrary.Logging.Configuration.EmailMessage.Send()
       at Microsoft.Practices.EnterpriseLibrary.Logging.LogSource.TraceData(TraceEventType eventType, Int32 id, LogEntry logEntry, TraceListenerFilter traceListenerFilter, TraceEventCache traceEventCache, ReportTracingError reportError)

    Category: 

    Priority: -1

    EventId: 6352
    Thursday, November 7, 2019 7:54 AM

All replies

  • [SLB.EMS.Framework.Reporting.Entities.SectionFileName] GenerateFiles(SLB.EMS.Framework.Reporting.Entities.GenerationRequest)

    Waht fro a reporting server are you using? I don't see any message from MS SQL Server/SSRS Reporting Services here.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Thursday, November 7, 2019 8:22 AM
  • Fixed after opening the port from application server to DB Server.(Where we deployed the reports)
    Thursday, November 7, 2019 12:46 PM
  • Hi All 

    However,after opening the port ,able to generate the reports from application server not from my local machine could you please suggest.

    Thursday, November 7, 2019 12:51 PM
  • It seems your original issue was resolved.

    As for this new issue, seem you have opened a new ticket.

    You could kindly close this ticket by marking you solution for this problem as answer, so we could focus on the new thread.

    Regards,

    Lukas


    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.


    Tuesday, November 12, 2019 6:30 AM