Sql fatal error

AyaNova 1.x - 6.x AyaNova 3.x to 6.x
1

Unhandled Exception:
Exception has been thrown by the target of an invocation.

System.Reflection.TargetInvocationException

Stack Trace:
at System.Windows.Forms.Control.SetVisibleCore(Boolean value)
at System.Windows.Forms.Form.SetVisibleCore(Boolean value)
at System.Windows.Forms.Control.set_Visible(Boolean value)
at AyaNova.Form1.(String , String )
at AyaNova.Form1.(Object , GroupEventArgs )
at Infragistics.Win.UltraWinExplorerBar.UltraExplorerBar.OnGroupClick(GroupEventArgs e)
at Infragistics.Win.UltraWinExplorerBar.UltraExplorerBar.FireEvent(UltraExplorerBarEventIds id, EventArgs e)
at Infragistics.Win.UltraWinExplorerBar.UltraExplorerBarGroup.DoHeaderClick()
at Infragistics.Win.UltraWinExplorerBar.UltraExplorerBarGroupHeaderUIElement.OnClick()
at Infragistics.Win.ControlUIElementBase.ProcessMouseUpHelper(Object sender, MouseEventArgs e)
at Infragistics.Win.ControlUIElementBase.ProcessMouseUp(Object sender, MouseEventArgs e)
at System.Windows.Forms.Control.OnMouseUp(MouseEventArgs e)
at Infragistics.Win.UltraWinExplorerBar.UltraExplorerBar.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
*** Exception has been thrown by the target of an invocation.
at System.Windows.Forms.Control.SetVisibleCore(Boolean value)
at System.Windows.Forms.Form.SetVisibleCore(Boolean value)
at System.Windows.Forms.Control.set_Visible(Boolean value)
at AyaNova.Form1.(String , String )
at AyaNova.Form1.(Object , GroupEventArgs )
at Infragistics.Win.UltraWinExplorerBar.UltraExplorerBar.OnGroupClick(GroupEventArgs e)
at Infragistics.Win.UltraWinExplorerBar.UltraExplorerBar.FireEvent(UltraExplorerBarEventIds id, EventArgs e)
at Infragistics.Win.UltraWinExplorerBar.UltraExplorerBarGroup.DoHeaderClick()
at Infragistics.Win.UltraWinExplorerBar.UltraExplorerBarGroupHeaderUIElement.OnClick()
at Infragistics.Win.ControlUIElementBase.ProcessMouseUpHelper(Object sender, MouseEventArgs e)
at Infragistics.Win.ControlUIElementBase.ProcessMouseUp(Object sender, MouseEventArgs e)
at System.Windows.Forms.Control.OnMouseUp(MouseEventArgs e)
at Infragistics.Win.UltraWinExplorerBar.UltraExplorerBar.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
*** UserListScheduleable: ID not found or not a scheduleable user:
1d859264-3f32-462a-9b0c-a67dddfdf4d3
at GZTW.AyaNova.BLL.UserListScheduleable.get_Item(Guid ItemID)
at GZTW.AyaNova.BLL.AppointmentList.DataPortal_Fetch(Object Criteria)

2

Ithink this was supposed to be posted under AyaNova v3 so have moved it to here from the AyaNova Related Products & Services forum.

Please identify when this occurs, is this with imported AyaNova CE data, what configuration this is,what is done prior to this occurring, etc- data you can provide would allow us to better provide support.

  • Joyce
3

I am going to make an assumption on what is occurring that results in this error as have not received further information. If this is not the issue, please do provide details.

An AyaNova user was created and set as the type Schedulable User.

This AyaNova user was scheduled for one or more service workorders.

Than this AyaNova user was set as another type - perhaps Non-Scheduleable User

Another AyaNova user was created or edited and set as type Schedulable User.

This other AyaNova user was scheduled for one or more service workorders.

If you now select the Schedule screen, the error will occur because there are AyaNova users scheduled on service workorders that are not of the type Scheduleable User.

The Schedule screen can only display information on schedulable users.

To not receive this error, perform either of the two:

  1. Open all service workorders and ensure all scheduled users are set to the AyaNova user that is set as the type Scheduleable User.

  2. Purchase additional AyaNova licenses for the number of users that have been scheduled on service workorders, apply the activation key, and than edit the users back to being of type Scheduleable User.

  • Joyce