2025-12-01 10:14:49.679 +05:30 WRN Using an in-memory repository. Keys will not be persisted to storage. 2025-12-01 10:14:49.731 +05:30 WRN Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2025-12-01 10:14:49.751 +05:30 INF Creating key {97615cfa-2b6f-40a1-b8ab-94d11128947b} with creation date 2025-12-01 04:44:49Z, activation date 2025-12-01 04:44:49Z, and expiration date 2026-03-01 04:44:49Z. 2025-12-01 10:14:49.763 +05:30 WRN No XML encryptor configured. Key {97615cfa-2b6f-40a1-b8ab-94d11128947b} may be persisted to storage in unencrypted form. 2025-12-01 10:14:49.922 +05:30 INF Application started. Press Ctrl+C to shut down. 2025-12-01 10:14:49.923 +05:30 INF Hosting environment: Production 2025-12-01 10:14:49.923 +05:30 INF Content root path: C:\inetpub\wwwroot\SangTransactionsAPI 2025-12-01 10:14:49.936 +05:30 47c473d5-8aed-4eb9-8f1f-a5cc1ecb9ad6 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-12-01 10:14:50.000 +05:30 47c473d5-8aed-4eb9-8f1f-a5cc1ecb9ad6 INF CORS policy execution successful. 2025-12-01 10:14:50.008 +05:30 47c473d5-8aed-4eb9-8f1f-a5cc1ecb9ad6 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 73.6401ms 2025-12-01 10:14:50.050 +05:30 69e140f7-8b92-4781-a7d6-132040060e6f 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-12-01 10:14:50.188 +05:30 69e140f7-8b92-4781-a7d6-132040060e6f INF CORS policy execution successful. 2025-12-01 10:14:50.206 +05:30 69e140f7-8b92-4781-a7d6-132040060e6f 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,ml;q=0.8}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY0NTYyOTc0LCJleHAiOjE3NjQ1NjY1NzQsImlhdCI6MTc2NDU2Mjk3NH0.tNbROOI7xaYYn_VvlnagYlZBUsCjCeOigSVAzP-4DGU}, {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}, {DNT: 1}, {Origin: http://localhost:5173} Host: 103.120.178.195 Body: 2025-12-01 10:14:50.251 +05:30 426e0a84-bbf9-468d-a7dd-5d9db553ec66 INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-01 10:14:50.287 +05:30 426e0a84-bbf9-468d-a7dd-5d9db553ec66 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-12-01 10:14:50.871 +05:30 426e0a84-bbf9-468d-a7dd-5d9db553ec66 ERR Invalid column name 'sNarration'. 2025-12-01 10:14:50.891 +05:30 426e0a84-bbf9-468d-a7dd-5d9db553ec66 ERR Invalid column name 'sNarration'. 2025-12-01 10:14:50.907 +05:30 426e0a84-bbf9-468d-a7dd-5d9db553ec66 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:5590cf21-9513-40c3-8877-d19ac7f84a00 Error Number:207,State:1,Class:16 2025-12-01 10:14:50.911 +05:30 426e0a84-bbf9-468d-a7dd-5d9db553ec66 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:5590cf21-9513-40c3-8877-d19ac7f84a00 Error Number:207,State:1,Class:16 2025-12-01 10:14:50.921 +05:30 426e0a84-bbf9-468d-a7dd-5d9db553ec66 INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-12-01 10:14:50.988 +05:30 426e0a84-bbf9-468d-a7dd-5d9db553ec66 INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 696.3278ms 2025-12-01 10:14:50.989 +05:30 426e0a84-bbf9-468d-a7dd-5d9db553ec66 INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-01 10:14:51.002 +05:30 426e0a84-bbf9-468d-a7dd-5d9db553ec66 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 951.9875ms 2025-12-01 10:25:49.572 +05:30 INF Application is shutting down... 2025-12-01 12:05:31.798 +05:30 WRN Using an in-memory repository. Keys will not be persisted to storage. 2025-12-01 12:05:31.844 +05:30 WRN Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2025-12-01 12:05:31.869 +05:30 INF Creating key {19a176ce-b5b7-4a3f-8ee4-12fa3d28399e} with creation date 2025-12-01 06:35:31Z, activation date 2025-12-01 06:35:31Z, and expiration date 2026-03-01 06:35:31Z. 2025-12-01 12:05:31.883 +05:30 WRN No XML encryptor configured. Key {19a176ce-b5b7-4a3f-8ee4-12fa3d28399e} may be persisted to storage in unencrypted form. 2025-12-01 12:05:32.044 +05:30 INF Application started. Press Ctrl+C to shut down. 2025-12-01 12:05:32.044 +05:30 INF Hosting environment: Production 2025-12-01 12:05:32.044 +05:30 INF Content root path: C:\inetpub\wwwroot\SangTransactionsAPI 2025-12-01 12:05:32.061 +05:30 aadb15ef-33ad-4f08-9ddb-fd49fb18f21e 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-12-01 12:05:32.132 +05:30 aadb15ef-33ad-4f08-9ddb-fd49fb18f21e INF CORS policy execution successful. 2025-12-01 12:05:32.142 +05:30 aadb15ef-33ad-4f08-9ddb-fd49fb18f21e 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 82.8266ms 2025-12-01 12:05:32.258 +05:30 a43ba751-c109-488c-9f81-0b4593f72031 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-12-01 12:05:32.374 +05:30 a43ba751-c109-488c-9f81-0b4593f72031 INF CORS policy execution successful. 2025-12-01 12:05:32.394 +05:30 a43ba751-c109-488c-9f81-0b4593f72031 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,ml;q=0.8}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY0NTcwOTIzLCJleHAiOjE3NjQ1NzQ1MjMsImlhdCI6MTc2NDU3MDkyM30.XM-sCBP9SypLBzjh-FlPXhX5sCo3pNr5iKs1OUoxt2s}, {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}, {DNT: 1}, {Origin: http://localhost:5173} Host: 103.120.178.195 Body: 2025-12-01 12:05:32.443 +05:30 ad7b6111-25cf-43f1-bba3-b551fdeadabf INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-01 12:05:32.490 +05:30 ad7b6111-25cf-43f1-bba3-b551fdeadabf 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-12-01 12:05:33.041 +05:30 ad7b6111-25cf-43f1-bba3-b551fdeadabf ERR Invalid column name 'sNarration'. 2025-12-01 12:05:33.063 +05:30 ad7b6111-25cf-43f1-bba3-b551fdeadabf ERR Invalid column name 'sNarration'. 2025-12-01 12:05:33.077 +05:30 ad7b6111-25cf-43f1-bba3-b551fdeadabf 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:eb0d4b0c-92d0-491c-8470-668f3dde0bab Error Number:207,State:1,Class:16 2025-12-01 12:05:33.081 +05:30 ad7b6111-25cf-43f1-bba3-b551fdeadabf 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:eb0d4b0c-92d0-491c-8470-668f3dde0bab Error Number:207,State:1,Class:16 2025-12-01 12:05:33.090 +05:30 ad7b6111-25cf-43f1-bba3-b551fdeadabf INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-12-01 12:05:33.152 +05:30 ad7b6111-25cf-43f1-bba3-b551fdeadabf INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 657.3078ms 2025-12-01 12:05:33.153 +05:30 ad7b6111-25cf-43f1-bba3-b551fdeadabf INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-01 12:05:33.164 +05:30 ad7b6111-25cf-43f1-bba3-b551fdeadabf 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 905.9392ms 2025-12-01 12:08:04.079 +05:30 2863049d-95a0-42cc-a50e-45e83c9a9969 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-12-01 12:08:04.091 +05:30 2863049d-95a0-42cc-a50e-45e83c9a9969 INF CORS policy execution successful. 2025-12-01 12:08:04.094 +05:30 2863049d-95a0-42cc-a50e-45e83c9a9969 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 16.4207ms 2025-12-01 12:08:04.135 +05:30 7e824981-688f-42b3-911c-dadcc14a31e4 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-12-01 12:08:04.141 +05:30 7e824981-688f-42b3-911c-dadcc14a31e4 INF CORS policy execution successful. 2025-12-01 12:08:04.146 +05:30 7e824981-688f-42b3-911c-dadcc14a31e4 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,ml;q=0.8}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY0NTcwOTIzLCJleHAiOjE3NjQ1NzQ1MjMsImlhdCI6MTc2NDU3MDkyM30.XM-sCBP9SypLBzjh-FlPXhX5sCo3pNr5iKs1OUoxt2s}, {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}, {DNT: 1}, {Origin: http://localhost:5173} Host: 103.120.178.195 Body: 2025-12-01 12:08:04.160 +05:30 2a915ba1-441e-4916-a72e-035b3c25c1b3 INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-01 12:08:04.163 +05:30 2a915ba1-441e-4916-a72e-035b3c25c1b3 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-12-01 12:08:04.260 +05:30 2a915ba1-441e-4916-a72e-035b3c25c1b3 ERR Invalid column name 'sNarration'. 2025-12-01 12:08:04.261 +05:30 2a915ba1-441e-4916-a72e-035b3c25c1b3 ERR Invalid column name 'sNarration'. 2025-12-01 12:08:04.265 +05:30 2a915ba1-441e-4916-a72e-035b3c25c1b3 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:eb0d4b0c-92d0-491c-8470-668f3dde0bab Error Number:207,State:1,Class:16 2025-12-01 12:08:04.269 +05:30 2a915ba1-441e-4916-a72e-035b3c25c1b3 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:eb0d4b0c-92d0-491c-8470-668f3dde0bab Error Number:207,State:1,Class:16 2025-12-01 12:08:04.271 +05:30 2a915ba1-441e-4916-a72e-035b3c25c1b3 INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-12-01 12:08:04.276 +05:30 2a915ba1-441e-4916-a72e-035b3c25c1b3 INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 111.9176ms 2025-12-01 12:08:04.277 +05:30 2a915ba1-441e-4916-a72e-035b3c25c1b3 INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-01 12:08:04.282 +05:30 2a915ba1-441e-4916-a72e-035b3c25c1b3 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 146.15ms 2025-12-01 12:08:08.644 +05:30 eaabb922-8e31-441b-b746-bd01de5b15d2 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-12-01 12:08:08.648 +05:30 eaabb922-8e31-441b-b746-bd01de5b15d2 INF CORS policy execution successful. 2025-12-01 12:08:08.649 +05:30 eaabb922-8e31-441b-b746-bd01de5b15d2 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,ml;q=0.8}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY0NTcwOTIzLCJleHAiOjE3NjQ1NzQ1MjMsImlhdCI6MTc2NDU3MDkyM30.XM-sCBP9SypLBzjh-FlPXhX5sCo3pNr5iKs1OUoxt2s}, {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}, {DNT: 1}, {Origin: http://localhost:5173} Host: 103.120.178.195 Body: 2025-12-01 12:08:08.653 +05:30 a5b0e0c7-9003-4eb4-be30-71f1cd973cf7 INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-01 12:08:08.653 +05:30 a5b0e0c7-9003-4eb4-be30-71f1cd973cf7 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-12-01 12:08:08.697 +05:30 a5b0e0c7-9003-4eb4-be30-71f1cd973cf7 ERR Invalid column name 'sNarration'. 2025-12-01 12:08:08.697 +05:30 a5b0e0c7-9003-4eb4-be30-71f1cd973cf7 ERR Invalid column name 'sNarration'. 2025-12-01 12:08:08.699 +05:30 a5b0e0c7-9003-4eb4-be30-71f1cd973cf7 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:eb0d4b0c-92d0-491c-8470-668f3dde0bab Error Number:207,State:1,Class:16 2025-12-01 12:08:08.701 +05:30 a5b0e0c7-9003-4eb4-be30-71f1cd973cf7 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:eb0d4b0c-92d0-491c-8470-668f3dde0bab Error Number:207,State:1,Class:16 2025-12-01 12:08:08.702 +05:30 a5b0e0c7-9003-4eb4-be30-71f1cd973cf7 INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-12-01 12:08:08.703 +05:30 a5b0e0c7-9003-4eb4-be30-71f1cd973cf7 INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 48.9004ms 2025-12-01 12:08:08.703 +05:30 a5b0e0c7-9003-4eb4-be30-71f1cd973cf7 INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-01 12:08:08.704 +05:30 a5b0e0c7-9003-4eb4-be30-71f1cd973cf7 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 59.4605ms 2025-12-01 12:18:31.388 +05:30 INF Application is shutting down... 2025-12-01 12:24:41.552 +05:30 WRN Using an in-memory repository. Keys will not be persisted to storage. 2025-12-01 12:24:41.596 +05:30 WRN Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2025-12-01 12:24:41.617 +05:30 INF Creating key {0e659196-6ade-45a1-be0d-b48a5af3dbb1} with creation date 2025-12-01 06:54:41Z, activation date 2025-12-01 06:54:41Z, and expiration date 2026-03-01 06:54:41Z. 2025-12-01 12:24:41.632 +05:30 WRN No XML encryptor configured. Key {0e659196-6ade-45a1-be0d-b48a5af3dbb1} may be persisted to storage in unencrypted form. 2025-12-01 12:24:41.818 +05:30 INF Application started. Press Ctrl+C to shut down. 2025-12-01 12:24:41.819 +05:30 INF Hosting environment: Production 2025-12-01 12:24:41.819 +05:30 INF Content root path: C:\inetpub\wwwroot\SangTransactionsAPI 2025-12-01 12:24:41.836 +05:30 103031d1-2e32-48d8-b7c9-a4fd476649d3 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-12-01 12:24:41.885 +05:30 103031d1-2e32-48d8-b7c9-a4fd476649d3 INF CORS policy execution successful. 2025-12-01 12:24:41.891 +05:30 103031d1-2e32-48d8-b7c9-a4fd476649d3 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 57.3499ms 2025-12-01 12:24:42.022 +05:30 53767803-0753-4378-a08d-2e2884954255 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-12-01 12:24:42.167 +05:30 53767803-0753-4378-a08d-2e2884954255 INF CORS policy execution successful. 2025-12-01 12:24:42.189 +05:30 53767803-0753-4378-a08d-2e2884954255 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,ml;q=0.8}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY0NTcwOTIzLCJleHAiOjE3NjQ1NzQ1MjMsImlhdCI6MTc2NDU3MDkyM30.XM-sCBP9SypLBzjh-FlPXhX5sCo3pNr5iKs1OUoxt2s}, {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}, {DNT: 1}, {Origin: http://localhost:5173} Host: 103.120.178.195 Body: 2025-12-01 12:24:42.241 +05:30 fc0767db-585d-4aed-a0b9-6b38cb5a6bc1 INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-01 12:24:42.288 +05:30 fc0767db-585d-4aed-a0b9-6b38cb5a6bc1 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-12-01 12:24:42.930 +05:30 fc0767db-585d-4aed-a0b9-6b38cb5a6bc1 ERR Invalid column name 'sNarration'. 2025-12-01 12:24:42.938 +05:30 fc0767db-585d-4aed-a0b9-6b38cb5a6bc1 ERR Invalid column name 'sNarration'. 2025-12-01 12:24:42.952 +05:30 fc0767db-585d-4aed-a0b9-6b38cb5a6bc1 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:7839033d-27aa-4718-a5a6-019704ad4aa6 Error Number:207,State:1,Class:16 2025-12-01 12:24:42.955 +05:30 fc0767db-585d-4aed-a0b9-6b38cb5a6bc1 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:7839033d-27aa-4718-a5a6-019704ad4aa6 Error Number:207,State:1,Class:16 2025-12-01 12:24:42.964 +05:30 fc0767db-585d-4aed-a0b9-6b38cb5a6bc1 INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-12-01 12:24:43.024 +05:30 fc0767db-585d-4aed-a0b9-6b38cb5a6bc1 INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 731.931ms 2025-12-01 12:24:43.024 +05:30 fc0767db-585d-4aed-a0b9-6b38cb5a6bc1 INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-01 12:24:43.034 +05:30 fc0767db-585d-4aed-a0b9-6b38cb5a6bc1 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 1011.6571ms 2025-12-01 12:35:41.431 +05:30 INF Application is shutting down... 2025-12-01 12:36:00.780 +05:30 WRN Using an in-memory repository. Keys will not be persisted to storage. 2025-12-01 12:36:00.830 +05:30 WRN Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2025-12-01 12:36:00.854 +05:30 INF Creating key {1bb73b2a-0789-4fe2-8f9a-8baf42cacf42} with creation date 2025-12-01 07:06:00Z, activation date 2025-12-01 07:06:00Z, and expiration date 2026-03-01 07:06:00Z. 2025-12-01 12:36:00.866 +05:30 WRN No XML encryptor configured. Key {1bb73b2a-0789-4fe2-8f9a-8baf42cacf42} may be persisted to storage in unencrypted form. 2025-12-01 12:36:01.020 +05:30 INF Application started. Press Ctrl+C to shut down. 2025-12-01 12:36:01.021 +05:30 INF Hosting environment: Production 2025-12-01 12:36:01.021 +05:30 INF Content root path: C:\inetpub\wwwroot\SangTransactionsAPI 2025-12-01 12:36:01.044 +05:30 32493bd3-f959-49c8-a77b-58681c867d72 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-12-01 12:36:01.105 +05:30 32493bd3-f959-49c8-a77b-58681c867d72 INF CORS policy execution successful. 2025-12-01 12:36:01.119 +05:30 32493bd3-f959-49c8-a77b-58681c867d72 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 78.5581ms 2025-12-01 12:36:01.264 +05:30 6822fa71-dd73-4bd3-a729-91d4f01b406c 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-12-01 12:36:01.392 +05:30 6822fa71-dd73-4bd3-a729-91d4f01b406c INF CORS policy execution successful. 2025-12-01 12:36:01.414 +05:30 6822fa71-dd73-4bd3-a729-91d4f01b406c 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,ml;q=0.8}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY0NTcwOTIzLCJleHAiOjE3NjQ1NzQ1MjMsImlhdCI6MTc2NDU3MDkyM30.XM-sCBP9SypLBzjh-FlPXhX5sCo3pNr5iKs1OUoxt2s}, {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}, {DNT: 1}, {Origin: http://localhost:5173} Host: 103.120.178.195 Body: 2025-12-01 12:36:01.488 +05:30 4686dda7-7891-49d5-b1b2-464b90fdf9ee INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-01 12:36:01.541 +05:30 4686dda7-7891-49d5-b1b2-464b90fdf9ee 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-12-01 12:36:03.593 +05:30 4686dda7-7891-49d5-b1b2-464b90fdf9ee ERR Invalid column name 'sNarration'. 2025-12-01 12:36:03.613 +05:30 4686dda7-7891-49d5-b1b2-464b90fdf9ee ERR Invalid column name 'sNarration'. 2025-12-01 12:36:03.631 +05:30 4686dda7-7891-49d5-b1b2-464b90fdf9ee 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:3447b8ab-dc44-4978-98e2-83ccdc204510 Error Number:207,State:1,Class:16 2025-12-01 12:36:03.636 +05:30 4686dda7-7891-49d5-b1b2-464b90fdf9ee 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:3447b8ab-dc44-4978-98e2-83ccdc204510 Error Number:207,State:1,Class:16 2025-12-01 12:36:03.647 +05:30 4686dda7-7891-49d5-b1b2-464b90fdf9ee INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-12-01 12:36:03.726 +05:30 4686dda7-7891-49d5-b1b2-464b90fdf9ee INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 2179.7109ms 2025-12-01 12:36:03.726 +05:30 4686dda7-7891-49d5-b1b2-464b90fdf9ee INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-01 12:36:03.742 +05:30 4686dda7-7891-49d5-b1b2-464b90fdf9ee 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 2478.393ms 2025-12-01 12:47:00.528 +05:30 INF Application is shutting down... 2025-12-01 16:48:51.531 +05:30 WRN Using an in-memory repository. Keys will not be persisted to storage. 2025-12-01 16:48:51.574 +05:30 WRN Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2025-12-01 16:48:51.594 +05:30 INF Creating key {77cecf39-0de5-43bd-ab15-1a609afde927} with creation date 2025-12-01 11:18:51Z, activation date 2025-12-01 11:18:51Z, and expiration date 2026-03-01 11:18:51Z. 2025-12-01 16:48:51.606 +05:30 WRN No XML encryptor configured. Key {77cecf39-0de5-43bd-ab15-1a609afde927} may be persisted to storage in unencrypted form. 2025-12-01 16:48:51.760 +05:30 INF Application started. Press Ctrl+C to shut down. 2025-12-01 16:48:51.761 +05:30 INF Hosting environment: Production 2025-12-01 16:48:51.761 +05:30 INF Content root path: C:\inetpub\wwwroot\SangTransactionsAPI 2025-12-01 16:48:51.774 +05:30 92fe4beb-e5b8-46d1-a3e1-62be8163e2f3 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-12-01 16:48:51.837 +05:30 92fe4beb-e5b8-46d1-a3e1-62be8163e2f3 INF CORS policy execution successful. 2025-12-01 16:48:51.844 +05:30 92fe4beb-e5b8-46d1-a3e1-62be8163e2f3 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 72.132ms 2025-12-01 16:48:51.930 +05:30 c4e2e559-d4d2-4f32-900e-821f6bd93a64 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-12-01 16:48:52.056 +05:30 c4e2e559-d4d2-4f32-900e-821f6bd93a64 INF CORS policy execution successful. 2025-12-01 16:48:52.079 +05:30 c4e2e559-d4d2-4f32-900e-821f6bd93a64 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,ml;q=0.8}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY0NTg3NDMxLCJleHAiOjE3NjQ1OTEwMzEsImlhdCI6MTc2NDU4NzQzMX0.SMlhN1I2S-ApfOr1a4yLEgzo2dbdo2ZuyWDA8KsDzeg}, {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}, {DNT: 1}, {Origin: http://localhost:5173} Host: 103.120.178.195 Body: 2025-12-01 16:48:52.123 +05:30 439d19dc-21b6-46a6-882c-09ea169d7a3e INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-01 16:48:52.150 +05:30 439d19dc-21b6-46a6-882c-09ea169d7a3e 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-12-01 16:48:52.745 +05:30 439d19dc-21b6-46a6-882c-09ea169d7a3e ERR Invalid column name 'sNarration'. 2025-12-01 16:48:52.763 +05:30 439d19dc-21b6-46a6-882c-09ea169d7a3e ERR Invalid column name 'sNarration'. 2025-12-01 16:48:52.783 +05:30 439d19dc-21b6-46a6-882c-09ea169d7a3e 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:d8f5859d-7930-4f54-97ba-d99a13ce325c Error Number:207,State:1,Class:16 2025-12-01 16:48:52.788 +05:30 439d19dc-21b6-46a6-882c-09ea169d7a3e 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:d8f5859d-7930-4f54-97ba-d99a13ce325c Error Number:207,State:1,Class:16 2025-12-01 16:48:52.799 +05:30 439d19dc-21b6-46a6-882c-09ea169d7a3e INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-12-01 16:48:52.886 +05:30 439d19dc-21b6-46a6-882c-09ea169d7a3e INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 731.2006ms 2025-12-01 16:48:52.887 +05:30 439d19dc-21b6-46a6-882c-09ea169d7a3e INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-01 16:48:52.898 +05:30 439d19dc-21b6-46a6-882c-09ea169d7a3e 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 967.2392ms 2025-12-01 16:51:00.110 +05:30 b780e1c2-de10-4da1-988a-ba3bea92fcc8 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-12-01 16:51:00.120 +05:30 b780e1c2-de10-4da1-988a-ba3bea92fcc8 INF CORS policy execution successful. 2025-12-01 16:51:00.125 +05:30 b780e1c2-de10-4da1-988a-ba3bea92fcc8 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 15.9066ms 2025-12-01 16:51:00.264 +05:30 b953dbaf-6eb9-4256-bd8a-4c04e596ada4 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-12-01 16:51:00.271 +05:30 b953dbaf-6eb9-4256-bd8a-4c04e596ada4 INF CORS policy execution successful. 2025-12-01 16:51:00.275 +05:30 b953dbaf-6eb9-4256-bd8a-4c04e596ada4 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,ml;q=0.8}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY0NTg3NDMxLCJleHAiOjE3NjQ1OTEwMzEsImlhdCI6MTc2NDU4NzQzMX0.SMlhN1I2S-ApfOr1a4yLEgzo2dbdo2ZuyWDA8KsDzeg}, {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}, {DNT: 1}, {Origin: http://localhost:5173} Host: 103.120.178.195 Body: 2025-12-01 16:51:00.286 +05:30 566cb116-1eb7-43a7-8faf-e8b04e6668f9 INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-01 16:51:00.288 +05:30 566cb116-1eb7-43a7-8faf-e8b04e6668f9 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-12-01 16:51:00.397 +05:30 566cb116-1eb7-43a7-8faf-e8b04e6668f9 ERR Invalid column name 'sNarration'. 2025-12-01 16:51:00.398 +05:30 566cb116-1eb7-43a7-8faf-e8b04e6668f9 ERR Invalid column name 'sNarration'. 2025-12-01 16:51:00.402 +05:30 566cb116-1eb7-43a7-8faf-e8b04e6668f9 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:d8f5859d-7930-4f54-97ba-d99a13ce325c Error Number:207,State:1,Class:16 2025-12-01 16:51:00.406 +05:30 566cb116-1eb7-43a7-8faf-e8b04e6668f9 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:d8f5859d-7930-4f54-97ba-d99a13ce325c Error Number:207,State:1,Class:16 2025-12-01 16:51:00.407 +05:30 566cb116-1eb7-43a7-8faf-e8b04e6668f9 INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-12-01 16:51:00.411 +05:30 566cb116-1eb7-43a7-8faf-e8b04e6668f9 INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 122.7201ms 2025-12-01 16:51:00.411 +05:30 566cb116-1eb7-43a7-8faf-e8b04e6668f9 INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-01 16:51:00.414 +05:30 566cb116-1eb7-43a7-8faf-e8b04e6668f9 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 149.0292ms 2025-12-01 17:01:51.250 +05:30 INF Application is shutting down... 2025-12-01 17:31:11.967 +05:30 WRN Using an in-memory repository. Keys will not be persisted to storage. 2025-12-01 17:31:12.011 +05:30 WRN Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2025-12-01 17:31:12.030 +05:30 INF Creating key {789b7a46-3b1a-4983-979a-5468b7c7a3cb} with creation date 2025-12-01 12:01:12Z, activation date 2025-12-01 12:01:12Z, and expiration date 2026-03-01 12:01:12Z. 2025-12-01 17:31:12.046 +05:30 WRN No XML encryptor configured. Key {789b7a46-3b1a-4983-979a-5468b7c7a3cb} may be persisted to storage in unencrypted form. 2025-12-01 17:31:12.195 +05:30 INF Application started. Press Ctrl+C to shut down. 2025-12-01 17:31:12.195 +05:30 INF Hosting environment: Production 2025-12-01 17:31:12.195 +05:30 INF Content root path: C:\inetpub\wwwroot\SangTransactionsAPI 2025-12-01 17:31:12.206 +05:30 82795ddc-a02b-4f96-ad61-85568389c161 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-12-01 17:31:12.257 +05:30 82795ddc-a02b-4f96-ad61-85568389c161 INF CORS policy execution successful. 2025-12-01 17:31:12.264 +05:30 82795ddc-a02b-4f96-ad61-85568389c161 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 59.6931ms 2025-12-01 17:31:12.404 +05:30 d7b94594-56f3-47b4-8f56-17422c6f3d7d 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-12-01 17:31:12.522 +05:30 d7b94594-56f3-47b4-8f56-17422c6f3d7d INF CORS policy execution successful. 2025-12-01 17:31:12.541 +05:30 d7b94594-56f3-47b4-8f56-17422c6f3d7d 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,ml;q=0.8}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY0NTg3NDMxLCJleHAiOjE3NjQ1OTEwMzEsImlhdCI6MTc2NDU4NzQzMX0.SMlhN1I2S-ApfOr1a4yLEgzo2dbdo2ZuyWDA8KsDzeg}, {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}, {DNT: 1}, {Origin: http://localhost:5173} Host: 103.120.178.195 Body: 2025-12-01 17:31:12.588 +05:30 d0e16f65-499f-446e-b390-5aefc94dfa84 INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-01 17:31:12.614 +05:30 d0e16f65-499f-446e-b390-5aefc94dfa84 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-12-01 17:31:13.173 +05:30 d0e16f65-499f-446e-b390-5aefc94dfa84 ERR Invalid column name 'sNarration'. 2025-12-01 17:31:13.183 +05:30 d0e16f65-499f-446e-b390-5aefc94dfa84 ERR Invalid column name 'sNarration'. 2025-12-01 17:31:13.197 +05:30 d0e16f65-499f-446e-b390-5aefc94dfa84 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:efcbe4d3-8abb-4a44-bf62-d8b51f21a869 Error Number:207,State:1,Class:16 2025-12-01 17:31:13.201 +05:30 d0e16f65-499f-446e-b390-5aefc94dfa84 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:efcbe4d3-8abb-4a44-bf62-d8b51f21a869 Error Number:207,State:1,Class:16 2025-12-01 17:31:13.212 +05:30 d0e16f65-499f-446e-b390-5aefc94dfa84 INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-12-01 17:31:13.281 +05:30 d0e16f65-499f-446e-b390-5aefc94dfa84 INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 661.6422ms 2025-12-01 17:31:13.282 +05:30 d0e16f65-499f-446e-b390-5aefc94dfa84 INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-01 17:31:13.295 +05:30 d0e16f65-499f-446e-b390-5aefc94dfa84 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 890.7763ms 2025-12-01 17:39:35.145 +05:30 7db3be76-5b54-4cc0-b89a-587b68b3b487 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-12-01 17:39:35.155 +05:30 7db3be76-5b54-4cc0-b89a-587b68b3b487 INF CORS policy execution successful. 2025-12-01 17:39:35.158 +05:30 7db3be76-5b54-4cc0-b89a-587b68b3b487 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.8302ms 2025-12-01 17:39:35.303 +05:30 3ac1494d-3cfc-4435-ab28-0c2cf6b20986 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-12-01 17:39:35.308 +05:30 3ac1494d-3cfc-4435-ab28-0c2cf6b20986 INF CORS policy execution successful. 2025-12-01 17:39:35.314 +05:30 3ac1494d-3cfc-4435-ab28-0c2cf6b20986 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,ml;q=0.8}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY0NTg3NDMxLCJleHAiOjE3NjQ1OTEwMzEsImlhdCI6MTc2NDU4NzQzMX0.SMlhN1I2S-ApfOr1a4yLEgzo2dbdo2ZuyWDA8KsDzeg}, {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}, {DNT: 1}, {Origin: http://localhost:5173} Host: 103.120.178.195 Body: 2025-12-01 17:39:35.327 +05:30 f95eaef3-9ccb-45f5-bc09-b001b3bd5e88 INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-01 17:39:35.330 +05:30 f95eaef3-9ccb-45f5-bc09-b001b3bd5e88 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-12-01 17:39:35.470 +05:30 f95eaef3-9ccb-45f5-bc09-b001b3bd5e88 ERR Invalid column name 'sNarration'. 2025-12-01 17:39:35.472 +05:30 f95eaef3-9ccb-45f5-bc09-b001b3bd5e88 ERR Invalid column name 'sNarration'. 2025-12-01 17:39:35.477 +05:30 f95eaef3-9ccb-45f5-bc09-b001b3bd5e88 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:18b09469-8853-4542-abc5-5ca54a8acad3 Error Number:207,State:1,Class:16 2025-12-01 17:39:35.485 +05:30 f95eaef3-9ccb-45f5-bc09-b001b3bd5e88 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:18b09469-8853-4542-abc5-5ca54a8acad3 Error Number:207,State:1,Class:16 2025-12-01 17:39:35.487 +05:30 f95eaef3-9ccb-45f5-bc09-b001b3bd5e88 INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-12-01 17:39:35.492 +05:30 f95eaef3-9ccb-45f5-bc09-b001b3bd5e88 INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 160.9388ms 2025-12-01 17:39:35.492 +05:30 f95eaef3-9ccb-45f5-bc09-b001b3bd5e88 INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-01 17:39:35.494 +05:30 f95eaef3-9ccb-45f5-bc09-b001b3bd5e88 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 190.9543ms 2025-12-01 17:49:48.203 +05:30 c7551754-1f6c-41c5-bed6-9430cd795e33 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-12-01 17:49:48.210 +05:30 c7551754-1f6c-41c5-bed6-9430cd795e33 INF CORS policy execution successful. 2025-12-01 17:49:48.212 +05:30 c7551754-1f6c-41c5-bed6-9430cd795e33 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 10.2208ms 2025-12-01 17:49:48.261 +05:30 a2049a58-8c9e-48f5-a6bb-b935609d04f8 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-12-01 17:49:48.267 +05:30 a2049a58-8c9e-48f5-a6bb-b935609d04f8 INF CORS policy execution successful. 2025-12-01 17:49:48.269 +05:30 a2049a58-8c9e-48f5-a6bb-b935609d04f8 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,ml;q=0.8}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY0NTkxNTg3LCJleHAiOjE3NjQ1OTUxODcsImlhdCI6MTc2NDU5MTU4N30.ApNTVxV8ZYTWqLa3KiVSiKcV0_--Ko6P8-QhA_FEp1c}, {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}, {DNT: 1}, {Origin: http://localhost:5173} Host: 103.120.178.195 Body: 2025-12-01 17:49:48.273 +05:30 7ad0beeb-20e6-4f46-b901-49ec59e86625 INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-01 17:49:48.275 +05:30 7ad0beeb-20e6-4f46-b901-49ec59e86625 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-12-01 17:49:48.418 +05:30 7ad0beeb-20e6-4f46-b901-49ec59e86625 ERR Invalid column name 'sNarration'. 2025-12-01 17:49:48.419 +05:30 7ad0beeb-20e6-4f46-b901-49ec59e86625 ERR Invalid column name 'sNarration'. 2025-12-01 17:49:48.422 +05:30 7ad0beeb-20e6-4f46-b901-49ec59e86625 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:334cf6f5-603d-4653-ace6-754f813cd0e1 Error Number:207,State:1,Class:16 2025-12-01 17:49:48.423 +05:30 7ad0beeb-20e6-4f46-b901-49ec59e86625 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:334cf6f5-603d-4653-ace6-754f813cd0e1 Error Number:207,State:1,Class:16 2025-12-01 17:49:48.424 +05:30 7ad0beeb-20e6-4f46-b901-49ec59e86625 INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-12-01 17:49:48.426 +05:30 7ad0beeb-20e6-4f46-b901-49ec59e86625 INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 150.3548ms 2025-12-01 17:49:48.426 +05:30 7ad0beeb-20e6-4f46-b901-49ec59e86625 INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-01 17:49:48.427 +05:30 7ad0beeb-20e6-4f46-b901-49ec59e86625 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 165.967ms 2025-12-01 18:00:11.958 +05:30 INF Application is shutting down... 2025-12-01 18:04:27.707 +05:30 WRN Using an in-memory repository. Keys will not be persisted to storage. 2025-12-01 18:04:27.756 +05:30 WRN Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 2025-12-01 18:04:27.778 +05:30 INF Creating key {0b53a8d1-18dd-4e36-aedb-74529fc6a88e} with creation date 2025-12-01 12:34:27Z, activation date 2025-12-01 12:34:27Z, and expiration date 2026-03-01 12:34:27Z. 2025-12-01 18:04:27.791 +05:30 WRN No XML encryptor configured. Key {0b53a8d1-18dd-4e36-aedb-74529fc6a88e} may be persisted to storage in unencrypted form. 2025-12-01 18:04:27.941 +05:30 INF Application started. Press Ctrl+C to shut down. 2025-12-01 18:04:27.941 +05:30 INF Hosting environment: Production 2025-12-01 18:04:27.941 +05:30 INF Content root path: C:\inetpub\wwwroot\SangTransactionsAPI 2025-12-01 18:04:27.953 +05:30 62c54273-3351-4ddc-8ffc-be66c8b56a2c 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-12-01 18:04:28.019 +05:30 62c54273-3351-4ddc-8ffc-be66c8b56a2c INF CORS policy execution successful. 2025-12-01 18:04:28.029 +05:30 62c54273-3351-4ddc-8ffc-be66c8b56a2c 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 76.768ms 2025-12-01 18:04:28.105 +05:30 1743d520-357e-4b37-947e-c90c94cc46b5 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-12-01 18:04:28.239 +05:30 1743d520-357e-4b37-947e-c90c94cc46b5 INF CORS policy execution successful. 2025-12-01 18:04:28.259 +05:30 1743d520-357e-4b37-947e-c90c94cc46b5 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,ml;q=0.8}, {Authorization: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY0NTkxNTg3LCJleHAiOjE3NjQ1OTUxODcsImlhdCI6MTc2NDU5MTU4N30.ApNTVxV8ZYTWqLa3KiVSiKcV0_--Ko6P8-QhA_FEp1c}, {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}, {DNT: 1}, {Origin: http://localhost:5173} Host: 103.120.178.195 Body: 2025-12-01 18:04:28.309 +05:30 56942ee5-5769-4511-a267-df9b9119d314 INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-01 18:04:28.347 +05:30 56942ee5-5769-4511-a267-df9b9119d314 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-12-01 18:04:28.950 +05:30 56942ee5-5769-4511-a267-df9b9119d314 ERR Invalid column name 'sNarration'. 2025-12-01 18:04:28.959 +05:30 56942ee5-5769-4511-a267-df9b9119d314 ERR Invalid column name 'sNarration'. 2025-12-01 18:04:28.972 +05:30 56942ee5-5769-4511-a267-df9b9119d314 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:b2be6b7d-44f5-4fd8-a2fa-cfe071e6c2fc Error Number:207,State:1,Class:16 2025-12-01 18:04:28.976 +05:30 56942ee5-5769-4511-a267-df9b9119d314 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:b2be6b7d-44f5-4fd8-a2fa-cfe071e6c2fc Error Number:207,State:1,Class:16 2025-12-01 18:04:28.989 +05:30 56942ee5-5769-4511-a267-df9b9119d314 INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-12-01 18:04:29.063 +05:30 56942ee5-5769-4511-a267-df9b9119d314 INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 711.3501ms 2025-12-01 18:04:29.065 +05:30 56942ee5-5769-4511-a267-df9b9119d314 INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-01 18:04:29.077 +05:30 56942ee5-5769-4511-a267-df9b9119d314 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 971.8879ms 2025-12-01 18:15:27.624 +05:30 INF Application is shutting down...