Monitoring IFS ERP Applications on Oracle WebLogic Server with WLSDM
One of our customer is using IFS ERP (http://ifsworld.com) software solution for their business. The IFS applications also can be hosted on Oracle WebLogic server and they wanted from us to tune their WebLogic domains and setup monitoring infrastructure with WLSDM for the IFS.
Firstly we have installed WLSDM in minutes to their IFS WebLogic test and production domains.
Then WLSDM started to monitor IFS domain and gather information about domain. Started to generate ALERTS and notifications immediate
After WLSDM installation, our customer gained power to monitor and diagnose their IFS as below:
Environment: IFS8, Oracle WebLogic Server 12c (12.1.2), WLSDM (Upgraded to v.2.5.2), Java-JDK (We have upgraded JAVA to jdk1.7.0_79)
3.1. Anymore they are able to monitor IFS’s back-end SQL statements and get notifications for the long-running SQLs. We have tuned Oracle SQLs online and improved application performance.
3.2. Anymore our client able to understand IFS infrastructure. IFS highly applies EJB Business Method Invocation for their back-end operations and services. Our client receives notifications about IFS EJB methods and able to get performance report for their EJB invokes. We can understand which business module has weak performance.
3.3. Before WLSDM, they always restart the whole IFS system without understanding what’s the exact problem. Anymore, they are able to restart the exact problematic module by monitoring WLSDM Health dashboard and following WLSDM health notifications for their IFS domain.
3.4. Our clients developing, customizing and generating new features on their IFS system continuously. But they were unable to understand new deployed customization performance. Anymore, they are getting below notifications for the weak SQLs and other kind of back-end operations. For instance, below notification is a back-end JDBC Statement Execute type and its cost is 358sec. This means, the new SQL must be tuned.
By getting below SMTP(email) notifications/alarms we understand what is going on the IFS WebLogic domain.
For the below STUCK thread error, we gave timeout for the relevant transactions and transformed IFS WebLogic domain more strong, healthy and responsive.