Processing Tfs_Analysis Database

I was trying to get TFS 2010 to work with SQL 2008 R2 Report Server. Because the order in which these servers were installed, the reporting service in TFS 2010 had to be fixed after it was migrated to a server computer from a test installation on a workstation.

I followed the suggestions at this link:

http://social.msdn.microsoft.com/Forums/en-US/tfsreporting/thread/1d566b21-3082-4aa8-bbc8-d02fb76791de/

I downloaded and uploaded necessary report definitions, I fixed the data sources, and I update security settings. When I tried to open a report, I got errors related to “dsIteration”. I opened a report definition in SQL Report Designer. When I tried to run a query on this dataset, I got a “no cube can be found” error.  

I had to get into “SQL Server Business Intelligence Development Studio” to open the “Tfs_Analysis” database. It is not visible from the “SQL Server Management Studio”. Although the “Tfs_AnalysisDataSource” tested fine, when I tried to process the database from the “Database” menu, I got an error:

“OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001.

Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Tfs_AnalysisDataSource', Name of 'Tfs_AnalysisDataSource'. “

I tried to fix the “Tfs_AnalysisDataSource” datasource. Everthing I tried was of no use. I updated the firewall for SQL Analysis Service. It uses port 2383 access. That was not enough. 

I found an article on the internet that was helpful:

http://blog.accentient.com/2010/04/08/ManuallyProcessingTheTeamFoundationServer2010DataWarehouseAndAnalysisServicesDatabase.aspx 

It taught me how to use a web service to build TFS report databases:

http://localhost:8080/tfs/TeamFoundation/Administration/v3.0/WarehouseControlService.asmx?

I went through the steps and they did not solve the problems. I restarted the SQL Analysis Service. It turned out that the “OLE DB error” was caused by the SQL Analysis Service itself. After the restart I got a bunch of SQL errors while processing the database, but none was “network-related”. I went into TFS Management Console and rebuilt the warehouse database, and reprocessed the “Tfs_Analysis” database. The reprocessing worked.

After that, the reports were still not accessible. I restarted the SQL Analysis Service again, and then I went through the web service calls again.

Finally, the reports came up.

AJAX Control Toolkit and .NET 4.0

If you would like to build a .NET 4.0 web application with Visual Studio 2010, and you would like to build the AJAX Control Toolkit from its source with .NET 4.0 as well, you may run into a little problem. Even though you can build the AJAX Control Toolkit itself just fine, but when you build your web application, the compiler will give an error: "Inheritance security rules violated by type: 'AjaxControlToolkit.TabPanelDesigner'. Derived types must either match the security accessibility of the base type or be less accessible."

A quick solution to this problem is to add the following to the "AssemblyInfo.cs" file of the AJAX Control Toolkit project (not your own web application project):

[assembly: SecurityRules(SecurityRuleSet.Level1)]

Of course, at the beginning of this file, make sure that you have

using System.Security;

After you have made these changes, rebuild the AJAX Control Toolkit, and then your web application. Your web application should build fine.

Update: A later build of AJAX Control Toolkit now works with Visual Studio 2010 without modification.

MySQL .NET Connector and .NET 4.0

Whe building a .NET 4.0 application with MySQL .NET Connector 6.2.2, you may get an 0x80131515 error from the SGEN utility, saying that the operation is not supported.

Apparently Visual Studio 2010 does not like the fact that the MySQL DLLs are pulled from the global assembly cache (GAC). If you add file references to these MySQL DLLs in your project, everything works.

To remove MySQL .NET Connector 6.2.2 from the GAC, you have to uninstall it. That is right: you have to uninstall it to use it!

After you uninstall MySQL .NET Connector 6.2.2 from the control panel, you can unzip the MySQL .NET Connector 6.2.2 zip file that you download from MySQL, and then place the files at a location that you can reference from your project.

Add references to these files in your project by browsing to them, you can then build your project with .NET 4.0 without errors.

RibbonControls and Visual Studio 2010 Beta

When building an WCF project with Visual Studio 2010 that includes Microsoft Office UI's RibbonControls, the project may not build correctly, even though the same project may have been built correctly under Visual Studio 2008. The error is "Operation is not supported. (Exception HRESULT: 0x80131515)".

To fix this problem, first the file "RibbonControlsLibrary.dll" must be unblocked. Right click on this file in Windows Explorer, and then selec "Properties". On the "General" tab, there is an "Unblock" button near the bottem. Click on the button to unblock it.

Second, do no place "RibbonControlsLibrary.dll" in the GAC. If you have already placed it in the GAC, you will get an error saying that "This assembly is not vetted for safe use by partial trust code". Remove it from the GAC by running "gacutil -u RibbonControlsLibrary" from Windows command line. Then add a reference to the file "RibbonControlsLibrary.dll" in your project directly.

This should make your WPF project build under Windows 2010.