Solución nº - CS357702

User is not created after logging in with Single Sign-On (SSO) when ThingWorx Platform is in High Availability (HA) Mode

Modificado: 14-Sep-2023   


Se aplica a

  • 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

Descripción

  • 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 PDF version of Article 357702 and may be out of date. For the latest version CS357702