Error in Management Reporter when you create a new Dynamics AX 2012 company

Link: http://support.microsoft.com/kb/2660994/en-us?sd=rss&spid=14927

SYMPTOMS:

You receive the following error in Report Designer when you create a new Dynamics AX 2012 company:

The operation could not be completed due to a failure on the server

The following will also be in Event Viewer:

Message: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> System.InvalidOperationException: This operation is not supported for a relative URI.
at System.Uri.get_Scheme()
at Microsoft.Dynamics.Performance.DataProvider.GeneralLedger.AX6.GLProvider..ctor()

CAUSE:

This issue is caused whenAzure AppFabric SDK v1.0is installed on the server where the Management Reporter services are installed. The Azure AppFabric SDK enters a new endpoint address in the machine.config that Management Reporter is not expecting.

Resolution:

Uninstall Azure AppFabric SDK v1.0 from the server where the Management Reporter services are installed.

Note This may prevent RapidStart – Dynamics Online software from functioning correctly on this computer.

MORE INFORMATION:

This issue will be resolved in a future Management Reporter release….

SharePoint 2010 Cannot open workbook because it’s not stored in an Excel Services Application trusted location

If you are using the Office Web apps in SharePoint 2010 then you may come across this error…

“This workbook cannot be opened because it is not stored in an Excel Services Application trusted location.

To create an Excel Services Application trusted location, contact your system administrator.”

I believe this error is most likely if you are going over SSL as the default trusted location is just http://

Jump into central admin and go to Manage service applications.

Click on Excel services Application.

Then click on “Trusted file locations”

You can see that http:// is already there, so you could just add https:// or put in a URL to a specific location

Fill in the boxes, I also ticked the trust children box.

Once you have done this go back to your Excel document and it will open up in the browser.

RemoteApp applications are displayed as black windows when you restart the applications in a Remote desktop connection in Windows Server 2008 R2

RemoteApp applications are displayed as black windows when you restart the applications in a Remote desktop connection in Windows Server 2008 R2

Symptoms:

Consider the following scenario:

 

• ·  You install the “Remote Desktop Session Host” role service on a computer that is running Windows Server 2008 R2.

 

• ·  You publish some RemoteApp applications on the server. Then, you create .rdp files for these applications.

 

• ·  You use an .rdp file to start a RemoteApp application through Remote Desktop Connection 7.0 over a slow

    network, such as a wireless area network (WAN) on a client computer.

 

• ·  On the client computer, you close the RemoteApp application. Then, you double-cick the .rdp file to restart the

    application.

 

In this scenario, these applications are displayed as black windows intermittently.

 

Cause:

This issue is caused by the display driver of the Remote Desktop Session host service on the server computer. During the connection stage, the monitor layout packets for the client computer are dropped because the outgoing buffers are full. These buffers usually become full when the client computer uses a slow network or a WAN.

 

 

 

 

 

Resolution:

Hotfix information

A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing the problem described in this article. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix. If the hotfix is available for download, there is a “Hotfix download available” section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the hotfix. Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support (http://support.microsoft.com/contactus/?ws=support)

Note The “Hotfix download available” form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.

Prerequisites

To apply this hotfix, your computer must be running Windows Server 2008 R2 or Windows Server 2008 R2 Service Pack 1 (SP1). Additionally, your computer must have the “Remote Desktop Session Host” role service installed. For more information about how to obtain a Windows 7 or a Windows Server 2008 R2 service pack, click the following article number to view the article in the Microsoft Knowledge Base:

976932 (http://support.microsoft.com/kb/976932/ ) Information about Service Pack 1 for Windows 7 and for Windows Server 2008 R2

Restart requirement

You must restart the computer after you apply this hotfix.

Hotfix replacement information

This hotfix does not replace a previously released hotfix.

File information

The English (United States) version of this hotfix installs files that have the attributes that are listed in the following tables. The dates and the times for these files are listed in Coordinated Universal Time (UTC). The dates and the times for these files on your local computer are displayed in your local time together with your current daylight saving time (DST) bias. Additionally, the dates and the times may change when you perform certain operations on the files.

 

 

 

 

Windows Server 2008 R2 file information notes

Important Windows 7 hotfixes and Windows Server 2008 R2 hotfixes are included in the same packages. However, hotfixes on the Hotfix Request page are listed under both operating systems. To request the hotfix package that applies to one or both operating systems, select the hotfix that is listed under “Windows 7/Windows Server 2008 R2″ on the page. Always refer to the “Applies To” section in articles to determine the actual operating system that each hotfix applies to.

 

• ·         The files that apply to a specific product, SR_Level (RTM, SPn), and service branch (LDR, GDR) can be identified by examining the file version numbers as shown in the following table.

 

Version	Product	SR_Level	Service branch
6.1.760 0. 20xxx	Windows Server 2008 R2	RTM	LDR
6.1.760 1. 21xxx	Windows Server 2008 R2	SP1	LDR

 

Collapse this tableExpand this table

• ·         The MANIFEST files (.manifest) and the MUM files (.mum) that are installed for each environment are listed separately in the “Additional file information for Windows Server 2008 R2″ section. MUM and MANIFEST files, and the associated security catalog (.cat) files, are extremely important to maintain the state of the updated components. The security catalog files, for which the attributes are not listed, are signed with a Microsoft digital signature.

For all supported x64-based versions of Windows Server 2008 R2

 

File name	File version	File size	Date	Time	Platform
Pci.sys	6.1.7600.20671	183,688	18-Mar-2010	18:37	x64
Termdd.sys	6.1.7600.20671	62,344	18-Mar-2010	18:37	x64

Collapse this tableExpand this table

For all supported IA-64-based versions of Windows Server 2008 R2

 

File name	File version	File size	Date	Time	Platform
Pci.sys	6.1.7600.20671	454,536	18-Mar-2010	18:14	IA-64
Termdd.sys	6.1.7600.20671	160,144	18-Mar-2010	18:14	IA-64
Volmgr.sys	6.1.7600.20671	160,656	18-Mar-2010	18:14	IA-64
Rdpwd.sys	6.1.7600.20671	489,984	18-Mar-2010	06:45	IA-64
Rdpdd.dll	6.1.7600.20671	434,176	18-Mar-2010	06:45	IA-64
Pci.sys	6.1.7601.21772	458,112	16-Jul-2011	04:21	IA-64
Termdd.sys	6.1.7601.21772	162,688	16-Jul-2011	04:21	IA-64
Volmgr.sys	6.1.7601.21772	164,224	16-Jul-2011	04:21	IA-64
Rdpwd.sys	6.1.7601.21772	503,808	16-Jul-2011	03:01	IA-64

Collapse this tableExpand this table

File Download:

KB Article Number(s)     : 981156

Language                             : All (Global)

Platform                              : x64

Location                               : http://hotfixv4.microsoft.com/Windows%207/Windows%20Server2008%20R2%20SP1/sp2/Fix373827/7600/free/435488_intl_x64_zip.exe

Activate disabled for SharePoint 2010 sandbox solution

Article Link Info:

This may be somewhat obvious but took me a few minutes to figure out what had happened. I have been developing sandbox solutions on my development box for a project I’m working on and was at the point of uploading some of the WSP’s to the staging SharePoint 2010 farm. They uploaded just fine to the site collection and showed the “Activate” button highlighted upon selecting the solution. Once the activate dialog box came up, however, the activate button was disabled as shown below:

The message states the control is disabled and it could be due to permissions, etc.  My first thoughts were to double check that my permissions were setup correctly on the staging farm (and of course I went about checking that) but then realized that it the “SharePoint User Code Host” service was disabled which was of course due to the “Microsoft SharePoint Foundation Sandboxed Code Service” being Stopped (or probably in this case just never started to begin with).

 

SharePoint 2010 User Code Host
Microsoft SharePoint Foundation Sandboxed Code Service

Resolution:

Go into Central Administration and navigate to System Settings –> Manage Services on Server and start the “Microsoft SharePoint Foundation Sandboxed Code Service” service.

Inside Microsoft Dynamics AX 2012 Videos

Thought to share these YouTube videos on Dynamics AX 2012:

Video1 – Developer Tools
- Stresses the importance of Models
- API’s
- Interoperability with .Net
- 3 yrs spent by Microsoft for the new Development Tools

Video 2 – Services and AIF
- Heavy investment in Services
- Mobile applications can plug in to the service model
- 90 webservices
- Simplified and Powerful Integration

Video 3 – Reporting
- Integration with Excel

Video 4 – Office Integration
- Collabration across Office, AX and Visual Studio
- Demo (Budget)

Video 5 – Usability
- End-User Simplicity
- Recruited people from the industry to test the usability scenarios
- Field Surveys
- Demo AR Customers/SO’s (Fact boxes)
- Consolidate Commands into Flexible Activity based Ribbons (Similar Look and feel as Excel, Word)
- Fast tabs
- “Go to Main Table” replaced by hyperlink lookups (cool feature)

Video 6 – Enterprise Portal
- Rich UI
- Travel Expense Demo
- Microsoft internal adoption (aka DogFooding)
- ISV’s interested to build on new add’ons for EP

Video 7 – Performance
- 20 x times faster than 2009
- Managed X++
- Leverages Virtualization
- Leverages AppFabric

Install and configure Analysis Services for Dynamics AX 2012

Install Microsoft Dynamics AX 2012 Analysis Prerequisites before installing Analysis Services components.

Restart Server if required and click Next

Select the SQL Server Instance Name

Select the Server Name and Database name which needs to be configured for Analysis Services and click Next

Complete the Prerequisite validation checklist and click Next

Analysis Services Configuration completed successfully.

Open Microsoft Dynamics AX 2012 Client –> Click on Files –> Tools –> Business Intelligence  (BI) Tools –> SQL Server Analysis Services Project Wizard

Click Next

Select the option “Deploy” to deploy Analysis Services to Analysis Server, and click Next

Select the existing Analysis Services Project “Dynamics AX” and click Next

Enable “Deploy the Project” by creating a default Analysis Database Name “Dynamics Ax” and click Next. Enabled to Process the projects once the project is deployed successfully.

Deploy Reports using PowerShell for Dynamics AX 2012

Wait for a few min’s to populate the variable, it will return back to the PS Prompt
TIP – You can also output to a file by appending out-file as shown

803 SSRS reports out of the box
Publishing reports
Note – takes around 45 mins to deploy (with some warnings which can be ignored I guess)