Beginning with the Istanbul release, the Performance Analytics Scores [pa_scores] table
was split into two tables, Scores Level 1 [pa_scores_l1] and Scores Level 2
[pa_scores_l2].
This change ensures optimal performance when collecting and analyzing scores, and enables
larger sets of scores. New instances created on the Istanbul release or later use the new scores
tables by default.
For instances created prior to
Istanbul,
you can migrate your existing data to the new scores tables. The original Scores [pa_scores]
table is truncated 10 days after successful migration.
Note: The scores migration can take several
hours to complete, depending on the number of scores. Schedule the migration in a non-production
instance and then carefully plan the migration in production.
During migration you cannot
collect, modify, or delete scores. Scheduled data collection jobs do not run during migration.
After migration completes, check any data collection jobs that were scheduled to run during the
migration, as these jobs were suspended.
Migration Monitor
After beginning the migration, you can track the migration status by navigating to
If any errors occur during migration, contact ServiceNow Customer Support to resolve the issue.
Delays in starting score migration
If any of the following processes are running, score migration does not begin until they
stop:
- Data collector jobs
- Collection cleaner jobs
- Scoresheet editing
