Tuesday, March 25, 2014

Setting Server Report parameters in Ax 2012 (rsItemNotFound)

                                Error while Setting server report parameters (rsItemNotFound)

Hello People..!!

Hope everyone is doing good and I would like to share an issue on generating invoice reports in Ax 2012 R2 CU7.

Scenario: when I am trying to open a report in AX 2012  R2 CU7 it is displaying an Infolog with an error.

"Error while Setting server Report parameters and the report cannot be found(rsItemNotfound)"




Solution: Make sure that the reports are deployed and all are in the correct layer.

In order to deploy a report, procedure is

Open a new development Workspace(CTRL + D)

In AOT-->SSRS Reports --> <type reportname> and right click on the selected report and deploy it.



Even, the deployment of all the reports can be done by using a single command in Microsoft DynamicsAx 2012 Management Shell 

Right click on the Management Shell and run as Administrator ,

Copy this command ----   "Publish-AXReport –ReportName *" and press enter.



you will see a window and shows the deploying of reports progress.

After deploying the reports a message is displayed that Deployment is Complete



Now restart the AOS and when you open a report it must resolve your issue.

Hope this post will be useful for everyone who gets this kind of error.

Thanks for reading ...Have a Great Day..!!!

Happy Daxing...:D

3 comments:

  1. it really helped me solve the error.. thank you very much..

    ReplyDelete
  2. Hi,
    I am facing error like this
    "
    Publish-AXReport : The following components have not been installed or are not
    configured correctly:
    Reporting extensions
    Consult your administrator or the documentation.
    At line:1 char:17
    + Publish-AXReport <<<< -ReportName *
    + CategoryInfo : NotInstalled: (:) [Publish-AXReport], InvalidOpe
    rationException
    + FullyQualifiedErrorId : The following components have not been installed
    or are not configured correctly:
    Reporting extensions
    Consult your administrator or the documentation.,Microsoft.Dynamics.AX.Fra
    mework.Management.Reports.PublishReportCommand

    Publish-AXReport : The deployment was cancelled because of an error. On the rep
    ort server, verify that:
    - The SQL Server Reporting Services service is running.
    - SQL Server Reporting Services is configured according to the instructions in
    the Microsoft Dynamics AX Installation Guide (http://go.microsoft.com/fwlink/?L
    inkID=163796).
    - The Remote Administration feature is allowed to communicate through Windows F
    irewall.
    At line:1 char:17
    + Publish-AXReport <<<< -ReportName *
    + CategoryInfo : ResourceUnavailable: (Microsoft.Dynam...ReportsD
    eployer:ReportsDeployer) [Publish-AXReport], ServerException
    + FullyQualifiedErrorId : The deployment was cancelled because of an error
    . On the report server, verify that:
    - The SQL Server Reporting Services service is running.
    - SQL Server Reporting Services is configured according to the instruction
    s in the Microsoft Dynamics AX Installation Guide (http://go.microsoft.com
    /fwlink/?LinkID=163796).
    - The Remote Administration feature is allowed to communicate through Wind
    ows Firewall.,Microsoft.Dynamics.AX.Framework.Management.Reports.PublishRe
    portCommand"
    I went to CEU-> System Administrator-> Business intellegence-> Reporting services-> Report Server and clicked validate, this works fine for me. When I run this command I face the error.
    Can you help me?

    ReplyDelete
    Replies
    1. Hi Satish,

      Did you install the reporting services extension from AX 2012 setup?

      Install it, restart the server and start deploying the reports.

      It must work if all the settings in reporting services configuration manager are setup correctly.


      Delete