Hi Folks,
I am facing report deployment issues in my Dev env.
1) We have 2 Dev environment
a) Dev
b) Pre Prod Dev
2) I have moved the Prod DB to Pre Prod Dev successfully and application working fine as well but not reports
3) Initially we configured the Pre Prod Dev to Dev report server, it was worked fine but if I do any modification in DP classes(even it not related to Query) it will pass through all code and loads value in Temp Tables but during the rendring/report run it throws the error which in this link [https://community.dynamics.com/ax/f/33/t/148270.aspx]
4) So I decided to install dedicated SSRS instance and DB for Pre Prod Dev and did that as what I did for Dev.
5) I have installed 2nd SSRS Instance in the DB server successfully but unable to deploy , then came to know Ax 2012 R2 and above only supports multiple instances. We are using Ax 2012 RTM CU3.
6) So I have installed the new SSRS Instance[Native Mode] in AOS machine[Dev and Pre Prod Dev have different AOS but in machine] and created new report server db.
7) New SSRS instance installed , configured fine and URL working fine , I can able to see the home page in IE by clicking the URL from Ax client and SSRS configuration manager.
8) Then I have tried to Deploy the reports but it got failed and throwing the below error.
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 <<<< -Id DevPreProd -ReportName CustTransList
+ 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 (go.microsoft.com/.../
inkID=163796).
- The Remote Administration feature is allowed to communicate through Windows F
irewall.
At line:1 char:17
+ Publish-AXReport <<<< -Id DevPreProd -ReportName CustTransList
+ 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
9) I have tried $reports = Get-AXReport -ReportName * and $reports , it was list down all reports fine.
10) I have installed as per Ax Installation guide, SSRS Service is running , I have enabled the remote Administration feature in DB and AOS machine as well. But still I couldn't proceed deployment, please share your valuable ideas on this.
Thanks in Advance
// Vasanth Arivali
