Article - CS357702
User is not created after logging in with Single Sign-On (SSO) when ThingWorx Platform is in High Availability (HA) Mode
Modified: 14-Sep-2023
Applies To
- ThingWorx Platform 9.0 SP10 to SP15
- ThingWorx Platform 9.2 F000 to SP6
- ThingWorx Platform 9.1 SP5 to SP10
- ThingWorx Platform 9.3 F000
Description
- User is not created after logging in with Single Sign-On (SSO) in High-Availability (HA) ThingWorx Platform
- Azure AD with HA and ADFS with HA, User is not created in ThingWorx after logging in
- After enabling SSO a user present in the IdP can log in but the ThingWorx entity for this user is not created : it is present in memory as ghost, but not in the database
- Can't log in twice with same user created using SSO auto-provisioning in ThingWorx cluster
- Creation of user entity while logging in with SSO fails with following errors in ErrorLog.log file located in <ThingworxStorage>\logs:
[L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: ] [S: ] [P: thingworx1] [T: http-nio-8080-exec-4] Could not commit the transaction. Rolling back... java.lang.NullPointerException: null at com.thingworx.persistence.mssql.MssqlSyncLogProvider.insertIntoSyncLog(MssqlSyncLogProvider.java:57) at com.thingworx.persistence.sync.AbstractSyncLogProvider.writeSyncLog(AbstractSyncLogProvider.java:90) at com.thingworx.persistence.ThingworxDefaultTransaction.commitWithSyncLog(ThingworxDefaultTransaction.java:138) [...] [L: ERROR] [O: E.c.q.l.c.Logger] [I: ] [U: ] [S: ] [P: thingworx1] [T: http-nio-8080-exec-4] Error occurred during commit for the ThingworxPersistenceProvider persistence provider. java.lang.NullPointerException: null at com.thingworx.persistence.mssql.MssqlSyncLogProvider.insertIntoSyncLog(MssqlSyncLogProvider.java:57) at com.thingworx.persistence.sync.AbstractSyncLogProvider.writeSyncLog(AbstractSyncLogProvider.java:90) at com.thingworx.persistence.ThingworxDefaultTransaction.commitWithSyncLog(ThingworxDefaultTransaction.java:138) [...]
This is a printer-friendly version of Article 357702 and may be out of date. For the latest version click CS357702