Using custom database schema for MSSQL cache in Telerik Reporting

1 Answer 172 Views
General Discussions
plig
Top achievements
Rank 1
plig asked on 17 Dec 2021, 10:58 AM

Hello,

in order to use the Telerik Reporting MSSQL cache I need to execute the sql described in https://docs.telerik.com/reporting/t-telerik-reporting-cache-mssqlserverstorage.

However, the database tables and stored procedures need to reside in the dbo database schema.

In my particular case I do not have access to the dbo schema, but only to custom schema.

Is it possible to specify somehow that the database objects needed for the caching reside in different schema instead of dbo?

Dimitar
Telerik team
commented on 22 Dec 2021, 10:07 AM

Have you tested modifying the script to use a different schema?

The script is meant to be a short example of how one may set up the necessary tables and stored procedures, in theory, there shouldn't be issues with using another schema as long as the tables and procedures are defined correctly.

plig
Top achievements
Rank 1
commented on 22 Dec 2021, 11:08 AM

Yes I have tested to modify the script and no - It does not work when I modify the script and create all the database objects in another schema instead of dbo.

This is the error:

Error registering the viewer with the service.
An error has occurred.
Could not find stored procedure 'sp_tr_GetString'.

The above mentioned stored procedure is located in student schema. If I create all the database objects in dbo schema - everything works.

Dimitar
Telerik team
commented on 27 Dec 2021, 10:28 AM

We have not encountered this issue before, for that reason, I have created a separate support ticket where we can discuss the problem, ticket id - 1547628.

1 Answer, 1 is accepted

Sort by
0
Dimitar
Telerik team
answered on 05 Jan 2022, 02:19 PM

Hello,

We discussed the problem in a support ticket and it turned out to be an issue with our code. Basically, the MsSqlServerStorage is currently written to only work with the dbo schema, we logged the issue on behalf of Plamen on our portal - MsSqlServerStorage works only with the dbo schema.

With that being said, there is a workaround to this issue which is basically implementing a custom IStorage2 class that will work exactly like the MsSqlServerStorage but can be configured to also work with other schemas, I have attached an example.

Although it's working, please note that this is a sample code that should be used as a reference and adjusted to the current scenario.

Regards,
Dimitar
Progress Telerik

Brand new Telerik Reporting course in Virtual Classroom - the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products. Check it out at https://learn.telerik.com/.
Tags
General Discussions
Asked by
plig
Top achievements
Rank 1
Answers by
Dimitar
Telerik team
Share this question
or