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:
Steps to Reproduce
- Login a London instance as administrator.
- Import the attached UI Action.
- Execute the UI Action from an incident in Workspace or directly through the REST API /api/now/ui/ui_action/242ebf3387a113002ae97e2526cb0bab.
- Notice the primary key exception on INSERT INTO SYSLOG_TRANSACTION.
This issue is fixed in London Patch 6 and Madrid. The error can be ignored in London as it does not block or affect any functionality.
Related Problem: PRB1273339