Symptom
In a MPX environment, a login policy defines "max days since login execeeded" to N days. The user "User1" follows this login policy.
User1's login was locked on a writer node and sa_get_user_status shows that his "last_login_time" was N days ago.
However, User1 has logged in and out since the last N days thus his "last_login_time" should be updated to a more recent date.
If you execute the command "cat IQMSG |grep -i User1" , you can see lots of connects/disconnects from this user during the past N days.
Read more...
Environment
IQ 16 SP 8
Product
Keywords
CR796124 ; 796124 ; sa_get_user_status ; last_login_time ; login policy ; login ; locked ; reset ; unlock ; user ; , KBA , BC-SYB-IQ , Sybase IQ , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.