scale-out. upgrade
2 Topics
"Invalid object name 'ExtendedCatalog'" after connecting a Jan 2025 PBIRS instance in scale-out
Hi. After trying to scale-out our PBIRS instance, we started to see the dreaded "An error occured within the report server database. This may be due to a connection failure, timeout or low disk condition within the database." Our setup: 1. one PBIRS instance, May 2024, with ReportServer database hosted on the same server (MS-SQL 2022 Standard) 2. installed an additional PBIRS instance on a new server, Jan 2025, without configuration 3. configured the new instance to use the ReportServer database of the first instance, and enabled scale-out 4. both instances work (paginated reports, subscriptions), except the fact that now both of them are randomly throwing errors of the mentioned type (when listing the directories, managing reports, even running etc) Sometimes it's the one about ExtendedCatalog, sometimes it's just a generic error message with no details, and even an error regarding a stored procedure, GetUserNameBySid if I'm not mistaken - usually the exact same action works fine after refreshing the page. My question is: it's possible that after connecting the Jan 2025 instance on the existing RS database, some objects might have been modified and because two instances with different versions (May 2024 + Jan 2025) are using it, it's in an inconsistent state for both and thus the random errors? Or there shouldn't be compatibility issues between these two versions regarding the RS database? Petebro would really appreciate an input from your end. Thank you!Solved984Views0likes2Comments
PowerBI Report server scaled-out deployment - upgrade steps
Hi All - looking for upgrade guilde for PowerBI scaled-out deployment. Specifically - sequence of steps for multiple servers removal from scaled-out deployment, upgrading and joining back. Any help is appreciated. Thx!653Views0likes0Comments