topic Re: Error Could not find stored procedure with scheduled refresh jobs in Report Server

Error Could not find stored procedure with scheduled refresh jobs

Anonymous — Tue, 02 Feb 2021 08:00:27 GMT

Hello,

I've a lot of power bi reports published to a report server, connected to a MySQL DB that refreshes on daily basis, however I get an error

[0] 0: Could not find stored procedure 'WriteCatalogExtendedContentChunkById'

I've searched online that if I refresh the local cash of PBIS's DB it will work fine, and yes it works fine after I refresh the local cash of the db but after 2 days this error occurs again.

power bi server version: 1.9.7627.11028 (October 2020)

power bi desktop version: 2.86.961.0 64-bit (October 2020)

any Idea how to solve this error permanently

Re: Error Could not find stored procedure with scheduled refresh jobs

Petebro — Tue, 02 Feb 2021 16:10:42 GMT

There were a number of scheduled refresh issues addressed in the Jan 2021 release from last week. Would it be possible to test some of your MySQL DB reports + refresh on that version? If it reproduces there as well then we would be able to take action on this.

Re: Error Could not find stored procedure with scheduled refresh jobs

Anonymous — Wed, 03 Feb 2021 08:28:28 GMT

Thanks for your response,

Reports itself is connected to MySQL DB and refresh from power bi desktop with no issues, the error itself keeps occurring when the scheduled jobs runs on the power bi server.

power bi server is installed along with SQL Server and the report files are reading data from MySQL db

waiting your response, thanks in advance.

Re: Error Could not find stored procedure with scheduled refresh jobs

Anonymous — Fri, 05 Feb 2021 09:04:03 GMT

any updates?

Re: Error Could not find stored procedure with scheduled refresh jobs

gsprague — Fri, 05 Feb 2021 13:55:39 GMT

Hi Anonymous , we recently released Power BI Report Server January 2021, which includes several scheduled refresh fixes. Would you be able to upgrade to the Jan 2021 release and see if this resolves the errors you're seeing?

Re: Error Could not find stored procedure with scheduled refresh jobs

Anonymous — Fri, 05 Feb 2021 14:21:15 GMT

Hello gsprague , thanks for your reply, please can you provide a link as didn't find Jan 21 version I still see Version 1.9.7675.15620 (October 2020) version

Re: Error Could not find stored procedure with scheduled refresh jobs

josef78 — Fri, 05 Feb 2021 22:30:34 GMT

Download Microsoft Power BI Report Server - January 2021 from Official Microsoft Download Center

Re: Error Could not find stored procedure with scheduled refresh jobs

Anonymous — Tue, 09 Feb 2021 09:05:17 GMT

Thanks, I'll update the server and check if the issue is resolved or no

Re: Error Could not find stored procedure with scheduled refresh jobs

Icey — Wed, 24 Feb 2021 01:37:03 GMT

Hi Anonymous ,

Can the latest version above solve the issue?

Best Regards,

Icey

Re: Error Could not find stored procedure with scheduled refresh jobs

Anonymous — Wed, 24 Feb 2021 07:32:23 GMT

actually no, as after I upgraded to the Jan 21 version, the server was down and faced many issues with Jan 21 version, for example: URL filtering was not working, so I rolled back to October 2020 version