2025-11-29 09:48:42.761 +05:30 WRN Using an in-memory repository. Keys will not be persisted to storage. 2025-11-29 09:48:42.805 +05:30 WRN Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2025-11-29 09:48:42.829 +05:30 INF Creating key {1feb7500-90fd-4671-aaa6-24ea34b1226b} with creation date 2025-11-29 04:18:42Z, activation date 2025-11-29 04:18:42Z, and expiration date 2026-02-27 04:18:42Z. 2025-11-29 09:48:42.848 +05:30 WRN No XML encryptor configured. Key {1feb7500-90fd-4671-aaa6-24ea34b1226b} may be persisted to storage in unencrypted form. 2025-11-29 09:48:43.000 +05:30 INF Application started. Press Ctrl+C to shut down. 2025-11-29 09:48:43.001 +05:30 INF Hosting environment: Production 2025-11-29 09:48:43.001 +05:30 INF Content root path: C:\inetpub\wwwroot\SangTransactionsAPI 2025-11-29 09:48:43.012 +05:30 4a9124a9-abb5-4a10-ac3b-07b5287e6d27 INF Request starting HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - null null 2025-11-29 09:48:43.079 +05:30 4a9124a9-abb5-4a10-ac3b-07b5287e6d27 INF CORS policy execution successful. 2025-11-29 09:48:43.086 +05:30 4a9124a9-abb5-4a10-ac3b-07b5287e6d27 INF Request finished HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - 204 null null 75.7519ms 2025-11-29 09:48:43.148 +05:30 9ac88308-add8-4779-9f81-4a673b4aa720 INF Request starting HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - null null 2025-11-29 09:48:43.258 +05:30 9ac88308-add8-4779-9f81-4a673b4aa720 INF CORS policy execution successful. 2025-11-29 09:48:43.276 +05:30 9ac88308-add8-4779-9f81-4a673b4aa720 INF HTTP request: Path: /transaction/gettransactionsummary QueryString: ?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 Headers: {Accept: application/json, text/plain, */*}, {Accept-Encoding: gzip, deflate}, {Accept-Language: en-US,en;q=0.9}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY0Mzg5ODk2LCJleHAiOjE3NjQzOTM0OTYsImlhdCI6MTc2NDM4OTg5Nn0.tKla8w9AXvwxyt6pJxKrWdSX3gvdIm1XAJnbo4HZdWI}, {Connection: keep-alive}, {Host: 103.120.178.195}, {Referer: http://localhost:5173/}, {User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36}, {Origin: http://localhost:5173} Host: 103.120.178.195 Body: 2025-11-29 09:48:43.322 +05:30 537773cc-6b72-438f-8c6e-1171b5ed17ab INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-11-29 09:48:43.348 +05:30 537773cc-6b72-438f-8c6e-1171b5ed17ab INF Route matched with {action = "GetTransactionSummary", controller = "Transaction"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetTransactionSummary(Sang.Transactions.Api.Models.APIRequest.TransactionSummaryRequest) on controller Sang.Transactions.Api.Controllers.TransactionController (Sang.Transactions.Api). 2025-11-29 09:48:43.917 +05:30 537773cc-6b72-438f-8c6e-1171b5ed17ab ERR Invalid column name 'sNarration'. 2025-11-29 09:48:43.934 +05:30 537773cc-6b72-438f-8c6e-1171b5ed17ab ERR Invalid column name 'sNarration'. 2025-11-29 09:48:43.947 +05:30 537773cc-6b72-438f-8c6e-1171b5ed17ab ERR Error Getting TransactionList1101 from database System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sNarration'. 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.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) 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(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchDataset(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.CoreSettings.Api.Repositories.TransactionRepository.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Services.TransactionService.<>c__DisplayClass12_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteDatasetResult[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String sortColumn, Boolean isAscending, Int32 groupId, String searchString) ClientConnectionId:fadd7784-d568-4440-bd23-eccec087b2e6 Error Number:207,State:1,Class:16 2025-11-29 09:48:43.950 +05:30 537773cc-6b72-438f-8c6e-1171b5ed17ab ERR SQL Exception occurred For DocType:1101: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sNarration'. 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.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) 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(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchDataset(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.CoreSettings.Api.Repositories.TransactionRepository.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Services.TransactionService.<>c__DisplayClass12_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteDatasetResult[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String sortColumn, Boolean isAscending, Int32 groupId, String searchString) at Sang.Transactions.Api.Services.TransactionService.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary(TransactionSummaryRequest summaryRequest) ClientConnectionId:fadd7784-d568-4440-bd23-eccec087b2e6 Error Number:207,State:1,Class:16 2025-11-29 09:48:43.962 +05:30 537773cc-6b72-438f-8c6e-1171b5ed17ab INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-11-29 09:48:44.035 +05:30 537773cc-6b72-438f-8c6e-1171b5ed17ab INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 681.8769ms 2025-11-29 09:48:44.036 +05:30 537773cc-6b72-438f-8c6e-1171b5ed17ab INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-11-29 09:48:44.047 +05:30 537773cc-6b72-438f-8c6e-1171b5ed17ab INF Request finished HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - 400 97 application/json; charset=utf-8 898.7518ms 2025-11-29 09:49:05.956 +05:30 a38bdf43-44ba-4354-96b6-91180e9db79c INF Request starting HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - null null 2025-11-29 09:49:05.963 +05:30 a38bdf43-44ba-4354-96b6-91180e9db79c INF CORS policy execution successful. 2025-11-29 09:49:05.964 +05:30 a38bdf43-44ba-4354-96b6-91180e9db79c INF Request finished HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - 204 null null 8.9454ms 2025-11-29 09:49:06.025 +05:30 b0430138-bc17-45fd-888f-3479c983ceee INF Request starting HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - null null 2025-11-29 09:49:06.028 +05:30 b0430138-bc17-45fd-888f-3479c983ceee INF CORS policy execution successful. 2025-11-29 09:49:06.031 +05:30 b0430138-bc17-45fd-888f-3479c983ceee INF HTTP request: Path: /transaction/gettransactionsummary QueryString: ?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 Headers: {Accept: application/json, text/plain, */*}, {Accept-Encoding: gzip, deflate}, {Accept-Language: en-US,en;q=0.9}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY0Mzg5ODk2LCJleHAiOjE3NjQzOTM0OTYsImlhdCI6MTc2NDM4OTg5Nn0.tKla8w9AXvwxyt6pJxKrWdSX3gvdIm1XAJnbo4HZdWI}, {Connection: keep-alive}, {Host: 103.120.178.195}, {Referer: http://localhost:5173/}, {User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36}, {Origin: http://localhost:5173} Host: 103.120.178.195 Body: 2025-11-29 09:49:06.039 +05:30 163a1798-22f7-4e87-9ac6-00e023d32d8a INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-11-29 09:49:06.040 +05:30 163a1798-22f7-4e87-9ac6-00e023d32d8a INF Route matched with {action = "GetTransactionSummary", controller = "Transaction"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetTransactionSummary(Sang.Transactions.Api.Models.APIRequest.TransactionSummaryRequest) on controller Sang.Transactions.Api.Controllers.TransactionController (Sang.Transactions.Api). 2025-11-29 09:49:06.070 +05:30 163a1798-22f7-4e87-9ac6-00e023d32d8a ERR Invalid column name 'sNarration'. 2025-11-29 09:49:06.071 +05:30 163a1798-22f7-4e87-9ac6-00e023d32d8a ERR Invalid column name 'sNarration'. 2025-11-29 09:49:06.073 +05:30 163a1798-22f7-4e87-9ac6-00e023d32d8a ERR Error Getting TransactionList1101 from database System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sNarration'. 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.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) 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(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchDataset(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.CoreSettings.Api.Repositories.TransactionRepository.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Services.TransactionService.<>c__DisplayClass12_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteDatasetResult[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String sortColumn, Boolean isAscending, Int32 groupId, String searchString) ClientConnectionId:fadd7784-d568-4440-bd23-eccec087b2e6 Error Number:207,State:1,Class:16 2025-11-29 09:49:06.076 +05:30 163a1798-22f7-4e87-9ac6-00e023d32d8a ERR SQL Exception occurred For DocType:1101: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sNarration'. 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.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) 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(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchDataset(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.CoreSettings.Api.Repositories.TransactionRepository.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Services.TransactionService.<>c__DisplayClass12_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteDatasetResult[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String sortColumn, Boolean isAscending, Int32 groupId, String searchString) at Sang.Transactions.Api.Services.TransactionService.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary(TransactionSummaryRequest summaryRequest) ClientConnectionId:fadd7784-d568-4440-bd23-eccec087b2e6 Error Number:207,State:1,Class:16 2025-11-29 09:49:06.077 +05:30 163a1798-22f7-4e87-9ac6-00e023d32d8a INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-11-29 09:49:06.079 +05:30 163a1798-22f7-4e87-9ac6-00e023d32d8a INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 39.0344ms 2025-11-29 09:49:06.079 +05:30 163a1798-22f7-4e87-9ac6-00e023d32d8a INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-11-29 09:49:06.081 +05:30 163a1798-22f7-4e87-9ac6-00e023d32d8a INF Request finished HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - 400 97 application/json; charset=utf-8 56.4424ms 2025-11-29 09:49:14.104 +05:30 e5b37b88-0eea-4833-85fb-93a9f6be4487 INF Request starting HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - null null 2025-11-29 09:49:14.105 +05:30 e5b37b88-0eea-4833-85fb-93a9f6be4487 INF CORS policy execution successful. 2025-11-29 09:49:14.106 +05:30 e5b37b88-0eea-4833-85fb-93a9f6be4487 INF Request finished HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - 204 null null 2.3607ms 2025-11-29 09:49:14.154 +05:30 a9677355-5a5c-449a-8907-53f3e20d42ed INF Request starting HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - null null 2025-11-29 09:49:14.157 +05:30 a9677355-5a5c-449a-8907-53f3e20d42ed INF CORS policy execution successful. 2025-11-29 09:49:14.157 +05:30 a9677355-5a5c-449a-8907-53f3e20d42ed INF HTTP request: Path: /transaction/gettransactionsummary QueryString: ?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 Headers: {Accept: application/json, text/plain, */*}, {Accept-Encoding: gzip, deflate}, {Accept-Language: en-US,en;q=0.9}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY0Mzg5ODk2LCJleHAiOjE3NjQzOTM0OTYsImlhdCI6MTc2NDM4OTg5Nn0.tKla8w9AXvwxyt6pJxKrWdSX3gvdIm1XAJnbo4HZdWI}, {Connection: keep-alive}, {Host: 103.120.178.195}, {Referer: http://localhost:5173/}, {User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36}, {Origin: http://localhost:5173} Host: 103.120.178.195 Body: 2025-11-29 09:49:14.162 +05:30 f8b5e333-5e82-48ca-b52e-c0142f36c6db INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-11-29 09:49:14.163 +05:30 f8b5e333-5e82-48ca-b52e-c0142f36c6db INF Route matched with {action = "GetTransactionSummary", controller = "Transaction"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetTransactionSummary(Sang.Transactions.Api.Models.APIRequest.TransactionSummaryRequest) on controller Sang.Transactions.Api.Controllers.TransactionController (Sang.Transactions.Api). 2025-11-29 09:49:14.193 +05:30 f8b5e333-5e82-48ca-b52e-c0142f36c6db ERR Invalid column name 'sNarration'. 2025-11-29 09:49:14.194 +05:30 f8b5e333-5e82-48ca-b52e-c0142f36c6db ERR Invalid column name 'sNarration'. 2025-11-29 09:49:14.196 +05:30 f8b5e333-5e82-48ca-b52e-c0142f36c6db ERR Error Getting TransactionList1101 from database System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sNarration'. 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.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) 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(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchDataset(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.CoreSettings.Api.Repositories.TransactionRepository.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Services.TransactionService.<>c__DisplayClass12_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteDatasetResult[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String sortColumn, Boolean isAscending, Int32 groupId, String searchString) ClientConnectionId:fadd7784-d568-4440-bd23-eccec087b2e6 Error Number:207,State:1,Class:16 2025-11-29 09:49:14.197 +05:30 f8b5e333-5e82-48ca-b52e-c0142f36c6db ERR SQL Exception occurred For DocType:1101: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sNarration'. 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.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) 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(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchDataset(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.CoreSettings.Api.Repositories.TransactionRepository.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Services.TransactionService.<>c__DisplayClass12_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteDatasetResult[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String sortColumn, Boolean isAscending, Int32 groupId, String searchString) at Sang.Transactions.Api.Services.TransactionService.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary(TransactionSummaryRequest summaryRequest) ClientConnectionId:fadd7784-d568-4440-bd23-eccec087b2e6 Error Number:207,State:1,Class:16 2025-11-29 09:49:14.198 +05:30 f8b5e333-5e82-48ca-b52e-c0142f36c6db INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-11-29 09:49:14.199 +05:30 f8b5e333-5e82-48ca-b52e-c0142f36c6db INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 35.7518ms 2025-11-29 09:49:14.199 +05:30 f8b5e333-5e82-48ca-b52e-c0142f36c6db INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-11-29 09:49:14.200 +05:30 f8b5e333-5e82-48ca-b52e-c0142f36c6db INF Request finished HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - 400 97 application/json; charset=utf-8 45.7721ms 2025-11-29 09:53:30.612 +05:30 a284e673-3a5e-4ee3-ab24-1b5fe58b313d INF Request starting HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - null null 2025-11-29 09:53:30.615 +05:30 a284e673-3a5e-4ee3-ab24-1b5fe58b313d INF CORS policy execution successful. 2025-11-29 09:53:30.616 +05:30 a284e673-3a5e-4ee3-ab24-1b5fe58b313d INF Request finished HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - 204 null null 5.0381ms 2025-11-29 09:53:30.664 +05:30 0d1a46b6-f857-401f-b33e-7570076edc77 INF Request starting HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - null null 2025-11-29 09:53:30.667 +05:30 0d1a46b6-f857-401f-b33e-7570076edc77 INF CORS policy execution successful. 2025-11-29 09:53:30.669 +05:30 0d1a46b6-f857-401f-b33e-7570076edc77 INF HTTP request: Path: /transaction/gettransactionsummary QueryString: ?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 Headers: {Accept: application/json, text/plain, */*}, {Accept-Encoding: gzip, deflate}, {Accept-Language: en-US,en;q=0.9}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY0Mzg5ODk2LCJleHAiOjE3NjQzOTM0OTYsImlhdCI6MTc2NDM4OTg5Nn0.tKla8w9AXvwxyt6pJxKrWdSX3gvdIm1XAJnbo4HZdWI}, {Connection: keep-alive}, {Host: 103.120.178.195}, {Referer: http://localhost:5173/}, {User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36}, {Origin: http://localhost:5173} Host: 103.120.178.195 Body: 2025-11-29 09:53:30.670 +05:30 79e469a5-394d-4cb6-9727-19f5b6135965 INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-11-29 09:53:30.671 +05:30 79e469a5-394d-4cb6-9727-19f5b6135965 INF Route matched with {action = "GetTransactionSummary", controller = "Transaction"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetTransactionSummary(Sang.Transactions.Api.Models.APIRequest.TransactionSummaryRequest) on controller Sang.Transactions.Api.Controllers.TransactionController (Sang.Transactions.Api). 2025-11-29 09:53:30.692 +05:30 79e469a5-394d-4cb6-9727-19f5b6135965 ERR Invalid column name 'sNarration'. 2025-11-29 09:53:30.692 +05:30 79e469a5-394d-4cb6-9727-19f5b6135965 ERR Invalid column name 'sNarration'. 2025-11-29 09:53:30.695 +05:30 79e469a5-394d-4cb6-9727-19f5b6135965 ERR Error Getting TransactionList1101 from database System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sNarration'. 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.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) 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(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchDataset(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.CoreSettings.Api.Repositories.TransactionRepository.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Services.TransactionService.<>c__DisplayClass12_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteDatasetResult[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String sortColumn, Boolean isAscending, Int32 groupId, String searchString) ClientConnectionId:fadd7784-d568-4440-bd23-eccec087b2e6 Error Number:207,State:1,Class:16 2025-11-29 09:53:30.696 +05:30 79e469a5-394d-4cb6-9727-19f5b6135965 ERR SQL Exception occurred For DocType:1101: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sNarration'. 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.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) 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(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchDataset(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.CoreSettings.Api.Repositories.TransactionRepository.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Services.TransactionService.<>c__DisplayClass12_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteDatasetResult[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String sortColumn, Boolean isAscending, Int32 groupId, String searchString) at Sang.Transactions.Api.Services.TransactionService.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary(TransactionSummaryRequest summaryRequest) ClientConnectionId:fadd7784-d568-4440-bd23-eccec087b2e6 Error Number:207,State:1,Class:16 2025-11-29 09:53:30.697 +05:30 79e469a5-394d-4cb6-9727-19f5b6135965 INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-11-29 09:53:30.698 +05:30 79e469a5-394d-4cb6-9727-19f5b6135965 INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 26.6208ms 2025-11-29 09:53:30.698 +05:30 79e469a5-394d-4cb6-9727-19f5b6135965 INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-11-29 09:53:30.699 +05:30 79e469a5-394d-4cb6-9727-19f5b6135965 INF Request finished HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - 400 97 application/json; charset=utf-8 34.563ms 2025-11-29 09:53:43.393 +05:30 bdd89746-0904-4b71-aa0f-389ec90aa3f0 INF Request starting HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - null null 2025-11-29 09:53:43.394 +05:30 bdd89746-0904-4b71-aa0f-389ec90aa3f0 INF CORS policy execution successful. 2025-11-29 09:53:43.394 +05:30 bdd89746-0904-4b71-aa0f-389ec90aa3f0 INF Request finished HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - 204 null null 1.8713ms 2025-11-29 09:53:43.453 +05:30 a72ca90a-ae63-40be-9594-55d8899b701b INF Request starting HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - null null 2025-11-29 09:53:43.454 +05:30 a72ca90a-ae63-40be-9594-55d8899b701b INF CORS policy execution successful. 2025-11-29 09:53:43.455 +05:30 a72ca90a-ae63-40be-9594-55d8899b701b INF HTTP request: Path: /transaction/gettransactionsummary QueryString: ?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 Headers: {Accept: application/json, text/plain, */*}, {Accept-Encoding: gzip, deflate}, {Accept-Language: en-US,en;q=0.9}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY0Mzg5ODk2LCJleHAiOjE3NjQzOTM0OTYsImlhdCI6MTc2NDM4OTg5Nn0.tKla8w9AXvwxyt6pJxKrWdSX3gvdIm1XAJnbo4HZdWI}, {Connection: keep-alive}, {Host: 103.120.178.195}, {Referer: http://localhost:5173/}, {User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36}, {Origin: http://localhost:5173} Host: 103.120.178.195 Body: 2025-11-29 09:53:43.456 +05:30 14a2c45e-19e9-4ddd-9cf6-ccdc266c39e7 INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-11-29 09:53:43.456 +05:30 14a2c45e-19e9-4ddd-9cf6-ccdc266c39e7 INF Route matched with {action = "GetTransactionSummary", controller = "Transaction"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetTransactionSummary(Sang.Transactions.Api.Models.APIRequest.TransactionSummaryRequest) on controller Sang.Transactions.Api.Controllers.TransactionController (Sang.Transactions.Api). 2025-11-29 09:53:43.472 +05:30 14a2c45e-19e9-4ddd-9cf6-ccdc266c39e7 ERR Invalid column name 'sNarration'. 2025-11-29 09:53:43.473 +05:30 14a2c45e-19e9-4ddd-9cf6-ccdc266c39e7 ERR Invalid column name 'sNarration'. 2025-11-29 09:53:43.474 +05:30 14a2c45e-19e9-4ddd-9cf6-ccdc266c39e7 ERR Error Getting TransactionList1101 from database System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sNarration'. 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.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) 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(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchDataset(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.CoreSettings.Api.Repositories.TransactionRepository.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Services.TransactionService.<>c__DisplayClass12_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteDatasetResult[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String sortColumn, Boolean isAscending, Int32 groupId, String searchString) ClientConnectionId:fadd7784-d568-4440-bd23-eccec087b2e6 Error Number:207,State:1,Class:16 2025-11-29 09:53:43.475 +05:30 14a2c45e-19e9-4ddd-9cf6-ccdc266c39e7 ERR SQL Exception occurred For DocType:1101: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sNarration'. 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.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) 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(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchDataset(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.CoreSettings.Api.Repositories.TransactionRepository.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Services.TransactionService.<>c__DisplayClass12_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteDatasetResult[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String sortColumn, Boolean isAscending, Int32 groupId, String searchString) at Sang.Transactions.Api.Services.TransactionService.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary(TransactionSummaryRequest summaryRequest) ClientConnectionId:fadd7784-d568-4440-bd23-eccec087b2e6 Error Number:207,State:1,Class:16 2025-11-29 09:53:43.476 +05:30 14a2c45e-19e9-4ddd-9cf6-ccdc266c39e7 INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-11-29 09:53:43.476 +05:30 14a2c45e-19e9-4ddd-9cf6-ccdc266c39e7 INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 19.486ms 2025-11-29 09:53:43.477 +05:30 14a2c45e-19e9-4ddd-9cf6-ccdc266c39e7 INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-11-29 09:53:43.477 +05:30 14a2c45e-19e9-4ddd-9cf6-ccdc266c39e7 INF Request finished HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - 400 97 application/json; charset=utf-8 23.9589ms 2025-11-29 10:04:42.749 +05:30 INF Application is shutting down... 2025-11-29 10:08:30.908 +05:30 WRN Using an in-memory repository. Keys will not be persisted to storage. 2025-11-29 10:08:30.942 +05:30 WRN Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2025-11-29 10:08:30.958 +05:30 INF Creating key {81837fb3-873c-4ff9-ad6c-dbdae70c8d8d} with creation date 2025-11-29 04:38:30Z, activation date 2025-11-29 04:38:30Z, and expiration date 2026-02-27 04:38:30Z. 2025-11-29 10:08:30.969 +05:30 WRN No XML encryptor configured. Key {81837fb3-873c-4ff9-ad6c-dbdae70c8d8d} may be persisted to storage in unencrypted form. 2025-11-29 10:08:31.095 +05:30 INF Application started. Press Ctrl+C to shut down. 2025-11-29 10:08:31.096 +05:30 INF Hosting environment: Production 2025-11-29 10:08:31.096 +05:30 INF Content root path: C:\inetpub\wwwroot\SangTransactionsAPI 2025-11-29 10:08:31.109 +05:30 ad46fc1f-f5d8-43c5-a891-dfe82f60cd2a INF Request starting HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - null null 2025-11-29 10:08:31.159 +05:30 ad46fc1f-f5d8-43c5-a891-dfe82f60cd2a INF CORS policy execution successful. 2025-11-29 10:08:31.166 +05:30 ad46fc1f-f5d8-43c5-a891-dfe82f60cd2a INF Request finished HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - 204 null null 58.4768ms 2025-11-29 10:08:31.225 +05:30 27aa3f3a-a4f7-47bc-a705-507a659b506e INF Request starting HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - null null 2025-11-29 10:08:31.351 +05:30 27aa3f3a-a4f7-47bc-a705-507a659b506e INF CORS policy execution successful. 2025-11-29 10:08:31.373 +05:30 27aa3f3a-a4f7-47bc-a705-507a659b506e INF HTTP request: Path: /transaction/gettransactionsummary QueryString: ?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 Headers: {Accept: application/json, text/plain, */*}, {Accept-Encoding: gzip, deflate}, {Accept-Language: en-US,en;q=0.9}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY0Mzg5ODk2LCJleHAiOjE3NjQzOTM0OTYsImlhdCI6MTc2NDM4OTg5Nn0.tKla8w9AXvwxyt6pJxKrWdSX3gvdIm1XAJnbo4HZdWI}, {Connection: keep-alive}, {Host: 103.120.178.195}, {Referer: http://localhost:5173/}, {User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36}, {Origin: http://localhost:5173} Host: 103.120.178.195 Body: 2025-11-29 10:08:31.421 +05:30 7ff00230-e818-460f-a3d3-8f1c3d464281 INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-11-29 10:08:31.445 +05:30 7ff00230-e818-460f-a3d3-8f1c3d464281 INF Route matched with {action = "GetTransactionSummary", controller = "Transaction"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetTransactionSummary(Sang.Transactions.Api.Models.APIRequest.TransactionSummaryRequest) on controller Sang.Transactions.Api.Controllers.TransactionController (Sang.Transactions.Api). 2025-11-29 10:08:31.905 +05:30 7ff00230-e818-460f-a3d3-8f1c3d464281 ERR Invalid column name 'sNarration'. 2025-11-29 10:08:31.914 +05:30 7ff00230-e818-460f-a3d3-8f1c3d464281 ERR Invalid column name 'sNarration'. 2025-11-29 10:08:31.925 +05:30 7ff00230-e818-460f-a3d3-8f1c3d464281 ERR Error Getting TransactionList1101 from database System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sNarration'. 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.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) 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(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchDataset(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.CoreSettings.Api.Repositories.TransactionRepository.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Services.TransactionService.<>c__DisplayClass12_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteDatasetResult[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String sortColumn, Boolean isAscending, Int32 groupId, String searchString) ClientConnectionId:9ac2167a-e461-4d54-bace-5b193001aab4 Error Number:207,State:1,Class:16 2025-11-29 10:08:31.930 +05:30 7ff00230-e818-460f-a3d3-8f1c3d464281 ERR SQL Exception occurred For DocType:1101: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sNarration'. 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.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) 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(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchDataset(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.CoreSettings.Api.Repositories.TransactionRepository.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Services.TransactionService.<>c__DisplayClass12_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteDatasetResult[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String sortColumn, Boolean isAscending, Int32 groupId, String searchString) at Sang.Transactions.Api.Services.TransactionService.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary(TransactionSummaryRequest summaryRequest) ClientConnectionId:9ac2167a-e461-4d54-bace-5b193001aab4 Error Number:207,State:1,Class:16 2025-11-29 10:08:31.939 +05:30 7ff00230-e818-460f-a3d3-8f1c3d464281 INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-11-29 10:08:31.999 +05:30 7ff00230-e818-460f-a3d3-8f1c3d464281 INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 550.3533ms 2025-11-29 10:08:32.000 +05:30 7ff00230-e818-460f-a3d3-8f1c3d464281 INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-11-29 10:08:32.014 +05:30 7ff00230-e818-460f-a3d3-8f1c3d464281 INF Request finished HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - 400 97 application/json; charset=utf-8 788.8138ms 2025-11-29 10:19:30.947 +05:30 INF Application is shutting down... 2025-11-29 10:44:34.185 +05:30 WRN Using an in-memory repository. Keys will not be persisted to storage. 2025-11-29 10:44:34.240 +05:30 WRN Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2025-11-29 10:44:34.267 +05:30 INF Creating key {2775ad2e-e9a9-43d9-bae5-5e357e1ab935} with creation date 2025-11-29 05:14:34Z, activation date 2025-11-29 05:14:34Z, and expiration date 2026-02-27 05:14:34Z. 2025-11-29 10:44:34.281 +05:30 WRN No XML encryptor configured. Key {2775ad2e-e9a9-43d9-bae5-5e357e1ab935} may be persisted to storage in unencrypted form. 2025-11-29 10:44:34.433 +05:30 INF Application started. Press Ctrl+C to shut down. 2025-11-29 10:44:34.433 +05:30 INF Hosting environment: Production 2025-11-29 10:44:34.433 +05:30 INF Content root path: C:\inetpub\wwwroot\SangTransactionsAPI 2025-11-29 10:44:34.446 +05:30 52450bba-f878-4194-8ebd-fd7e0db2334d INF Request starting HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - null null 2025-11-29 10:44:34.502 +05:30 52450bba-f878-4194-8ebd-fd7e0db2334d INF CORS policy execution successful. 2025-11-29 10:44:34.510 +05:30 52450bba-f878-4194-8ebd-fd7e0db2334d INF Request finished HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - 204 null null 66.113ms 2025-11-29 10:44:34.566 +05:30 12569502-9e16-4551-a09a-5133061e6bef INF Request starting HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - null null 2025-11-29 10:44:34.671 +05:30 12569502-9e16-4551-a09a-5133061e6bef INF CORS policy execution successful. 2025-11-29 10:44:34.689 +05:30 12569502-9e16-4551-a09a-5133061e6bef INF HTTP request: Path: /transaction/gettransactionsummary QueryString: ?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 Headers: {Accept: application/json, text/plain, */*}, {Accept-Encoding: gzip, deflate}, {Accept-Language: en-US,en;q=0.9}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY0Mzg5ODk2LCJleHAiOjE3NjQzOTM0OTYsImlhdCI6MTc2NDM4OTg5Nn0.tKla8w9AXvwxyt6pJxKrWdSX3gvdIm1XAJnbo4HZdWI}, {Connection: keep-alive}, {Host: 103.120.178.195}, {Referer: http://localhost:5173/}, {User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36}, {Origin: http://localhost:5173} Host: 103.120.178.195 Body: 2025-11-29 10:44:34.727 +05:30 a01f23d9-a7a3-4a9e-9d75-1a16732fc522 INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-11-29 10:44:34.752 +05:30 a01f23d9-a7a3-4a9e-9d75-1a16732fc522 INF Route matched with {action = "GetTransactionSummary", controller = "Transaction"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetTransactionSummary(Sang.Transactions.Api.Models.APIRequest.TransactionSummaryRequest) on controller Sang.Transactions.Api.Controllers.TransactionController (Sang.Transactions.Api). 2025-11-29 10:44:35.155 +05:30 a01f23d9-a7a3-4a9e-9d75-1a16732fc522 ERR Invalid column name 'sNarration'. 2025-11-29 10:44:35.163 +05:30 a01f23d9-a7a3-4a9e-9d75-1a16732fc522 ERR Invalid column name 'sNarration'. 2025-11-29 10:44:35.173 +05:30 a01f23d9-a7a3-4a9e-9d75-1a16732fc522 ERR Error Getting TransactionList1101 from database System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sNarration'. 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.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) 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(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchDataset(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.CoreSettings.Api.Repositories.TransactionRepository.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Services.TransactionService.<>c__DisplayClass12_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteDatasetResult[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String sortColumn, Boolean isAscending, Int32 groupId, String searchString) ClientConnectionId:c954b9e7-0e59-4dee-928b-a2ba99637fdc Error Number:207,State:1,Class:16 2025-11-29 10:44:35.176 +05:30 a01f23d9-a7a3-4a9e-9d75-1a16732fc522 ERR SQL Exception occurred For DocType:1101: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sNarration'. 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.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) 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(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchDataset(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.CoreSettings.Api.Repositories.TransactionRepository.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Services.TransactionService.<>c__DisplayClass12_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteDatasetResult[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String sortColumn, Boolean isAscending, Int32 groupId, String searchString) at Sang.Transactions.Api.Services.TransactionService.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary(TransactionSummaryRequest summaryRequest) ClientConnectionId:c954b9e7-0e59-4dee-928b-a2ba99637fdc Error Number:207,State:1,Class:16 2025-11-29 10:44:35.186 +05:30 a01f23d9-a7a3-4a9e-9d75-1a16732fc522 INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-11-29 10:44:35.249 +05:30 a01f23d9-a7a3-4a9e-9d75-1a16732fc522 INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 492.0355ms 2025-11-29 10:44:35.250 +05:30 a01f23d9-a7a3-4a9e-9d75-1a16732fc522 INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-11-29 10:44:35.259 +05:30 a01f23d9-a7a3-4a9e-9d75-1a16732fc522 INF Request finished HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - 400 97 application/json; charset=utf-8 693.6447ms 2025-11-29 10:55:34.108 +05:30 INF Application is shutting down... 2025-11-29 12:05:35.394 +05:30 WRN Using an in-memory repository. Keys will not be persisted to storage. 2025-11-29 12:05:35.445 +05:30 WRN Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2025-11-29 12:05:35.467 +05:30 INF Creating key {a96bb0ef-6be2-4de1-be9e-59c30a58723d} with creation date 2025-11-29 06:35:35Z, activation date 2025-11-29 06:35:35Z, and expiration date 2026-02-27 06:35:35Z. 2025-11-29 12:05:35.482 +05:30 WRN No XML encryptor configured. Key {a96bb0ef-6be2-4de1-be9e-59c30a58723d} may be persisted to storage in unencrypted form. 2025-11-29 12:05:35.647 +05:30 INF Application started. Press Ctrl+C to shut down. 2025-11-29 12:05:35.648 +05:30 INF Hosting environment: Production 2025-11-29 12:05:35.648 +05:30 INF Content root path: C:\inetpub\wwwroot\SangTransactionsAPI 2025-11-29 12:05:35.662 +05:30 fc026338-9284-484f-88e7-06eb5ada764c INF Request starting HTTP/1.1 POST http://103.120.178.195/SangTransactionsAPI/transactionpost/upsertpurchase - application/json 4367 2025-11-29 12:05:35.802 +05:30 fc026338-9284-484f-88e7-06eb5ada764c INF Failed to validate the token.Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: IDX10223: Lifetime validation failed. The token is expired. ValidTo (UTC): '7/25/2025 6:17:40 PM', Current time (UTC): '11/29/2025 6:35:35 AM'. at Microsoft.IdentityModel.Tokens.Validators.ValidateLifetime(Nullable`1 notBefore, Nullable`1 expires, SecurityToken securityToken, TokenValidationParameters validationParameters) at Microsoft.IdentityModel.JsonWebTokens.JsonWebTokenHandler.ValidateTokenPayloadAsync(JsonWebToken jsonWebToken, TokenValidationParameters validationParameters, BaseConfiguration configuration) at Microsoft.IdentityModel.JsonWebTokens.JsonWebTokenHandler.ValidateJWSAsync(JsonWebToken jsonWebToken, TokenValidationParameters validationParameters, BaseConfiguration configuration) 2025-11-29 12:05:35.813 +05:30 fc026338-9284-484f-88e7-06eb5ada764c INF Bearer was not authenticated. Failure message: IDX10223: Lifetime validation failed. The token is expired. ValidTo (UTC): '7/25/2025 6:17:40 PM', Current time (UTC): '11/29/2025 6:35:35 AM'. 2025-11-29 12:05:35.853 +05:30 fc026338-9284-484f-88e7-06eb5ada764c INF HTTP request: Path: /transactionpost/upsertpurchase QueryString: Headers: {Accept: */*}, {Accept-Encoding: gzip, deflate, br}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiVGVzdFVzZXIyIiwidW5pcXVlX25hbWUiOiJUZXN0VXNlcjIiLCJuYW1laWQiOiI3IiwiQ3VzdG9tQ2xhaW1UeXBlIjpbIkRhdGFiYXNlS2V5IiwiRGF0YWJhc2VOYW1lIiwiQ2hhbm5lbElkIiwiTGFuZ3VhZ2VJZCJdLCJEYXRhYmFzZUtleSI6IjciLCJEYXRhYmFzZU5hbWUiOiJTUzAwMDEiLCJDaGFubmVsSWQiOiIyIiwiTGFuZ3VhZ2VJZCI6IjEiLCJuYmYiOjE3NTM0NjU2NjAsImV4cCI6MTc1MzQ2NzQ2MCwiaWF0IjoxNzUzNDY1NjYwfQ.nS0IbOs22MUN3X1DdqmMyBumUZuSz8u9XB8tVXAaF8A}, {Connection: keep-alive}, {Content-Length: 4367}, {Content-Type: application/json}, {Host: 103.120.178.195}, {User-Agent: PostmanRuntime/7.49.1}, {Postman-Token: 85d56fec-df3b-48a0-a060-4af46e554273} Host: 103.120.178.195 Body: { "viewId":10, "baseDoc":1101, "transHeader": { "transId":0, "date":"2025-07-01", "docType":1101, "docNo": "es*001goo1", "aC1":2, "priorityLevel":1, "channel":1, "net":100, "origNet":102.9, "repost":false, "be":1, "draft":false, "exchRateDiff":0 }, "transHeaderDetails": { "PlaceOfSupply":1, "Narration":"Narration1", "gross":200 }, "transBodyDetails": [ { "Id":1, "AdditionalCharges":5.0, "Discount":2.0, "Discount%":2, "TaxableAmt":3.0, "VAT%":1.1, "VATAmt":2.1, "ExciseTax": 1.2, "Subsidy":2 },{ "Id":2, "AdditionalCharges": 6.0, "TaxableAmt":4.0, "ExciseTax": 2.2 } ], "transAttachDetails": [ { "slNo": 1, "attachType": 1, "refNo": "1", "fileName": "fileName1" },{ "slNo": 2, "attachType": 1, "refNo": "2", "fileName": "" } ], "transFinanceDetails": [ { "transDtId": 0, "date": "2025-07-01", "siNo": 1, "custVend": 9, "currency": 1, "exchRate": 1, "gross": 100, "baseAmount": 100, "transAmount": 100, "dueDate": "2025-07-01", "pdc": true, "cogs": true, "forex": true, "void": false, "auth": 0, "status": 0, "type": 0, "mTransDtId": 0, "locked": false, "reconciled": false, "reversed": false, "authLevel": 0, "refTransId": 0, "linkTransId": 0, "be": 1, "tag1": 1, "tag2": 1, "tag3": 1 } ], "transDetails": [ { "transDtId": 0, "date": "2025-07-01", "siNo": 1, "product": 41, "qty": 2, "baseQty": 2, "altQty": 2, "unit": 11, "rate": 100, "gross": 200, "stockValue": 200, "netValue": 200, "dueDate": "2025-07-01", "updateInv": true, "pdc": false, "cogs": false, "forex": false, "void": false, "auth": 0, "status": 0, "type": 0, "mTransDtId": 0, "locked": false, "reconciled": false, "reversed": false, "authLevel": 0, "refTransId": 0, "linkTransId": 0, "be": 1, "warehouse": 1, "tag1": 1, "tag2": 1, "tag3": 1, "batchNo": "b1", "expDate": "2025-08-01", "mfDate": "2025-07-01" }, { "transDtId": 0, "date": "2025-07-01", "siNo": 1, "product": 42, "qty": 3, "baseQty": 2, "altQty": 2, "unit": 11, "rate": 100, "gross": 300, "stockValue": 200, "netValue": 200, "dueDate": "2025-08-01", "updateInv": true, "pdc": false, "cogs": false, "forex": false, "void": false, "auth": 0, "status": 0, "type": 0, "mTransDtId": 0, "locked": false, "reconciled": false, "reversed": false, "authLevel": 0, "refTransId": 0, "linkTransId": 0, "be": 1, "warehouse": 1, "tag1": 1, "tag2": 1, "tag3": 1, "batchNo": "b1", "expDate": "2025-08-01", "mfDate": "2025-07-01" } ], "transSerialNoDetails": [ { "id": 1, "siNo": 1, "serialNo": "serialNo1", "be": 1, "warehouse": 1, "tag1": 1, "tag2": 1, "tag3": 1 } ], "transReferenceDetails": [ { "id": 1, "adjType": 1, "be": 1, "docType": 1101, "docNo": "es*001goo", "date": "2025-07-01", "payMethod": 1, "account": 1, "currency": 1, "exchRate": 1, "amount": 100, "orgAmount": 100, "exchDiff": 0, "dueDate": "2025-07-01", "reference": "", "narration": "testpost1", "pdc": false, "converted": false, "refId": 0 } ], "transLinkDetails": [ { "id": 1, "linkDocType": 2, "linkDocNo": "lDoc1", "linkDate": "2025-07-01", "product": 12, "linkedTransId": 1, "linkedTransDtId": 12, "qty": 10, "aC1": 1, "aC2": 1 } ] } 2025-11-29 12:05:35.896 +05:30 2230b043-a827-4d0a-9ce0-3cbc2107c010 INF Authorization failed. These requirements were not met: DenyAnonymousAuthorizationRequirement: Requires an authenticated user. 2025-11-29 12:05:35.908 +05:30 2230b043-a827-4d0a-9ce0-3cbc2107c010 INF AuthenticationScheme: Bearer was challenged. 2025-11-29 12:05:35.909 +05:30 2230b043-a827-4d0a-9ce0-3cbc2107c010 INF HTTP Response: StatusCode: 401 Headers: {X-Correlation-Id: fc026338-9284-484f-88e7-06eb5ada764c}, {X-Token-Expired: true}, {WWW-Authenticate: Bearer error="invalid_token", error_description="The token expired at '07/25/2025 18:17:40'"} Body: 2025-11-29 12:05:35.923 +05:30 2230b043-a827-4d0a-9ce0-3cbc2107c010 INF Request finished HTTP/1.1 POST http://103.120.178.195/SangTransactionsAPI/transactionpost/upsertpurchase - 401 null null 263.0418ms 2025-11-29 12:08:19.915 +05:30 17511c23-00d0-40ba-b2e8-67d135342755 INF Request starting HTTP/1.1 POST http://103.120.178.195/SangTransactionsAPI/transactionpost/upsertpurchase - application/json 4367 2025-11-29 12:08:19.945 +05:30 17511c23-00d0-40ba-b2e8-67d135342755 INF HTTP request: Path: /transactionpost/upsertpurchase QueryString: Headers: {Accept: */*}, {Accept-Encoding: gzip, deflate, br}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiVGVzdFVzZXIyIiwidW5pcXVlX25hbWUiOiJUZXN0VXNlcjIiLCJuYW1laWQiOiI3IiwiQ3VzdG9tQ2xhaW1UeXBlIjpbIkRhdGFiYXNlS2V5IiwiRGF0YWJhc2VOYW1lIiwiQ2hhbm5lbElkIiwiTGFuZ3VhZ2VJZCJdLCJEYXRhYmFzZUtleSI6IjciLCJEYXRhYmFzZU5hbWUiOiJTUzAwMDEiLCJDaGFubmVsSWQiOiIyIiwiTGFuZ3VhZ2VJZCI6IjEiLCJuYmYiOjE3NjQzOTgyNTksImV4cCI6MTc2NDQwMTg1OSwiaWF0IjoxNzY0Mzk4MjU5fQ.WG85KrDoPX2G2LwqxiuTiUeeXG7s9xzC05vkzDDNGRM}, {Connection: keep-alive}, {Content-Length: 4367}, {Content-Type: application/json}, {Host: 103.120.178.195}, {User-Agent: PostmanRuntime/7.49.1}, {Postman-Token: 78f7a63d-f2bd-4de7-8127-ea9896125a8a} Host: 103.120.178.195 Body: { "viewId":10, "baseDoc":1101, "transHeader": { "transId":0, "date":"2025-07-01", "docType":1101, "docNo": "es*001goo1", "aC1":2, "priorityLevel":1, "channel":1, "net":100, "origNet":102.9, "repost":false, "be":1, "draft":false, "exchRateDiff":0 }, "transHeaderDetails": { "PlaceOfSupply":1, "Narration":"Narration1", "gross":200 }, "transBodyDetails": [ { "Id":1, "AdditionalCharges":5.0, "Discount":2.0, "Discount%":2, "TaxableAmt":3.0, "VAT%":1.1, "VATAmt":2.1, "ExciseTax": 1.2, "Subsidy":2 },{ "Id":2, "AdditionalCharges": 6.0, "TaxableAmt":4.0, "ExciseTax": 2.2 } ], "transAttachDetails": [ { "slNo": 1, "attachType": 1, "refNo": "1", "fileName": "fileName1" },{ "slNo": 2, "attachType": 1, "refNo": "2", "fileName": "" } ], "transFinanceDetails": [ { "transDtId": 0, "date": "2025-07-01", "siNo": 1, "custVend": 9, "currency": 1, "exchRate": 1, "gross": 100, "baseAmount": 100, "transAmount": 100, "dueDate": "2025-07-01", "pdc": true, "cogs": true, "forex": true, "void": false, "auth": 0, "status": 0, "type": 0, "mTransDtId": 0, "locked": false, "reconciled": false, "reversed": false, "authLevel": 0, "refTransId": 0, "linkTransId": 0, "be": 1, "tag1": 1, "tag2": 1, "tag3": 1 } ], "transDetails": [ { "transDtId": 0, "date": "2025-07-01", "siNo": 1, "product": 41, "qty": 2, "baseQty": 2, "altQty": 2, "unit": 11, "rate": 100, "gross": 200, "stockValue": 200, "netValue": 200, "dueDate": "2025-07-01", "updateInv": true, "pdc": false, "cogs": false, "forex": false, "void": false, "auth": 0, "status": 0, "type": 0, "mTransDtId": 0, "locked": false, "reconciled": false, "reversed": false, "authLevel": 0, "refTransId": 0, "linkTransId": 0, "be": 1, "warehouse": 1, "tag1": 1, "tag2": 1, "tag3": 1, "batchNo": "b1", "expDate": "2025-08-01", "mfDate": "2025-07-01" }, { "transDtId": 0, "date": "2025-07-01", "siNo": 1, "product": 42, "qty": 3, "baseQty": 2, "altQty": 2, "unit": 11, "rate": 100, "gross": 300, "stockValue": 200, "netValue": 200, "dueDate": "2025-08-01", "updateInv": true, "pdc": false, "cogs": false, "forex": false, "void": false, "auth": 0, "status": 0, "type": 0, "mTransDtId": 0, "locked": false, "reconciled": false, "reversed": false, "authLevel": 0, "refTransId": 0, "linkTransId": 0, "be": 1, "warehouse": 1, "tag1": 1, "tag2": 1, "tag3": 1, "batchNo": "b1", "expDate": "2025-08-01", "mfDate": "2025-07-01" } ], "transSerialNoDetails": [ { "id": 1, "siNo": 1, "serialNo": "serialNo1", "be": 1, "warehouse": 1, "tag1": 1, "tag2": 1, "tag3": 1 } ], "transReferenceDetails": [ { "id": 1, "adjType": 1, "be": 1, "docType": 1101, "docNo": "es*001goo", "date": "2025-07-01", "payMethod": 1, "account": 1, "currency": 1, "exchRate": 1, "amount": 100, "orgAmount": 100, "exchDiff": 0, "dueDate": "2025-07-01", "reference": "", "narration": "testpost1", "pdc": false, "converted": false, "refId": 0 } ], "transLinkDetails": [ { "id": 1, "linkDocType": 2, "linkDocNo": "lDoc1", "linkDate": "2025-07-01", "product": 12, "linkedTransId": 1, "linkedTransDtId": 12, "qty": 10, "aC1": 1, "aC2": 1 } ] } 2025-11-29 12:08:19.957 +05:30 13006cfa-5d38-42ec-a882-f16e623ab3c1 INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionPostController.UpsertPurchase (Sang.Transactions.Api)' 2025-11-29 12:08:19.993 +05:30 13006cfa-5d38-42ec-a882-f16e623ab3c1 INF Route matched with {action = "UpsertPurchase", controller = "TransactionPost"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] UpsertPurchase(Sang.Transactions.Api.Models.TransactionUpsertRequest.PurchaseRequest) on controller Sang.Transactions.Api.Controllers.TransactionPostController (Sang.Transactions.Api). 2025-11-29 12:08:21.240 +05:30 13006cfa-5d38-42ec-a882-f16e623ab3c1 INF Executing ConflictObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-11-29 12:08:21.266 +05:30 13006cfa-5d38-42ec-a882-f16e623ab3c1 INF Executed action Sang.Transactions.Api.Controllers.TransactionPostController.UpsertPurchase (Sang.Transactions.Api) in 1268.4051ms 2025-11-29 12:08:21.267 +05:30 13006cfa-5d38-42ec-a882-f16e623ab3c1 INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionPostController.UpsertPurchase (Sang.Transactions.Api)' 2025-11-29 12:08:21.268 +05:30 13006cfa-5d38-42ec-a882-f16e623ab3c1 INF HTTP Response: StatusCode: 409 Headers: {X-Correlation-Id: 17511c23-00d0-40ba-b2e8-67d135342755}, {Content-Type: application/json; charset=utf-8}, {Content-Length: 91} Body: {"status":"Failure","statusCode":3002,"message":"Donnot Allow Expired Batch","result":null} 2025-11-29 12:08:21.273 +05:30 13006cfa-5d38-42ec-a882-f16e623ab3c1 INF Request finished HTTP/1.1 POST http://103.120.178.195/SangTransactionsAPI/transactionpost/upsertpurchase - 409 91 application/json; charset=utf-8 1358.8857ms 2025-11-29 12:18:35.066 +05:30 INF Application is shutting down... 2025-11-29 12:35:58.419 +05:30 WRN Using an in-memory repository. Keys will not be persisted to storage. 2025-11-29 12:35:58.458 +05:30 WRN Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2025-11-29 12:35:58.475 +05:30 INF Creating key {3fbd3012-03df-49eb-b188-94bcf1ca9c33} with creation date 2025-11-29 07:05:58Z, activation date 2025-11-29 07:05:58Z, and expiration date 2026-02-27 07:05:58Z. 2025-11-29 12:35:58.489 +05:30 WRN No XML encryptor configured. Key {3fbd3012-03df-49eb-b188-94bcf1ca9c33} may be persisted to storage in unencrypted form. 2025-11-29 12:35:58.637 +05:30 INF Application started. Press Ctrl+C to shut down. 2025-11-29 12:35:58.637 +05:30 INF Hosting environment: Production 2025-11-29 12:35:58.637 +05:30 INF Content root path: C:\inetpub\wwwroot\SangTransactionsAPI 2025-11-29 12:35:58.649 +05:30 de87b759-0fb4-48c1-9864-d0a010a68583 INF Request starting HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - null null 2025-11-29 12:35:58.697 +05:30 de87b759-0fb4-48c1-9864-d0a010a68583 INF CORS policy execution successful. 2025-11-29 12:35:58.703 +05:30 de87b759-0fb4-48c1-9864-d0a010a68583 INF Request finished HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - 204 null null 56.4126ms 2025-11-29 12:35:58.924 +05:30 f4c25cbe-5ffd-4a2e-8ab8-236382ddd87e INF Request starting HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - null null 2025-11-29 12:35:59.051 +05:30 f4c25cbe-5ffd-4a2e-8ab8-236382ddd87e INF CORS policy execution successful. 2025-11-29 12:35:59.069 +05:30 f4c25cbe-5ffd-4a2e-8ab8-236382ddd87e INF HTTP request: Path: /transaction/gettransactionsummary QueryString: ?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 Headers: {Accept: application/json, text/plain, */*}, {Accept-Encoding: gzip, deflate}, {Accept-Language: en-US,en;q=0.9}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY0Mzk2OTgxLCJleHAiOjE3NjQ0MDA1ODEsImlhdCI6MTc2NDM5Njk4MX0.6iD1bri-DTxY11jv_hAJBcf5-9RQcOTgeNvKN95ksEo}, {Connection: keep-alive}, {Host: 103.120.178.195}, {Referer: http://localhost:5173/}, {User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36}, {Origin: http://localhost:5173} Host: 103.120.178.195 Body: 2025-11-29 12:35:59.108 +05:30 22a0dcfe-11b3-4109-a295-62830446deca INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-11-29 12:35:59.135 +05:30 22a0dcfe-11b3-4109-a295-62830446deca INF Route matched with {action = "GetTransactionSummary", controller = "Transaction"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetTransactionSummary(Sang.Transactions.Api.Models.APIRequest.TransactionSummaryRequest) on controller Sang.Transactions.Api.Controllers.TransactionController (Sang.Transactions.Api). 2025-11-29 12:35:59.618 +05:30 22a0dcfe-11b3-4109-a295-62830446deca ERR Invalid column name 'sNarration'. 2025-11-29 12:35:59.630 +05:30 22a0dcfe-11b3-4109-a295-62830446deca ERR Invalid column name 'sNarration'. 2025-11-29 12:35:59.643 +05:30 22a0dcfe-11b3-4109-a295-62830446deca ERR Error Getting TransactionList1101 from database System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sNarration'. 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.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) 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(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchDataset(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.CoreSettings.Api.Repositories.TransactionRepository.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Services.TransactionService.<>c__DisplayClass12_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteDatasetResult[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String sortColumn, Boolean isAscending, Int32 groupId, String searchString) ClientConnectionId:77dde2b5-2037-47f3-9ff2-8f524bd71a64 Error Number:207,State:1,Class:16 2025-11-29 12:35:59.646 +05:30 22a0dcfe-11b3-4109-a295-62830446deca ERR SQL Exception occurred For DocType:1101: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sNarration'. 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.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) 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(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchDataset(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.CoreSettings.Api.Repositories.TransactionRepository.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Services.TransactionService.<>c__DisplayClass12_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteDatasetResult[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String sortColumn, Boolean isAscending, Int32 groupId, String searchString) at Sang.Transactions.Api.Services.TransactionService.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary(TransactionSummaryRequest summaryRequest) ClientConnectionId:77dde2b5-2037-47f3-9ff2-8f524bd71a64 Error Number:207,State:1,Class:16 2025-11-29 12:35:59.655 +05:30 22a0dcfe-11b3-4109-a295-62830446deca INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-11-29 12:35:59.714 +05:30 22a0dcfe-11b3-4109-a295-62830446deca INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 574.9661ms 2025-11-29 12:35:59.715 +05:30 22a0dcfe-11b3-4109-a295-62830446deca INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-11-29 12:35:59.726 +05:30 22a0dcfe-11b3-4109-a295-62830446deca INF Request finished HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - 400 97 application/json; charset=utf-8 802.7223ms 2025-11-29 12:46:58.373 +05:30 INF Application is shutting down... 2025-11-29 12:50:40.650 +05:30 WRN Using an in-memory repository. Keys will not be persisted to storage. 2025-11-29 12:50:40.689 +05:30 WRN Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2025-11-29 12:50:40.707 +05:30 INF Creating key {8df86fcd-1e51-4d3c-b87a-af17599b1e70} with creation date 2025-11-29 07:20:40Z, activation date 2025-11-29 07:20:40Z, and expiration date 2026-02-27 07:20:40Z. 2025-11-29 12:50:40.719 +05:30 WRN No XML encryptor configured. Key {8df86fcd-1e51-4d3c-b87a-af17599b1e70} may be persisted to storage in unencrypted form. 2025-11-29 12:50:40.883 +05:30 INF Application started. Press Ctrl+C to shut down. 2025-11-29 12:50:40.883 +05:30 INF Hosting environment: Production 2025-11-29 12:50:40.883 +05:30 INF Content root path: C:\inetpub\wwwroot\SangTransactionsAPI 2025-11-29 12:50:40.895 +05:30 e5175b0d-ad34-4e87-a58f-cb6247a20c4d INF Request starting HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - null null 2025-11-29 12:50:40.947 +05:30 e5175b0d-ad34-4e87-a58f-cb6247a20c4d INF CORS policy execution successful. 2025-11-29 12:50:40.956 +05:30 e5175b0d-ad34-4e87-a58f-cb6247a20c4d INF Request finished HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - 204 null null 63.2295ms 2025-11-29 12:50:41.011 +05:30 86a557f8-9e22-4f7f-8037-0205a687cf3d INF Request starting HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - null null 2025-11-29 12:50:41.121 +05:30 86a557f8-9e22-4f7f-8037-0205a687cf3d INF CORS policy execution successful. 2025-11-29 12:50:41.142 +05:30 86a557f8-9e22-4f7f-8037-0205a687cf3d INF HTTP request: Path: /transaction/gettransactionsummary QueryString: ?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 Headers: {Accept: application/json, text/plain, */*}, {Accept-Encoding: gzip, deflate}, {Accept-Language: en-US,en;q=0.9}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY0NDAwNTg0LCJleHAiOjE3NjQ0MDQxODQsImlhdCI6MTc2NDQwMDU4NH0.xo2aKPBtYG9j-IlO4Nr-GW-x4huQljdgllBaCESV-oI}, {Connection: keep-alive}, {Host: 103.120.178.195}, {Referer: http://localhost:5173/}, {User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36}, {Origin: http://localhost:5173} Host: 103.120.178.195 Body: 2025-11-29 12:50:41.188 +05:30 acbd5785-6bde-4ca4-bda1-56d5b9c7f992 INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-11-29 12:50:41.222 +05:30 acbd5785-6bde-4ca4-bda1-56d5b9c7f992 INF Route matched with {action = "GetTransactionSummary", controller = "Transaction"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetTransactionSummary(Sang.Transactions.Api.Models.APIRequest.TransactionSummaryRequest) on controller Sang.Transactions.Api.Controllers.TransactionController (Sang.Transactions.Api). 2025-11-29 12:50:41.674 +05:30 acbd5785-6bde-4ca4-bda1-56d5b9c7f992 ERR Invalid column name 'sNarration'. 2025-11-29 12:50:41.688 +05:30 acbd5785-6bde-4ca4-bda1-56d5b9c7f992 ERR Invalid column name 'sNarration'. 2025-11-29 12:50:41.706 +05:30 acbd5785-6bde-4ca4-bda1-56d5b9c7f992 ERR Error Getting TransactionList1101 from database System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sNarration'. 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.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) 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(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchDataset(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.CoreSettings.Api.Repositories.TransactionRepository.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Services.TransactionService.<>c__DisplayClass12_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteDatasetResult[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String sortColumn, Boolean isAscending, Int32 groupId, String searchString) ClientConnectionId:ad71adec-0c80-475f-8e66-58f9fe52a5ea Error Number:207,State:1,Class:16 2025-11-29 12:50:41.709 +05:30 acbd5785-6bde-4ca4-bda1-56d5b9c7f992 ERR SQL Exception occurred For DocType:1101: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sNarration'. 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.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) 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(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchDataset(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.CoreSettings.Api.Repositories.TransactionRepository.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Services.TransactionService.<>c__DisplayClass12_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteDatasetResult[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String sortColumn, Boolean isAscending, Int32 groupId, String searchString) at Sang.Transactions.Api.Services.TransactionService.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary(TransactionSummaryRequest summaryRequest) ClientConnectionId:ad71adec-0c80-475f-8e66-58f9fe52a5ea Error Number:207,State:1,Class:16 2025-11-29 12:50:41.718 +05:30 acbd5785-6bde-4ca4-bda1-56d5b9c7f992 INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-11-29 12:50:41.782 +05:30 acbd5785-6bde-4ca4-bda1-56d5b9c7f992 INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 555.3166ms 2025-11-29 12:50:41.783 +05:30 acbd5785-6bde-4ca4-bda1-56d5b9c7f992 INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-11-29 12:50:41.793 +05:30 acbd5785-6bde-4ca4-bda1-56d5b9c7f992 INF Request finished HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - 400 97 application/json; charset=utf-8 781.6295ms 2025-11-29 13:01:40.578 +05:30 INF Application is shutting down... 2025-11-29 15:23:05.663 +05:30 WRN Using an in-memory repository. Keys will not be persisted to storage. 2025-11-29 15:23:05.703 +05:30 WRN Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2025-11-29 15:23:05.725 +05:30 INF Creating key {ce252d80-1a71-4979-9059-6879dfbb7940} with creation date 2025-11-29 09:53:05Z, activation date 2025-11-29 09:53:05Z, and expiration date 2026-02-27 09:53:05Z. 2025-11-29 15:23:05.736 +05:30 WRN No XML encryptor configured. Key {ce252d80-1a71-4979-9059-6879dfbb7940} may be persisted to storage in unencrypted form. 2025-11-29 15:23:05.871 +05:30 INF Application started. Press Ctrl+C to shut down. 2025-11-29 15:23:05.872 +05:30 INF Hosting environment: Production 2025-11-29 15:23:05.872 +05:30 INF Content root path: C:\inetpub\wwwroot\SangTransactionsAPI 2025-11-29 15:23:05.884 +05:30 787c6a8e-6c52-4fdf-89cb-1d15d0a25fa3 INF Request starting HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - null null 2025-11-29 15:23:05.929 +05:30 787c6a8e-6c52-4fdf-89cb-1d15d0a25fa3 INF CORS policy execution successful. 2025-11-29 15:23:05.935 +05:30 787c6a8e-6c52-4fdf-89cb-1d15d0a25fa3 INF Request finished HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - 204 null null 52.6009ms 2025-11-29 15:23:05.990 +05:30 9f7e3047-636c-4b83-9f30-7fe42986dc78 INF Request starting HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - null null 2025-11-29 15:23:06.095 +05:30 9f7e3047-636c-4b83-9f30-7fe42986dc78 INF CORS policy execution successful. 2025-11-29 15:23:06.111 +05:30 9f7e3047-636c-4b83-9f30-7fe42986dc78 INF HTTP request: Path: /transaction/gettransactionsummary QueryString: ?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 Headers: {Accept: application/json, text/plain, */*}, {Accept-Encoding: gzip, deflate}, {Accept-Language: en-US,en;q=0.9}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY0NDA5ODkwLCJleHAiOjE3NjQ0MTM0OTAsImlhdCI6MTc2NDQwOTg5MH0.n3N_IsoAV79WIJUvwKoNNZyROBjoR7yFVeMA6aGh56w}, {Connection: keep-alive}, {Host: 103.120.178.195}, {Referer: http://localhost:5173/}, {User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36}, {Origin: http://localhost:5173} Host: 103.120.178.195 Body: 2025-11-29 15:23:06.150 +05:30 208b9344-3727-48bc-b7bd-829ddf71fc74 INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-11-29 15:23:06.176 +05:30 208b9344-3727-48bc-b7bd-829ddf71fc74 INF Route matched with {action = "GetTransactionSummary", controller = "Transaction"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetTransactionSummary(Sang.Transactions.Api.Models.APIRequest.TransactionSummaryRequest) on controller Sang.Transactions.Api.Controllers.TransactionController (Sang.Transactions.Api). 2025-11-29 15:23:06.610 +05:30 208b9344-3727-48bc-b7bd-829ddf71fc74 ERR Invalid column name 'sNarration'. 2025-11-29 15:23:06.619 +05:30 208b9344-3727-48bc-b7bd-829ddf71fc74 ERR Invalid column name 'sNarration'. 2025-11-29 15:23:06.632 +05:30 208b9344-3727-48bc-b7bd-829ddf71fc74 ERR Error Getting TransactionList1101 from database System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sNarration'. 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.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) 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(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchDataset(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.CoreSettings.Api.Repositories.TransactionRepository.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Services.TransactionService.<>c__DisplayClass12_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteDatasetResult[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String sortColumn, Boolean isAscending, Int32 groupId, String searchString) ClientConnectionId:0ba59a04-eb62-4330-bbf8-2d8fc810bebc Error Number:207,State:1,Class:16 2025-11-29 15:23:06.635 +05:30 208b9344-3727-48bc-b7bd-829ddf71fc74 ERR SQL Exception occurred For DocType:1101: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sNarration'. 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.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) 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(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchDataset(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.CoreSettings.Api.Repositories.TransactionRepository.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Services.TransactionService.<>c__DisplayClass12_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteDatasetResult[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String sortColumn, Boolean isAscending, Int32 groupId, String searchString) at Sang.Transactions.Api.Services.TransactionService.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary(TransactionSummaryRequest summaryRequest) ClientConnectionId:0ba59a04-eb62-4330-bbf8-2d8fc810bebc Error Number:207,State:1,Class:16 2025-11-29 15:23:06.643 +05:30 208b9344-3727-48bc-b7bd-829ddf71fc74 INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-11-29 15:23:06.700 +05:30 208b9344-3727-48bc-b7bd-829ddf71fc74 INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 520.0708ms 2025-11-29 15:23:06.701 +05:30 208b9344-3727-48bc-b7bd-829ddf71fc74 INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-11-29 15:23:06.712 +05:30 208b9344-3727-48bc-b7bd-829ddf71fc74 INF Request finished HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - 400 97 application/json; charset=utf-8 721.6533ms 2025-11-29 15:33:18.026 +05:30 d96c27d5-fd59-428a-bdce-0e7bccdfab32 INF Request starting HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - null null 2025-11-29 15:33:18.035 +05:30 d96c27d5-fd59-428a-bdce-0e7bccdfab32 INF CORS policy execution successful. 2025-11-29 15:33:18.038 +05:30 d96c27d5-fd59-428a-bdce-0e7bccdfab32 INF Request finished HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - 204 null null 12.625ms 2025-11-29 15:33:18.080 +05:30 1d4b1544-b525-4c3d-944f-5fd2814bf4db INF Request starting HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - null null 2025-11-29 15:33:18.084 +05:30 1d4b1544-b525-4c3d-944f-5fd2814bf4db INF CORS policy execution successful. 2025-11-29 15:33:18.089 +05:30 1d4b1544-b525-4c3d-944f-5fd2814bf4db INF HTTP request: Path: /transaction/gettransactionsummary QueryString: ?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 Headers: {Accept: application/json, text/plain, */*}, {Accept-Encoding: gzip, deflate}, {Accept-Language: en-US,en;q=0.9}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY0NDA5ODkwLCJleHAiOjE3NjQ0MTM0OTAsImlhdCI6MTc2NDQwOTg5MH0.n3N_IsoAV79WIJUvwKoNNZyROBjoR7yFVeMA6aGh56w}, {Connection: keep-alive}, {Host: 103.120.178.195}, {Referer: http://localhost:5173/}, {User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36}, {Origin: http://localhost:5173} Host: 103.120.178.195 Body: 2025-11-29 15:33:18.101 +05:30 be0fad74-fa28-43d6-ad14-afb2a6b9f0d5 INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-11-29 15:33:18.102 +05:30 be0fad74-fa28-43d6-ad14-afb2a6b9f0d5 INF Route matched with {action = "GetTransactionSummary", controller = "Transaction"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetTransactionSummary(Sang.Transactions.Api.Models.APIRequest.TransactionSummaryRequest) on controller Sang.Transactions.Api.Controllers.TransactionController (Sang.Transactions.Api). 2025-11-29 15:33:18.160 +05:30 be0fad74-fa28-43d6-ad14-afb2a6b9f0d5 ERR Invalid column name 'sNarration'. 2025-11-29 15:33:18.164 +05:30 be0fad74-fa28-43d6-ad14-afb2a6b9f0d5 ERR Invalid column name 'sNarration'. 2025-11-29 15:33:18.170 +05:30 be0fad74-fa28-43d6-ad14-afb2a6b9f0d5 ERR Error Getting TransactionList1101 from database System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sNarration'. 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.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) 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(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchDataset(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.CoreSettings.Api.Repositories.TransactionRepository.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Services.TransactionService.<>c__DisplayClass12_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteDatasetResult[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String sortColumn, Boolean isAscending, Int32 groupId, String searchString) ClientConnectionId:f95236fd-ff2f-4e67-af28-1bb608c16e5b Error Number:207,State:1,Class:16 2025-11-29 15:33:18.178 +05:30 be0fad74-fa28-43d6-ad14-afb2a6b9f0d5 ERR SQL Exception occurred For DocType:1101: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sNarration'. 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.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) 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(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchDataset(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.CoreSettings.Api.Repositories.TransactionRepository.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Services.TransactionService.<>c__DisplayClass12_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteDatasetResult[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String sortColumn, Boolean isAscending, Int32 groupId, String searchString) at Sang.Transactions.Api.Services.TransactionService.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary(TransactionSummaryRequest summaryRequest) ClientConnectionId:f95236fd-ff2f-4e67-af28-1bb608c16e5b Error Number:207,State:1,Class:16 2025-11-29 15:33:18.181 +05:30 be0fad74-fa28-43d6-ad14-afb2a6b9f0d5 INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-11-29 15:33:18.185 +05:30 be0fad74-fa28-43d6-ad14-afb2a6b9f0d5 INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 82.1254ms 2025-11-29 15:33:18.185 +05:30 be0fad74-fa28-43d6-ad14-afb2a6b9f0d5 INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-11-29 15:33:18.187 +05:30 be0fad74-fa28-43d6-ad14-afb2a6b9f0d5 INF Request finished HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - 400 97 application/json; charset=utf-8 106.295ms 2025-11-29 15:37:17.709 +05:30 bdc2beab-3a6f-4cf5-9a96-e2515d3bf1e6 INF Request starting HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - null null 2025-11-29 15:37:17.716 +05:30 bdc2beab-3a6f-4cf5-9a96-e2515d3bf1e6 INF CORS policy execution successful. 2025-11-29 15:37:17.718 +05:30 bdc2beab-3a6f-4cf5-9a96-e2515d3bf1e6 INF Request finished HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - 204 null null 8.9569ms 2025-11-29 15:37:17.764 +05:30 213b8fe1-b2bb-4202-b7eb-1478ae8a0b46 INF Request starting HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - null null 2025-11-29 15:37:17.770 +05:30 213b8fe1-b2bb-4202-b7eb-1478ae8a0b46 INF CORS policy execution successful. 2025-11-29 15:37:17.773 +05:30 213b8fe1-b2bb-4202-b7eb-1478ae8a0b46 INF HTTP request: Path: /transaction/gettransactionsummary QueryString: ?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 Headers: {Accept: application/json, text/plain, */*}, {Accept-Encoding: gzip, deflate}, {Accept-Language: en-US,en;q=0.9}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY0NDA5ODkwLCJleHAiOjE3NjQ0MTM0OTAsImlhdCI6MTc2NDQwOTg5MH0.n3N_IsoAV79WIJUvwKoNNZyROBjoR7yFVeMA6aGh56w}, {Connection: keep-alive}, {Host: 103.120.178.195}, {Referer: http://localhost:5173/}, {User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36}, {Origin: http://localhost:5173} Host: 103.120.178.195 Body: 2025-11-29 15:37:17.778 +05:30 313ad03c-4343-449d-b104-55b2bf6242dc INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-11-29 15:37:17.779 +05:30 313ad03c-4343-449d-b104-55b2bf6242dc INF Route matched with {action = "GetTransactionSummary", controller = "Transaction"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetTransactionSummary(Sang.Transactions.Api.Models.APIRequest.TransactionSummaryRequest) on controller Sang.Transactions.Api.Controllers.TransactionController (Sang.Transactions.Api). 2025-11-29 15:37:17.823 +05:30 313ad03c-4343-449d-b104-55b2bf6242dc ERR Invalid column name 'sNarration'. 2025-11-29 15:37:17.824 +05:30 313ad03c-4343-449d-b104-55b2bf6242dc ERR Invalid column name 'sNarration'. 2025-11-29 15:37:17.827 +05:30 313ad03c-4343-449d-b104-55b2bf6242dc ERR Error Getting TransactionList1101 from database System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sNarration'. 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.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) 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(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchDataset(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.CoreSettings.Api.Repositories.TransactionRepository.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Services.TransactionService.<>c__DisplayClass12_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteDatasetResult[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String sortColumn, Boolean isAscending, Int32 groupId, String searchString) ClientConnectionId:f95236fd-ff2f-4e67-af28-1bb608c16e5b Error Number:207,State:1,Class:16 2025-11-29 15:37:17.829 +05:30 313ad03c-4343-449d-b104-55b2bf6242dc ERR SQL Exception occurred For DocType:1101: System.Data.SqlClient.SqlException (0x80131904): Invalid column name 'sNarration'. 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.TryNextResult(Boolean& more) at System.Data.SqlClient.SqlDataReader.NextResult() at System.Data.ProviderBase.DataReaderContainer.NextResult() at System.Data.Common.DataAdapter.FillNextResult(DataReaderContainer dataReader) 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(DataSet dataSet, String srcTable, IDataReader dataReader, Int32 startRecord, Int32 maxRecords) at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Sang.Service.Common.CommonService.CommonEntityService.ExecuteAndFetchDataset(String procedureName, SqlParameter[] parameters, Boolean useExtendedTimeout) at Sang.CoreSettings.Api.Repositories.TransactionRepository.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Services.TransactionService.<>c__DisplayClass12_0.<b__0>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecuteDatasetResult[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String sortColumn, Boolean isAscending, Int32 groupId, String searchString) at Sang.Transactions.Api.Services.TransactionService.GetTransactionSummary(TransactionSummaryRequest summaryRequest) at Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary(TransactionSummaryRequest summaryRequest) ClientConnectionId:f95236fd-ff2f-4e67-af28-1bb608c16e5b Error Number:207,State:1,Class:16 2025-11-29 15:37:17.830 +05:30 313ad03c-4343-449d-b104-55b2bf6242dc INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-11-29 15:37:17.831 +05:30 313ad03c-4343-449d-b104-55b2bf6242dc INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 51.6675ms 2025-11-29 15:37:17.832 +05:30 313ad03c-4343-449d-b104-55b2bf6242dc INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-11-29 15:37:17.832 +05:30 313ad03c-4343-449d-b104-55b2bf6242dc INF Request finished HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/gettransactionsummary?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=1 - 400 97 application/json; charset=utf-8 68.4682ms 2025-11-29 15:48:05.559 +05:30 INF Application is shutting down...