Home Forums Reporting Services Reporting Services Invalid Semantic Model RE: Invalid Semantic Model

  • March 9, 2006 at 5:45 pm

    #625835

    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é