March 8, 2006 at 5:30 am
Hello,
I got the following error while trying to create a report model:
The semantic model is not valid. Details: The element 'Entity' in namespace 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling' has incomplete content. List of possible elements expected: 'IdentifyingAttributes' in namespace 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling'. Line 943, position 3. (rsModelingError) (Report Services SOAP Proxy Source)
------------------------------
For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsModelingError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00
------------------------------
Program Location:
at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.GenerateModel(String DataSource, String Model, String Parent, Property[] Properties)
at Microsoft.SqlServer.Management.UI.RSWrapper.NodeDataSource.GenerateModel(String name, String folderpath, String description)
at Microsoft.SqlServer.Management.UI.RSUserInterface.DataSourcePropertiesGenerateModel.OnRunNow(Object sender)
at Microsoft.SqlServer.Management.SqlMgmt.PanelExecutionHandler.Run(RunType runType, Object sender)
at Microsoft.SqlServer.Management.SqlMgmt.ViewSwitcherControlsManager.RunNow(RunType runType, Object sender)
I've searched every forum and every page from microsoft but couldn't find a single reference about this problem. I don't know what to do and I really need to get this model working fine for report builder
Can you help me?
André
March 9, 2006 at 3:23 pm
I have seen similar problems when you have table names that conflict with certain "reserved words". I can't think of a good example right now, but to troubleshoot this you can try paring down the list of tables you include in the model and see which one is the culpret by simple process of elimination.
I hope this helps,
Lance
March 9, 2006 at 4:15 pm
On second thought, I'm not sure this is the same error I was seeing. To start your troubleshooting you should check the server's logfiles to see if the web service logged an error during the call to GenerateModel. The log files are typically located at:
c:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\LogFiles
You can do a simple search for the string "ERROR:" in all logfiles to see if any errors were logged.
Good luck,
Lance
March 9, 2006 at 5:45 pm
Hello Lance
First of all, thanks for your reply... it was the first one i've had for this problem... and believe me... i've posted this in every SSRS forum or discussion.
Back to the problem...
As for the tables... i have the following tables in my cube:
"FCT_Cambios", "FCT_Orcamento", "DIM_Tempo", "DIM_Agentes", "DIM_Segmentos", "DIM_Online", "DIM_Tarmix", "DIM_Ticket_Form", "FCT_Dados".
I don't think it's possible to one of those tables to match the others.
As for the logs, I've checked the log in the SSRS directory, but the information it provided me is exactly the same one provided in the error prompt.
Next, i'll add the text from the log file...
ReportServerWebApp__03_10_2006_00_24_28.log
w3wp!library!1!10-03-2006-00:24:29:: i INFO: Initializing ReportBuilderTrustLevel to '0' as specified in Configuration file.
w3wp!library!1!10-03-2006-00:24:29:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!10-03-2006-00:24:29:: i INFO: Initializing MaxScheduleWait to default value of '1' second(s) because it was not specified in Configuration file.
w3wp!library!1!10-03-2006-00:24:29:: i INFO: Initializing DatabaseQueryTimeout to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!10-03-2006-00:24:29:: i INFO: Initializing ProcessRecycleOptions to default value of '0' because it was not specified in Configuration file.
w3wp!library!1!10-03-2006-00:24:29:: i INFO: Initializing RunningRequestsScavengerCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!10-03-2006-00:24:29:: i INFO: Initializing RunningRequestsDbCycle to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!10-03-2006-00:24:29:: i INFO: Initializing RunningRequestsAge to default value of '30' second(s) because it was not specified in Configuration file.
w3wp!library!1!10-03-2006-00:24:29:: i INFO: Initializing CleanupCycleMinutes to default value of '10' minute(s) because it was not specified in Configuration file.
w3wp!library!1!10-03-2006-00:24:29:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!10-03-2006-00:24:29:: i INFO: Initializing WatsonFlags to default value of '1064' because it was not specified in Configuration file.
w3wp!library!1!10-03-2006-00:24:29:: i INFO: Initializing WatsonDumpOnExceptions to default value of 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' because it was not specified in Configuration file.
w3wp!library!1!10-03-2006-00:24:29:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to default value of 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' because it was not specified in Configuration file.
w3wp!library!1!10-03-2006-00:24:29:: i INFO: Initializing SecureConnectionLevel to default value of '1' because it was not specified in Configuration file.
w3wp!library!1!10-03-2006-00:24:29:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!10-03-2006-00:24:29:: i INFO: Initializing WebServiceUseFileShareStorage to default value of 'False' because it was not specified in Configuration file.
w3wp!ui!6!10/3/2006-00:26:53:: e ERROR: The semantic model is not valid. Details: The element 'Entity' in namespace 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling' has incomplete content. List of possible elements expected: 'IdentifyingAttributes' in namespace 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling'. Line 943, position 3. ---> The semantic model is not valid. Details: The element 'Entity' in namespace 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling' has incomplete content. List of possible elements expected: 'IdentifyingAttributes' in namespace 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling'. Line 943, position 3.
w3wp!ui!6!10/3/2006-00:26:53:: e ERROR: HTTP status code --> 200
-------Details--------
System.Web.Services.Protocols.SoapException: The semantic model is not valid. Details: The element 'Entity' in namespace 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling' has incomplete content. List of possible elements expected: 'IdentifyingAttributes' in namespace 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling'. Line 943, position 3. ---> The semantic model is not valid. Details: The element 'Entity' in namespace 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling' has incomplete content. List of possible elements expected: 'IdentifyingAttributes' in namespace 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling'. Line 943, position 3.
at Microsoft.ReportingServices.UI.NewDependentItem.ApplyChanges()
at Microsoft.ReportingServices.UI.BaseApplyPage.ApplyBtn_Click(Object sender, EventArgs e)
at Microsoft.ReportingServices.UI.ScriptButton.OnClick(EventArgs e)
at Microsoft.ReportingServices.UI.ScriptButton.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
w3wp!ui!6!10/3/2006-00:26:53:: e ERROR: Exception in ShowErrorPage: System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
ReportServer__03_10_2006_00_25_21.log
w3wp!webserver!1!10-03-2006-00:25:21:: i INFO: Reporting Web Server started
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
w3wp!library!1!10-03-2006-00:25:21:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
w3wp!resourceutilities!1!10-03-2006-00:25:21:: i INFO: Reporting Services starting SKU: Developer
w3wp!resourceutilities!1!10-03-2006-00:25:21:: i INFO: Evaluation copy: 0 days left
w3wp!runningjobs!1!10-03-2006-00:25:21:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1!10-03-2006-00:25:21:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!10-03-2006-00:25:21:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1!10-03-2006-00:25:21:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!8!03/10/2006-00:25:23:: i INFO: Call to GetPermissions:/
w3wp!library!8!03/10/2006-00:25:23:: i INFO: Catalog SQL Server Edition = Developer
w3wp!library!8!03/10/2006-00:25:24:: i INFO: Call to GetSystemPermissions
w3wp!library!8!03/10/2006-00:26:26:: i INFO: Call to GetPermissions:/Data Sources
w3wp!library!8!03/10/2006-00:26:26:: i INFO: Call to GetSystemPermissions
w3wp!library!8!03/10/2006-00:26:28:: i INFO: Call to GetPermissions:/Data Sources/TAP - Cube
w3wp!library!8!03/10/2006-00:26:28:: i INFO: Call to GetSystemPermissions
w3wp!library!8!03/10/2006-00:26:33:: i INFO: Call to GetPermissions:/Data Sources/TAP - Cube
w3wp!library!8!03/10/2006-00:26:33:: i INFO: Call to GetSystemPermissions
w3wp!library!8!03/10/2006-00:26:39:: i INFO: Call to GetPermissions:/Data Sources/TAP - Cube
w3wp!library!8!03/10/2006-00:26:39:: i INFO: Call to GetSystemPermissions
w3wp!library!8!03/10/2006-00:26:39:: i INFO: Call to GenerateModel('/Data Sources/TAP - Cube', 'TAP Model', '/Data Sources')
w3wp!semanticqueryengine!8!03/10/2006-00:26:53:: e ERROR: Throwing Microsoft.ReportingServices.Modeling.XmlValidationException: The semantic model is not valid. Details: The element 'Entity' in namespace 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling' has incomplete content. List of possible elements expected: 'IdentifyingAttributes' in namespace 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling'., ;
Info: Microsoft.ReportingServices.Modeling.XmlValidationException: The semantic model is not valid. Details: The element 'Entity' in namespace 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling' has incomplete content. List of possible elements expected: 'IdentifyingAttributes' in namespace 'http://schemas.microsoft.com/sqlserver/2004/10/semanticmodeling'.
w3wp!library!8!10-03-2006-00:35:21:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0
Can you see anything unusual around here?
Thanks for your help
André
March 15, 2006 at 7:41 am
I have the solution.
After the opening of the case in microsoft, this problem was analysed by the support teams and I got an answer today.
The problem seems to be one relationship i've built between a fact table and a dimension table.
In the current release of SSRS and SSAS, a relationship from one entity to another is implicitly to the key of the destination entity.
I was using a Time dimension (the dimension key was "day") and I was building a relationship based on the attribute "month".
So, the relationship was ignored and my fact table had no relationships and therefore, no identifyers, and that was the cause of the problem.
The solution for my case was relating the month to the first day of the month in the Time table.
I was told Microsoft plans to lift such limitation on the next releases.
Hope this helps for anyone with similar problems
André
February 15, 2008 at 10:56 am
I have the same error but my problem is that I set the AttributeHierarchyDisplayFolder to "\" which I need it for excel. Is there any escape characters that can be used to specify "\"? Thanks.
September 27, 2012 at 10:50 am
mamtap (2/15/2008)
I have the same error but my problem is that I set the AttributeHierarchyDisplayFolder to "\" which I need it for excel. Is there any escape characters that can be used to specify "\"? Thanks.
exact same issue with the "\" generating report off of semantic model
any solutions?
BUMP
Corie Curcillo
MCT, MCDBA, MCSD
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply