but none of the detailed reports work the summary report come up

right away . but if i select any detailed report or try and create a new one i get this error. and this is happening on the server as well as the clients workstation.

i also made sure that the workstation is set to the same dir. as the server.

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)
*** Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
   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)

A few suggestions for troubleshooting as from the message you are getting a time out due to the amount of time its taking to process the request:

Are you using the SQL Express 2005 or SQL Server 2000 or ?

What's the load on the server? Are you low on memory, high CPU usage?

What's the average pages/sec? (check out processes in Task Manager in "Page Faults") (also check out http://support.theplanet.com/knowledgebase/users/kb.php?id=10109)

Take a look at this link for monitoring performace http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=28&rl=1

What other programs and services are running on this server at the same time? If you're not using a service on your SQL Server box, stop it. The processing and memory that it's taking up can be put to better use supporting SQL Server.

What has been applied (new program, new service, new service patch, new hardware, etc)  to this server between when you did not get this issue and now?

Do you have an anti-virus program on this SQL Server that is scanning the database? This can substantially slow performance.

Do you  have hyper-threading enabled? There are a number of posts and tests on the Internet that hyperthreading with SQL can slow local performance - other posts show improved performance. If you have it enabled, disable it and test again.

AyaNova Sales & Technical Support

http://www.ayanova.com

this is my test box and is not running any other software. except what you (ayanova) recommended

also i should point out . that the only reports that do fail are from the main service module

i did some further testing today . and found that all detailed reports in all other modules seem to work fine . inside a work order  i can create a new detailed template and that works fine

but if i try and create or use a detailed report (template) in the main service module it fails every time . now this happend ( or i noticed it ) after i imported the template from the template area of your forum .i dont beleave they are at fault but it seemed after i uploaded them is when i seemed to have an issue

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.

How many records are displaying in your Service Workorders grid when you run this report?

When you check Task Manager - what is the CPU usage? What is the memory usage? What are the pages/sec?

I am assuming from your reply "is not running any other software. except what you (ayanova) recommended" that you mean there is no other software installed other than SQL Server and all relevant patches, and AyaNova v3.03, all operating patches and your backup software?

Have you checked services as suggested and confirmed services not needed are disabled as depending on the operating system and choices taken during the installation there could be a lot of other services running just by default?

Have you confirmed if hyperthreading is enabled on this server and if so, disabled it?

What operating system are you running? 

What version of SQL Server are you running? 

Please do provide information on the questions I have asked as they all are important to determining the issue.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

How many records are displaying in your Service Workorders grid when you run this report?

When you check Task Manager - what is the CPU usage? What is the memory usage? What are the pages/sec?

I am assuming from your reply "is not running any other software. except what you (ayanova) recommended" that you mean there is no other software installed other than SQL Server and all relevant patches, and AyaNova v3.03, all operating patches and your backup software? yes running 3.03 and sql express

Have you checked services as suggested and confirmed services not needed are disabled as depending on the operating system and choices taken during the installation there could be a lot of other services running just by default? no the only service that is using resources is ayanova and sql. ayanova runs at around 10% and when the report fails sql in running at around 40-50% of resourse.

Have you confirmed if hyperthreading is enabled on this server and if so, disabled it? will check this today.

What operating system are you running?   server 2003 sp1

What version of SQL Server are you running?  Sql Express (will do latest updates )

also one thing i did notice is that the sql express is running at around 180 to 200 megs of ram it is using .seems a little high. and when the report that i am test has about 300 tickets open work orders.  it fails if i only run a report for 50 of these workorders it does run fine.

what is the fix for this.

i need to be able to run atleast 300 to 500 workorder in a month . with out having to separate clients out or workorder types. 

Have you checked hyperthreading as of yet?

SQL uses a lot more resources than Firebird which is why you are seeing a much larger amount of memory used by the SQL.

For comparison, using SQL Express on a Athlon 2000+ with 512MB, I am able to run the report Total Workorders Billable Grouped by CLient for 912 workorders in less than a minute with  no timeout occurring. I am also able to run the report Total Workorders Billable Grouped by Client for 9369 workorders with no timeout occurring.

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

also this is happening on the server i am not even using the network to do this testing.

is there something wrong with my install ?

should i start over on a new server and setup firebird ?

the reason i went with Sql was  thought it would do better with a large amount a data.

but maybe i should try firebird instead ?