web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

deploy ssrs report error

(0) ShareShare
ReportReport
Posted on by 942

Hello,

Every time I try to deploy any SSRS report to the SSRS server I'm getting this error

pastedimage1666870493839v2.png

Googling on the matter hasn't helped me a lot. Any suggestions will be much appreciated.

Thank you.

I have the same question (0)
  • Komi Siabi Profile Picture
    13,113 Most Valuable Professional on at

    Can you please tell us how and from where you deployed the report?

  • dark_knight Profile Picture
    942 on at

    I tried to deploy via powershell like that. it's standard report. all reports fail with the same error

    PS C:\windows\system32> C:\AosService\PackagesLocalDirectory\Plugins\AxReportVmRoleStartupTask\DeployAllReportsToSSRS.ps
    1 -Module ApplicationSuite -ReportName BankPaymAdviceVendV2.Report -PackageInstallLocation “C:\AosService\PackagesLocalD

    IN powershell I get this error

    Publish-AXReport : An error occurred while deploying the report BankPaymAdviceVendV2.Report, ApplicationSuite.
    This might be because the SQL Server Reporting Services has not been installed, or is not configured correctly.
    At C:\AosService\PackagesLocalDirectory\Plugins\AxReportVmRoleStartupTask\Reporting.psm1:504 char:9
              Publish-AXReport -MaxDegreeOfParallelism 1 -ErrorAction Conti ...
              ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
          CategoryInfo          : NotSpecified: (Microsoft.Dynam...shReportCommand:PublishReportCommand) [Publish-AXReport
       ], InvalidOperationException
          FullyQualifiedErrorId : Error,Microsoft.Dynamics.AX.Framework.Management.Reports.PublishReportCommand
    
    Publish-AXReport : System.Web.Services.Protocols.SoapException: Error while loading code module:
    'Microsoft.Dynamics.ApplicationSuite.Reporting.BusinessLogic, Version=7.0.0.0, Culture=neutral,
    PublicKeyToken=31bf3856ad364e35'. Details: Could not load file or assembly
    'Microsoft.Dynamics.ApplicationSuite.Reporting.BusinessLogic, Version=7.0.0.0, Culture=neutral,
    PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.
       at Microsoft.ReportingServices.Library.ReportingService2005Impl.CreateReport(String Report, String Parent, Boolean
    Overwrite, Byte[] Definition, Property[] Properties, Guid batchId, Warning[]& Warnings)
       at Microsoft.ReportingServices.WebServer.ReportingService2005.CreateReport(String Report, String Parent, Boolean
    Overwrite, Byte[] Definition, Property[] Properties, Warning[]& Warnings)
    At C:\AosService\PackagesLocalDirectory\Plugins\AxReportVmRoleStartupTask\Reporting.psm1:504 char:9
              Publish-AXReport -MaxDegreeOfParallelism 1 -ErrorAction Conti ...
              ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
          CategoryInfo          : NotSpecified: (Microsoft.Dynam...shReportCommand:PublishReportCommand) [Publish-AXReport
       ], SoapException
          FullyQualifiedErrorId : Error,Microsoft.Dynamics.AX.Framework.Management.Reports.PublishReportCommand
    
    
    ReportName                                    Status
    ----------                                    ------
    BankPaymAdviceVendV2.Report, ApplicationSuite Error
    Deployment completed.
    2.5001176 Seconds.
    C:\AosService\PackagesLocalDirectory\Plugins\AxReportVmRoleStartupTask\DeployAllReportsToSSRS.ps1 :
    System.Management.Automation.RuntimeException: Errors occured during report deployment.
    At line:1 char:1
      C:\AosService\PackagesLocalDirectory\Plugins\AxReportVmRoleStartupTas ...
      ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
          CategoryInfo          : NotSpecified: (:) [Write-Error], WriteErrorException
          FullyQualifiedErrorId : Microsoft.PowerShell.Commands.WriteErrorException,DeployAllReportsToSSRS.ps1

    also I tried by opening Report Server Configuration Manager and clicking on Web Portal URL and clicking upload button there(the very first screenshot)

    pastedimage1666879629976v1.png

    In powershell and in web portal the error is the same as I posted in the first post

  • Komi Siabi Profile Picture
    13,113 Most Valuable Professional on at

    Hello,

    Kindly give us some background info.

    I can see that, there is no single report in the Dynamics folder on the screenshot in your original post.

    Did you delete them before ?

    Is this a newly deployed environment?

    Did you take import a database in here?

  • DN-27070130-0 Profile Picture
    61 on at
    Hi,
     
    I had a same problem with this Issue.
     
    This issue came after I upgrade SQL Server 2016 to SQL server 2022.
    When Upgrade, the SQL Reporting must be uninstalled, so I Uninstall and Install the new one. SQL Reporting Service 2022.

    But when I Deploy the report, the error is come.
     
    And when I want upload from web still same error.

    Did you already solved the error?

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Abhilash Warrier Profile Picture

Abhilash Warrier 669 Super User 2025 Season 2

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 471 Super User 2025 Season 2

#3
Martin Dráb Profile Picture

Martin Dráb 423 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans