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.
Support we have page_two and manufacturers tables in database and the table DDL is:
SQL> desc page_two;
Name NULL? TYPE
----------------------------------------- -------- (more...)
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 (more...)
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 (more...)
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 (more...)
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. (more...)
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 126.96.36.199 we MAY continuously see below error.
Error code : 60062
Error message : Invalid username or (more...)
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 (more...)
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 (more...)
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.
Detect Java Web Start
Usually we access JavaClient from the entrance http://host:port/JavaClient/start.html . This start. (more...)
We all understand that the principle task of PMON is to clean resource after abnormal end of connection process, monitor/recover the background process and register instance to a Lisener. This article will analyze the background task.
Clean Resource of Process Disconnection.
We debug the process with event 10246. As 10246 (more...)
Recently we got several customers' report that the IQuery API in client SDK program has poorer performance in Agile 188.8.131.52 than 184.108.40.206. If to monitor SDK client program's memory heap usage we will see much more heap is used in 220.127.116.11 (more...)
We will discuss the concept of checksum in Agile PLM and related technology. If enabled Checksum Calculation in Agile PLM, we may see below error when do CheckOut/CheckIn file attachment. This scenario means the original physical file is modified by external program beyond Agile.
There are quite a few ways (more...)
I have been asked by customers and partners about one same puzzle that why IQuery.execute() runs extremely fast, while the first time execution of Iterator.hasNext() runs very slow。To answer and summarize the background technology of IQuery, let's analyze it detailedly. Below is a very typical usage of IQuery.
Out Of Thread means there are many tasks (requests) are pending to run, but only a few Threads are available. Many queued tasks have to wait for running threads to be idle. It is a much more complicated case and it is very hard to be identified from Thread Dump (more...)