RTSM/UCMDB users locked

  • KM03543798
  • 30-Oct-2019
  • 30-Oct-2019

Summary

Users locked on DB.

Error

Caused by: java.sql.SQLException: [mercury][Oracle JDBC Driver][Oracle]ORA-01012: not logged on

Cause

1. IDLE_TIMEOUT for the Profile used, you can change connection lifetime to 36000
2. Ensure that the firewall does not close idle connections to the server. (verify into firewall rules if port used for db connection it's open "Allow input trafic", and do same step for machine whre is instaled DB)
3. Ensure that user used for connection have enought permission
4. Ensure you use correct credentials for db login.

Fix

Unlock Users or disable lockout mechanism (invalid.login.lock.out.enabled to false and restart)