AyaNova 3.x - Problems erasing data

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

We are currently running Ayanova 3.2.6.0 with SQL server 2000. When we attempt to erasethe entireAyanova databasewe get the following error:

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.Update(Object obj, DataPortalContext context)
at CSLA.DataPortal.Update(Object obj)
at GZTW.AyaNova.BLL.DBManager.EraseDatabase(String SafetyKey)
at AyaNova.GlobalxForm.(Object , ToolClickEventArgs )
at Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.OnToolClick(ToolClickEventArgs e)
at Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.FireEvent(ToolbarEventIds id, EventArgs e)
at Infragistics.Win.UltraWinToolbars.ToolBase.OnToolClick()
at Infragistics.Win.UltraWinToolbars.ButtonToolUIElement.DoClickProcessing(MouseEventArgs e)
at Infragistics.Win.UltraWinToolbars.ButtonToolUIElement.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.UltraToolbarsDockArea.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.Update(Object obj, DataPortalContext context)
at CSLA.DataPortal.Update(Object obj)
at GZTW.AyaNova.BLL.DBManager.EraseDatabase(String SafetyKey)
at AyaNova.GlobalxForm.(Object , ToolClickEventArgs )
at Infragistics.Win.UltraWinToolbars.UltraToolbarsManager.OnToolClick(ToolClickEventArgs e)
&n

2

Hi

Please perform the update all to 3.3.0 as per http://forum.ayanova.com/Forum96-1.aspx

Than with only the AyaNova Administrator logged in, perform the steps to erase the database.

Let me know the result.

  • Joyce
3

With the update we seem to still have the same problem however the error message is much shorter this time:

Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

4

Hi

What probably is happening is that there is so much data that the time to take to erase it is longer than the SQL database timeout setting can allow for.

Perform the SQL maintenance as per http://forum.ayanova.com/Topic1905-96-1.aspx

It may also take a number of sessions of running the Erase the Entire Database before it can finish erasing all tables.

Also make sure no one else is logged into the AyaNova database (via AyaNova program, Generator, AyaNovaDP, etc) when doing so.

  • Joyce