Report Viewer sometimes requires MSDTC

[kgb2013]

Hello.

We are using the version 2020.5.2.0 of the web report viewer and we see something weird going on.

We use the viewer in two different MVC controllers.
On one of them everything works OK, but on the other one we get messages that the MSDTC (Microsoft Distributed Transaction Coordinator) is not running.
Do you know based on what criteria it decides that it needs the MSDTC service running?
Because the MSDTC service is causing us troubles and we would like to avoid using it, if possible.
And the code for the GetReport/ViewerEvent actions between the two controllers seems pretty identical, so I am not sure what is going on.

Also, we experience another problem. On some reports with user parameters as input, we get the first page rendered, but when trying to move to the next pages we get blank pages.
If we switch the viewer to show multiple pages at once, thus disabling pagination, all the pages are rendered.
When it fails to render a page, the response from the server looks normal, but doesn't have any content:

Any idea what might be going on there?
I was trying to modify the caching settings, but I couldn't fix the problem yet.

Thank you,
Kostas

[Lech Kulikowski]

Hello,

> On one of them everything works OK, but on the other one we get messages that the MSDTC (Microsoft Distributed Transaction Coordinator) is not running.

Please check:
https://stackoverflow.com/questions/103 ... on-from-th
https://entityframework.net/knowledge-b ... the-source

> I was trying to modify the caching settings, but I couldn't fix the problem yet.

Please send us a sample project that reproduces the issue for analysis.

Thank you.

[kgb2013]

We have opened the DTC port on the SQL Server machine and the first problem was fixed.

Also, using only :

Code: Select all

StiMvcViewer.ViewerEventResult();

...in the `ViewerEvent()` action, for letting it use the cached report fixed the second problem.

[Lech Kulikowski]

Hello,

Thank you for the information.