Product documentation Docs
    • English
    • Deutsch
    • 日本語
    • 한국어
    • Français
  • More Sites
    • Now Community
    • Developer Site
    • Knowledge Base
    • Product Information
    • ServiceNow.com
    • Training
    • Customer Success Center
    • ServiceNow Support Videos
  • Log in

Product documentation

  • Home
How search works:
  • Punctuation and capital letters are ignored
  • Special characters like underscores (_) are removed
  • Known synonyms are applied
  • The most relevant topics (based on weighting and matching to search terms) are listed first in search results
Topics are ranked in search results by how closely they match your search terms
  • A match on the entire phrase you typed
  • A match on part of the phrase you typed
  • A match on ALL of the terms in the phrase you typed
  • A match on ANY of the terms in the phrase you typed

Note: Matches in titles are always highly ranked.

  • Release version
    Table of Contents
    • Analytics, Intelligence, and Reporting
Table of Contents
Choose your release version
    Home Madrid Analytics, Intelligence, and Reporting Analytics, Intelligence, and Reporting Performance Analytics Performance Analytics data architecture Migrating Performance Analytics scores

    Migrating Performance Analytics scores

    • Save as PDF Selected topic Topic & subtopics All topics in contents
    • Unsubscribe Log in to subscribe to topics and get notified when content changes.
    • Share this page

    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

    1. Navigate to Performance Analytics > Scores Migration Monitor.
    2. 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.
    3. (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.

    Tags:

    Feedback
    On this page

    Previous topic

    Next topic

    • Contact Us
    • Careers
    • Terms of Use
    • Privacy Statement
    • Sitemap
    • © ServiceNow. All rights reserved.

    Release version
    Choose your release version

      Migrating Performance Analytics scores

      • Save as PDF Selected topic Topic & subtopics All topics in contents
      • Unsubscribe Log in to subscribe to topics and get notified when content changes.
      • Share this page

      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

      1. Navigate to Performance Analytics > Scores Migration Monitor.
      2. 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.
      3. (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.

      Tags:

      Feedback

          Share this page

          Got it! Feel free to add a comment
          To share your product suggestions, visit the Idea Portal.
          Please let us know how to improve this content

          Check any that apply

          To share your product suggestions, visit the Idea Portal.
          Confirm

          We were unable to find "Coaching" in Jakarta. Would you like to search instead?

          No Yes
          • Contact Us
          • Careers
          • Terms of Use
          • Privacy Statement
          • Sitemap
          • © ServiceNow. All rights reserved.

          Subscribe Subscribed Unsubscribe Last updated: Tags: January February March April May June July August September October November December No Results Found Versions Search preferences successfully updated My release version successfully updated My release version successfully deleted An error has occurred. Please try again later. You have been unsubscribed from all topics. You are now subscribed to and will receive notifications if any changes are made to this page. You have been unsubscribed from this content Thank you for your feedback. Form temporarily unavailable. Please try again or contact  docfeedback@servicenow.com  to submit your comments. The topic you requested does not exist in the release. You were redirected to a related topic instead. The available release versions for this topic are listed There is no specific version for this documentation. Explore products Click to go to the page. Release notes and upgrades Click to open the dropdown menu. Delete Remove No selected version Reset This field is required You are already subscribed to this topic Attach screenshot The file you uploaded exceeds the allowed file size of 20MB. Please try again with a smaller file. Please complete the reCAPTCHA step to attach a screenshot
          Log in to personalize your search results and subscribe to topics
          No, thanks Login