When searching on the Service Portal, there are multiple entries to the [sp_log] table. This leads to a data integrity issue when the table is reported on (for example, the OOB report "Service Portal Search Terms").

Steps to Reproduce

To make this easier, you may want to delete all records from the 'sp_log' table before performing this test.

  1. Log into an affected instance as a user (or as the System Administrator)
  2. Navigate to Service Portal > Service Portal Home
  3. Click on Knowledge
  4. Enter a search phrase, such as "Microsoft Windows" and press Enter
  5. Navigate to the [sp_log] table (eg: type "sp_log.LIST" in the navigator).
  6. Notice that there are multiple entries for the "type = search" all with letters involved with "Microsoft Windows", as if the search was being entered while typing the actual search query
  7. Now navigate to Service Portal > Usage Overview, and look at the "Service Portal Search Terms". Notice that there are multiple entries for the search even though there was only one actual search for "Microsoft Windows".


This issue has been fixed. If you are able to upgrade, review the Fixed In or Intended Fix Version fields to determine whether any versions have a planned or permanent fix.


Related Problem: PRB1246448

Seen In

There is no data to report.

Intended Fix Version


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:2019-03-06 09:23:56