Maximo 6.2.6 and WebLogic - Connections piling up in maxsession table

[Donagh]

Hello,

We are running maximo 6.2.6 in our development server and we started to experience "performace issues" (slowdowns).

Checking the maxsession table, we discovered hundreds of active connections. We have several utilities that connect via

RMI and apparently they are no longer disconnecting properly after the upgrade.

At first I was concerned that it was a problem with our utilities, so I used the checkmxserver.bat utility on the Maximo

server to test. Here are the steps to reproduce:

1. Run the checkmxserver.bat utility 10 times on both the 6.2.00 machine and the 6.2.6 machine.
2. Connect to the database on both machines and do a "select * from maxsession" query.
3. On the 6.2.00 machine, there is only one row in the table (the MAXIMO default session). On the 6.2.6 machine, there are

eleven rows in the table (one MAXIMO default session and ten MAXADMIN sessions, with MAXADMIN being the login I passed to

checkmxserver.bat)

I noticed that there is a known bug with "idle" sessions on WebSphere, but we are running WebLogic and these sessions are

forcibly closed with a call to MXServer.Disconnect() so they should not be flagged as "idle".

Has anyone else seen this behavior?

Thanks in advance,

Donagh

[Yesterday]

• Taskrunner error CTGIN22... by LEUCIR [Yesterday at 01:11:50 pm]
• PM Estimated Due Date whe... by canislupus [May 21, 2012, 01:56:48 pm]
• unable to get wpmaterial ... by G Jeevan [May 21, 2012, 12:28:50 pm]
• KPIMAIN lookup not workin... by G Jeevan [May 21, 2012, 12:26:23 pm]
• add user access by Sarbjeet.Jassal [May 21, 2012, 08:04:33 am]
• Not able to access the ma... by Sarbjeet.Jassal [May 21, 2012, 07:57:40 am]
• How to Connect to Fax Mac... by Dileep Kumar [May 16, 2012, 06:26:22 am]
• Is there a way to track t... by rickmac [May 14, 2012, 06:43:03 am]
• how to change the backgou... by gorgehemtr [May 12, 2012, 06:15:14 am]
• How to break description ... by murugovind [May 11, 2012, 12:40:26 pm]