Thursday, 11 February 2021

Get an error “An error occurred during report data sets execution”

 enter image description here

Solution 1:

  1. First of all build + synchronize of all models

  2. Redeployed all reports using Power Shell script

  3. Checked that report's (not of all, but only the one I need) data source tables are all of TempDB type

  4. Checked settings in "Reporting Services Configuration Manager" - Web Service URL and Web Portal URL are correct.


Solution 2 :

The problem was in SSL certificates.

So you can solve the issue following steps below:

1) go to environment which causes the errors in Lifecycle Services

2) there click Maintain => Rotate secrets => choose "Rotate secrets" tile on the right side

3) Click "Yes"

It took about 20-30 minutes to rotate them. After that i didn't get any errors when printing reports.


 

No comments:

Post a Comment