- 浏览: 118416 次
- 性别:
- 来自: 武汉
最新评论
This past weekend I spent about 25 plus hours rehosting a production Windchill server to an identical development Windchill server. One of the last steps in cleaning up the rehost procedure is removing valuted items out of the database for replica sites. This needs to be done before you can remove all replica servers that are not being used. Typically, you aren't going to have replica servers talking to your development environment. Plus this helps keep your Windchill logs from getting cluttered with uneccesary errors and warnings.
Before you begin the SQL statement below is for MS SQL 2005 or MS SQL 2008. Also, remember that due to the settings of the Windchill database the column and table names are case sensitive.
-
Idenitfy if your database has a scheme
- By default the scheme is wtuser, but can be set to anything when the database is created
-
Run the following SQL script to get your vault names
select * from schemename.ReplicaVault
-
Open up a new script window, and run the following script to see which vaults have vaulted files
select idA2A2 from schemename.ReplicaFolder where idA3A5 in (select idA2A2 from schemename.ReplicaVault where name ='vault_name_from_query_above')
-
Make note of the vaults that return a number from the query above, and
then run the following script to delete from records from the database:
delete from schemename.MasteredonReplicaItem where idA3A4 in (select idA2A2 from schemename.ReplicaFolder where idA3A5 in (select idA2A2 from schemename.ReplicaVault where name ='vault_name_with_records_from_step_2'))
- After this is complete you can now remove the sites from the Sites administration from within Windchill. This is not an approved process by PTC, but I have worked with PTC's tech support to come up with this solution.
发表评论
-
How to deactivate a user in Windchill?
2012-10-17 22:09 976Introduction Procedure base ... -
How to shorten display time for the inline message in Windchill 10.0
2012-09-03 00:24 1178标题 How to shorten display ... -
How to perform SaveAs on WTPart using API in Windchill PDMLink 10.0
2012-04-05 18:38 1536标题 How to perform SaveAs ... -
Manual Installation Steps For Archive Client Installation on Red Hat Linux 4.0
2012-03-31 19:18 978On Red hat Linus 4.0 (64-Bit), ... -
Windchill单点登录方案
2012-03-31 00:20 3036Windchill SSO 单点登录 可下载附件查看。 ... -
如何在Windchill PDMLink 9.1设定多个Background Method Server去执行特定的工作流
2012-03-31 00:17 2663标题 如何在Windchill PDMLink 9.1 ... -
通过IE8访问Windchill PDMLink 10.0,出现警告提示"Windchill 只支持标准模式下的浏览器".
2012-03-31 00:15 3039标题 通过IE8访问Windchill PDMLink ... -
JSP Authentication with the Method Server
2012-02-07 20:31 3059During development for a cus ... -
Solution for searching the latest revision object
2012-02-01 11:44 1017// Implement your query ... -
Solution for search object with IBA Attribute
2012-02-01 11:39 1473QuerySpec qs = new Quer ... -
Required Ports for Windchill
2011-10-29 18:53 1049Windchill utilizes multiple por ... -
[WIP] How to see the document creator full name instead of the login name in DTI
2011-09-07 14:23 853标题 [WIP] How to see the doc ... -
Windchill Project Daily Build
2011-08-26 22:54 683下载软件: ant svnant sliksvn htt ... -
How to set schedule for Synchronization from Replica to Master?
2011-08-23 10:17 1079To do this, please follow these ... -
copy user from team administrator to workflow team.
2011-07-16 12:14 1643The code can be used directly i ... -
How to Disallow Anonymous Access to Aphelion LDAP?
2011-06-12 17:34 1649Description This TPI add ... -
MethodServer Exits Prematurely With the Error *com.ptc.windchill.upgrade.history
2011-06-11 23:39 2898Description ---------------- ... -
从Aphelion迁移至WindchillDS
2011-06-11 23:00 923假设: 1. Aphelion ... -
How to Configure Windchill with Active Directory
2011-06-09 22:28 3777说明 This article describe ... -
Taking the Windchill System Offline
2011-06-09 22:20 1185Description This documen ...
相关推荐
R. Fergus, B. Singh, A. Hertzmann, S. T. Roweis, and W. T. Freeman. Removing camera shake from a single photograph. ACM Trans. Graphics, 25(3):787–794, 2006.
Removing Credentials from a Cloned EBS Production Database (Doc ID 419475.1)
Removing the Genetics from the Standard.pdf
removing fog from atmosphere
解决Veeam Backup 因Removing VM snapshot 备份任务停在99%的问题
5.1 Accessing SQL From a Programming Language 157 5.2 Functions and Procedures 173 5.3 Triggers 180 5.4 Recursive Queries 187 5.5 Advanced Aggregation Features 192 5.6 OLAP 197 5.7 Summary 209 ...
Attention all Python Programmers who want to spend less time coding, eliminate bugs, and make your ...Removing Items From a List Reversing a List Removing Duplicate Values Searching for Values Counting
From Motion Blur to Motion Flow: a Deep Learning Solution for Removing Heterogeneous Motion Blur
Modeling and Simultaneously Removing Bias via Adversarial Neural Networks.pdf 位置偏置
Removing moire pattern using with a matlab algorithm
Removing or Reordering Columnsin a List of Rows Recipe 4.8. Transposing Two-Dimensional Arrays Recipe 4.9. Getting a Value from a Dictionary Recipe 4.10. Adding an Entry to a Dictionary ...
Tutorial about how to remove sentinel dongle protection
Method of removing moving shadow based on texture
Different strategies for removing duplicate records in SQL Server
根据输入边界条件生成所需泰森多边形,可以自由调整网格密度
o Converting your database from the Sarge tutorial o Ronny Tiebel's PHP administration frontend o Peter Gutwein's PHP administration frontend • Optional features o Offering webmail access o ...
8.13 Module: jet2sql-Creating a SQL DDL from an Access Database 9. User Interfaces 9.1 Avoiding lambda in Writing Callback Functions 9.2 Creating Menus with Tkinter 9.3 Creating Dialog Boxes...
Players alternate turns, and on his/her turn, a player’s move consists of removing one or more stones from any single pile. Play ends when all the stones have been removed, at which point the last ...
本程序源自:<Removing Camera Shake from a Single Image>, SIGGRAPH 2006 paper
从局部信息推测基恩士的Removing BackGround Information算法的实现。.doc