A new user has been created and I'm unable to edit the clients that are listed from the second row onwards using this new user log in. The clients are added by the logged in user only. the user has admin privileges but still unable to edit the clients. I've noticed that it allows to Edit from ListKeys page i.e. ListKeys -> Edit and save the changes. The saved changes are available in otk_db.oauth_client_key table but it doesn't update otk_db.oauth_client table
Any reason on why there are two tables ? I noticed that for few records the data in otk_db.oauth_client is older when compared to otk_db.oauth_client_key table. It might be because of the reason that it is allowing me to edit from ListKeys page.
I've debugged the issue to some extent and at this moment it appears to be the problem with L7 caching. Overall when tried to edit a client, the client_ident is passed from UI to the server and on server it first looks at cache and if not found then executes a DB query to return the client matching with client_ident. Now the problem is when it looks in L7 cache to retrieve the client it is currently returning all the available client records. The 'Edit Form' policy is then picking up the top record and prefills the fields on the page with top record details.
I tried to delete the L7 cache, the only way to do this is to set the expiry time to a lower timestamp, but it still says that cache is valid and returning all the records, I might be doing something wrong. (OTK Caching customization).