Page 1 of 1

Report Viewer sometimes requires MSDTC

Posted: Mon Feb 01, 2021 4:28 pm
by 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:
Image
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

Re: Report Viewer sometimes requires MSDTC

Posted: Mon Feb 01, 2021 9:14 pm
by 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.

Re: Report Viewer sometimes requires MSDTC

Posted: Fri Feb 05, 2021 9:59 am
by 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.

Re: Report Viewer sometimes requires MSDTC

Posted: Fri Feb 05, 2021 2:46 pm
by Lech Kulikowski
Hello,

Thank you for the information.