Monday, October 26, 2009

Error trying to add Web Reference to SmartDevice Project in VS 2008

In a development of SmartDevice project in Visual Studio 2008, when add or update a Web Reference an error message like the following is showed:

The custom tool 'MSDiscoCodeGenerator' failed. Could not retrieve the current project.

To solve this issue, just go to the command prompt in the Visual Studio 2008 directory (Start -> Programs-> Microsoft Visual Studio 2008 -> Visual Studio Tools -> Visual Studio 2008 Command Prompt )

From the command line execute the following command:
  • devenv /resetskippkgs
With that, a new instance of VS 2008 will be started and the update or add of the Web Reference will work fine.

Monday, October 5, 2009

Error in TFS Reports. Query execution failed for data set 'dsLastProcessedTime'

When upgrade to SQL Server 2008, the SQL Server that use the TFS to show the reports present the following message:

Query execution failed for data set 'dsLastProcessedTime'.

To resolve this problem, you need to do the following:

  1. Go to the following Address http://server/Reports
  2. Select the Data Source TfsOlapReportsDS
  3. Check the option 'Enable This Data Source'
  4. In Data Source Type, select 'Microsoft SQL Server Analysis Services'
  5. In Connection String, write 'Data source=[servername]; initial catalog=TfsWarehouse' (without ')
  6. Check 'Credentials stored securely in the report server', and type the user name [domain\user] and the password for the user in the domain who has access to the server of analysis Services.
  7. Check 'Use as Windows Credentials ...' and 'Impersonate the authenticated user...' and click the botton Apply.

After that, do the same for the Data Source TfsReportDS, with the following exceptions

  1. In the Data Source Type, select Microsoft SQL Server.
  2. In the Connection String write 'Data Source=[servername]; initial catalog=TfsWarehouse'.

Use the same configuration used in the Data Source TfsOlapReportDS.

With that, the reports should be showed again.