The following error has been reported while attempting to sign on to the iMIS Desktop:
Exception information: Exception type: InvalidOperationException Exception message: Not authorized. at Asi.Web.UI.Common.FormsAuthentication.Login.Page_Load(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Sample Screen capture:
For the error:
exception type: InvalidOperationException
Exception message: Not authorized.
I found a few reports of that error but in one case the MANAGER logon was inserted via sql and was lowercase. It was updated to all uppercase and that resolved the issue, That is why you should test by creating a new staff account to see if that works then look/compare to the other account.
Sample UPDATE SQL Command to correct such a concern.
Note: Make sure to back up your database prior making any changes.
UPDATE Users SET UserId='PROBLEMACCOUNT' WHERE UserId='problemaccount'
The username may be upper case in the UserMain table but lower case in the Users table.
Please, review the screen capture attached on a test performed depicting the same behavior.
Tested Steps in Replicating the Issue on a Test Environment
Created a test staff user account in my Imis test server which is using a starter database. I then tested the Imis desktop login process with this user (firstname.lastname@example.org), and I was successfully signed in to the imis desktop without any issues, and I was able to switch to different options.
Most importantly, inspected these two tables to determine if they both show a consistent casing in both tables (users and usermain) as shown below, and all looked fine.
As an experiment, I changed the UserID to lower case in the (users) table as shown below, and I then attempted to login to the Imis Desktop, and I was able to replicate the same error that you have observed. Please, see the following screen captures.
UPDATE Users SET UserIdemail@example.com' WHERE UserIdfirstname.lastname@example.org'
To resolve the above, I reverted back so both have the same casing "upper case"
UPDATE Users SET UserId='ROLARTE@GMAIL.COM' WHERE UserIdemail@example.com'