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

System.Reflection.TargetInvocationException

Stack Trace:
   at System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean isBinderDefault, Assembly caller, Boolean verifyAccess)
   at System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean verifyAccess)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at CSLA.Server.DataPortal.CallMethod(Object obj, String method, Object[] params)
   at CSLA.Server.DataPortal.Fetch(Object Criteria, DataPortalContext context)
   at CSLA.DataPortal.Fetch(Object Criteria)
   at GZTW.AyaNova.BLL.WorkorderServiceDetailedReportData.GetItems(String xmlCriteria)
   at AyaNova.WorkordersServiceForm.
(Object , ToolClickEventArgs )
   at Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.OnToolClick(ToolClickEventArgs e)
   at Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.FireEvent(ToolbarEventIds id, EventArgs e)
   at Infragistics.Win.UltraWinToolbars.ListTool.set_SelectedItemIndex(Int32 value)
   at Infragistics.Win.UltraWinToolbars.ListTool.DoDefaultActionForItem(Int32 itemIndex)
   at Infragistics.Win.UltraWinToolbars.ListToolMenuItem.OnClick()
   at Infragistics.Win.UltraWinToolbars.PopupMenuItemUIElement.DoClickProcessing(MouseEventArgs e)
   at Infragistics.Win.UltraWinToolbars.PopupMenuItemUIElement.OnMouseUp(MouseEventArgs e)
   at Infragistics.Win.UIElement.OnMouseUp(MouseEventArgs e)
   at Infragistics.Win.TextUIElementBase.OnMouseUp(MouseEventArgs e)
   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.UltraWinToolbars.PopupControlBase.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.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean isBinderDefault, Assembly caller, Boolean verifyAccess)
   at System.Reflection.RuntimeMethodInfo.InternalInvoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean verifyAccess)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)
   at CSLA.Server.DataPortal.CallMethod(Object obj, String method, Object[] params)
   at CSLA.Server.DataPortal.Fetch(Object Criteria, DataPortalContext context)
   at CSLA.DataPortal.Fetch(Object Criteria)
   at GZTW.AyaNova.BLL.WorkorderServiceDetailedReportData.GetItems(String xmlCriteria)
   at AyaNova.WorkordersServiceForm.
(Object , ToolClickEventArgs )
   at Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.OnToolClick(ToolClickEventArgs e)
   at Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.FireEvent(ToolbarEventIds id, EventArgs e)
   at Infragistics.Win.UltraWinToolbars.ListTool.set_SelectedItemIndex(Int32 value)
   at Infragistics.Win.UltraWinToolbars.ListTool.DoDefaultActionForItem(Int32 itemIndex)
   at Infragistics.Win.UltraWinToolbars.ListToolMenuItem.OnClick()
   at Infragistics.Win.UltraWinToolbars.PopupMenuItemUIElement.DoClickProcessing(MouseEventArgs e)
   at Infragistics.Win.UltraWinToolbars.PopupMenuItemUIElement.OnMouseUp(MouseEventArgs e)
   at Infragistics.Win.UIElement.OnMouseUp(MouseEventArgs e)
   at Infragistics.Win.TextUIElementBase.OnMouseUp(MouseEventArgs e)
   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.UltraWinToolbars.PopupControlBase.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)
*** The column prefix 'AWORKORDERSTATUS' does not match with a table name or alias name used in the query.
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   at GZTW.Data.GZTWDatabase.DoExecuteReader(IDbCommand command, CommandBehavior cmdBehavior)
   at GZTW.Data.GZTWDatabase.ExecuteReader(DBCommandWrapper command)
   at GZTW.AyaNova.BLL.WorkorderServiceDetailedReportData.DataPortal_Fetch(Object Criteria)

1. What version of AyaNova v3 are you running? (select menu Help -> About) (are you using the latest version 3.1.3?)

2. Please export at least three of the reports that result in this error, zip them all together using Winzip and attach.

1. Be logged in with full access to Administration
2. Select Report Templates grid
3. Select each report to open, select the menu option Export report template, save to a file
4. Using WinZip, zip up all these exported report templates and attach.

This way I can reproduce the error and determine the issue.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

2.attached is the msg I get when I try and print any with one exception of the reports from service.

I am just checking this out with SQL Server configuration and will get back to you as soon as possible.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

There is an issue if using the SQL Server configuration accessing report templates from the Service Workorders grid made via the Detailed Report Template.

We will get this addressed, and I will post here as soon as we have a solution.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

We have posted a QuickFix update in the AyaNova Known Issues & Updates to update to v3.1.5 to address this issue.

Thank you again for bringing this issue to our attention so it could be addressed.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com