StrataFrame Forum

Error executing SetPermissionsFromUser

http://forum.strataframe.net/Topic7895.aspx

By Tim Dol - 4/4/2007

I have a client that is getting this error when they login. All other users can login without problems. Any idea's what could be the cause?  This particular user has been logging in fine for 2-3 weeks. It started happening this morning.

Thanks

TIm

InvalidOperationException
 Nullable object must have a value.

 Source     : mscorlib

 Stack Trace:
   at System.ThrowHelper.ThrowInvalidOperationException(ExceptionResource resource)
   at System.Nullable`1.get_Value()
   at MicroFour.StrataFrame.Security.LoggedInUser.SetPermissionsFromUser(Int32 UserPK)
   at MicroFour.StrataFrame.Security.LoggedInUser.CreateNew(SFSUsersBO UserInfo)
   at MicroFour.StrataFrame.Security.LoggedInUser.SetLoggedOnUser(SFSUsersBO UserInfo)
   at MicroFour.StrataFrame.Security.Login.AttemptLogin(Object sender, EventArgs e)
   at Avanti.MenuSystem.AvantiLoginForm.OnAttemptLogin()
   at Avanti.MenuSystem.AvantiLoginForm.cmdOk_Click(Object sender, EventArgs e)
   at System.Windows.Forms.Control.OnClick(EventArgs e)
   at System.Windows.Forms.Button.OnClick(EventArgs e)
   at System.Windows.Forms.Button.PerformClick()
   at Avanti.MenuSystem.AvantiLoginForm.txtPassword_KeyDown(Object sender, KeyEventArgs e)
   at System.Windows.Forms.Control.OnKeyDown(KeyEventArgs e)
   at System.Windows.Forms.Control.ProcessKeyEventArgs(Message& m)
   at System.Windows.Forms.Control.ProcessKeyMessage(Message& m)
   at System.Windows.Forms.Control.WmKeyChar(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.TextBoxBase.WndProc(Message& m)
   at System.Windows.Forms.TextBox.WndProc(Message& m)
   at System.Windows.Forms.Control.ControlNativewindow.OnMessage(Message& m)
   at System.Windows.Forms.Control.ControlNativewindow.WndProc(Message& m)
   at System.Windows.Forms.Nativewindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

 

By Trent L. Taylor - 4/4/2007

Have you opened up the SFSUsers and SFSPermissions tables to make sure there are not any NULL values?  Second, are you doing anything (i.e. creating an audit record) when a user logs in?  One thing you can do is turn on the data debugger so you can see the query.  More than likely this is where you are going to end up so I would just start there by turning on the data debugger for that data source.
By Tim Dol - 4/4/2007

I checked all the data and it all looked okay.  I had the customer remove all the user permissions, save, and then add everything back. The problem seemed to go away.

It seems to be a one-off for now so I won't worry about it.

Thanks

Tim