SQLTeam.com | Weblogs | Forums

Running import job into application results in sql error

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

This is the error - check the actual SQL code and verify the code is correct.

Thank you however what does this mean, what code to check on the Application end or SQL itself?

depends. are you using stored procedures then it would be on sql end, if inline sql it would be in the application end.

they interact with the SQL DB from this application called LAW for document processing.
i do not know if using SP or inline