Notifications

560 views

Description

After an upgrade to London, the LogTransactionMonitor will attempt to log REST transactions (even though they have already been logged) if the transaction deletes a record in a table where deletes are audited. The SQL error traced is the following:

com.glide.db.GlideSQLException: FAILED TRYING TO EXECUTE ON CONNECTION 11: INSERT INTO syslog_transaction0000
...
Unique Key violation detected by database (Duplicate entry '04cefb3387a113002ae97e2526cb0b7b' for key 'PRIMARY')
 

Steps to Reproduce

  1. Login a London instance as administrator.
  2. Import the attached UI Action.
  3. Execute the UI Action from an incident in Workspace or directly through the REST API /api/now/ui/ui_action/242ebf3387a113002ae97e2526cb0bab.
  4. Notice the primary key exception on INSERT INTO SYSLOG_TRANSACTION.

Workaround

This issue will be fixed in the Madrid release. The error can be ignored in London as it does not block or affect any functionality.


Related Problem: PRB1273339

Seen In

There is no data to report.

Intended Fix Version

London Patch 6
Madrid

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-01-17 11:36:58
Published:2018-12-03