RSS

Category Archives: Report

Dynamics AX 2012 R3 Report Deployment Error with Visual Studio 2013

Issues:

When deploying a report in R3 with VS 2013, you might see the error below

The “GenerateRdlTask” task failed unexpectedly.

System.IO.FileLoadException: Loading this assembly would produce a different grant set from other instances. (Exception from HRESULT: 0x80131401)

image

Solutions

1. Open the Start Menu and right click on Computer. Select Properties.

2. Select Advanced system settings.

3. In the Advanced tab, select Environment Variables.

4. Select New.

5. Set Variable Name: COMPLUS_LoaderOptimization

6. Set Variable Value: 1

image

image

7. Log out and log back in

8. Open the report using VS 2013 and try again.

 
1 Comment

Posted by on May 18, 2016 in Development, Report

 

Tags: , , , , ,

SSRS Report Server Settings Validation Error

Issue:

I’m trying to validate  report server setup of a client and got the error below
Make sure that SQL Server Reporting Services is configured correctly. Verify the Web Service URL and Report Manager URL configuration in the SQL Reporting Services Configuration Manager.

image

Solution:

After some troubleshooting, it turns out UAC was not turned off. I am running on MS Windows Server 2012.

UAC has to be turned off via registry by changing the DWORD “EnableLUA” from 1 to 0 in “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\policies\system”. You will get a notification that a reboot is required. After the reboot, UAC is disabled.

After UAC is disabled, the issue is resolved.

Steps :

Windows 2008:
Deactivating UAC in Windows 2008 R2 was possible via running msconfig (for example winkey+r -> msconfig), going to the Tools tab and launching “Change UAC settings”. There, you select “Never notify” to disable UAC.

Windows Server 2012:
The same approach is still available in Windows Server 2012, though UAC is still active after you selected “Never notify”. You have the option to turn off UAC via registry by changing the DWORD “EnableLUA” from 1 to 0  in “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\policies\system”. You will get a notification that a reboot is required. After the reboot, UAC is disabled.

STEP 1: Go to UAC

image

STEP 2: Change to “Never notify”

STEP 3: Change “EnableLUA” to 0

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\policies\system

image

 
1 Comment

Posted by on January 28, 2015 in Development, General, Report

 

Tags: , , , , , ,

SSRS Report in R3 – VS 2012 vs. VS 2010

Problem:
In R3 environment, when I tried to to edit a report,  i received the following message
“Unable to preview the report, install the Business Intelligence Development Studio feature of Microsoft SQL Server For more information”

image

AOT > Visual Studio Projects > Select a project > Right Click > Edit

image

Notice that VS 2010 is still being used as a default one.

image

Solution:
AX R3 still needs to integrate with Visual Studio 2010 and therefore you have to have BIDS (Business Intelligence Development Studio). You can use a SQL Server 2008 R2 installation image to install it (it’s one of the components you can select during installation of “A new standalone server or additional components” on the client machine.

SQL Server 2008 R2 Setup Feature Selection

How to installing(adding) features (SSRS) to an existing SQL installation. Please follow this link:
http://mssqltrek.com/2012/02/10/installingadding-featuressrs-to-an-existing-sql-installation/

 

Tags: , , , , , ,

 
%d bloggers like this: