2025-12-09 09:18:41.438 +05:30 WRN Using an in-memory repository. Keys will not be persisted to storage. 2025-12-09 09:18:41.485 +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-09 09:18:41.503 +05:30 INF Creating key {f9178da6-c798-435a-8a37-804872bd28a0} with creation date 2025-12-09 03:48:41Z, activation date 2025-12-09 03:48:41Z, and expiration date 2026-03-09 03:48:41Z. 2025-12-09 09:18:41.514 +05:30 WRN No XML encryptor configured. Key {f9178da6-c798-435a-8a37-804872bd28a0} may be persisted to storage in unencrypted form. 2025-12-09 09:18:41.676 +05:30 INF Application started. Press Ctrl+C to shut down. 2025-12-09 09:18:41.677 +05:30 INF Hosting environment: Production 2025-12-09 09:18:41.677 +05:30 INF Content root path: C:\inetpub\wwwroot\SangTransactionsAPI 2025-12-09 09:18:41.687 +05:30 bd8f71ba-33f8-4f54-8bef-fac57eaf9251 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=4 - null null 2025-12-09 09:18:41.743 +05:30 bd8f71ba-33f8-4f54-8bef-fac57eaf9251 INF CORS policy execution successful. 2025-12-09 09:18:41.750 +05:30 bd8f71ba-33f8-4f54-8bef-fac57eaf9251 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=4 - 204 null null 64.0922ms 2025-12-09 09:18:41.905 +05:30 766739a0-eb26-4cfd-ac19-e77e75a87b60 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=4 - null null 2025-12-09 09:18:42.012 +05:30 766739a0-eb26-4cfd-ac19-e77e75a87b60 INF CORS policy execution successful. 2025-12-09 09:18:42.042 +05:30 766739a0-eb26-4cfd-ac19-e77e75a87b60 INF HTTP request: Path: /transaction/gettransactionsummary QueryString: ?DocType=1101&viewId=32&languageId=1&refreshFlag=true&pageNumber=1&pageSize=25&search=&sortColumn=&isAscending=false&BE=4 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.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY1MjUyMDY1LCJleHAiOjE3NjUyNTU2NjUsImlhdCI6MTc2NTI1MjA2NX0.B2nup8zyZZIlzI-qYlDoGRwNj8XF_Miw37SOGAWGkN4}, {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-09 09:18:42.090 +05:30 f796759f-c4e0-495d-b09a-108ba4d15b35 INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-09 09:18:42.121 +05:30 f796759f-c4e0-495d-b09a-108ba4d15b35 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-09 09:18:42.614 +05:30 f796759f-c4e0-495d-b09a-108ba4d15b35 ERR Invalid column name 'sNarration'. 2025-12-09 09:18:42.635 +05:30 f796759f-c4e0-495d-b09a-108ba4d15b35 ERR Invalid column name 'sNarration'. 2025-12-09 09:18:42.649 +05:30 f796759f-c4e0-495d-b09a-108ba4d15b35 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:ed217f02-1b40-4eea-ae52-348488513206 Error Number:207,State:1,Class:16 2025-12-09 09:18:42.653 +05:30 f796759f-c4e0-495d-b09a-108ba4d15b35 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:ed217f02-1b40-4eea-ae52-348488513206 Error Number:207,State:1,Class:16 2025-12-09 09:18:42.662 +05:30 f796759f-c4e0-495d-b09a-108ba4d15b35 INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-12-09 09:18:42.720 +05:30 f796759f-c4e0-495d-b09a-108ba4d15b35 INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 595.5035ms 2025-12-09 09:18:42.721 +05:30 f796759f-c4e0-495d-b09a-108ba4d15b35 INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-09 09:18:42.735 +05:30 f796759f-c4e0-495d-b09a-108ba4d15b35 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=4 - 400 97 application/json; charset=utf-8 830.633ms 2025-12-09 09:19:08.226 +05:30 191ed580-90b2-4cac-b441-8f9b29c3e3ee INF Request starting HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/getdocno?Doctype=1101&TransId=0&Type=1&BE=4 - null null 2025-12-09 09:19:08.235 +05:30 191ed580-90b2-4cac-b441-8f9b29c3e3ee INF CORS policy execution successful. 2025-12-09 09:19:08.237 +05:30 191ed580-90b2-4cac-b441-8f9b29c3e3ee INF Request finished HTTP/1.1 OPTIONS http://103.120.178.195/SangTransactionsAPI/transaction/getdocno?Doctype=1101&TransId=0&Type=1&BE=4 - 204 null null 11.2369ms 2025-12-09 09:19:08.373 +05:30 3be8a1dd-4a65-4452-86ac-8fef57d93e5c INF Request starting HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/getdocno?Doctype=1101&TransId=0&Type=1&BE=4 - null null 2025-12-09 09:19:08.375 +05:30 3be8a1dd-4a65-4452-86ac-8fef57d93e5c INF CORS policy execution successful. 2025-12-09 09:19:08.378 +05:30 3be8a1dd-4a65-4452-86ac-8fef57d93e5c INF HTTP request: Path: /transaction/getdocno QueryString: ?Doctype=1101&TransId=0&Type=1&BE=4 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.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY1MjUyMDY1LCJleHAiOjE3NjUyNTU2NjUsImlhdCI6MTc2NTI1MjA2NX0.B2nup8zyZZIlzI-qYlDoGRwNj8XF_Miw37SOGAWGkN4}, {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-09 09:19:08.387 +05:30 acbb3d42-3a4f-4cd1-9851-948a22d740d3 INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetDocNo (Sang.Transactions.Api)' 2025-12-09 09:19:08.396 +05:30 acbb3d42-3a4f-4cd1-9851-948a22d740d3 INF Route matched with {action = "GetDocNo", controller = "Transaction"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetDocNo(Int32, Int32, Int32, Int32) on controller Sang.Transactions.Api.Controllers.TransactionController (Sang.Transactions.Api). 2025-12-09 09:19:08.522 +05:30 acbb3d42-3a4f-4cd1-9851-948a22d740d3 INF Executing OkObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-12-09 09:19:08.524 +05:30 acbb3d42-3a4f-4cd1-9851-948a22d740d3 INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetDocNo (Sang.Transactions.Api) in 127.4802ms 2025-12-09 09:19:08.524 +05:30 acbb3d42-3a4f-4cd1-9851-948a22d740d3 INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetDocNo (Sang.Transactions.Api)' 2025-12-09 09:19:08.524 +05:30 acbb3d42-3a4f-4cd1-9851-948a22d740d3 INF HTTP Response: StatusCode: 200 Headers: {X-Correlation-Id: 3be8a1dd-4a65-4452-86ac-8fef57d93e5c}, {Content-Type: application/json; charset=utf-8}, {Content-Length: 128} Body: {"status":"Success","statusCode":2000,"message":"Record(s) successfully retrieved.","result":"[{\"DocNo\":\"\",\"TransId\":0}]"} 2025-12-09 09:19:08.526 +05:30 acbb3d42-3a4f-4cd1-9851-948a22d740d3 INF Request finished HTTP/1.1 GET http://103.120.178.195/SangTransactionsAPI/transaction/getdocno?Doctype=1101&TransId=0&Type=1&BE=4 - 200 128 application/json; charset=utf-8 153.0939ms 2025-12-09 09:29:41.264 +05:30 INF Application is shutting down...