Showing posts with label project. Show all posts
Showing posts with label project. Show all posts

Monday, March 26, 2012

MSResultSetGenerator does not work any more

I try to generate a typed result set. I first added a new data source to my project and then changed the custom tool property of the .xsd file from MSDataSetGenerator to MSResultSetGenerator. This was working a few days ago, but recently, it stopped working. I now get the following error when I right click on my .xsd and then "run custom tool":

Error 102 Custom tool error: Failed to generate code. Illegal characters in path. C:\Users\Mathias\Documents\Visual Studio 2005\Projects\WindowsApplication9\WindowsApplication9\NorthwindDataSet1.xsd 1 1 WindowsApplication9

I tried this in several projects, for example I created a new WinForms project and then just added the norhwind.sdf sample database.

I use Visual Studio 2005 + SP1 + SP1 Vista patch (beta) + SQL Compact Edition + ADO .NET Sync Services CTP on Vista Ultimate.

Things I tried to repair this so far:
- VS2005 repair setup
- Reinstalled SQL Compact Edition
- Reinstalled ADO .NET Sync Services
- Reinstalled VS2005 SP1

I have the same problem and it seems that when I try to generate the data source with an empty sql mobile database it works.

When I add tables to the database it does not.

This suggest to me that it must have something to do with the naming conventions of the database tables and/or fields. I'm trying that next.

Did you make any progress? Please report

|||Just as a thought - have you tried running VS2005 as administrator and see if you have the same issue. Be warned VS2005 under Vista is still not officially supported as they haven't released the update yet - the beta fixes some, but definitely not all the Vista related issues.|||Thanks, but I'm already running VS as admin.|||Mathias - I now have the same configuration with you and I am experiencing the same issues. It appears the updates do not play well with the designer (at least under Vista).|||Thanks for testing this. Looks like I have to wait for the final VS Vista upgrade or use it in a VPC with XP.

MSResultSetGenerator does not work any more

I try to generate a typed result set. I first added a new data source to my project and then changed the custom tool property of the .xsd file from MSDataSetGenerator to MSResultSetGenerator. This was working a few days ago, but recently, it stopped working. I now get the following error when I right click on my .xsd and then "run custom tool":

Error 102 Custom tool error: Failed to generate code. Illegal characters in path. C:\Users\Mathias\Documents\Visual Studio 2005\Projects\WindowsApplication9\WindowsApplication9\NorthwindDataSet1.xsd 1 1 WindowsApplication9

I tried this in several projects, for example I created a new WinForms project and then just added the norhwind.sdf sample database.

I use Visual Studio 2005 + SP1 + SP1 Vista patch (beta) + SQL Compact Edition + ADO .NET Sync Services CTP on Vista Ultimate.

Things I tried to repair this so far:
- VS2005 repair setup
- Reinstalled SQL Compact Edition
- Reinstalled ADO .NET Sync Services
- Reinstalled VS2005 SP1

I have the same problem and it seems that when I try to generate the data source with an empty sql mobile database it works.

When I add tables to the database it does not.

This suggest to me that it must have something to do with the naming conventions of the database tables and/or fields. I'm trying that next.

Did you make any progress? Please report

|||Just as a thought - have you tried running VS2005 as administrator and see if you have the same issue. Be warned VS2005 under Vista is still not officially supported as they haven't released the update yet - the beta fixes some, but definitely not all the Vista related issues.|||Thanks, but I'm already running VS as admin.|||Mathias - I now have the same configuration with you and I am experiencing the same issues. It appears the updates do not play well with the designer (at least under Vista).|||Thanks for testing this. Looks like I have to wait for the final VS Vista upgrade or use it in a VPC with XP.

Friday, March 23, 2012

MSP_CUBE tables not updating with current data

Hi there,

I have recently been put into a role working with Project Server Web Access and OLAP cubes. Am experiencing trouble displaying current data in the Portfolio Analyzer in Web Access.

After adding and deleting data, inlcuding projects and resources, the updates are not reflecting when analysing the cube data. I have successfully reprocessed the cube from the Analysis Manager but still does not show current data.

When looking at the MSP_CUBE_* tables in SQL Manager, these tables directly reflect the data displayed in the cube. ie. The non-current data.

Is there a specific way to update these tables with the current data from the ProjectServer tables ?

Thanks in advance,

Ben

Updating this source data is really a Project Server issue rather than an Analysis Services one. There might be some people here that use both, but you would be better off asking in a Project/ProjectServer focused forum or newsgroup.sql