40 views

Description

Following an upgrade to Paris upgrade, many 'Unique key violation detected' errors on "INSERT INTO sys_user_unlicensed" can be observed in the [syslog] table.


Here is an example:

Error Exception during statement to xxxxxxxxxxx: INSERT INTO sys_user_unlicensed (`sys_id`,`sys_updated_by`,`license_family`,`attributor_id`,`sys_created_on`,`roles`,`sys_mod_count`,`sys_updated_on`,`entitlement_type`,`user`,`sys_created_by`) VALUES('180296e0dbc86050ee48a155059619d7','system','app_engine_v2','[sys_id for user]','2020-10-21 03:15:37',NULL,0,'2020-10-21 03:15:37','application','3594055737ab3a003f31036754990e23','system'): no thrown error


Error FAILED TRYING TO EXECUTE ON CONNECTION glide.4 (connpid=2522866): INSERT INTO sys_user_unlicensed (`sys_id`,`sys_updated_by`,`license_family`,`attributor_id`,`sys_created_on`,`roles`,`sys_mod_count`,`sys_updated_on`,`entitlement_type`,`user`,`sys_created_by`) VALUES('180296e0dbc86050ee48a155059619d7','system','app_engine_v2','2af092a8db886050ee48a15505961960','2020-10-21 03:15:37',NULL,0,'2020-10-21 03:15:37','application','3[sys_id for user]','system') /* onenccindustry021, gs:glide.scheduler.worker.5, tx:26f09e68db886050ee48a1550596198a */
Unique Key violation detected by database ((conn=2522866) Duplicate entry '3594055737ab3a003f31036754990e23-app_engine_v2' for key 'user')
: com.glide.db.GlideSQLException: FAILED TRYING TO EXECUTE ON CONNECTION glide.4 (connpid=2522866): INSERT INTO sys_user_unlicensed (`sys_id`,`sys_updated_by`,`license_family`,`attributor_id`,`sys_created_on`,`roles`,`sys_mod_count`,`sys_updated_on`,`entitlement_type`,`user`,`sys_created_by`) VALUES('180296e0dbc86050ee48a155059619d7','system','app_engine_v2','2af092a8db886050ee48a15505961960','2020-10-21 03:15:37',NULL,0,'2020-10-21 03:15:37','application','[sys_id for user]','system') /* onenccindustry021, gs:glide.scheduler.worker.5, tx:26f09e68db886050ee48a1550596198a */
Unique Key violation detected by database ((conn=2522866) Duplicate entry '3594055737ab3a003f31036754990e23-app_engine_v2' for key 'user')
: com.glide.db.DBIError.wrapAndThrow(DBIError.java:153)
com.glide.db.DBIError.handleException(DBIError.java:86)
com.glide.db.DBI.executeStatement(DBI.java:1107)
com.glide.db.DBI.executeStatement(DBI.java:1046)
com.glide.db.DBI.executeStatement(DBI.java:1034)

Steps to Reproduce

Upgrade to the Paris release.

Workaround

This problem is currently under review. You can contact ServiceNow Technical Support or subscribe to this Known Error article by clicking the Subscribe button at the top right of this form to be notified when more information will become available.


Related Problem: PRB1446169

Seen In

SR - IRM - Audit Management - New York 2019 Q3
SR - IRM - GRC Profiles - Madrid 2019 Q2
SR - IRM - GRC Workbench - New York 2019 Q3
SR - IRM - Policy and Compliance - Madrid 2019 Q2
SR - IRM - Risk Management - New York 2019 Q3
SR - Security - Integration Framework - Madrid 2019 Q2
SR - Security - Support Common - Madrid 2019 Q2
SR - Security - Support Orchestration - Madrid 2019 Q2
SR - SIR - Security Incident Response - Madrid 2019 Q2
SR - SIR - Security Incident Response PA Content - New York 2019 Q3
SR - SIR - Security Incident Response UI Patch - London 2019 Q2 v.6.2.3
SR - SIR - Store SecOps Setup Assistant - Madrid 2019 Q2
SR - SIR - Store Threat Core - Madrid 2019 Q2
SR - SIR - Store Trusted Security Circles Client - New York 2019 Q3
SR - VR - Qualys - New York 2019 Q3
SR - VR - Vulnerability Response - New York 2019 Q3
SR - VR - Vulnerability Response PA Content - Madrid 2019 Q2

Intended Fix Version

Paris Patch 4
Quebec

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:2020-11-26 12:38:58
Published:2020-11-20