Invalid Semantic Model
Hi, I'm trying to generate a Report Model from the out of the box Team Foundation Server 2010 OLAP data source (Tfs2010OlapReportDS) which connects to the Tfs_Analysis cube running under SQL Server 2008. I get the following error The semantic model is not valid. Details: The 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling:Name' element is invalid - The value '' is invalid according to its datatype 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling:NonEmptyString' - The actual length is less than the MinLength value. (InvalidSemanticModel) There is one other post in the forum which had the same error but no conclusive answer.
March 14th, 2012 10:54am

Hi Vlad, Where do you create the data mode? could you please give more detail steps to create the data mode? In the TFS or report manager? If in the TFS, Team Foundation Server - Reporting & Warehouse forum will be better to post this question. http://social.msdn.microsoft.com/Forums/en/tfsreporting/threads Challen Fu TechNet Community Support
Free Windows Admin Tool Kit Click here and download it now
March 14th, 2012 11:11pm

Hi Challen, Thanks for the response. I am trying to generate the model in Report Manager. Detailed steps as follows Go to Report Manager home pageClick on TfsOlap2010ReportDSClick on Generate ModelEnter Tfs2010OlapReportModel in the Name fieldClick OKError is displayed as per my original post
March 15th, 2012 7:18am

Hi Challen, I posted the extra info as requested but have not yet received a response. Should a Microsoft engineer have responded by now?
Free Windows Admin Tool Kit Click here and download it now
March 20th, 2012 11:05am

Hi Vlad, I try to reproduce this error in your scenario, however everything works very well, are your report server and Cube database on the same instance with the same edition? I will do more research to this issue. Thanks for your understanding. Regards, Challen Fu TechNet Community Support
March 21st, 2012 12:57am

Hi Challen, Apologies I hadn't realised you were looking into this. Yes this is a single tier TFS 2010 installation with everything (App and Data tier) in the same instance and hence same edition. I was successfully able to generate the Report Model for the other out of the box data source Tfs2010ReportDS if that helps in any way
Free Windows Admin Tool Kit Click here and download it now
March 21st, 2012 9:37am

Hi Vlad, did you happen to have previous version of SSAS (2005) installed on your machine prior of installing TFS 2010? I would also suggest to compare *.smdl file associated with the report model on both working and not working systems. Thanks, Vlad.
March 22nd, 2012 10:04pm

Hi Vlad, No I didn't. This was a clean install of SQL server 2008 and TFS 2010. Unfortunately I dodn't have a working system as I have the same issue in our test environment. Can you expand on what you would be looking for in a comparison? Thanks
Free Windows Admin Tool Kit Click here and download it now
March 23rd, 2012 10:15am

I would suggest to check if your OLAP database can be browsed in SQL Server Management Studio and then delete and re-create your datasource. If this will not help, please open incident with Microsoft support for further troubleshooting. Best regards, Vlad.
March 23rd, 2012 7:23pm

Hi Vlad, It's taken while for me to get round to trying your suggestion. Yes I can browse the OLAP database in SQL Server Managemnent Studio, howvever deleting and recreating the datasource hasn't worked I'm afraid. Thanks for your help. I'll raise with Microsoft.
Free Windows Admin Tool Kit Click here and download it now
May 17th, 2012 11:14am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics