Facing Issue with Report Viewer Control on Stateless Environment

Question

User70109750 posted

Hi All,

I am facing one issue in my production environment.

We have our asp.net MVC application that is hosted on Azure VMs with a load balanced environment. We have removed the sticky session and implement the stateless mechanism for the complete application. Now we are facing one issue with our reporting page,

We have used ReportViewer Control in one of page and we have 2 report servers for generating the reports which is also running in load balanced environment.

It is working fine when the sticky session on, once the sticky session us turned off for our application we have the following issue

if CustomerA wants view ReportA and at the same time if CustomerB wants to view ReportB, then ReportB is displaying for CustomerA by Report Viewer Control.

I am not able to recognize the issue.

So, Can anyone help me regarding "How the ReportViewer Control behaves when the sticky session is turned off".

I have found one link

https://social.msdn.microsoft.com/Forums/expression/en-US/eb0c4582-bede-45c6-b9ca-603877b3604e/possible-to-use-microsoft-report-viewer-in-azure?forum=windowsazuredevelopment

Is it true that ReportViewer Control needs sticky session?

Please help me to resolve this issue.

 

Answer 1

User283571144 posted

Hi SowjanayaKayasri,

As far as I know, the ASP.Net ReportViewer relies on ASP.Net session state to store critical data that can’t always be easily regenerated. 

So it need the stick session.

The stick session could assign a singleserver to a particular user, based on their HTTP session or IP address. 

It will make the user countiue accessing the server he has alreary accessed.

Best Regards,

Brando