I had to import user data using some external script.
Did you backup your database before importing this data? Only it sounds like you could have damaged your database.
Yes, i have backup of database. If i revert it works fine.
I have added data to only user and usermeta tables.I have imported around 11 thousand users so doing import task again is time consuming.
Are any settings stored in usermeta table? which i might have overwritten?
If possible please suggest me some solutions which i can try out to fix the issue.
Thank you.
The only thing I can suggest is that you restore your backup database.