Reconnecting Disconnected Principals in Windchill via SQL Script

最新推荐文章于 2024-08-30 09:24:48 发布

原创最新推荐文章于 2024-08-30 09:24:48 发布 · 267 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#SQL #SQL Server #UP

Windchill 专栏收录该内容

31 篇文章

订阅专栏

本文详细介绍了如何通过获取离线原则的IDA2A2号，使用特定脚本来更新WTU表中记录的状态，从而解决Windchill系统中离线原则的问题。操作包括获取IDA2A2、更新离线状态为非离线，并刷新离线原则页面以消除离线原则。定期检查可以避免系统异常行为。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

If you have your Windchill server instance setup to authenticate users against your Active Directory (AD) you will need to keep an eye on your disconnected principals (Site – Utilities – Principal Administrator – Maintenance). Disconnected principals are AD accounts that have been deleted or disabled, and Windchill is letting you know that it is unable to associate records in the WTUser table to an active AD account.

If this que is left untouched it can cause your system to behave abnormally. So it’s a good thing to check this que at least once a week. If you are seeing accounts showing up here that means that their AD accounts have been either deleted or disabled. In the past I have seen Windchill mark an active account as being a disconnected principal. The following steps will help you resolve this issue.

First, you will need to get the idA2A2 number of the account in questions. The idA2A2 is the unique identifier for each record in the WTUser table. The following script will get you the idA2A2 for the records in question:
```
select idA2A2,name, repairNeeded from wtuser.WTUser
where repairNeeded = 1
```
The results from the script should match what is showing from the principal pal administrator screen.
Now to update the record so that it’s not longer a disconnected principal.This script will update record in the WTUser table to no longer be a disconnected principal:
```
update wtuser.WTUser
set
repairNeeded = 0
where idA2A2 = idA2A2_from_previous_script
```

After the script is executed refresh the disconnected principals page in Windchill. The account in question should disappear. repeat the update script for each disconnected principal that you wish to correct.