Article - CS357702

User is not created after logging in with SSO on High-Availability Thingworx platform

Modified: 02-Feb-2022   


Applies To

  • ThingWorx Platform 9.0 SP10 to SP14
  • ThingWorx Platform 9.1 SP5 to SP9
  • ThingWorx Platform 9.2 F000 to SP5

Description

  • User is not created after logging in with SSO on High-Availability 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
  • Creation of user entity while logging in with SSO fails with following errors in ErrorLog :
[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)
	[...]
  • Can't log in twice with same user created using SSO auto-provisioning in Thingworx cluster
This is a PDF version of Article CS357702 and may be out of date. For the latest version click https://www.ptc.com/en/support/article/CS357702