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.
SAP Knowledge Base Article - Preview