Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Management reporter CU...
Microsoft Dynamics AX (Archived)

Management reporter CU11 Abnormal growth for TempDB

(0) ShareShare
ReportReport
Posted on by Reyaz@Alfa 467

Hi All,

I have been rebuilding data mart  version CU11 but failed because ofinsufficient disk space for TempDB. I already have allocated 250 GB diskspace for TempDB.  i couldn't get any reason for that. Please help

*This post is locked for comments

  • Reyaz@Alfa Profile Picture
    Reyaz@Alfa 467 on at
    RE: Management reporter CU11 Abnormal growth for TempDB

    Hi Matt,

    I ran the query that is showing some job processing continuously but nothing found that cause tempDB abnormal growth. 

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management reporter CU11 Abnormal growth for TempDB

    My point i guess is to find what is causing the issue rather than just seeing the problem. For that, I recommend to check what is currently running management reporter and what it is running in tempdb and do a correlation. Maybe you actually found the query, so then can you try to run it manually and see if it executes quickly

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management reporter CU11 Abnormal growth for TempDB

    Please use this query to find which management reporter task is continuously running :

    SELECT CIG.[Description]

    , T.Name

    , CASE TS.StateType

    WHEN 3 THEN 'PROCESSING'

    WHEN 5 THEN 'COMPLETE'

    WHEN 7 THEN 'ERROR'

    ELSE Convert(varchar(max),TS.StateType)

    END AS StateType

    , TS.Progress

    , TR.Id AS TriggerId

    , CASE TR.IsEnabled

    WHEN 1 THEN 'ENABLED'

    WHEN 0 THEN 'DISABLED'

    ELSE Convert(varchar(max),TR.IsEnabled)

    END AS TriggerStatus

    , TR.Interval

    , CASE TR.UnitOfMeasure

    WHEN 4 THEN 'DAYS'

    WHEN 3 THEN 'HOURS'

    WHEN 2 THEN 'MINUTES'

    WHEN 1 THEN 'SECONDS'

    ELSE Convert(varchar(max),TR.UnitOfMeasure)

    END AS IntervalTiming

    , DATEADD(minute, DATEDIFF(minute,GETUTCDATE(),GETDATE()), TS.[LastRunTime]) as LocalLastRunTime

    , DATEADD(minute, DATEDIFF(minute,GETUTCDATE(),GETDATE()), TS.[NextRunTime]) as LocalNextRunTime

    --, TS.[LastRunTime] as UTCLastRunTime

    --, TS.[NextRunTime] as UTCNextRunTime

    FROM Scheduling.Task T with (nolock)

    JOIN Scheduling.TaskState TS with (nolock) ON T.Id = TS.TaskId

    JOIN Scheduling.[Trigger] TR with (nolock) ON TR.Id = T.TriggerId

    JOIN Connector.IntegrationGroup CIG with (nolock) on CIG.[IntegrationId] = T.CategoryId

    WHERE T.TypeId in ('55D3F71A-2618-4EAE-9AA6-D48767B974D8', '6F6B935B-FC0A-46B9-8F53-27C6AF7437F0', 'D81C1197-D486-4FB7-AF8C-078C110893A0')

    ORDER BY CIG.[Description], T.Name

  • Reyaz@Alfa Profile Picture
    Reyaz@Alfa 467 on at
    RE: Management reporter CU11 Abnormal growth for TempDB

    Hi Matt,

    Not sure, but the below one could be one of the query.

    System.AggregateException: One or more errors occurred. ---> System.Data.SqlClient.SqlException: A severe error occurred on the current command.  The results, if any, should be discarded.

    A severe error occurred on the current command.  The results, if any, should be discarded.

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    select * into #extraCombos

    from DimensionCombinationStaging dcs

    where Id not in (select Id from DimensionCombination)

    and Id not in (select Id from DimensionCombinationResolving)

    and Id not in (select Id from DimensionCombinationUnreferenced)

    truncate table DimensionCombinationStaging

    insert into DimensionCombinationStaging with (TABLOCK)

    select * from #extraCombos

    where FreshnessDate >= DATEADD(hh, -4, SYSUTCDATETIME())

    or SourceKey in (Select distinct DimensionsKey from FactStaging)

    insert into DimensionCombinationArchive with (TABLOCK)

    select * from #extraCombos

    where FreshnessDate < DATEADD(hh, -4, SYSUTCDATETIME())

    and SourceKey not in (Select distinct DimensionsKey from FactStaging)

    drop table #extraCombos

      at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

      at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

      at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

      at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)

      at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)

      at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

      at Microsoft.Dynamics.Performance.DDM.SqlUtility.ExecuteSql(String sql)

      at System.Threading.Tasks.Parallel.<>c__DisplayClassf`1.<ForWorker>b__c()

      at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)

      at System.Threading.Tasks.Task.<>c__DisplayClass11.<ExecuteSelfReplicating>b__10(Object param0)

      --- End of inner exception stack trace ---

      at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)

      at System.Threading.Tasks.Task.Wait()

      at System.Threading.Tasks.Parallel.ForWorker[TLocal](Int32 fromInclusive, Int32 toExclusive, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Func`4 bodyWithLocal, Func`1 localInit, Action`1 localFinally)

      at System.Threading.Tasks.Parallel.ForEachWorker[TSource,TLocal](IEnumerable`1 source, ParallelOptions parallelOptions, Action`1 body, Action`2 bodyWithState, Action`3 bodyWithStateAndIndex, Func`4 bodyWithStateAndLocal, Func`5 bodyWithEverything, Func`1 localInit, Action`1 localFinally)

      at System.Threading.Tasks.Parallel.ForEach[TSource](IEnumerable`1 source, Action`1 body)

      at Microsoft.Dynamics.Performance.DDM.SqlUtility.ExecuteSqlInParallel(IEnumerable`1 parallelSql)

      at Microsoft.Dynamics.Performance.DDM.FactLoader.ProcessStagedData(String connectionString)

      at Microsoft.Dynamics.Integration.Adapters.DimensionalDataMart.DataMartAdapter.RunMaintenance()

      at Microsoft.Dynamics.Integration.Service.Tasks.MaintenanceTask.RunImplementation()

    ---> (Inner Exception #0) System.Data.SqlClient.SqlException (0x80131904): A severe error occurred on the current command.  The results, if any, should be discarded.

    A severe error occurred on the current command.  The results, if any, should be discarded.

    DBCC execution completed. If DBCC printed error messages, contact your system administrator.

    select * into #extraCombos

    from DimensionCombinationStaging dcs

    where Id not in (select Id from DimensionCombination)

    and Id not in (select Id from DimensionCombinationResolving)

    and Id not in (select Id from DimensionCombinationUnreferenced)

    truncate table DimensionCombinationStaging

    insert into DimensionCombinationStaging with (TABLOCK)

    select * from #extraCombos

    where FreshnessDate >= DATEADD(hh, -4, SYSUTCDATETIME())

    or SourceKey in (Select distinct DimensionsKey from FactStaging)

    insert into DimensionCombinationArchive with (TABLOCK)

    select * from #extraCombos

    where FreshnessDate < DATEADD(hh, -4, SYSUTCDATETIME())

    and SourceKey not in (Select distinct DimensionsKey from FactStaging)

    drop table #extraCombos

      at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)

      at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)

      at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)

      at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)

      at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)

      at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

      at Microsoft.Dynamics.Performance.DDM.SqlUtility.ExecuteSql(String sql)

      at System.Threading.Tasks.Parallel.<>c__DisplayClassf`1.<ForWorker>b__c()

      at System.Threading.Tasks.Task.InnerInvokeWithArg(Task childTask)

      at System.Threading.Tasks.Task.<>c__DisplayClass11.<ExecuteSelfReplicating>b__10(Object param0)

    ClientConnectionId:55e5d39d-11f5-4b94-a779-0a0cddb947ab<---

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management reporter CU11 Abnormal growth for TempDB

    which task and do you know that ?

  • Reyaz@Alfa Profile Picture
    Reyaz@Alfa 467 on at
    RE: Management reporter CU11 Abnormal growth for TempDB

    Hi Matt,

    it is management reporter maintenance task that is filling the tempdb in abnormal way.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management reporter CU11 Abnormal growth for TempDB

    I had a similar issue in the past. First, find the query that it's filling your tempdb

    dba.stackexchange.com/.../how-to-identify-which-query-is-filling-up-the-tempdb-transaction-log

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,188 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,030 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans