Home Madrid Analytics, Intelligence, and Reporting Analytics, Intelligence, and Reporting Performance Analytics Performance Analytics data architecture Migrating Performance Analytics scores

Migrating Performance Analytics scores

The Performance Analytics Scores [pa_scores] table was split into two tables. This structure helps with processing large numbers of scores. You can migrate your scores from the old table structure to the new, using the score migration tool.

Warning: The new table structure is not supported on Oracle databases.

In Istanbul, the Scores [pa_scores] table was split into Scores Level 1 [pa_scores_l1] and Scores Level 2 [pa_scores_l2]. The pa_scores_l2 table contains the second-level breakdown matrix of scores and the pa_scores_l1 table contains all other scores. This separation of scores 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.

Instances created prior to Istanbul still use the original Scores [pa_scores] table after upgrading. However, you can migrate your scores on these instances to the new scores tables. Your instance must be on a release that supports the scores migration tool, as follows:

London, with patch 10
Madrid, with patch 6
All New York and later releases

Migration Monitor

After beginning the migration, you can track the migration status by navigating to Performance Analytics > Scores Migration Monitor.

If any errors occur during migration, contact ServiceNow Technical Support to resolve the issue.

Delays in starting score migration

If any of the following processes are running, score migration remains in the Waiting state until they stop:

Data collector jobs
Collection cleaner jobs
Scoresheet editing

Schedule the Performance Analytics scores migration

Schedule the automated migration process to move existing scores to the new table structure.

Before you begin

Role required: admin. Users with the pa_admin role can view the migration monitor page but cannot schedule the migration.

About this task

Migrating scores improves performance and scalability of Performance Analytics. Migration should be performed during off-peak hours.

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.

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.
The original Scores [pa_scores] table is truncated 10 days after successful migration.

Procedure

Navigate to Performance Analytics > Scores Migration Monitor.
Click the Schedule Scores Migration button.
If there are greater than 300 million scores on the instance, the button is disabled. Contact ServiceNow Technical Support to begin the scores migration.

The scores migration is scheduled. The page displays the time that the migration is scheduled to start, and the estimated completion time.
(Optional) Click the Logs or Active Jobs links to view additional information about the migration.
If there are any data collection or cleanup jobs running when you start the migration, the migration waits for those jobs to complete before beginning. All scheduled collection and cleanup jobs are paused during the migration.

What to do next

If the migration fails for any reason, contact ServiceNow Technical Support for assistance. Existing scores remain in place.

Previous topic

Next topic

Release version

Migrating Performance Analytics scores

Warning: The new table structure is not supported on Oracle databases.

London, with patch 10
Madrid, with patch 6
All New York and later releases

Migration Monitor

After beginning the migration, you can track the migration status by navigating to Performance Analytics > Scores Migration Monitor.

If any errors occur during migration, contact ServiceNow Technical Support to resolve the issue.

Delays in starting score migration

If any of the following processes are running, score migration remains in the Waiting state until they stop:

Data collector jobs
Collection cleaner jobs
Scoresheet editing

Schedule the Performance Analytics scores migration

Schedule the automated migration process to move existing scores to the new table structure.

Before you begin

Role required: admin. Users with the pa_admin role can view the migration monitor page but cannot schedule the migration.

About this task

Migrating scores improves performance and scalability of Performance Analytics. Migration should be performed during off-peak hours.

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.
The original Scores [pa_scores] table is truncated 10 days after successful migration.

Procedure

Navigate to Performance Analytics > Scores Migration Monitor.
Click the Schedule Scores Migration button.
If there are greater than 300 million scores on the instance, the button is disabled. Contact ServiceNow Technical Support to begin the scores migration.

The scores migration is scheduled. The page displays the time that the migration is scheduled to start, and the estimated completion time.
(Optional) Click the Logs or Active Jobs links to view additional information about the migration.
If there are any data collection or cleanup jobs running when you start the migration, the migration waits for those jobs to complete before beginning. All scheduled collection and cleanup jobs are paused during the migration.

What to do next

If the migration fails for any reason, contact ServiceNow Technical Support for assistance. Existing scores remain in place.

How search works:

Topics are ranked in search results by how closely they match your search terms

Migrating Performance Analytics scores

Migrating Performance Analytics scores

Migration Monitor

Delays in starting score migration

Schedule the Performance Analytics scores migration

On this page

Migrating Performance Analytics scores

Migrating Performance Analytics scores

Migration Monitor

Delays in starting score migration

Schedule the Performance Analytics scores migration

Log in to personalize your search results and subscribe to topics