Potentially there was an issue with the one of the 9 functions updating the data mart integration. To verify the last time all of the process completed open the Configuration Console and select the integration and verify the 'last time everything was fully integrated' data. If the date has not updated and is over three days old there is potential for data not to update correctly in the data mart database.
In the Configuration Console > Logs data mart integration review the logs for any error messages that could be contributing to the issue. You could also run the following script against the Management Reporter database.
select CIG.[Description]
, ST.[Name]
, SM.[Text]
, DATEADD(minute, DATEDIFF(minute,GETUTCDATE(),GETDATE()), SL.[StartTime]) as LocalStartTime
, DATEADD(minute, DATEDIFF(minute,GETUTCDATE(),GETDATE()), SL.[EndTime]) as LocalEndTime
, SL.[TotalRetryNumber]
, SL.[IsFailed]
, STT.[Name] as TaskType
from [Scheduling].[Log] SL with (nolock)
inner join [Scheduling].[Task] ST with (nolock) on SL.TaskId = ST.Id
inner join [Scheduling].[Message] SM with (nolock) on SL.Id = SM.LogId
inner join [Scheduling].[TaskType] STT with (nolock) on ST.TypeId = STT.Id
inner join [Connector].[IntegrationGroup] CIG with (nolock) on CIG.[IntegrationId] = ST.[CategoryId]
order by SL.[StartTime] desc
Below is a SQL query that will help verify the current data mart process when ran against the Management Reporter database. The state Type of 3 mean the function is currently in progress and 5 mean it is complete.
select [Connector].[IntegrationGroup].[Description], [Scheduling].[Task].[Name],
[Scheduling].[TaskState].[Progress], [Scheduling].[TaskState].[StateType],
[Scheduling].[TaskState].[LastRunTime], [Scheduling].[TaskState].[NextRunTime],
[Connector].[Map].[ContinueOnRecordError], [Scheduling].[Trigger].[UnitOfMeasure],
[Scheduling].[Trigger].[Interval], [Scheduling].[Trigger].[IsEnabled]
from [Connector].[Map] with (nolock)
inner join [Scheduling].[Task] on [Scheduling].[Task].[Id] = [Connector].[Map].[MapId]
inner join [Scheduling].[TaskState] on [Scheduling].[Task].[Id] = [Scheduling].[TaskState].[TaskId]
inner join [Connector].[IntegrationGroup] on [Connector].[IntegrationGroup].[IntegrationId] = [Scheduling].[Task].[CategoryId]
inner join [Scheduling].[Trigger] on [Scheduling].[Task].[TriggerId] = [Scheduling].[Trigger].[Id]
order by [Connector].[IntegrationGroup].[Description], [Scheduling].[Task].[Name]
