Workorder reports

I am having this issue with almost all of my work order reports that are run from the Service module. This same exception is coming from all the Ayanova Standard with the exception of one(Service workorders Invoiced).All of theerrors are the same with reference to"*** The column prefix ‘AWORKORDERSTATUS’ does not match with a table name or alias name used in the query." I also get the same exception whenItry and open the report to modify them.I also posted the information as an attachment. Please help.

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.DataP

Hi

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

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

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

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

  • Joyce
  1. I have installed 3.1.3 with SQL

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

I just upgraded to the 3.1.4 and I am getting the same results.

Thank you

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

  • Joyce

Thank you for bringing this to our attention.

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

Hi again

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