iMIS Desktop Error Not Authorized

 

 

iMIS 2017

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:

 

iMIS_Desktop_Error_-_Not_Authorized.jpg

 

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 (rolarte@gmail.com), 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.

 

Query_Statements1.jpg

 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 UserId='rolarte@gmail.com' WHERE UserId='rolarte@gmail.com'

 

Query_Statements1.jpg

 

iMIS_Desktop_Error_-_Not_Authorized.jpg

 

To resolve the above, I reverted back so both have the same casing "upper case"

 

UPDATE Users SET UserId='ROLARTE@GMAIL.COM' WHERE UserId='rolarte@gmail.com'

 

 

 

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk