Thursday Jan 30, 2014

Use mail.debug to collect JavaMail log for Agile Email Notification

You may always have email problem from Agile that users are able to get Inbox mail on Agile UI, but fail to get it through email, it happens randomly, sometime users receive and sometime not. And you see error "Actual Exception : null" from server log which does not help us.[Read More]

Monday Jan 20, 2014


Agile has a smart rule named "BOM Multi-Level Recursion". And when we route a Change Order to next status, Agile will check current Change Affected Items' Recursion status in Audit function. Last week I have one customer reporting that he gets an unfriendly error message when do Audit Release function. java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at "AGILE.AGILE_SERVER_BOM_EXPANSION", line 711 ORA-06512: at line 1[Read More]

Thursday Nov 07, 2013

Conflict between Change Control and ASL Mapping

Yesterday I got one strange report that on Agile, adding a Supplier into Item's Supplier tab will always remove all the data from Item.PageTwo.MultiList01 field which is assigned to a User Group list.[Read More]

Friday Nov 01, 2013

Use MD5 to validate the exchanged files between Oracle and Customer

Oracle Supports may ask customers to upload some data files (Database Dump, Trace Log, etc) for research. We often see the scenario that the uploaded huge files are corrupted and have to ask to re-upload. Then we may waste much time during this period. To avoid this, customers can tell Support the MD5 checksum of the upload files, requesting support to validate same if they have gotten the correct file in good format.[Read More]

Thursday Oct 17, 2013

PL/SQL to delete invalid data from token Strings

Previous article describes how to delete the duplicated values from token string in bulk mode. This one extends it and shows the way to delete invalid data.[Read More]

Thursday Oct 03, 2013

Remove duplicated values programmatically

We may always see multiple duplicated values for one attribute on Agile WebClient, which happens sometimes, very often. It is OK to correct them from UI if less objects have such issue. But it is boring if too many exist there. We will have a very simple way to quickly identify the column in database table and fix them effectively by a PL/SQL Procedure.[Read More]

Friday Sep 13, 2013

JK Connector for Tomcat on IIS 7.5

There are many ways to setup proxy server for Agile File Server. Apache HTTP Web Server, IIS or hardware Load Balancer. If you already have IIS as Proxy for Agile Application Server, then you are fine to install JK Connector on IIS to support Agile File Server, no need to setup other Proxy servers. This document will show how to configure JK Connector on IIS as proxy to service backend Agile File Server. It is also a practical instruction for non-Agile users on how to setup JK Connector 1.2.37 for Tomcat 7.x on IIS 7.5 (Windows 2008R2).[Read More]

Wednesday Aug 21, 2013

Custom Cookie impacts Agile File Server operations

Many customers use Web Proxy or hardware Load Balancer in front of Agile Application Server to implement the function of proxy and failover. LoadBalancer may be configured to insert its own cookies to keep session stickiness across different back end Application Servers. It is for technical purpose. While Web Proxy also may be added customized cookie for business uses for customers' own. Each of case about custom cookie may cause File Server fail to upload/download files on IE browser. Let's see how it happens and how to resolve.[Read More]

Wednesday Aug 07, 2013

Rotate stdout.log for Weblogic running as Windows Service mode

To rotate the stdout.log of Weblogic on Windows Service is quite easy to achieve. It is different from other server log and platforms for Weblogic. I have no idea why Weblogic design as that but it is really tricky. We will see how it setups and how it works for Agile PLM from below presentation.[Read More]

Monday Jul 29, 2013

Transaction Timeout in Agile + Weblogic

We may see different transaction timeout error in Agile (It also happens to other applications). There are two places where control the Timeout setting, JTA, EJB tier and Loadbalancer/Proxy. I will demonstrate three cases to show how to identify them. Though most of the timeout issues are caused by applications and we MUST find out the REAL root cause to fix them definitely, increase transaction-timeout still can resolve most of these cases as a temporary solution/workaround.[Read More]

Monday Jul 15, 2013

Agile File Server impacted by TCP Compression Solution

Usually, Agile JavaClient is only used internally. Here "internally" I especially means the LAN in same physical location. I do not suggest it to be "externally" used across WAN or VPN. That is because JavaClient is a fat client, each EJB invockation involves too much redundant data in TCP packages. And you will see delay in JavaClient if you intend to use externally, the delay includes slow login, slow response of tab click. However there is still some customers using it externally and their feedback is JavaClient works very fast in WAN like in LAN, with some special network technology. Customers are happy with that, but issue comes...[Read More]

Friday Jul 05, 2013

Agile 9.3.2 URL PX error in Tomcat 6/7

We have a published Knowledge Document (Note 1549998.1) describing one strange issue that with the correct usage of cookie authentication of URL PX deployed in Tomcat6/7 againt Agile PLM we MAY continuously see below error: java.lang.SecurityException: User: cee71a234165ffc3:-5926181d:13fa9e51af6:-7ffd::e0FFUzoxMjh9REU3NDAyNjI4RENCOTYxMTExRkNCMDUwQzIwNjkxNzFCMkEx, failed to be authenticated.[Read More]

Monday Jun 24, 2013

At most how many customized P3 attributes could be added into Agile?

I have one customer/Oracle Partner Consultant asking me such question: how many customized attributes can be allowed to add to Agile's subclass Page Three? I never did research against this because Agile User Guide never says this and theoretically Agile supports unlimited amount of customized attributes, unless the browser itself cannot handle them in allocated memory. However my customers says when to add almost 1000 attributes, the browser (Web Client) will not show any Page Three attributes, including all the out-of-box attributes. Let's see why.[Read More]

Tuesday Jun 18, 2013

Develop PHP HTTP Destination for Agile PLM ACS

I seldom see customer use HTTP Destination for Agile ACS because of its code difficulty. But someone ever asked this question about how to code PHP program as the HTTP destination to process ACS data from Agile PLM. In our Agile PLM ACS User Guide, there is only one sample HTTP head data for reference. It is very abstract to understand and to develop the code. I will discuss this with details. After you read this article, you will also know how to write different HTTP Destination code with other languages like JSP and Asp.Net.[Read More]

Saturday Jun 08, 2013

Agile JavaClient and Java Web Start

JavaClient uses Java Web Start technology to launch all required jar files and resources into local cache to deploy with online and offline mode. We will discuss how JavaClient is loaded from remote Application Server.[Read More]


« July 2016