Hi guyz,
We are on Maximo 6.2, Oracle 10g, Weblogic App Server.
Recently, we notice that our application is getting slower. I see the following in the log file whenever it gets slower:
06 Nov 2009 20:26:52:315
INFO Total number of users connected to the system:6
06 Nov 2009 20:26:52:315
INFO Memory Total = 531038208 ,Free = 410326736
06 Nov 2009 20:26:52:518 INFO Reloading +maximo.workorder.statuschange. of*
EventListenerRegistration in maximo cache
06 Nov 2009 20:27:34:483
INFO Skip transaction for assignment ONLYCLOSE
06 Nov 2009 20:27:34:483
INFO Skip transaction for assignment CLOSE
06 Nov 2009 20:27:34:749
INFO Skip transaction for assignment RELFIN
06 Nov 2009 20:27:52:355
INFO ADDRESS: mbosets (2), mbos (2)
06 Nov 2009 20:27:52:355
INFO ALNDOMAIN: mbosets (2), mbos (2)
06 Nov 2009 20:27:52:355
INFO CHARTOFACCOUNTS: mbosets (2), mbos (3)
06 Nov 2009 20:27:52:355
INFO COMPANIES: mbosets (5), mbos (9)
06 Nov 2009 20:27:52:355
INFO CONTRACT: mbosets (4), mbos (4)
06 Nov 2009 20:27:52:355
INFO CRONTASKINSTANCE: mbosets (6), mbos (11)
06 Nov 2009 20:27:52:355
INFO CRONTASKPARAM: mbosets (1), mbos (5)
06 Nov 2009 20:27:52:355
INFO DOCLINKS: mbosets (2), mbos (2)
06 Nov 2009 20:27:52:355
INFO INVENTORY: mbosets (1), mbos (1)
06 Nov 2009 20:27:52:355
INFO ITEM: mbosets (1), mbos (2)
06 Nov 2009 20:27:52:355
INFO LOCATIONS: mbosets (1), mbos (2)
06 Nov 2009 20:27:52:355
INFO LONGDESCRIPTION: mbosets (1), mbos (null)
06 Nov 2009 20:27:52:355
INFO MAXAPPS: mbosets (3), mbos (144)
06 Nov 2009 20:27:52:355
INFO MAXGROUP: mbosets (2), mbos (26)
06 Nov 2009 20:27:52:355
INFO MAXMENU: mbosets (4), mbos (3700)
06 Nov 2009 20:27:52:355
INFO MAXMESSAGES: mbosets (1), mbos (null)
06 Nov 2009 20:27:52:355
INFO MAXMODULES: mbosets (1), mbos (20)
06 Nov 2009 20:27:52:355
INFO MAXSESSION: mbosets (1), mbos (2)
06 Nov 2009 20:27:52:355
INFO PO: mbosets (3), mbos (9)
06 Nov 2009 20:27:52:355
INFO POCHANGESTATUS: mbosets (1), mbos (2)
06 Nov 2009 20:27:52:355
INFO POLINE: mbosets (8), mbos (10)
06 Nov 2009 20:27:52:355
INFO POTERM: mbosets (1), mbos (1)
06 Nov 2009 20:27:52:355
INFO PR: mbosets (2), mbos (469)
06 Nov 2009 20:27:52:355 INFO PRLINE: mbosets (468), mbos (2748)
06 Nov 2009 20:27:52:355
INFO REPORT: mbosets (1), mbos (4)
06 Nov 2009 20:27:52:355
INFO SCHPURCHVIEW: mbosets (1), mbos (1)
06 Nov 2009 20:27:52:355
INFO SIGOPTION: mbosets (1), mbos (3053)
06 Nov 2009 20:27:52:355
INFO SYNONYMDOMAIN: mbosets (3), mbos (11)
Please see the growth of Mbos and Mbosets on PRLine (in the log snippet above)
As this continues, after few hours the number of MBOs and MBOSets on PRLine increases and at one point of time it spikes to an extent where it has 2608 mbosets and 36709 MBOs on PRLine
06 Nov 2009 20:31:52:561
INFO PR: mbosets (15), mbos (6222)
06 Nov 2009 20:31:52:561
INFO PRLINE: mbosets (6208), mbos (36709)
As this continues, the memory usage increases, which leads to OutofMemoryException. Eventually the node (in the cluster) stops functioning.
Have you guyz faced any such issue earlier? If so, kindly revert back with the possible solution.
Thanks