While attempting to filter workorders in the Service Workorders>Parts grid I received the following error message in the Crash popup window:

Incorrect syntax near '8924'

Now every time I attempt to log back in with my user account this same window and error message pops up.  I attempted to 'ignore' but the programs still shuts down.

I have tried the 'logging everyone off and rebooting the server' to no avail.

No other users accounts are affected.

Here is the snippet of crash analysis text from the Ayalog.txt file that is written when the crash occurs:

--------------------------------------------------------------------------------

2007-08-03 19:15:48,266 [1872] FATAL AyaNova.Form1 - Unhandled exception
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: Incorrect syntax near '8924'.
   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.WorkorderServicePartList.DataPortal_Fetch(Object Criteria)
   --- End of inner exception 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.WorkorderServicePartList.0(String , Int32 )
   at GZTW.AyaNova.BLL.ListFactory.GetList(String key, String filter, Int32 maxrecords)
   at AyaNova.MainGrid.0(String , Boolean , String )
   at AyaNova.MainGrid.3(Boolean )
   at AyaNova.MainGrid.ShowList(String listKey)
   at AyaNova.Form1.0(String , String )
   at AyaNova.Form1.4()
   at AyaNova.Form1.6(Object , EventArgs )
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Windows.Forms.Form.OnLoad(EventArgs e)
   at System.Windows.Forms.Form.OnCreateControl()
   at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible)
   at System.Windows.Forms.Control.CreateControl()
   at System.Windows.Forms.Control.WmShowWindow(Message& m)
   at System.Windows.Forms.Control.WndProc(Message& m)
   at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
   at System.Windows.Forms.ContainerControl.WndProc(Message& m)
   at System.Windows.Forms.Form.WmShowWindow(Message& m)
   at System.Windows.Forms.Form.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)
2007-08-03 19:16:58,356 [1872] WARN  AyaNova.Form1 - User opted to abort after exception.  Exiting now
2007-08-03 19:16:58,497 [1872] INFO  AyaNova.Form1 - AyaNova has shut down OK
[Footer]
--------------------------------------------------------------------------------

I've also attached a screenshot of the filter setting that caused the crash.

How can I log back in?  Is there an easy way to reset the user account?

Thanks,

Bob 

	Post Attachments
	Filter settings prior to crash.zip (4 views, 55.20 KB)

1. Log in as AyaNova Administrator
2. Open that user's entry screen from the Users grid in the Administration naviagation pane
3. Click on the "Clear all user's form customizations"
4. Save and exit
5. Now log in as that user

I've tried to recreate what I believe you have done from the screenshot (Custom field on the Workorder column, selecting Operator of Contains with Operand of three workorder numbers), but I do not get such an error. So that development can see everything related to why this error occurs and code to prevent it, please provide the following sent directly to support@ayanova.com

1. Make a backup of your AyaNova database file, zip it using WinZip and send to support@ayanova.com
2. Include the AyaNova Administrator username and password
3. Include the specific user that was experiencing this error
4. Include all filters on all columns that resulting in the error occurring so that it can be re-created
5. Reference this forum post http://forum.ayanova.com/Topic3318-90-1.aspx in your email

[NOTE For Others Experiencing Similar: As this AyaNova user has been experiencing network drops and  and other network related issues, and has one server running not just AyaNova and SQL Express but also SharePoint and Exchange and other programs, have suggested that AyaNova database and its SQL Express to moved to another server as the load on the existing server is causing bottlenecks in data being sent and received - until such time as the server can be upgraded]

- Joyce

AyaNova Sales & Technical Support

http://www.ayanova.com

I'll zip up and send the database.

Thanks!

Bob

I appreciate all of you help!

Thanks,

Bob