Notifications

70 views

Description

The job should NOT be executed after going live with the Benchmark application. the historical collection and the copy job should be executed only when the KPIs are updated before going live and need to update the Bechmark dashboard before the Global scores are downloaded at 11th of each moth.

After executing the 'Benchmark Historical Data Collection' collection job, it is necessary to run 'Copy historical scores from PA to Benchmarks table' to reflect the updated scores on the benchmark dashboard.

'Copy historical scores from PA to Benchmarks table' will not work unless the

invalid start date in customer scores for indicator : ee6d8347536003000d620d0323dc34db

Steps to Reproduce

1- Execute 'Benchmark Historical Data Collection' collection job after making changes to the benchmark KPIs
2- Confirm the scores changed from Analytics Hub of the indicator(s)
3- Run the 'Copy historical scores from PA to Benchmarks table' job:
https://<instance_name>.service-now.com/nav_to.do?uri=sysauto_bm_script.do?sys_id=528c78655b551300514d484c11f91aeb
4- Observe errors from the localhost logs:
invalid start date in customer scores for indicator : ee6d8347536003000d620d0323dc34db
5- The Benchmark dashboard does not show the latest scores.

Expected results = The job should copy the PA scores to benchmark table so the Benchmark dashboard shows the updated scores.

Workaround

The workaround is setting the time zone of System Administrator user as GMT and execute the job. The job will copy the PA scores and update the Benchmark dashboard.


Related Problem: PRB1419330

Seen In

Orlando Patch 4
SR - IRM - Audit Management - New York 2019 Q3
SR - IRM - Audit Management PA Content - Madrid 2019 Q1
SR - IRM - GRC Profiles - Madrid 2019 Q2
SR - IRM - PA Premium Integration - New York 2019 Q3
SR - IRM - Policy and Compliance - Madrid 2019 Q2
SR - IRM - Policy and Compliance PA Content - Madrid 2019 Q1
SR - IRM - Risk Management - New York 2019 Q3
SR - IRM - Risk Management PA Content - Madrid 2019 Q1
SR - IRM - Vendor Risk Management - Madrid 2019 Q1
SR - ITOM - CMDB CI Class Models - 201909
SR - ITOM - Discovery and Service Mapping - 201908

Intended Fix Version

Quebec

Safe Harbor Statement

This "Intended Fix Version" information is meant to outline ServiceNow's general product direction and should not be relied upon in making a purchasing decision. The information provided here is for information purposes only and may not be incorporated into any contract. It is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described for our products remains at ServiceNow's sole discretion.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2020-09-11 12:57:15
Published:2020-08-12