Forum Discussion

daniel_doboseru's avatar
daniel_doboseru
Regular Visitor
1 year ago
Solved

ReportServer database procedures are continuously getting recreated in scale-out deployment

Hi,   In a scale-out setup with two nodes, we started by having a standalone instance with May 2024 version, joined another one with Jan 2025 version, and started to have some transient issues (see...
@PowerBI Report Server
scale-out
  • daniel_doboseru's avatar
    daniel_doboseru
    1 year ago

    A feedback to the above problem: even though both instances were on the same version (Jan 2025) one of them was running in trial mode because of an issue with the key and the db objects had a different footprint thus causing the server to try to repair/re-sync them each time a request came from the other instance. After fixing the key issue and upgrading from trial to normal instance the problem disappeared instantly.

daniel_doboseru's avatar
daniel_doboseru
Regular Visitor
1 year ago

A feedback to the above problem: even though both instances were on the same version (Jan 2025) one of them was running in trial mode because of an issue with the key and the db objects had a different footprint thus causing the server to try to repair/re-sync them each time a request came from the other instance. After fixing the key issue and upgrading from trial to normal instance the problem disappeared instantly.