web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
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 2

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

I have the same question (0)
  • Community Member Profile Picture
    Community Member 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

  • Reyaz@Alfa Profile Picture
    Reyaz@Alfa 2 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 on at
    RE: Management reporter CU11 Abnormal growth for TempDB

    which task and do you know that ?

  • Reyaz@Alfa Profile Picture
    Reyaz@Alfa 2 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 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

  • Community Member Profile Picture
    Community Member 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

  • Reyaz@Alfa Profile Picture
    Reyaz@Alfa 2 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. 

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

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Pallavi Phade – Community Spotlight

We are honored to recognize Pallavi Phade as our Community Spotlight honoree for…

Congratulations to the October Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 3

#3
Willem van Duren Profile Picture

Willem van Duren 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans