Dynamic Reportbook - load balancing

1 Answer 83 Views
General Discussions Report Book
Pete
Top achievements
Rank 1
Pete asked on 10 Nov 2021, 08:46 PM

Hello,

We have a dynamic report book we create for one of our reports. It has been working for several years. 

We just implemented load balancing and had to change our "ReportServiceConfiguration" to use MsSqlServerStorage instead of FileStorage. That works for all of the other reports except for this report book.

When you run the reportbook it behave strangely, sometimes it will display a few pages, other times it will get an error "index out of range exception". It is as if something is cached and it gets confused when switching servers. 

We are using ASP.NET MVC.

Any suggestions?

1 Answer, 1 is accepted

Sort by
0
Todor
Telerik team
answered on 15 Nov 2021, 10:55 AM

Hi Pete,

Generally, the report book is a collection of reports that get rendered together. That said, the entire report book would be rendered on the same server. The generated document is kept as a single entity on the storage. Hence, if you reuse the report book, all the reports in it would be taken from the same place.

Do you use the same MsSqlServer instance for all the servers in the web farm? Note that this is required so that all the servers can access all clients' stored states.

It is strange that the problem reproduces only with a report book. Can you elaborate on the scenario? Do you create the dynamic report book in a Custom ReportSource Resolver? If so, can you send the code of the resolver?

Consider also attaching Trace Listeners to the REST Service instances. They should log relevant information on the problem when it happens.

You may try to use Fiddler Jam to obtain more information on the communication between the viewers and the servers of the web farm.

I suggest opening a support ticket and attaching the above logs so that we can investigate them locally.

Regards,
Todor
Progress Telerik

Brand new Telerik Reporting course in Virtual Classroom - the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products. Check it out at https://learn.telerik.com/.
Tags
General Discussions Report Book
Asked by
Pete
Top achievements
Rank 1
Answers by
Todor
Telerik team
Share this question
or