Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Finance forum / SSRS deployment error
Finance forum

SSRS deployment error

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Prehistory:

I updated SQL server from 2016 to 2019 (preview) to be able to restore a .bacpac of Tier 2 to my Dev.

I made next steps:
1) Update from SQL 2016 to SQL 2017. This update forced me to uninstall SQL Reporting Services 2016 and install SQL Reporting Services 2017

2) Update SQL 2017 to latest version: installed latest KB

3) Update SQL 2017 to SQL 2019 preview.

Current situation:

Dynamics 365 F&O works fine after this update. However, SSRS reports do not work. I did not make a backup of original encryption key. This is a source of a problem. A solution is to delete all reports and redeploy.

Now I cannot deploy any report. The error is " Error while loading code module: ‘Microsoft.Dynamics.ApplicationSuite.Reporting.BusinessLogic, Version=7.0.0.0, ..."

4_2D00_24_2D00_2019-10_2D00_06_2D00_10-AM.png

Investigation result:

I think, the problem is about missing Report Extension.

I found an interesting scrip in …\PackageLocalDirectory\Plugins\AxReportVmRoleStartupTask. The name of scrip is SQL2014To2016Upgrade Inside this script we can find a function, which installs extensions. I wrote own script to call only this function, but execution fails.

4_2D00_24_2D00_2019-10_2D00_13_2D00_08-AM.png


Questions:

1) Am I right with my investigation?
2) How can I install Report Extension manually?

Categories:
Management Reporter
Development / Customization / SDK
  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SSRS deployment error

    Thanks.

    Unfortunatelly, we worked in parallel to solve issue described in link. We both realized, that this issue is about stored procedure.

    The key of issue, that used in procedure "TRIM" command was introduced in SQL Server 2017.

    I decided to upgrade SQL to 2017. Now I know, that it was not a good idea.

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 46,610 User Group Leader on at
    RE: Dynamics 365 F&O. SSRS deployement error

    who knows what has been written behind DLLs that might be looking for a specific version of SQL server.

    I believe what others said. This is not IPhone, that you may want to update all the times, as you may want. Keep with the documentation please.

  • Verified answer
    nmaenpaa Profile Picture
    nmaenpaa 101,156 on at
    RE: Dynamics 365 F&O. SSRS deployement error

    You should not update the SQL Server on your environment.

    Instead please follow this workaround process for the .bacpac import issue: rahulmsdax.blogspot.com/.../error-message-error-importing.html

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Dynamics 365 F&O. SSRS deployement error

    Hello Andre,

    I updated only a SQL Server of cloud-hosted development environment (Tire 1).

    As I said, Dyanmics 364 F&O works fine except SSRS.

    Also,I tried a script called DeploySsrsExtension.ps1. Same result: "System.InvalidOperationException: Unable to back up the SQL Server Reporting Services encryption key. The operation failed with error code RPCServerNotListening."

    Thanks in advacne!

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,661 Super User 2024 Season 2 on at
    RE: Dynamics 365 F&O. SSRS deployement error

    Hi Vz42,

    Can you tell what type of environment you updated and for what reason? Note that for on-premise, currently only 64-bit versions of SQL Server 2016 are supported.

    See also the documentation: https://docs.microsoft.com/en-us/dynamics365/unified-operations/fin-and-ops/get-started/system-requirements-on-prem#software-requirements-for-database-servers

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,661 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,379 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans