SEVERE: OIM Authenticator [user weblogic soft locked]

When trying to configure OIM, we found the error at the Admin server log, that

[2012-09-05T10:09:15.851+05:30] [AdminServer] [ERROR] [] [OIM Authenticator] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: 670d968dbdc0c587:6b822dff:13991dc167d:-8000-00000000000009a6,0] User weblogic soft locked
[2012-09-05T10:14:15.934+05:30] [AdminServer] [ERROR] [] [OIM Authenticator] [tid: ExecuteThread: '3' for queue: 'weblogic.socket.Muxer'] [userId: ] [ecid: 670d968dbdc0c587:6b822dff:13991dc167d:-8000-000000000000002a,0] User weblogic soft locked
[2012-09-05T10:14:15.949+05:30] [AdminServer] [ERROR] [] [OIM Authenticator] [tid: ExecuteThread: '2' for queue: 'weblogic.socket.Muxer'] [userId: ] [ecid: 670d968dbdc0c587:6b822dff:13991dc167d:-8000-000000000000000f,0] User weblogic soft locked
[2012-09-05T10:14:15.961+05:30] [AdminServer] [ERROR] [] [OIM Authenticator] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: weblogic] [ecid: 670d968dbdc0c587:6b822dff:13991dc167d:-8000-00000000000009b5,0] User weblogic soft locked
[2012-09-05T10:17:47.549+05:30] [AdminServer] [ERROR] [] [OIM Authenticator] [tid: [ACTIVE].ExecuteThread: '1' for queue: 'weblogic.kernel.Default (self-tuning)'] [userId: ] [ecid: 670d968dbdc0c587:6b822dff:13991dc167d:-8000-00000000000009d2,0] [APP: consoleapp] User weblogic soft locked


Fix:

Stop all the servers including Adminserver.

Connect with OIM Schema to the database in my case it was DEV1_OIM

query usr table

and you can find the USR_LAST_NAME (WEBLOGIC) is locked.

Manually update the column

like

update DEV1_OIM.usr set USR_LOCKED=0 where USR_LAST_NAME='WEBLOGIC'

update DEV1_OIM.usr set  USR_LOGIN_ATTEMPTS_CTR=0 where USR_LAST_NAME='WEBLOGIC'

update DEV1_OIM.usr set USR_LOCKED_ON = null where USR_LAST_NAME='WEBLOGIC'

And restart Admin server.

Cheers!!!