Reproting Extension installation process tips and triks

Hi,

While installation of Reporting Extension of AX 2009 we are facing lots of Errors and Warning, so this post is for some tips and tricks regarding  installation of Reporting Extension as much as possible without of Errors and Warning.

1. Install all the prerequisite for reporting extensions.
2. Configure the Reporting services with the use of Reporting services configuration manager from configuration tool of SQL server 2008
3. Check the URL both reporting service url and reporting manager url from configuration services for accessing and proper running.
4. In the Dynamics AX 2009 >> Administration >> setup>> Reporting services .. Update the information regarding reporting services and create folder named DynamicsAX and click on the create button to create Datasource on the reporting manager URL.
5. Install reporting Extensions from AX 2009 setup
6. reset the IIS
7. Deploying  reports : Please do this activity with the login of BCPROXY user only.
Run report deployment tool from Dynamics AX 2009
8. Do not deploy all the reports at a time.
9 Deploy the reports one by one or select the some bunch of reports ( like all reports which start from letter B,C,D...or else )
10. Please do not deploy or select any reports which start with letter "S".
11. In Between this you might get warning with HTML code and reports failed to deploy at this time the general solution is to restart the Reporting services from Services.msc
12. And at the end you can deploy the all remaining reports.


----
Kishor

Report Deployment Errors in AX 2009

While deployment of reports (Reporting Extensions) in Ax 2009 the following error has been generated. 

Error:
Unable to connect to http://server:port/ReportServer/ReportService2005.asmx as specified in the config file for the report server at DriveName:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\RSReportServer.config. 

If this url is not correct please update the config file, otherwise make sure the report server is configured correctly.

Solution:

Go to Encryption Keys >> Delete Encrypted Content >> Delete 

------

Error while installing Microsoft Dynamics AX Reporting Extensions and Role Centers and Enterprise Portal

Issues:

Reporting extensions cannot be installed and display the below error message, Event Log & Setup Log:

Error Message :

Role centers and Enterprise Portal cannot be installed. Setup cannot connect to the Application Object Server Instance (AOS) by using Business Connector.

Generated Event log:

Log Name: Application
Source: Microsoft.Dynamics.Framework.BusinessConnector
Event ID: 1000
Description: Session log on for Microsoft Dynamics failed Microsoft.Dynamics.Framework.BusinessConnector.Session.Exceptions.FatalSessionException

Dynamics Adapter Logon failed.

Setup Log:

Property RemoveComponents set to: ’0′
Property BypassWarnings set to: ’0′
Entering method GetBusinessConnectorProxyAccount
An error has occured while Setup was establishing a connection through Business Connector. Error: No .NET Business Connector session could be found.
Leaving method GetBusinessConnectorProxyAccount
An error has occured while Setup was establishing a connection through Business Connector. Error: No .NET Business Connector session could be found.
Microsoft.Dynamics.Framework.Deployment.Web.EPWebException

Solution:

1. Change the client configuration file to run on Business connector.

2. Check if the client configuration file is pointing to required Server Name & TCP/IP Port, if not modify and apply the settings.

3. Start the Microsoft Dynamics AX Setup wizard and install the selected components “Reporting extensions” and Click Next.

4. After the installation is complete, you must deploy the default reports that are included with Microsoft Dynamics AX.

-------

What i did ...

1. I have created the business connector configuration for AOS ( which m using for installation EP and Reporting Extension.

2. In the client configuration assign the AOS name to the local client.

-----------------------------------------------------------

Source : http://dynamicsaxsolutions.wordpress.com/

Reporting Extension Server URL Validation problem

1. 1.    Check the Reporting Services (Started or not) from the services.
2. 2.       Check the reporting services configuration manager from SQL server 2008 configuration tool and add service account as business connector account.
3. 3.       Browse the Reportserver and Report manager URL from RS configuration manager.
4. 4.       Copy the URL and paste same into the above reporting servers window.
5. 5.       (You can also check that weather your url in Reporting server is right or not.
6. Update URL https to http.

How to resolve Ax 2009 SRS reports deployment error or exception

This article explains how to remove

• While deploying AX SRS reports from AX client (AOT->Report Libraries), system gives below error / exception
• While deploying AX Reports Deployment tools , system gives below error / exception

Symptom:
In case of SQL Server 2008
One or more libraries built with warnings. Please see MSBuild log at C:\Documents and Settings\Administrator\Local Settings\Temp\tmp.tmp
Deploying 0 data source(s) and 63 design(s) in 42 culture(s) (2521 item(s) total)...
Unable to connect to http : // [your system name] /ReportServer/ReportService2005.asmx as specified in the config file for the report server at C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\RSReportServer.config. If this url is not correct please update the config file, otherwise make sure the report server is configured correctly. The deployment log file can be found at "C:\Users\Administrator\AppData\Local\Temp\1\tmp.txt"


In case of SQL Server 2005
One or more libraries built with warnings. Please see MSBuild log at C:\Documents and Settings\Administrator\Local Settings\Temp\tmp.tmp
Deploying 0 data source(s) and 63 design(s) in 42 culture(s) (2521 item(s) total)...
Unable to connect to http : // [your system name] /ReportServer/ReportService2005.asmx as specified in the
config file for the report server at C:\Program Files\Microsoft SQL Server\ MSSQL.3\Reporting Services\ReportServer\RSReportServer.config. If this url is not correct please update the config file, otherwise make sure the report server is configured correctly.
The deployment log file can be found at "C:\Users\Administrator\AppData\Local\Temp\1\tmp.txt"


Resolution:
Check following:
1) Is your report manager working from IIS or Internet explorer? If no then make it workable. If it works then you can see Report Manager Home.
2) Is web service http : // [your system name] /ReportServer/ReportService2005.asmx working?

To make the default Report Manager workable, you can see the installation and configuration guidance.

If you are using SQL server 2008, open the C:\Program Files\Microsoft SQL Server\MSRS10.MSSQLSERVER\Reporting Services\ReportServer\RSReportServer.config file in an editor (Notepad is perfect).

If you are using SQL server 2005, open the C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\ rsreportserver.config file in an editor (Notepad is perfect).

Now you have to modify this config file. Before you do this I do recommend you to make a copy of this file as a backup.Press Ctrl + F and find ‘SQLCommandTimeoutSeconds’. By default the value is 60. Increate the value upto 300 and save the file.

Now restart the IIS.
Launch AX SRS report deployment tool. I hope it will work.

Once the AX SRS Reports deployment is finished go back to the above mentioned config file and decrease the value 60 from 300. 
~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~


Error: System.Web.Services.Protocols.SoapException: An unexpected error occurred while compiling expressions. Native compiler return value: ‘[BC30137] Error saving temporary Win32 resource file 'C:\Users\axadmin\AppData\Local\Temp\vbcF484.tmp': The process cannot access the file because it is being used by another process. ’.
Solution: 1) Restart SQL Server Reporting Services
            2) Stop the antivirus application running on the same server.   
Note: Use at your own risk. There is no warranty on this article.

AX 2009 - Installing Reporting Extensions on Windows server 2008 steps

hi friends,

The below are the steps which i followed while installing reporting extensions on Windows server 2008.

1. Install SQL Server 2008 with Reporting Services.
2. Install Ax - 2009 Application files,AOS, Client,
3. Install All the prerequisite for Reporting Extensions
    To install these software components, see Install prerequisites on the report server.

4. Install Reporting Extensions and .Net business connector.
3. Configure Report server with the Microsoft SQL SERVER 2008 >> Configuration and Tools >> Reporting Services configuration Manager
4. Deploy Reports using the path Microsoft Dynamics Ax 2009 >> Microsoft Dynamics Ax 2009 Reports Deployment.

AX 2009 Report extension installation

Hi Friends,

I am trying to install Report extension. When I run the Setup, I get the following message :

"You must install SQL server 2005 Reporting Services Service Pack 2 before installing the report extensions".

Some of the Resolution that i find out:

1. You can download regarding hofix released by Microsoft and replace dll file.
    HoFix Release By Microsoft - Click Here

~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~

2.The another resolution of updating registry key as follows:

Setup does not recognize that SQL Server 2005 Service Pack 2 is installed When installing the reporting extensions, you may receive an error message that states that you must install SQL Server 2005 Service Pack 2. If you have installed SQL Server 2005 Service Pack 2 and receive this error message, complete the following steps.

1. Open the registry and find the HKLM\SOFTWARE\Microsoft\Microsoft SQL Server key.

2. Right-click the HKLM\SOFTWARE\Microsoft\Microsoft SQL Server key & choose New >Key

3. Name the key Reporting Services.

4. Right-click the Reporting Services key and choose New > String Value.

5. Name the string value Version. The Version string value will have a type of REG_SZ.

6. Double-click the Version string value and enter 9.00.3042.00 as the value data. Click OK

~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~

While viewing the URL of reports if gets errors of symmetric key then change the setting in the Encryption Key (Change Action and Delete Action) as per required.
~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~:~