SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Invalid Semantic Model


Invalid Semantic Model

Author
Message
André Santana
André Santana
SSC Rookie
SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)

Group: General Forum Members
Points: 35 Visits: 49
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é


Lance Hunt
Lance Hunt
Valued Member
Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)

Group: General Forum Members
Points: 61 Visits: 11

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


Lance Hunt
Lance Hunt
Valued Member
Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)Valued Member (61 reputation)

Group: General Forum Members
Points: 61 Visits: 11

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

http://www.lance-hunt.net


André Santana
André Santana
SSC Rookie
SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)

Group: General Forum Members
Points: 35 Visits: 49

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é


André Santana
André Santana
SSC Rookie
SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)SSC Rookie (35 reputation)

Group: General Forum Members
Points: 35 Visits: 49

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é


mamtap
mamtap
Grasshopper
Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)Grasshopper (20 reputation)

Group: General Forum Members
Points: 20 Visits: 56
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.
Corie Curcillo
Corie Curcillo
SSC-Enthusiastic
SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)SSC-Enthusiastic (144 reputation)

Group: General Forum Members
Points: 144 Visits: 31
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search