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, ..."
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.
Questions:
1) Am I right with my investigation?
2) How can I install Report Extension manually?
