Dynamics Community Forum Thread Details

Data Mart Delay After Year-End Close?

Hello:

For GP 2015 R2, we ran year-end close in four companies and the close was successful. The close occurred, during the day at approximately 5:00PM.

At midnight afterward, Management Reporter's Trial Balance did not show that the balances had rolled forward into the new fiscal year.

But, when the same report was run six hours later, the Trial Balance reported that the balances indeed had rolled forward.

Could there have been simply a delay with Management Reporter's Data Mart?

I did notice from reviewing the Configuration Console's Data Mart Integration Log that many maintenance tasks did not take place until after midnight.

For example, at different points in time after midnight, the log reported that "GL Transaction to Fact" had written many records and in some cases hundreds of thousands of records.

This activity, like I said, occurred after midnight and not before.

Again, could this have been the reason why Management Reporter did not report the balances had rolled forward until later?

Thanks!

John

Hello John:

The configuration Console should have last time everything fully integrated: timestamp

That should tell you if DM has fully caught up. Also, I recently received the below script from our VAR.

The output of the below query will give a clearer picture. This query should be run against the MR database not the DM database.

    select CIG.[Description], STK.[Name], STS.[Progress],
   CASE STS.[StateType]
       WHEN 3 THEN '3-Processing'
       WHEN 5 THEN '5-Complete'
       WHEN 7 THEN '7-Error'
   END AS StateType,
   DATEADD(minute, DATEDIFF(minute,GETUTCDATE(),GETDATE()), STS.[LastRunTime]) as LocalLastRunTime,
   DATEADD(minute, DATEDIFF(minute,GETUTCDATE(),GETDATE()), STS.[NextRunTime]) as LocalNextRunTime,
   STRG.[Interval],
   CASE STRG.[UnitOfMeasure]
       WHEN 1 THEN 'Seconds'
       WHEN 2 THEN 'Minutes'
       WHEN 3 THEN 'Hours'
       WHEN 4 THEN 'Days'
   END AS UnitOfMeasure,
   STRG.[IsEnabled]
   from [Scheduling].[Task] STK with (nolock)
   inner join [Scheduling].[TaskState] STS with (nolock) on STK.[Id] = STS.[TaskId]
   inner join [Connector].[IntegrationGroup] CIG with (nolock) on CIG.[IntegrationId] = STK.[CategoryId]
   inner join [Scheduling].[Trigger] STRG with (nolock) on STK.[TriggerId] = STRG.[Id]
   order by CIG.[Description], STK.[Name]