Could not find stored procedure 'sp_tr_GetInstancesByKey'

[Luis]

Hello folks,

I am working on an project that use a .NET 8 Web API as the backend and an Angular frontend to render telerik reports. Everything was working fine until we decided to upgrade Telerik.Reporting.Services.AspNetCore to version 18.3.24.1112

We also updated the following package in our frontend app. 

"@progress/telerik-angular-report-viewer": "^24.24.1112"

 

and updated the version from telerikReportViewerTemplate to match the version from our Reporting.Services package from the backend.

 <tr-viewer

    [containerStyle]="viewerContainerStyle"

    [serviceUrl]="noAuth ? openServiceUrl : telerikReportOptionParameters.serviceUrl"

    [authenticationToken]="noAuth ? null : telerikReportOptionParameters.authToken"

    [viewMode]="telerikReportOptionParameters.viewMode"

    [scaleMode]="telerikReportOptionParameters.scale"

    [scale]="1.0"

    [pageMode]="'SINGLE_PAGE'"

    [templateUrl]="

      (noAuth ? openServiceUrl : telerikReportOptionParameters.serviceUrl) +

      '/resources/templates/telerikReportViewerTemplate-18.3.24.1112.html'

    "

    [reportSource]="{ report: reportParams.trdxName, parameters: reportParams }"

    [exportBegin]="exportBegin.bind(thisComponent)"

    [exportEnd]="exportEnd.bind(thisComponent)"

    [printBegin]="printBegin.bind(thisComponent)"

    [printEnd]="printEnd.bind(thisComponent)"

    [renderingBegin]="renderingBegin.bind(thisComponent)"

    [renderingEnd]="renderingEnd.bind(thisComponent)"

    [pageReady]="pageReady.bind(thisComponent)"

  ></tr-viewer>

 

Now whenever we try to show any of our reports, we get the error: Could not find stored procedure 'sp_tr_GetInstancesByKey'

Our connection string hasn't changed and when I look at our database I can see these related stored procedures, but not the one mentioned in the error message.



Does anybody know what the problem might be?

[Mila]

Try running  Telerik Database Cache Configurator  (DatabaseCacheConfigurator.exe): 

Configuring an MSSQL Database Storage - Telerik Reporting

[Mila]

Try running  Telerik Database Cache Configurator  (DatabaseCacheConfigurator.exe): 

Configuring an MSSQL Database Storage - Telerik Reporting

[Luis]

Thank you!

Yes that made it, I also had to install Telerik Reporting 2024 Q4, because I had an older version that did not create that stored procedure when running the DatabaseCacheConfigurator.