Error executing SetPermissionsFromUser

Tim Dol — Wed, 04 Apr 2007 18:41:20 GMT

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)

RE: Error executing SetPermissionsFromUser

Tim Dol — Wed, 04 Apr 2007 18:41:20 GMT

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

RE: Error executing SetPermissionsFromUser

Trent L. Taylor — Wed, 04 Apr 2007 13:09:51 GMT

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.

StrataFrame Forum » StrataFrame Application Framework - V1 » Role Based Security » Error executing SetPermissionsFromUser

Error executing SetPermissionsFromUser

RE: Error executing SetPermissionsFromUser

RE: Error executing SetPermissionsFromUser