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


