hello, need some assistance with this resultant log file from a user I am trying to assist. im not a guru of sql in any matter just need some insight into this error.:
Microsoft.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '.'.
at Microsoft.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at Microsoft.Data.SqlClient.SqlDataReader.TryConsumeMetaData() at Microsoft.Data.SqlClient.SqlDataReader.get_MetaData() at Microsoft.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest) at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
at Microsoft.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
at Microsoft.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
at EDIS.GenUtils.Sql.SqlDbBase.<>c__DisplayClass51_01.<ExecuteInternal>b__0() at EDIS.GenUtils.Sql.InternalUtility.Retryable.Execute[TResult](Func1 action, Func3 retryWhen, Func3 waitTime, Action1 logRetry) at EDIS.GenUtils.Sql.SqlDbBase.ExecuteInternal[T](DbConnection connection, Query query, Func2 transformer)
at EDIS.GenUtils.Sql.SqlDbBase.ExecuteScalar[T](Query`1 query)
at LAW.Eda.Models.CaseModels.Operations.SearchGroupModel.AddSearchGroup(String groupName) in E:\TeamCity\BuildAgent01\work\cef14319a8529dfb\LexisNexis.Eda\Models\CaseModels\Operations\SearchGroupModel.cs:line 46
at LAW.Explore.Views.Searches.SearchSetsViewModel.<get_AddSearchSetCommand>b__24_1() in E:\TeamCity\BuildAgent01\work\cef14319a8529dfb\LexisNexis.EdAnalyzer\Views\Searches\SearchSetsViewModel.cs:line 96
at LAW.Explore.ViewModels.ViewModelBase.CommandExecutor.Execute(Object parameter) in E:\TeamCity\BuildAgent01\work\cef14319a8529dfb\LexisNexis.EdAnalyzer\ViewModels\ViewModelBase.cs:line 89
at LAW.Explore.ViewModels.ViewModelBase.CommandExecutor.Execute(Object parameter) in E:\TeamCity\BuildAgent01\work\cef14319a8529dfb\LexisNexis.EdAnalyzer\ViewModels\ViewModelBase.cs:line 89
at System.Windows.Input.CommandManager.TranslateInput(IInputElement targetElement, InputEventArgs inputEventArgs)
at System.Windows.UIElement.OnKeyDownThunk(Object sender, KeyEventArgs e)
at System.Windows.RoutedEventArgs.InvokeHandler(Delegate handler, Object target)
at System.Windows.RoutedEventHandlerInfo.InvokeHandler(Object target, RoutedEventArgs routedEventArgs)
at System.Windows.EventRoute.InvokeHandlersImpl(Object source, RoutedEventArgs args, Boolean reRaised)
at System.Windows.UIElement.RaiseEventImpl(DependencyObject sender, RoutedEventArgs args)
at System.Windows.UIElement.RaiseTrustedEvent(RoutedEventArgs args)
at System.Windows.Input.InputManager.ProcessStagingArea()
at System.Windows.Input.InputManager.ProcessInput(InputEventArgs input)
at System.Windows.Input.InputProviderSite.ReportInput(InputReport inputReport)
at System.Windows.Interop.HwndKeyboardInputProvider.ReportInput(IntPtr hwnd, InputMode mode, Int32 timestamp, RawKeyboardActions actions, Int32 scanCode, Boolean isExtendedKey, Boolean isSystemKey, Int32 virtualKey)
at System.Windows.Interop.HwndKeyboardInputProvider.ProcessKeyAction(MSG& msg, Boolean& handled)
at System.Windows.Interop.HwndSource.CriticalTranslateAccelerator(MSG& msg, ModifierKeys modifiers)
at System.Windows.Interop.HwndSource.OnPreprocessMessage(Object param)
at System.Windows.Threading.ExceptionWrapper.InternalRealCall(Delegate callback, Object args, Int32 numArgs)
at System.Windows.Threading.ExceptionWrapper.TryCatchWhen(Object source, Delegate callback, Object args, Int32 numArgs, Delegate catchHandler)
ClientConnectionId:422a06b5-0884-43e0-970e-78421f0cb6e9
Error Number:102,State:1,Class:15