Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

an error occured within the report server database

Hello,
I moved the database off powerBI server (on premise) to another server with sql 2019, and now the schedule doesn't work anymore. I have an error message : "an error occured within the report server database. this may be due to a connection failure...

 

before the change of location of the database, the planning was working well.

what should be checked?

I have to reinstall the power BI server for everything to work properly?

rights issue?

i don't how to reslove my problem

version of power bi report server : Version1.12.7981.11681(September 2021)

 

 

 

6 REPLIES 6
v-luwang-msft
Community Support
Community Support

Hi @Anonymous ,

What you can do if you get the above message is:

1. Ensure that SQL Server Reporting Services (SSRS) are up and running.

2. Ensure that the user with which you are accessing the relevant reports has Folder/Report permissions to do so.

3. Ensure that the SSRS instance’s service account (can be found in SQL Server Configuration Manager or SQL Server Reporting Services Configuration Manager) has db_owner access to the respective ReportServer and ReportServerTempDB databases.

And you can further troubleshoot using the below steps:

In SQL Server Configuration Manager, navigate to “SQL Server Services”, then right-click on the SQL Server Reporting Service and on the “Advanced” tab, find the Dump Directory path.

Via Windows Explorer, navigate to the the Dump Directory folder (that is actually the location of the SSRS instance’s log files), try to reproduce the problem and then directly open the latest log file. Check the entries in the log file, where in addition to the above message, you will also find more details. For example you might see the additional error message: “The transaction log for database ‘ReportServer’ is full“….

If you indeed find the error about the transaction log, then it is crystal clear that you need to check the database server onto which the ReportServer database is hosted, for disk space issues. In this case, you need to check the drive that hosts the transaction log file for the “ReportServer” database. If you cannot shrink other log files and thus return space back to OS for further use by the transaction log of database “ReportServer”, then you will need to add more space to the disk.

 

Also you could tryto grant sysadmin Privilege to Report server service account.

Similar question refer:

https://social.technet.microsoft.com/Forums/ie/en-US/8decb9e2-ce0f-4f5a-a6ab-4ed2a7fe21e0/an-error-occurred-within-the-report-server-database-this-may-be-due-to-a-connection-failure?forum=sqlreportingservices 

https://www.sqlnethub.com/blog/an-error-occurred-within-the-report-server-database-this-may-be-due-to-a-connection-failure-timeout-or-low-disk-condition-within-the-database/  

 

 

Did I answered your question?Pls mark my reply as a answer.

 

 

 

Best Regards

Lucien

Anonymous
Not applicable

Hi,

it was not possible to correct the schedule update problem.

Another power BI server install was done and now everything is working

 

Thank you for these advices which made it possible to find a solution

Anonymous
Not applicable

HI,

Thank you for these explanations.

We do all these actions and I come back to the forum for feedback

Anonymous
Not applicable

Hi,

Thank you for these explanations, this will allow us to move forward in the solution

we are going to migrate the SQL Server Agent jobs with the database administrators.

I'll run the T-SQL next

I will post after these actions

whereismydata
Resolver IV
Resolver IV

Hi, did you also migrate the SQL Server Agent Jobs? PowerBI RS creates an SQL Server Agent Jobs for each schedule.

The name of the job is a GUID created by PBIRS.

You can query the ID's with this statement:

SELECT [ScheduleID] --> Name of job
      ,[ReportID]
	  ,c.Name
      ,[SubscriptionID] --> This id needs to be passed in the procedure
      ,[ReportAction]
  FROM [pbiReportServer].[dbo].[ReportSchedule] r
  LEFT JOIN [pbiReportServer].[dbo].[Catalog] c ON r.ReportID = c.ItemID
  ORDER BY Name asc

Within the job there is only one step of type T-SQL with this command

exec [pbiReportServer].dbo.AddEvent @EventType='DataModelRefresh', @EventData='INSERT Subscription ID'

Hope this helps

Anonymous
Not applicable

HI,

We migrate the SQL Server Agent Jobs, and

and we execute the TSQL command like your example, 

but we have the same error : we can't  modify the plannification

How do I determine what is not working ?

is it necessary to re install server power bi ?

 

 

Claude_newPBI_0-1661347734071.png

 

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.