Sunday, 28 December 2014

Process to avoid Concurrent Sessions for a User in Maximo


Connect to the Maximo database (IP)
Execute the following query :
 select * from MAXPROPVALUE where propname='mxe.enableConcurrentCheck'

 If the value of the PROPVALUE field is 1, then a user can only have a single session on maximo. If it is 0, then the user can have multiple concurrent sessions in Maximo.

 To update this value if required, execute the following SQL statement : 

 # For Multiple Session 
UPDATE MAXPROPVALUE SET PROPVALUE='0'  WHERE PROPNAME='mxe.enableConcurrentCheck' 
#For Single Session

 UPDATE MAXPROPVALUE SET PROPVALUE='1'  WHERE PROPNAME='mxe.enableConcurrentCheck'
Posted by at

3 comments:

  1. Adhitiyan Muslim15 March 2016 at 23:21

    HI Saroj..

    I've tried a new method that you provide, but the result is, all of user cannot login again.

    Can You help me?

    Thank YOu

    ReplyDelete
  2. Saroj Kumar20 March 2016 at 22:16

    If the propvalue is updated to 1 then multiple session for a user is not allowed.

    ReplyDelete
  3. Saroj Kumar20 March 2016 at 22:17

    If the propvalue is updated to 1 then multiple session for a user is not allowed.

    ReplyDelete

Subscribe to: Post Comments (Atom)