12-Amethyst

Question

What tables are updated when adding a new user

Forum|Forum|1 year ago
October 8, 2024
5 replies
2750 views

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.

M

mmeadows-3

16-Pearl

Please refer to knowledge base article CS109367.

C

CraigFinney

Author

12-Amethyst

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.

S

STEVEG

21-Topaz I

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

23-Emerald I

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.

C

CraigFinney

Author

12-Amethyst

Does not show up.

HelesicPetr

22-Sapphire II

Hi @CraigFinney

I would like to just say that if you use external LDAP then you should create the user in that LDAP like ActiveDirecotry.

The Windchill side is just read-only and you can not create the user from Windchill side

I can be wrong if you allow Windchill to change the AD side but it is not common from my expereience.

PetrH

C

CraigFinney

Author

12-Amethyst

The company policy is to create the external login (AD / :LDAP), and we sync Windchill to that login (I would be the last in about 20 to 30 steps) . When the method server stopped responding, I was in the middle of creating the windchill login that would sync with it, so only 1/2 the tables got updated. I cannot find the user to complete the update, and I cannot create it as new as some tables have it. I just need to know all the tables that are updated when creating the login ID within Windchill (tables in Windchill and tables in the DB).

M

mmeadows-3

16-Pearl

If you are fully integrated with the corporate LDAP, then your first step in Windchill is to assign the new user a license. Windchill reads the new user from the corporate LDAP and populates the tables shown in CS109367,

Sound like maybe you are using a local LDAP (OpenDJ/Windchill DS) for defining participants in Windchill (populating the database tables) and using the corporate LDAP with Apache for authentication only. Is that correct?

Follow CS109367 and define the database queries to track down the incomplete user account. You can also run WinDU to investigate participant issues.

Invalid Ldap Entries
Validate Users, Groups and Organizations in the DB and in LDAP
Verifies All Principals Domain

D

d_graham

18-Opal

@CraigFinney ,

Can tell us what tables you have already checked so that we don't suggest checking table X when you have already checked table X?

C

CraigFinney

Author

12-Amethyst

I think we check the wt.user table. but I am not 100% sure. When I go to load the user ID, as a Participant, I get a not found. When I attempt to create it, I get a Not Unique login ID. I cannot find it to fix it or delete it, but I cannot create over it.

D

d_graham

18-Opal

I've always wanted a tool that could search tables and columns to find a value.

This post motivated me to finally to write it.

I did filter the column name to search only columns with CLASSNAMEKEY in their name.

This limited to the search to a mere 1122 columns.

Of those there are 34 tables with a column where the value of the column equaled the search String, wt.org.WTUser.

Who knew? 😊

See image below.