Ports and protocol which had been used by Windchill

Http: 80
JavaRMIServlet: 5001~5010
ProjectLink Meeting port: 5620~5660

Therefore, network administrator should open these ports.

Check Windchill failed queue how-to

1. Go to Site tag and click Utils
2. Go to Queue Manager page
3. Choose failed queue, ex. WfUserWorkQueue
4. pickup one queue entry which had been marked as server, and select 'show' option in dropdown list
5. check error message, ex. wt.workflow.robots.WfInternalMethod:135596
6. used sql statement to figure out which object cause this failed queue.
select t2.businessobjreference, t2.name from WfInternalMethod t1, wfprocess t2 where t1.ida2a2 = 135596 and t1.ida3parentprocessref = t2.ida2a2
7. we can get information from step6.
businessobjreference is VR:wt.doc.WTDocument:136558
name is TPV - Release Workflow_0000000046 - Electronic Component Sample Request Operation Quide A
8. go to search page: apply 0000000046 to number to be our search criteria,
then we can check the related workflow to check what's wrong

Utilized JAXB to generate POJOs automatically -- Green Integration Part II

Utilized JAXB to generate POJOs automatically -- Green Integration Part II

Agenda

• Scenario
• JAXB (Java Architecture for XML Binding)
• Implementation steps in Green Integration
• JAXB Usage
• JAXB Limitations

Follow-up procedure, after installed partslink

Follow-up procedure, after installed partslink

1. Make sure web.xml had define ConfigFile location

1 2 3 4

<context-param> <param-name>ConfigFile</param-name> <param-value>D:/ptc/Windchill/partslink/conf/main.properties</param-value> </context-param>

2. open windchill shell, change directory to <WT_HOME>\partslink\db\sql
3. login to database, execute make_schema_ora.sql script
SQL> @make_schema_ora.sql
4. Load ACL, execute command: windchill wt.load.WindchillLoader -Application=Windchill.PartsLink

Windchill Quick Backup

Procedure

1. backup applicationa & configuration, i.e. D:\PTC\Windchill8\codebase

2. backup database, i.e. execute command: exp pdm8/pdm8@WINDDEV file=D:\tmp\database\WINDDEV.dmp log=D:\tmp\database\WINDDEV.log

If any problem occurred, just overwrite codebase and do database import to do system recovery

Windchill Change Password

In past, Windchill does not provide change password function.
Many customers will complain about this.
Now, Windchill 8 M040 had provided.
But default, M040 disabled change password function, we need to turn it on.

Process:
1. define in site.xconf

1 2 3

<property name="wt.org.services.userPasswordChangeEnabled" overridable="true" targetfile="codebase/wt.properties" value="true">

2. execute xconfmanager -p in windchill shell

3. restart tomcat, method server. And do not forgot to clean tomcat cache.

OraDoclet - Database Documentation Generator

Overview

The purpose of OraDoclet is generation of the detailed database documentation
resembling the JavaDoc style. It is a custom doclet that functions either with the
JavaDoc tool or as a standalone Java application. The documentation generated
has a form of static html files and describes all objects in the given Oracle
database schema.

http://oradoclet.sourceforge.net/

OraDoclet - Database Documentation Generator

Applied Commons Transaction to do File Transactions in Green Integration

Guide to Windchill Performance Tuning

http://junyuo.googlepages.com/GuidetoWindchillPerformanceTuning.rar

Java 2 Software Development Kit (J2SE SDK) - the new jre isn't working

Scenario
I have instaled the new j2se development kit 5.0 and jre5.0, but my browser cannot open any applet and Sun Java console. The error is ---- " The Java Runtime Environment cannot be loaded from <\bin\server\jvm.dll> ???!!!

Solution
In your "Documents and Settings\username\Application Data" folder you'll probably find a folder named "Sun". Delete that folder (or rename it).

reference: http://forum.java.sun.com/thread.jspa?threadID=567821&forumID=17

Leverage Squirrel SQL Client And DAO4J to Do Code Generation

http://albertguo.myweb.hinet.net/trainingMaterials/DAOCodeGen.rar

XStream Quick Start

http://albertguo.myweb.hinet.net/trainingMaterials/XStreamQuickStart.rar

Utilized XStrem in Green Integration (Take CMCS Project for Example)

http://albertguo.myweb.hinet.net/trainingMaterials/UtilizedXStreminGreenIntegration.rar

An easy, small but powerful WebLog analyzer – WebLog Expert

http://albertguo.myweb.hinet.net/trainingMaterials/WebLogExpert.rar

Commons Transaction -- Transactional File System in Java

http://albertguo.myweb.hinet.net/trainingMaterials/CommonsTransaction.rar

[JavaScript] How to do trim() in JavaScript

<body onload="test()">

<script>

String.prototype.trim = function() { return this.replace(/^\s+|\s+$/, ''); };

function test() {

var str = " a ";

alert("Original string: '" + str + "'");

str = str.trim();

alert("Incompletely stripped string: '" + str + "'");

}

</script>

reference
http://www.bigbold.com/snippets/posts/show/701

[JavaScript] How to do trim() in JavaScript

<body onload="test()">

<script>

String.prototype.trim = function() { return this.replace(/^\s+|\s+$/, ''); };

function test() {

var str = " a ";

alert("Original string: '" + str + "'");

str = str.trim();

alert("Incompletely stripped string: '" + str + "'");

}

</script>

[Windchill] How to generate mData

Steps.
1. open rose
2. Tools --> Windchill --> System Generation
3. Click OK

Troubleshoot
It may show generation refuse error in the progress of system generation
Error: wt.templateutil.processor.DefaultTemplateProcessor is not Extendable, so cannot extend it.

Solution
1. Open user.properties (under /Codebase)
2. add one attribute wihch named wt.generation.overrideNonExtendableClasses, and add classes which we want to do extend. If we have multiple classes need to do extend, sperate them by comma.
ex. wt.generation.overrideNonExtendableClasses=wt.templateutil.processor.DefaultTemplateProcessor,wt.templateutil.processor.FormTaskDelegate
After you add them to user.properties, you can see this kind of warning message, it means you had successfully finished system generation.
Warning: wt.templateutil.processor.DefaultTemplateProcessor is not Extendable, but is being allowed as a backward compatible override

[Database] Oracle JDBC FAQ

http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.htm

[Mail] commons-mail 亂碼問題

[常見問題1]sent出去的mail的中文標題變成亂碼

呼叫setCharset此方法，設定編碼方式為UTF-8

public void setCharset(java.lang.String newCharset)

http://jakarta.apache.org/commons/email/api-release/org/apache/commons/mail/Email.html#setCharset(java.lang.String)



[常見問題2]sent出去的mail的中文內文便成亂碼

呼叫setContent此方法，第一個參數給予訊息內容，第二個參數給予conent type，例如text/plain;charset=UTF-8

public void setContent(java.lang.Object aObject,
                  java.lang.String aContentType)

http://jakarta.apache.org/commons/email/api-release/org/apache/commons/mail/Email.html#setContent(java.lang.Object,%20java.lang.String)


[常見問題3]sent出去的附件中文檔名變成亂碼

在EmailAttachment的物件中的setName方法中，使用MimeUtility的encodeText方法
attachment.setName(MimeUtility.encodeText("中文訊息", "UTF-8", null));

http://java.sun.com/products/javamail/javadocs/javax/mail/internet/MimeUtility.html