locked
ssrs 2014 errorrule 'Create list of measure group-dimension pairs RRS feed

  • Question

  • I'm getting this error generating a model for a ssas tabular model in ssrs 2014.  When I test the tabulur definition in Excel under SSAS everything works fine and there are no errors.

    Thanks

    From the log

    semanticmodelgenerator!ReportServer_0-1!b58!06/13/2014-15:39:25:: e ERROR: Semantic Model Generator: ModelGeneratorExtention
    An error occurred while executing rule 'Create list of measure group-dimension pairs':Unexpected error occurred : Unable to obtain cube schema object for cube dimension '[$DimDate].[DimDate]'..
    semanticmodelgenerator!ReportServer_0-1!b58!06/13/2014-15:39:25:: e ERROR: Semantic Model Generator: ModelGeneratorExtention
    An error occurred during the generation of semantic model : [Create list of measure group-dimension pairs]Unexpected error occurred : Unable to obtain cube schema object for cube dimension '[$DimDate].[DimDate]'..
    library!ReportServer_0-1!b58!06/13/2014-15:39:25:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ModelGenerationErrorException: , Microsoft.ReportingServices.Diagnostics.Utilities.ModelGenerationErrorException: An error occurred while generating model. ---> System.InvalidOperationException: An error occurred during the generation of semantic model : [Create list of measure group-dimension pairs]Unexpected error occurred : Unable to obtain cube schema object for cube dimension '[$DimDate].[DimDate]'.. ---> System.InvalidOperationException: [Create list of measure group-dimension pairs]Unexpected error occurred : Unable to obtain cube schema object for cube dimension '[$DimDate].[DimDate]'. ---> Microsoft.AnalysisServices.Modeling.Generation.ModelGenerationException: Unexpected error occurred : Unable to obtain cube schema object for cube dimension '[$DimDate].[DimDate]'.
       at Microsoft.AnalysisServices.Modeling.Generation.ModelGenerationDiagnostics.Assert(Boolean condition, String message, Boolean throwOnFail)
       at Microsoft.AnalysisServices.Modeling.Generation.Rules.MapMeasureGroupsToDegenerateDimensions.Process(RuleFlowRecords& generatedRules, RuleExecutionRequirement& rulesExecutionRequirement)
       at Microsoft.AnalysisServices.Modeling.Generation.Flow.RuleProcessor.ProcessRule(IRule rule, RuleContext ruleContext)
       --- End of inner exception stack trace ---
       at Microsoft.AnalysisServices.Modeling.Generation.Flow.RuleProcessor.ProcessRule(IRule rule, RuleContext ruleContext)
       at Microsoft.AnalysisServices.Modeling.Generation.Flow.RuleProcessor.ProcessRuleFlowRecord(RuleFlowRecord ruleFlowRecord)
       at Microsoft.AnalysisServices.Modeling.Generation.Flow.RuleProcessor.ProcessRule(IRule rule, RuleContext ruleContext)
       at Microsoft.AnalysisServices.Modeling.Generation.Flow.RuleProcessor.ProcessRuleFlowRecord(RuleFlowRecord ruleFlowRecord)
       at Microsoft.AnalysisServices.Modeling.Generation.Flow.RuleProcessor.Process()
       --- End of inner exception stack trace ---
       at Microsoft.AnalysisServices.Modeling.Generation.Flow.RuleProcessor.Process()
       at Microsoft.AnalysisServices.Modeling.Generation.ModelGenerator.Generate()
       at Microsoft.AnalysisServices.Modeling.Generation.ModelGeneratorExtention.ReGenerateModel(IDbConnection connection, XmlReader currentModelReader, XmlWriter newModelWriter)
       at Microsoft.ReportingServices.Library.GenerateModelAction.GenerateModel(DataSourceInfo dataSource)
       --- End of inner exception stack trace ---;
    ui!ReportManager_0-2!3f3c!06/13/2014-15:39:25:: e ERROR: System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An error occurred while generating model. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ModelGenerationErrorException: An error occurred while generating model. ---> System.InvalidOperationException: An error occurred during the generation of semantic model : [Create list of measure group-dimension pairs]Unexpected error occurred : Unable to obtain cube schema object for cube dimension '[$DimDate].[DimDate]'.. ---> System.InvalidOperationException: [Create list of measure group-dimension pairs]Unexpected error occurred : Unable to obtain cube schema object for cube dimension '[$DimDate].[DimDate]'. ---> Microsoft.AnalysisServices.Modeling.Generation.ModelGenerationException: Unexpected error occurred : Unable to obtain cube schema object for cube dimension '[$DimDate].[DimDate]'.
       at Microsoft.ReportingServices.Library.ReportingService2010Impl.GenerateModel(String DataSource, String Model, String Parent, Property[] Properties, CatalogItem& ItemInfo, Warning[]& Warnings)
       at Microsoft.ReportingServices.WebServer.ReportingService2010.GenerateModel(String DataSource, String Model, String Parent, Property[] Properties, CatalogItem& ItemInfo, Warning[]& Warnings)
       at Microsoft.ReportingServices.UI.NewDependentItem.ApplyChanges()
       at Microsoft.ReportingServices.UI.BaseApplyPage.ApplyBtn_Click(Object sender, EventArgs e)
       at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
       at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
       at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    ui!ReportManager_0-2!3f3c!06/13/2014-15:39:25:: e ERROR: HTTP status code --> 200
    -------Details--------
    System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: An error occurred while generating model. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ModelGenerationErrorException: An error occurred while generating model. ---> System.InvalidOperationException: An error occurred during the generation of semantic model : [Create list of measure group-dimension pairs]Unexpected error occurred : Unable to obtain cube schema object for cube dimension '[$DimDate].[DimDate]'.. ---> System.InvalidOperationException: [Create list of measure group-dimension pairs]Unexpected error occurred : Unable to obtain cube schema object for cube dimension '[$DimDate].[DimDate]'. ---> Microsoft.AnalysisServices.Modeling.Generation.ModelGenerationException: Unexpected error occurred : Unable to obtain cube schema object for cube dimension '[$DimDate].[DimDate]'.
       at Microsoft.ReportingServices.Library.ReportingService2010Impl.GenerateModel(String DataSource, String Model, String Parent, Property[] Properties, CatalogItem& ItemInfo, Warning[]& Warnings)
       at Microsoft.ReportingServices.WebServer.ReportingService2010.GenerateModel(String DataSource, String Model, String Parent, Property[] Properties, CatalogItem& ItemInfo, Warning[]& Warnings)

       at Microsoft.ReportingServices.UI.NewDependentItem.ApplyChanges()

       at Microsoft.ReportingServices.UI.BaseApplyPage.ApplyBtn_Click(Object sender, EventArgs e)

       at System.Web.UI.WebControls.Button.OnClick(EventArgs e)

       at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)

       at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)

       at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    library!ReportServer_0-1!b58!06/13/2014-15:39:25:: i INFO: Call to GetSystemPropertiesAction().
    ui!ReportManager_0-2!3f3c!06/13/2014-15:39:25:: e ERROR: 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 Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String errMsg)
    library!WindowsService_2!bd0!06/13/2014-15:41:25:: i INFO: Call to CleanBatch()
    library!WindowsService_2!bd0!06/13/2014-15:41:26:: i INFO: Cleaned 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs, 0 persisted streams, 0 segments, 0 segment mappings, 0 edit sessions.
    library!WindowsService_2!bd0!06/13/2014-15:41:26:: i INFO: Call to CleanBatch() ends
    rshost!rshost!3f3c!06/13/2014-19:37:27:: i INFO: Currently registered url http://+:80/ReportServer_SQLEXPRESS/ on endpoint 2
    rshost!rshost!3f3c!06/13/2014-19:37:27:: i INFO: Currently registered url http://+:80/Reports_SQLEXPRESS/ on endpoint 3
    rshost!rshost!3f3c!06/13/2014-19:37:27:: i INFO: Endpoint 4 is disabled and no url is registered vdir=/ReportServer_SQLEXPRESS/ReportBuilder, pdir=C:\Program Files\Microsoft SQL Server\MSRS12.SQLEXPRESS\Reporting Services\ReportServer\ReportBuilder.
    rshost!rshost!e38!06/13/2014-19:37:27:: i INFO: Derived memory configuration based on physical memory as 16487384 KB
    appdomainmanager!DefaultDomain!e38!06/13/2014-19:37:27:: i INFO: Appdomain:5 ReportServer_SQLEXPRESS_0-1-130471616741701355 unregistered.
    library!WindowsService_2!22c!06/13/2014-19:37:29:: i INFO: Call to CleanBatch()
    appdomainmanager!ReportServer_0-1!e38!06/13/2014-19:37:30:: i INFO: Appdomain:5 ReportServer_SQLEXPRESS_0-1-130471616741701355 unloading
    appdomainmanager!DefaultDomain!e38!06/13/2014-19:37:33:: i INFO: Appdomain:6 ReportManager_SQLEXPRESS_0-2-130471623126349107 unregistered.
    appdomainmanager!ReportManager_0-2!e38!06/13/2014-19:37:33:: i INFO: Appdomain:6 ReportManager_SQLEXPRESS_0-2-130471623126349107 unloading
    servicecontroller!DefaultDomain!e38!06/13/2014-19:37:41:: i INFO: Recycling the service from the default domain
    dbpolling!WindowsService_2!376c!06/13/2014-19:37:41:: i INFO: EventPolling polling service stopped
    dbpolling!WindowsService_2!376c!06/13/2014-19:37:41:: i INFO: NotificationPolling polling service stopped
    dbpolling!WindowsService_2!376c!06/13/2014-19:37:41:: i INFO: SchedulePolling polling service stopped
    dbpolling!WindowsService_2!376c!06/13/2014-19:37:41:: i INFO: UpgradePolling polling service stopped
    runningjobs!WindowsService_2!e38!06/13/2014-19:37:41:: e ERROR: Timer Database Cleanup (NT Service) still executing, breaking...
    rshost!rshost!e38!06/13/2014-19:37:48:: i INFO: Application domain type WindowsService statistics: created: 3, unloaded: 3, failed: 0, timed out: 0.
    appdomainmanager!DefaultDomain!e38!06/13/2014-19:37:48:: i INFO: Appdomain:7 WindowsService_3 started.
    library!WindowsService_2!22c!06/13/2014-19:37:52:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: , An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database.;
    library!WindowsService_2!22c!06/13/2014-19:37:52:: w WARN: Transaction rollback was not executed connection is invalid
    dbcleanup!WindowsService_2!22c!06/13/2014-19:37:52:: e ERROR: Error in CleanExpiredSessions: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: An error occurred within the report server database.  This may be due to a connection failure, timeout or low disk condition within the database. ---> System.Data.SqlClient.SqlException: Database 'ReportServer$SQLEXPRESSTempDB' is being recovered. Waiting until recovery is finished.
    library!WindowsService_3!e38!06/13/2014-19:37:55:: i INFO: SQLDump flags: ReferencedMemory, AllThreads, SendToWatson
    library!WindowsService_3!e38!06/13/2014-19:37:55:: i INFO: MiniDump flags: DataSegs, UnloadedModules, ProcessThreadData
    library!WindowsService_3!e38!06/13/2014-19:37:55:: i INFO: Dump on: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException,Microsoft.ReportingServices.ReportProcessing.UnhandledReportRenderingException
    library!WindowsService_3!e38!06/13/2014-19:37:55:: i INFO: Do not dump on: System.Threading.ThreadAbortException,System.Web.UI.ViewStateException,System.OutOfMemoryException,System.Web.HttpException,System.IO.IOException,System.IO.FileLoadException,Microsoft.SharePoint.SPException,Microsoft.ReportingServices.WmiProvider.WMIProviderException
    library!WindowsService_3!e38!06/13/2014-19:37:55:: i INFO: Minidump location: C:\Program Files\Microsoft SQL Server\MSRS12.SQLEXPRESS\Reporting Services\Logfiles
    resourceutilities!WindowsService_3!e38!06/13/2014-19:37:56:: i INFO: Reporting Services starting SKU: Developer


    • Edited by Bill St123 Monday, June 16, 2014 2:59 PM
    Saturday, June 14, 2014 1:16 AM