Good evening. I have a ticket number 1563975. Attached video where you can see attached information. The TRS core database does not support SSAS OLAP connection. Only local connections work. Can you add that it is centralized?

We are using database storage for the Report Server and we are monitoring the report server service.

If the database is not accessible, for example due to it being updated, the service may stay running but it will not be able to send scheduled tasks.

In this state of the service (running, but not working), no monitoring or automated restart of the service will be triggered.

Please change the state of the service from running to not running when the service is losing contact with the database

The 'report name/Shelve' path seems to be broken.

For example, when I try to preview the report in Server > Web Preview in the Standalone Designer connected to the Report Server, the browser tries to open the URL 'reportServerHost/Report/View/CategoryName/ReportName/Shelve'. However, it hangs and doesn't display anything.

When I delete a report from the Reports page, it disappears from the list. However, its details are still visible.

When I refresh the page, the deleted report info disappears.

The Report Server's built-in Web Report Designer does not resolve custom functions assemblies that are referenced in the TelerikReporting.config configuration and thus, on Design time, they are not visible under Functions -> Misc. 

The workaround around is to reference the custom functions assembly in the Web.config file in {install_dir}\Telerik.ReportServer.Web

When I try to set a new SMTP I receive the error:

An error occurred while saving the settings: The changes were not applied!

There is nothing logged by the Trace Listener or in the Windows Event Viewer.

Some of my scheduled tasks generate errors in the ServiceAgent log like:

Telerik.ReportServer.ServiceAgent.exe Error: 0 : Sending an email message failed:
System.Net.Mail.SmtpException: Exceeded storage allocation. The server response was: 4.3.1 Message size exceeds fixed maximum message size
   at System.Net.Mail.DataStopCommand.CheckResponse(SmtpStatusCode statusCode, String serverResponse)
...

and

Telerik.ReportServer.ServiceAgent.exe Error: 0 : Sending an email message failed:
System.Net.Mail.SmtpException: Failure sending mail. ---> System.IO.IOException: Unable to write data to the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host
   at System.Net.Sockets.NetworkStream.Write(Byte[] buffer, Int32 offset, Int32 size)
...

In these cases, the report document seems to be generated correctly, however, it is too large to be attached to an email and there aren't any emails sent to the users.

It would be helpful to have at least notifications sent to the admin that the task was executed, but the emails were not sent due to particular reasons.

I am trying to edit an existing user, and before changing anything I receive the error message 'The email is already taken!'. This happens occasionally.

Here is a link to a video that demonstrates the problem.

Edit User Dialog cannot be closed through the Cancel/Save button after resetting the user's password. The issue appears to happen when the password is auto-filled.

Even though the dialog cannot be closed through the Cancel/Save button, it closes successfully through the X button in the top right corner. However, that user will no longer be visible on the page needs to be reloaded.

Currently the Report Server appears to keep the execution history of scheduled report tasks indefinitely.  The task execution history is a very useful feature but there appears to be no way to limit the history to a certain amount of time.  For our use case it is unlikely that we will need to go further back then 1 or two months in the history and as we get months an even years of history (which includes the execution and related documents) the time needed to backup and restore the Report Server increases.  We only have about 30 scheduled reports that run each day but over a year that is 10,000+ executions that are stored and anything over a month or so old has little value to us.  I am not sure if these also have an impact on the overall performance of the Report Server or at least the Scheduler portion of the UI but that would be another reason to limit the retention.

Currently the only method to delete the executions is to either (a) do it manually via the UI (screenshot below) or (b) to write an application that deletes executions outside our retention window using the API to query and then delete them.  Method (a) is too time consuming for a person to do and (b) will require writing the application but then also monitoring it's status and keeping up with any changes in the API over time.

I would propose adding some method of allowing users to set a "retention period" for scheduled task executions.

• The retention period would ideally be able to be set globally and overridden for a particular task
• The retention period would be specified in days
• To actually remove the old executions you could create a task that runs once a day and is executed by the windows service that exists -OR- each time the task executes to run the report it can also look to see which historical executions are older then the retention period and delete them.
• The removal of the historical tasks should also delete any associated documents

Implementing this would allow for much quicker upgrades, backups, and restores of the Report Server.

We are using Azure Redis Cache for the Report Server storage. Azure Redis stops the support for TLS 1.0 and 1.1 as stated in Remove TLS 1.0 and 1.1 from use with Azure Cache for Redis.

If I set Azure Redis to allow TLS 1.0 everything works fine.

If I switch the minimum TLS version in Azure to 1.2 (or 1.1 for that matter) I start to get the error:

No connection is available to service this operation: GET TRS\1\SV
   at StackExchange.Redis.ConnectionMultiplexer.ExecuteSyncImpl[T](Message message, ResultProcessor`1 processor, ServerEndPoint server)
   at StackExchange.Redis.RedisBase.ExecuteSync[T](Message message, ResultProcessor`1 processor, ServerEndPoint server)
   at StackExchange.Redis.RedisDatabase.StringGet(RedisKey key, CommandFlags flags)
   at Telerik.Reporting.Cache.StackExchangeRedis.RedisStorage.GetBytes(String key)
   at Telerik.Reporting.Services.Engine.PersistableObject.GetInt(String key)
   at Telerik.ReportServer.Engine.StorageUpgrader.UpgradeStorageVersion()
   at Telerik.ReportServer.Web.Models.ReportServerWebHost..ctor(IStorage storage)
   at Telerik.ReportServer.Web.WebApiConfig.ConfigureDependencyResolver()
   at Telerik.ReportServer.Web.WebApiConfig.Register(HttpConfiguration config)
   at System.Web.Http.GlobalConfiguration.Configure(Action`1 configurationCallback)
   at Telerik.ReportServer.Web.WebApiApplication.Application_Start()

The articles I can find all state that we should add "sslprotocols=tls12" in addition to "ssl=true" in the connection string to support TLS 1.2.  When I do this I get the error "Keyword 'sslProtocols' is not supported". 

This won't let me use Azure Redis Cache.

I suspect the issue is due to the deprecated package that you use for the Redis database connection.

For that reason, I would like it to be updated to the new one so that I may continue to use Azure Redis.

The CommandTimeout property of the MSSQL Storage is respected when provided in the ReportServerAdmin.config of the Report Server, for example with the following code:

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <configSections>
    <section name="reportServer" type="Telerik.ReportServer.Web.Configuration.ReportServerConfigurationSection, Telerik.ReportServer.Web" requirePermission="false" allowLocation="true" />
  </configSections>
  <reportServer>
    <storage provider="MsSqlServer">
      <parameters>
                <parameter name="ConnectionString" value="Data Source=(local)\MSSQLSERVER01;Initial Catalog=RESTStorage;Integrated Security=SSPI" />
		<parameter name="commandTimeout" value="360" />
      </parameters>
    </storage>
  </reportServer>
</configuration>

The user should be able to provide this value from the Configuration page for the Storage settings, as this is done for the connection string.

Hello, almost every time I select a scheduled task that I have to scroll down to select in the Scheduling tab, the grid view jumps back up to the top of the task list, making it very annoying to look through tasks.

1. Open Scheduling tab.

2. Scroll down in scheduled task grid view below the first N rows displayed.

3. Select row corresponding to a scheduled task.

4. Task grid view returns to the top N rows of the scheduled tasks.

Thank you

In the Schedule I want to set the specific name of the attachment instead of the Report's intern name.

I have a report named Report xyz per period with parameters for day-, week and month report.

When I make a schedule I cannot set the name of the attachment when I sent it by mail, it's alway Report xyz per period.

If you unselect all the days from the Day of the Week in the recurrence rule of a scheduled task of data alert, the task can be saved but will throw an Internal Server Error and you won't be able to list the available tasks on the server.

The linked muted video demonstrates the problem.

Here is the error stack trace produced by the ServiceAgent:

Telerik.ReportServer.ServiceAgent.exe Information: 0 : Loaded 37 tasks in total.
Telerik.ReportServer.ServiceAgent.exe Error: 0 : System.IndexOutOfRangeException: Index was outside the bounds of the array.
   at Telerik.WinControls.UI.Scheduler.ICalendar.CalHelper.TryParseRecurrenceRuleProperties(RecurrenceRule result, IEnumerable`1 keywordPairs)
   at Telerik.WinControls.UI.Scheduler.ICalendar.CalHelper.TryParseRRuleCore(String valueToParse, RecurrenceRule& result)
   at Telerik.ReportServer.Web.Utils.Appointment..ctor(DateTime startUtc, String recurrenceRule)
   at Telerik.ReportServer.ServiceAgent.Tasks.TaskInfo.UpdateNextOccurrenceTime(DateTime utcFrom, DateTime utcTo)
   at Telerik.ReportServer.ServiceAgent.Services.SchedulingService.CalculatePendingTasks(List`1 pendingTasks)
   at Telerik.ReportServer.ServiceAgent.Services.SchedulingService.MainLoop()
   at Telerik.ReportServer.ServiceAgent.Services.SchedulingService.StartMain()

Currently, the Report Server is installed with binding only to HTTP-type sites. This may break a Report Server site bound to an HTTPS site after upgrading to a new version. It is necessary to add the binding to HTTPS manually after each upgrade.

It would be great if there is an option for binding to HTTPS with the installation and if all the bindings can be preserved after upgrading.