Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Invalid Semantic Model Expand / Collapse
Author
Message
Posted Wednesday, March 08, 2006 5:30 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 3:54 AM
Points: 3, Visits: 46
 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é

Post #264094
Posted Thursday, March 09, 2006 3:23 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 14, 2011 2:14 PM
Points: 17, 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

Post #264676
Posted Thursday, March 09, 2006 4:15 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 14, 2011 2:14 PM
Points: 17, 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

 

Post #264684
Posted Thursday, March 09, 2006 5:45 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 3:54 AM
Points: 3, Visits: 46

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é

 

Post #264698
Posted Wednesday, March 15, 2006 7:41 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 3:54 AM
Points: 3, Visits: 46
 

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é 

Post #265872
Posted Friday, February 15, 2008 10:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, February 17, 2012 11:17 AM
Points: 2, Visits: 44
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.
Post #456426
Posted Thursday, September 27, 2012 10:50 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, October 16, 2012 1:47 PM
Points: 80, 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
Post #1365388
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse