web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

The underlying connection was closed: The connection was closed unexpectedly. Error on CEO and CFO EP Role center page

(0) ShareShare
ReportReport
Posted on by 220

Hi All,

On our live server EP site we are getting "The underlying connection was closed: The connection was closed unexpectedly" error. We are getting the error when we open the role center page for CEO and CFO.

We have got some event logs on event viewer regarding the issue, Please find below the event details.

Event Log Error:

The description for Event ID 1000 from source Microsoft Dynamics AX Enterprise Portal cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

If the event originated on another computer, the display information had to be saved with the event.

The following information was included with the event:

An unexpected exception occurred in the Microsoft Dynamics AX report viewer control. Contact your system administrator for assistance.


The underlying connection was closed: The connection was closed unexpectedly.

System.Net.WebException
at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods()
at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname)
at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.SetConnectionSSLForMethod(String methodname)
at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.ProxyMethodInvocation.Execute[TReturn](RSExecutionConnection connection, ProxyMethod`1 initialMethod, ProxyMethod`1 retryMethod)
at Microsoft.Reporting.WebForms.SoapReportExecutionService.LoadReport(String report, String historyId)
at Microsoft.Reporting.WebForms.ServerReport.EnsureExecutionSession()
at Microsoft.Reporting.WebForms.ServerReport.GetParameters()
at Microsoft.Reporting.WebForms.ParametersArea.GetMetaDataFromReport()
at Microsoft.Reporting.WebForms.ParametersArea.CreateChildControls()

Event Xml:
<Event xmlns="schemas.microsoft.com/.../event">
<System>
<Provider Name="Microsoft Dynamics AX Enterprise Portal" />
<EventID Qualifiers="0">1000</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2018-04-02T13:05:29.000000000Z" />
<EventRecordID>974874</EventRecordID>
<Channel>Application</Channel>
<Computer>AGH-SPWFE1-PRD.DIP.LAN</Computer>
<Security />
</System>
<EventData>
<Data>An unexpected exception occurred in the Microsoft Dynamics AX report viewer control. Contact your system administrator for assistance.


The underlying connection was closed: The connection was closed unexpectedly.

System.Net.WebException
at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.GetSecureMethods()
at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.IsSecureMethod(String methodname)
at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.SetConnectionSSLForMethod(String methodname)
at Microsoft.Reporting.WebForms.Internal.Soap.ReportingServices2005.Execution.RSExecutionConnection.ProxyMethodInvocation.Execute[TReturn](RSExecutionConnection connection, ProxyMethod`1 initialMethod, ProxyMethod`1 retryMethod)
at Microsoft.Reporting.WebForms.SoapReportExecutionService.LoadReport(String report, String historyId)
at Microsoft.Reporting.WebForms.ServerReport.EnsureExecutionSession()
at Microsoft.Reporting.WebForms.ServerReport.GetParameters()
at Microsoft.Reporting.WebForms.ParametersArea.GetMetaDataFromReport()
at Microsoft.Reporting.WebForms.ParametersArea.CreateChildControls()

</Data>
</EventData>
</Event>

Please help us to resolve the issue.

*This post is locked for comments

I have the same question (0)
  • Jie G Profile Picture
    on at

    Hi Vinod,

    1. Can you repro this issue always or just randomly?

    2. Check the configuration file for reporting service:  RSReportServer.config, which should be located at <C:\Program Files\Microsoft SQL Server\MSRS***.MSSQLSERVER\Reporting Services \ReportServer>. Search for SecureConnectionLevel to see its value, change it to 0 if not. And search for Timeout to increase them. Then have a test.

  • Vinod Bhandari Profile Picture
    220 on at

    Hi Ada,

    We can reproduce the issue and its not random.

    I have checked the settings on RSReportServer.config file and i can see the value set to SecureConnectionLevel is 0. But i have gone through some other blog and they have suggested to change the value to 0 or 1.

    Is it the value that we need to change or any other. Please suggest.

  • Jie G Profile Picture
    on at

    Hi Vinod,

    Did you configure SSRS as HTTPS and bind it with a certificate? If so, use 1 or 2, otherwise, use 0, which means we will access SSRS web service via HTTP. Based on my experience,  you may try to turn off firewall between your EP server and SSRS server, disable Anti-Virus software and reboot the servers to see if you can address the issue. To analyze it, you need to check the network data to see why the connection was closed. This should be investigated from SSRS/Network side.

  • Vinod Bhandari Profile Picture
    220 on at

    Hi Ada,

    Thank you for the suggestions, We shall try that and get back to you with the findings.

    Regards,

    Vinod Bhandari

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#1
Priya_K Profile Picture

Priya_K 4

#3
MyDynamicsNAV Profile Picture

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans