Troubleshoot Report Deployment Issues [AX 2012]

Updated: February 1, 2013

Applies To: Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012

This topic provides information that can help you troubleshoot issues that you may encounter when you deploy Microsoft Dynamics AX reports.

For more information about how to troubleshoot Microsoft SQL Server Reporting Services reports, see Troubleshooting Report Problems in the SQL Server documentation.

The following table provides possible issues and troubleshooting details for common deployment issues.

Issue

More information for troubleshooting

Unable to deploy the report in Visual Studio

  • Try to build the report. If there are errors, address the errors, and then try to deploy the report again.

  • If User Account Control (UAC) is enabled, disable UAC, or start Microsoft Dynamics AX with administrator privileges. Click the Start menu, point to All Programs, click the Microsoft Dynamics AX folder, right-click Microsoft Dynamics AX, and then click Run as administrator.

    When you start Visual Studio by using Edit on the Application Object Tree (AOT) menu for the report, it starts with administrator privileges. Try to deploy the report.

Unable to deploy the report in the AOT

  • Try to build the report. If there are errors, address the errors, and then try to deploy the report again.

  • If UAC is enabled, disable UAC, or start Microsoft Dynamics AX with administrator privileges. To do so, click the Start menu, point to All Programs, click the Microsoft Dynamics AX folder, right-click Microsoft Dynamics AX, and then click Run as administrator.

The following list describes two scenarios and the steps to troubleshoot reports that are not updated.

  • The deployed report is not updated after you modify the report in Visual Studio.

    Follow these steps to update the Report Definition Language (RDL) and the data for the report:

    1. In the AOT, expand the SSRS Reports node, right-click the Reports node, and then click Refresh.

    2. Expand the Reports node, right-click the report to update, and then click Restore. The RDL and the data that is rendered on the report are updated.

      NoteNote

      You can also update the cache. In a Development Workspace, on the Tools menu, click Caches, and then click Refresh elements.

  • The deployed report is not updated after you add a default value to an existing parameter and then deploy the report.

    There are two options to resolve this issue:

    • Update the default value in Reporting Services Report Manager.

    • Delete the report before you deploy it.

      NoteNote

      We do not recommend this option if you use the report history or subscriptions, because these are bound to the report and are deleted together with it.

The most common reasons for permission errors are as follows:

  • UAC is enabled. Run the applications that you are deploying reports from as the administrator. Right-click the application, and then click Run as administrator.

  • You are not a member of the local Administrators group on the report server.

  • You have not configured Reporting Services for local administration.

    If you want to administer a report server instance locally, you must complete additional configuration steps to deploy Reporting Services on Windows Server 2008. Windows Server 2008 limits the overuse of elevated permissions by removing administrator permissions when users try to access applications. Because the operating system removes permissions, members of the local Administrators group run most applications as if they are using the Standard User account. Although this practice improves the overall security of a system, it prevents you from using the predefined, built-in role assignments that Reporting Services creates for local administrators.

    For information about how to fix this issue, see How to: Configure a Report Server for Local Administration on Windows Vista and Windows Server 2008 (UAC).

When you try to access the Report Manager website, you may receive the following permission error:

User '[DomainName]\[UserName]' does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed.

By default, you cannot access the Report Manager website if UAC is enabled. To access the Report Manager site when UAC is enabled, follow these steps.

  1. Open your browser as an administrator. To open Internet Explorer as an administrator, follow these steps:

    1. Click Start.

    2. Right-click the Internet Explorer option.

    3. Click Run as administrator.

  2. Open the Report Manager website. By default, the URL is http://[SSRSServerName]:80/Reports.

When you deploy the report, you are running an application that is based on Windows Communication Foundation. The application uses the extendedProtectionPolicy type. The underlying .NET Framework 2.0 SP2 Network Client Library feature layer is not updated when the Windows Communication Foundation feature layer is updated to use the new type. The underlying .NET Framework 2.0 SP2 Network Client Library feature layer does not support this new type.

For information about why this occurred, and to download the hotfix, see Microsoft Support Article 2262911.

When you try to deploy a report, you may receive the following error:

The network path was not found.

To resolve this issue, you may have to start the Remote Registry service on the server that runs Reporting Services. Follow these steps to start the service.

  1. Click Start > Administrative Tools > Services to open the Services management console.

  2. Right-click the Remote Registry service, and then click Start.

Deployment failures can be expected if more than one developer is trying to deploy a report. Deployment often requires a service restart, which affects other active deployments.

You must be a local administrator on the report server to deploy reports.

When you deploy reports, you may receive the following error:

The process cannot access the file '[ReportName].dll' because it is being used by another process.

To resolve this issue, you can add the RestartReportServer option as part of the report deployment in Windows PowerShell. For more information, see Deploy the default reports.

Community Additions

ADD
Show: