What tables are updated when adding a new user

[CraigFinney]

Version: Windchill 12.0

Use Case: Background method server died just as I was in the middle of creating a new Windchill login.

Description:

A while back, the background method server died just as I was in the middle of creating a new user. This resulted in not being able to find the user since it was not completely created and cannot create the user as it already exists.

We have a external LDAP for logging into our windchill and oracle DB for primary object storage.

What DB tables are updated when we create a new user? I suspect there is more than one. We attempted to remove the user from one table, but it did not make a difference.

[mmeadows-3]

Please refer to knowledge base article CS109367.

[CraigFinney]

These tables we checked, and we removed from the user table, but still having the same issue.   I cannot create new, nor can I find the user to edit.

[STEVEG]

Then you might need to get PTC support.  I don't know if there is anyone on this forum that will want to risk trying to help with the chance of messing up your tables.

[avillanueva]

What does your disconnected principals report look like? Is it showing that user?  Surprised that the transaction did not roll back when the crash occurred. You say that you cannot make any changes to any user? I suspect that the DB still has a lock on that table somehow.