7/16/2022 12:48:35 PM
D:\Wincloud-LIVE\MultiTenant Hosting Live\WebAPI\/ARAPI_Log/ARAPI_Log.txt

System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'R_ND'.
Invalid column name 'TRN_TY_ID'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.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 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   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.ExecuteReader()
   at WebAR_API.DAL.DBCon.GetDatatable(String Query)
   at WebAR_API.Controllers.ARTransaController.PrcfnNAtoARPosting(Hashtable Param)
ClientConnectionId:85dc889d-b129-4145-8025-9ad004eab970
Error Number:207,State:1,Class:16Invalid column name 'R_ND'.
Invalid column name 'TRN_TY_ID'..Net SqlClient Data Provider   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.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 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   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.ExecuteReader()
   at WebAR_API.DAL.DBCon.GetDatatable(String Query)
   at WebAR_API.Controllers.ARTransaController.PrcfnNAtoARPosting(Hashtable Param)
Date :7/16/2022 12:48:35 PM
SELECT (CASE WHEN(CONVERT(DATETIME,DATEADD(D,1,LAST_NA_POST_DT)) <> CONVERT(DATETIME,'11/03/2021')) THEN '1' ELSE '0' END) FROM AR_CONTROL WHERE COMPANY_ID='WS'Date :7/22/2022 8:33:19 AM
SELECT (CASE WHEN(CONVERT(DATETIME,DATEADD(D,1,LAST_NA_POST_DT)) <> CONVERT(DATETIME,'11/04/2021')) THEN '1' ELSE '0' END) FROM AR_CONTROL WHERE COMPANY_ID='WS'Date :7/22/2022 8:33:21 AM

System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'R_ND'.
Invalid column name 'TRN_TY_ID'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.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 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   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.ExecuteReader()
   at WebAR_API.DAL.DBCon.GetDatatable(String Query)
   at WebAR_API.Controllers.ARTransaController.PrcfnNAtoARPosting(Hashtable Param)
ClientConnectionId:af44afe1-65ab-4982-b34d-a6f464eae272
Error Number:207,State:1,Class:16Invalid column name 'R_ND'.
Invalid column name 'TRN_TY_ID'..Net SqlClient Data Provider   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.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 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   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.ExecuteReader()
   at WebAR_API.DAL.DBCon.GetDatatable(String Query)
   at WebAR_API.Controllers.ARTransaController.PrcfnNAtoARPosting(Hashtable Param)Date :8/18/2022 12:30:26 PM

System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'R_ND'.
Invalid column name 'TRN_TY_ID'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.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 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   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.ExecuteReader()
   at WebAR_API.DAL.DBCon.GetDatatable(String Query)
   at WebAR_API.Controllers.ARTransaController.PrcfnNAtoARPosting(Hashtable Param)
ClientConnectionId:af44afe1-65ab-4982-b34d-a6f464eae272
Error Number:207,State:1,Class:16Invalid column name 'R_ND'.
Invalid column name 'TRN_TY_ID'..Net SqlClient Data Provider   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.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 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   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.ExecuteReader()
   at WebAR_API.DAL.DBCon.GetDatatable(String Query)
   at WebAR_API.Controllers.ARTransaController.PrcfnNAtoARPosting(Hashtable Param)Date :8/18/2022 12:30:26 PM
SELECT (CASE WHEN(CONVERT(DATETIME,DATEADD(D,1,LAST_NA_POST_DT)) <> CONVERT(DATETIME,'11/19/2021')) THEN '1' ELSE '0' END) FROM AR_CONTROL WHERE COMPANY_ID='WS'Date :8/30/2022 2:13:40 PM
SELECT (CASE WHEN(CONVERT(DATETIME,DATEADD(D,1,LAST_NA_POST_DT)) <> CONVERT(DATETIME,'11/20/2021')) THEN '1' ELSE '0' END) FROM AR_CONTROL WHERE COMPANY_ID='WS'Date :8/30/2022 2:13:42 PM
SELECT (CASE WHEN(CONVERT(DATETIME,DATEADD(D,1,LAST_NA_POST_DT)) <> CONVERT(DATETIME,'11/21/2021')) THEN '1' ELSE '0' END) FROM AR_CONTROL WHERE COMPANY_ID='WS'Date :8/30/2022 2:13:43 PM
SELECT (CASE WHEN(CONVERT(DATETIME,DATEADD(D,1,LAST_NA_POST_DT)) <> CONVERT(DATETIME,'11/22/2021')) THEN '1' ELSE '0' END) FROM AR_CONTROL WHERE COMPANY_ID='WS'Date :8/30/2022 2:13:45 PM
SELECT (CASE WHEN(CONVERT(DATETIME,DATEADD(D,1,LAST_NA_POST_DT)) <> CONVERT(DATETIME,'11/23/2021')) THEN '1' ELSE '0' END) FROM AR_CONTROL WHERE COMPANY_ID='WS'Date :8/30/2022 2:13:46 PM
SELECT (CASE WHEN(CONVERT(DATETIME,DATEADD(D,1,LAST_NA_POST_DT)) <> CONVERT(DATETIME,'11/24/2021')) THEN '1' ELSE '0' END) FROM AR_CONTROL WHERE COMPANY_ID='WS'Date :8/30/2022 2:13:48 PM
SELECT (CASE WHEN(CONVERT(DATETIME,DATEADD(D,1,LAST_NA_POST_DT)) <> CONVERT(DATETIME,'11/25/2021')) THEN '1' ELSE '0' END) FROM AR_CONTROL WHERE COMPANY_ID='WS'Date :8/30/2022 2:30:36 PM
SELECT (CASE WHEN(CONVERT(DATETIME,DATEADD(D,1,LAST_NA_POST_DT)) <> CONVERT(DATETIME,'11/26/2021')) THEN '1' ELSE '0' END) FROM AR_CONTROL WHERE COMPANY_ID='WS'Date :8/30/2022 2:30:38 PM
SELECT (CASE WHEN(CONVERT(DATETIME,DATEADD(D,1,LAST_NA_POST_DT)) <> CONVERT(DATETIME,'11/27/2021')) THEN '1' ELSE '0' END) FROM AR_CONTROL WHERE COMPANY_ID='WS'Date :8/30/2022 2:30:39 PM
SELECT (CASE WHEN(CONVERT(DATETIME,DATEADD(D,1,LAST_NA_POST_DT)) <> CONVERT(DATETIME,'11/28/2021')) THEN '1' ELSE '0' END) FROM AR_CONTROL WHERE COMPANY_ID='WS'Date :8/30/2022 2:30:41 PM
SELECT (CASE WHEN(CONVERT(DATETIME,DATEADD(D,1,LAST_NA_POST_DT)) <> CONVERT(DATETIME,'11/29/2021')) THEN '1' ELSE '0' END) FROM AR_CONTROL WHERE COMPANY_ID='WS'Date :8/30/2022 2:30:46 PM
SELECT (CASE WHEN(CONVERT(DATETIME,DATEADD(D,1,LAST_NA_POST_DT)) <> CONVERT(DATETIME,'12/08/2021')) THEN '1' ELSE '0' END) FROM AR_CONTROL WHERE COMPANY_ID='WS'Date :11/4/2022 2:12:47 PM
SELECT (CASE WHEN(CONVERT(DATETIME,DATEADD(D,1,LAST_NA_POST_DT)) <> CONVERT(DATETIME,'12/09/2021')) THEN '1' ELSE '0' END) FROM AR_CONTROL WHERE COMPANY_ID='WS'Date :11/4/2022 2:12:51 PM

System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting varchar to data type numeric.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.Common.LoadAdapter.FillFromReader(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.DataTable.Load(IDataReader reader, LoadOption loadOption, FillErrorEventHandler errorHandler)
   at System.Data.DataTable.Load(IDataReader reader)
   at WebAR_API.DAL.DBCon.GetDatatable(String Query)
   at WebAR_API.Controllers.ARTransaController.PrcfnTrnType(Hashtable Param)
ClientConnectionId:562a927f-e675-4637-9422-8e959e098898
Error Number:8115,State:6,Class:16Arithmetic overflow error converting varchar to data type numeric..Net SqlClient Data Provider   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.Common.LoadAdapter.FillFromReader(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.DataTable.Load(IDataReader reader, LoadOption loadOption, FillErrorEventHandler errorHandler)
   at System.Data.DataTable.Load(IDataReader reader)
   at WebAR_API.DAL.DBCon.GetDatatable(String Query)
   at WebAR_API.Controllers.ARTransaController.PrcfnTrnType(Hashtable Param)Date :11/5/2022 6:46:15 AM

System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting varchar to data type numeric.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.Common.LoadAdapter.FillFromReader(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.DataTable.Load(IDataReader reader, LoadOption loadOption, FillErrorEventHandler errorHandler)
   at System.Data.DataTable.Load(IDataReader reader)
   at WebAR_API.DAL.DBCon.GetDatatable(String Query)
   at WebAR_API.Controllers.ARTransaController.PrcfnTrnType(Hashtable Param)
ClientConnectionId:562a927f-e675-4637-9422-8e959e098898
Error Number:8115,State:6,Class:16Arithmetic overflow error converting varchar to data type numeric..Net SqlClient Data Provider   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.Common.LoadAdapter.FillFromReader(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)
   at System.Data.DataTable.Load(IDataReader reader, LoadOption loadOption, FillErrorEventHandler errorHandler)
   at System.Data.DataTable.Load(IDataReader reader)
   at WebAR_API.DAL.DBCon.GetDatatable(String Query)
   at WebAR_API.Controllers.ARTransaController.PrcfnTrnType(Hashtable Param)Date :11/5/2022 6:46:33 AM

System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'R_ND'.
Invalid column name 'TRN_TY_ID'.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.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 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   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.ExecuteReader()
   at WebAR_API.DAL.DBCon.GetDatatable(String Query)
   at WebAR_API.Controllers.ARTransaController.PrcfnNAtoARPosting(Hashtable Param)
ClientConnectionId:06d80559-ad45-4086-8444-6c40b42df169
Error Number:207,State:1,Class:16Invalid column name 'R_ND'.
Invalid column name 'TRN_TY_ID'..Net SqlClient Data Provider   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   at System.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 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   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.ExecuteReader()
   at WebAR_API.DAL.DBCon.GetDatatable(String Query)
   at WebAR_API.Controllers.ARTransaController.PrcfnNAtoARPosting(Hashtable Param)Date :11/29/2022 3:18:00 PM
SELECT (CASE WHEN(CONVERT(DATETIME,DATEADD(D,1,LAST_NA_POST_DT)) <> CONVERT(DATETIME,'12/08/2021')) THEN '1' ELSE '0' END) FROM AR_CONTROL WHERE COMPANY_ID='WS'Date :11/30/2022 5:47:02 PM
SELECT (CASE WHEN(CONVERT(DATETIME,DATEADD(D,1,LAST_NA_POST_DT)) <> CONVERT(DATETIME,'12/09/2021')) THEN '1' ELSE '0' END) FROM AR_CONTROL WHERE COMPANY_ID='WS'Date :11/30/2022 5:47:07 PM
SELECT (CASE WHEN(CONVERT(DATETIME,DATEADD(D,1,LAST_NA_POST_DT)) <> CONVERT(DATETIME,'05/21/2022')) THEN '1' ELSE '0' END) FROM AR_CONTROL WHERE COMPANY_ID='WS'Date :1/9/2023 6:40:01 PM
SELECT (CASE WHEN(CONVERT(DATETIME,DATEADD(D,1,LAST_NA_POST_DT)) <> CONVERT(DATETIME,'05/22/2022')) THEN '1' ELSE '0' END) FROM AR_CONTROL WHERE COMPANY_ID='WS'Date :1/9/2023 6:40:55 PM
SELECT (CASE WHEN(CONVERT(DATETIME,DATEADD(D,1,LAST_NA_POST_DT)) <> CONVERT(DATETIME,'05/24/2022')) THEN '1' ELSE '0' END) FROM AR_CONTROL WHERE COMPANY_ID='WS'