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

System.Reflection.TargetInvocationException

Stack Trace:
   at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
   at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
   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.WorkorderQuoteDetailedReportData.GetItem(Guid WorkorderID)
   at AyaNova.WorkorderForm.
(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.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.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)
*** Exception has been thrown by the target of an invocation.
   at System.RuntimeMethodHandle._InvokeMethodFast(Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
   at System.RuntimeMethodHandle.InvokeMethodFast(Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeTypeHandle typeOwner)
   at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)
   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.WorkorderQuoteDetailedReportData.GetItem(Guid WorkorderID)
   at AyaNova.WorkorderForm.
(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.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.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)
*** Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.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.WorkorderQuoteDetailedReportData.DataPortal_Fetch(Object Criteria)

A similar error occurred posted in topic http://forum.ayanova.com/Topic969-100-1.aspx?Highlight=Timeout+expired  I am trying to find his post where he posted what he did with the SQL Server that resolved his timeout errors - I have contacted him asking what was his resolution in this instance.

The message you are receiving is due to a timeout - the query to obtain the data for the report is timing out possibliy due to the amount of data, or due to a bottleneck on the server or an issue with the program files on your computer.

Please provide a copy of your About AyaNova information - to double check all files are up to date. Log into AyaNova on the server itself where the database resides, select menu Help -> About AyaNova, copy all text to a NotePad document, save and attach to your reply (attachments can be txt or zip extensions only on this forum)

Than let's narrow down the window of troubleshooting first and go from there:

Still logged in on the server itself (so not adding additonal possibilities to troubleshooting) how many records are being displayed in the Quotes grid in the Quotes navigation pane when this error occurs?

Troubleshooting by displaying only one record in the Quotes grid, and select a summary report template - does the error occur?

Troubleshoot by displaying only one record in the Quotes grid and select a detailed report template - does the error occur?

Do the same but select to create a new Sumary Report Template, and do the same but select to create a new Detailed Report Template

Now move to the Quotes navigation pane Items grid - do the same, does the error occur with the same selections?

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

I have the informaiton you requested. I have tried all of the troubleshooting steps and come up with one thing being decisive. Any report that has detailed report throws the time out error. I have attached a copy of the config that you wanted.

Are you saying any detailed report from any grid returns the timeout error? Or only a detailed report from the Quotes grid in the Quotes navigation pane returns the timeout error?

Please confirm if this occurs in Service Workorders grid, Quotes -> Items grid, etc - or only in a specific grid.

How many records are displaying in the grid when the error occurs?

Have you tested with only one record displaying in this grid and selecting to create a new Detailed report? What is the result?

How many records are displaying in the grid when you experience this issue?

Are you using SQL Express or SQL Server?

Are you troubleshooting on the server itself where the database resides or on a networked computer?

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

Well now that you bring up that point you are right that it is happening on the workorder side of the grid. I have not had to use the detailed report on the workorder side in some time but it seems to be suffering the same fate.

how many records? I have tried both one and multiples.

happens with std default detailed reports or when you click on new.

using SQL Server 2000

troubleshooting on the server it self.

I am able to reproduce the error but only if the grid is not filtered would a timeout error occur.

For example, I have a database here with over 5000 workorders.

If I open the Service Workorders grid with No Filter selected in the Filter Drop List, and First 100 rows selected, and I select the generic Sample Detailed Service Workorder with Grand Total report template (a detailed type reprot template) I will get a timeout error.

If instead I make a filter to only show records for the last day, resulting in displaying only two records, save this filter, and than select the detailed report, no timeout error.

Or if instead I make a filter to only show records since January 2006, save the filter, select to show All Rows, and select the detailed report - no timeout occurs.

Can I get you to perform exactly the following:

1. In the Service Workorders grid in the Service navigation pane, select to filter so that you are only showing a couple records. Save this filter. Now select the Detailed Service Workorder with Grand Total report template - does it display correctly?

2. Now reset back to No Filter, and select the same report template - the error occurs doesn't it?

3. Now make a new filter to show workorders so you get quite a few (100+), save this filter, and than select the same report template again - does the error occur?

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

in workorders i can get this to work by narrowing the search down. one thing that did come up is no matter how broad or narrow the search is when using "new detailed report template" I receive this error from the workorder grid. on the quotes grid, it happens ever time.

How many quote records are displaying in the Quotes grid in the Quotes navigation pane when you get this error attempting to create a new detailed report template for Quotes?

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com