Hello,

a six servers configuration for Forefront Client Security:

Database Collection Server: OnePoint: All SQL jobs ok (e.g.: reindex done this morning)

Database Reporting Server: SystemCenterReporting: All SQL Jobs ok (+ SystemCenterDTSPackageTask successfully done 1:00 a.m.)

Collection Server: services are running fine

Management Server: Dashboard missing 14-Day Histroy for the past 13 days... 

Distribution Server: ok

Where to look why the 14-day history is not populated as the DTS task is running successfully daily...?

Thanks,

Hi,

There is no error just "No Data"

The dashboard is properly displayed once in a while for 7-15 days then it fails again and again...

Thanks,

Hi,

Are there any errors when you display the report?

Please have a look on the following links.

http://technet.microsoft.com/en-us/library/bb418961.aspx#FourteenDayHistory

http://social.technet.microsoft.com/Forums/en-US/3d43a749-b73b-4cae-85f6-1462377816b3/fcs-report-not-being-displayed?forum=Forefrontclientreporting

Best Regards,

Joyce

Hi,

Please check event log to confirm DataTransformationServices works fine.

You could also check the Scheduled Tasks to make sure SystemCenterDTSPackageTask is running.

For more information: http://social.technet.microsoft.com/Forums/forefront/en-US/5b011497-62d8-4bb3-90b6-00352e1ffb8b/forefront-14day-history?forum=Forefrontclientreporting

Best Regards,

Joyce

Hello,

The execution of the following DTS Package succeeded: 

Package Name: Microsoft Forefront Client Security
Package Description: Microsoft Forefront Client Security DTS
Package ID: {4589F8C7-17D3-4A87-BB5B-0DBF47B6D00A}
Package Version: {4CEED116-EDE0-4069-90A7-2ADA6F9FAEF6}
Package Execution Lineage: {21B7837D-075E-4B9B-A11F-E1BF3F55934B}
Executed On: SOPFCSRS1
Executed By: svcFFCS
Execution Started: 5/15/2014 1:15:01 AM
Execution Completed: 5/15/2014 1:15:32 AM
Total Execution Time: 31.466 seconds

Package Steps execution information:


Step 'DTSStep_DTSTransferObjectsTask_1' succeeded
Step Execution Started: 5/15/2014 1:15:01 AM
Step Execution Completed: 5/15/2014 1:15:02 AM
Total Step Execution Time: 1.077 seconds
Progress count in Step: 0

Step 'DTSStep_DTSTransferObjectsTask_3' succeeded
Step Execution Started: 5/15/2014 1:15:02 AM
Step Execution Completed: 5/15/2014 1:15:32 AM
Total Step Execution Time: 29.593 seconds
Progress count in Step: 0

Step 'DTSStep_DTSExecuteSQLTask_1' succeeded
Step Execution Started: 5/15/2014 1:15:32 AM
Step Execution Completed: 5/15/2014 1:15:32 AM
Total Step Execution Time: 0.141 seconds
Progress count in Step: 0

Step 'DTSStep_DTSDynamicPropertiesTask_1' succeeded
Step Execution Started: 5/15/2014 1:15:01 AM
Step Execution Completed: 5/15/2014 1:15:01 AM
Total Step Execution Time: 0.047 seconds
Progress count in Step: 0

Step 'DTSStep_DTSExecuteSQLTask_2' succeeded
Step Execution Started: 5/15/2014 1:15:01 AM
Step Execution Completed: 5/15/2014 1:15:01 AM
Total Step Execution Time: 0.343 seconds
Progress count in Step: 0

Step 'DTSStep_DTSExecuteSQLTask_3' succeeded
Step Execution Started: 5/15/2014 1:15:32 AM
Step Execution Completed: 5/15/2014 1:15:32 AM
Total Step Execution Time: 0.187 seconds
Progress count in Step: 0 

Apparently the DataTransformationServices works fine...

Scheduled Task:

the job is running no problem

Thanks,

Dom

Hi,

Have you resolved this problem?

Best Regards,

Joyce

Hi,

No the issue is still here!

Thanks,