When a dsp environment uses Windows Authentication and a User in the CranSoft.dbo.User table has an expiration date, the dsp top border will display but the user can not login and there is no error explaining why.
I am writing this up as a Jira ticket I am creating a feature request to create a report in dsp under Admin/Security, similar to the Users (Locked) page, that displays all users that have an expiration date in their user record. It took a while to resolve this issue so a simple report page would certainly have made the resolution quicker.
--------------------------------------------------------------------------------------------------------------------------------------------------------
Opening Reply:
We have a few existing users who cannot see the home page contents after upgrade to windows 10. They only can see the top bar's background but blank page even not the homepage button (company logo).
We already have a lots of users include my self have updated to windows without this issues.
Check the user history, it says they have been successful logged in.
Admin team confirmed that there is no user window's account change.
Can you please let me know what I can do or check to solve this issues? Thanks.
---------------------------------------------------------------------------------------------------------------------------------------------------
Resolution:
Hi Ernest, Deepa is gone for the day so I am reviewing your ticket. I might be misunderstanding something but it looks like the users that can't login have expiration dates in their User Records. Please go into Admin/Security/Users and go to the vertical of one of the users that no longer works and blank out the date and save. The user might need to clear their cache out in the browser but see if they can get into dsp. Since you recreated LWARKAR, assuming that you didn't copy them from another user, they should be able to log in okay.Please let us know if this resolves this issue.
Thanks,
Patty Conrad
---------------------------------------------------------------------------------------------------------------------------------------------------
Hi, Deepa
Ernest removed the expired date and confirmed with all users who are impacted. They are all good now. Expiration date was the issue.
Thanks for your help and now you can close the ticketed. Thanks.
Best Regards,
Sylvia Tian
One question:
Where can I find a log or message telling me an expired user has attempted to log into DSP?
Regards,
Ernest
Hi, Deepa
Ernest removed the expired date and confirmed with all users who are impacted. They are all good now. Expiration date was the issue.
Thanks for your help and now you can close the ticketed. Thanks.
Best Regards,
Sylvia Tian
From: Deepa Yadav (BackOffice Associates Support) [mailto:support@backofficeassociates.zendesk.com]
Sent: Tuesday, 22 August 2017 11:29 p.m.
To: Sylvia Tian
Subject: [BackOffice Associates] Re: Existing user cannot see the home page contents after upgrade to Windows 10
Hi Ernest,When windows authentication is not being used, the user will get the following message when they attempt to log into dsp: This user account has expired. Please contact your system administrator.Because you all are using Windows Authentication and there isn't a login screen, the user doesn't get a message regarding their account being expired.There isn't a report produced that shows all expired users.I can write a feature request for a report as well as a developer's ticket for the blank dsp screen when a windows authenticated user attempts to login after their expiration date has passed.
Thanks,
Patty Conrad
Hi, Patty
That would be really helpful not only for us but all other similar users. Thanks.
Best Regards,
Sylvia Tian
This seems to me like a bug. There should be a meaningful error when an expired user attempts to log in via Windows Authentication. Also, can't they query the User table as a "report"?SELECT UserID, [Name], ExpirationDate FROM [user]WHERE ExpirationDate IS NOT NULLAND ExpirationDate < GETDATE()