2025-12-08 05:17:22.057 +05:30 WRN Using an in-memory repository. Keys will not be persisted to storage. 2025-12-08 05:17:22.113 +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-08 05:17:22.134 +05:30 INF Creating key {c2895ccd-0717-43eb-8f06-195566106ab7} with creation date 2025-12-07 23:47:22Z, activation date 2025-12-07 23:47:22Z, and expiration date 2026-03-07 23:47:22Z. 2025-12-08 05:17:22.148 +05:30 WRN No XML encryptor configured. Key {c2895ccd-0717-43eb-8f06-195566106ab7} may be persisted to storage in unencrypted form. 2025-12-08 05:17:22.337 +05:30 INF Application started. Press Ctrl+C to shut down. 2025-12-08 05:17:22.338 +05:30 INF Hosting environment: Production 2025-12-08 05:17:22.338 +05:30 INF Content root path: C:\inetpub\wwwroot\SangTransactionsAPI 2025-12-08 05:17:22.352 +05:30 f3ef4fe4-8ec9-4000-aeb0-9da314749652 INF Request starting HTTP/1.1 GET http://103.120.178.195:80/SangTransactionsAPI/ - null null 2025-12-08 05:17:22.445 +05:30 f3ef4fe4-8ec9-4000-aeb0-9da314749652 INF HTTP request: Path: / QueryString: Headers: {Accept-Encoding: gzip}, {Host: 103.120.178.195:80}, {User-Agent: Mozilla/5.0 (compatible; CensysInspect/1.1; +https://about.censys.io/)} Host: 103.120.178.195:80 Body: 2025-12-08 05:17:22.482 +05:30 ce2d01fb-68bc-44da-9d5b-884488880e67 INF HTTP Response: StatusCode: 404 Headers: {X-Correlation-Id: f3ef4fe4-8ec9-4000-aeb0-9da314749652} Body: 2025-12-08 05:17:22.495 +05:30 ce2d01fb-68bc-44da-9d5b-884488880e67 INF Request finished HTTP/1.1 GET http://103.120.178.195:80/SangTransactionsAPI/ - 404 null null 148.8965ms 2025-12-08 05:17:22.500 +05:30 ce2d01fb-68bc-44da-9d5b-884488880e67 INF Request reached the end of the middleware pipeline without being handled by application code. Request path: GET http://103.120.178.195:80/SangTransactionsAPI/, Response status code: 404 2025-12-08 05:28:21.911 +05:30 INF Application is shutting down... 2025-12-08 10:20:18.665 +05:30 WRN Using an in-memory repository. Keys will not be persisted to storage. 2025-12-08 10:20:18.747 +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-08 10:20:18.777 +05:30 INF Creating key {e4e5823b-40f2-47cd-81b7-8eceea10a50f} with creation date 2025-12-08 04:50:18Z, activation date 2025-12-08 04:50:18Z, and expiration date 2026-03-08 04:50:18Z. 2025-12-08 10:20:18.795 +05:30 WRN No XML encryptor configured. Key {e4e5823b-40f2-47cd-81b7-8eceea10a50f} may be persisted to storage in unencrypted form. 2025-12-08 10:20:19.047 +05:30 INF Application started. Press Ctrl+C to shut down. 2025-12-08 10:20:19.048 +05:30 INF Hosting environment: Production 2025-12-08 10:20:19.048 +05:30 INF Content root path: C:\inetpub\wwwroot\SangTransactionsAPI 2025-12-08 10:20:19.087 +05:30 aa849fc1-0efa-4e66-8c6a-08f726a4b2b3 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-08 10:20:19.186 +05:30 aa849fc1-0efa-4e66-8c6a-08f726a4b2b3 INF CORS policy execution successful. 2025-12-08 10:20:19.198 +05:30 aa849fc1-0efa-4e66-8c6a-08f726a4b2b3 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 117.2508ms 2025-12-08 10:20:19.256 +05:30 96a2f420-4df2-426a-96e1-d62f293fde79 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-08 10:20:19.414 +05:30 96a2f420-4df2-426a-96e1-d62f293fde79 INF CORS policy execution successful. 2025-12-08 10:20:19.438 +05:30 96a2f420-4df2-426a-96e1-d62f293fde79 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.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY1MTY4MjUwLCJleHAiOjE3NjUxNzE4NTAsImlhdCI6MTc2NTE2ODI1MH0.zZJs8Vc-jHqnEfAW7D6nQVZLHpvs3vvThJfYk2xEpbE}, {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-08 10:20:19.483 +05:30 4409f024-72a0-412b-b710-41b5c9027bfc INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-08 10:20:19.517 +05:30 4409f024-72a0-412b-b710-41b5c9027bfc 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-08 10:20:20.467 +05:30 4409f024-72a0-412b-b710-41b5c9027bfc ERR Invalid column name 'sNarration'. 2025-12-08 10:20:20.488 +05:30 4409f024-72a0-412b-b710-41b5c9027bfc ERR Invalid column name 'sNarration'. 2025-12-08 10:20:20.511 +05:30 4409f024-72a0-412b-b710-41b5c9027bfc 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:bd870911-ac9c-4c6a-8da8-6b297695c35d Error Number:207,State:1,Class:16 2025-12-08 10:20:20.516 +05:30 4409f024-72a0-412b-b710-41b5c9027bfc 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:bd870911-ac9c-4c6a-8da8-6b297695c35d Error Number:207,State:1,Class:16 2025-12-08 10:20:20.533 +05:30 4409f024-72a0-412b-b710-41b5c9027bfc INF Executing BadRequestObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-12-08 10:20:20.609 +05:30 4409f024-72a0-412b-b710-41b5c9027bfc INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api) in 1086.1649ms 2025-12-08 10:20:20.610 +05:30 4409f024-72a0-412b-b710-41b5c9027bfc INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetTransactionSummary (Sang.Transactions.Api)' 2025-12-08 10:20:20.627 +05:30 4409f024-72a0-412b-b710-41b5c9027bfc 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 1370.8045ms 2025-12-08 10:31:17.320 +05:30 INF Application is shutting down... 2025-12-08 10:32:13.087 +05:30 WRN Using an in-memory repository. Keys will not be persisted to storage. 2025-12-08 10:32:13.121 +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-08 10:32:13.141 +05:30 INF Creating key {11ff2fd6-1cd9-46fd-8763-f5d75735c277} with creation date 2025-12-08 05:02:13Z, activation date 2025-12-08 05:02:13Z, and expiration date 2026-03-08 05:02:13Z. 2025-12-08 10:32:13.151 +05:30 WRN No XML encryptor configured. Key {11ff2fd6-1cd9-46fd-8763-f5d75735c277} may be persisted to storage in unencrypted form. 2025-12-08 10:32:13.282 +05:30 INF Application started. Press Ctrl+C to shut down. 2025-12-08 10:32:13.283 +05:30 INF Hosting environment: Production 2025-12-08 10:32:13.283 +05:30 INF Content root path: C:\inetpub\wwwroot\SangTransactionsAPI 2025-12-08 10:32:13.298 +05:30 82944c52-9bd0-4884-bd1f-2b47f849459d 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-08 10:32:13.359 +05:30 82944c52-9bd0-4884-bd1f-2b47f849459d INF CORS policy execution successful. 2025-12-08 10:32:13.368 +05:30 82944c52-9bd0-4884-bd1f-2b47f849459d 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 72.8282ms 2025-12-08 10:32:13.507 +05:30 9137066f-ef7b-4077-950f-2045c17936e0 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-08 10:32:13.623 +05:30 9137066f-ef7b-4077-950f-2045c17936e0 INF CORS policy execution successful. 2025-12-08 10:32:13.640 +05:30 9137066f-ef7b-4077-950f-2045c17936e0 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.eyJuYW1lIjoiRGlwaW4iLCJ1bmlxdWVfbmFtZSI6IkRpcGluIiwibmFtZWlkIjoiMiIsIkN1c3RvbUNsYWltVHlwZSI6WyJEYXRhYmFzZUtleSIsIkRhdGFiYXNlTmFtZSIsIkNoYW5uZWxJZCIsIkxhbmd1YWdlSWQiXSwiRGF0YWJhc2VLZXkiOiI4IiwiRGF0YWJhc2VOYW1lIjoiU1MwMDAyIiwiQ2hhbm5lbElkIjoiMiIsIkxhbmd1YWdlSWQiOiIxIiwibmJmIjoxNzY1MTY4MjUwLCJleHAiOjE3NjUxNzE4NTAsImlhdCI6MTc2NTE2ODI1MH0.zZJs8Vc-jHqnEfAW7D6nQVZLHpvs3vvThJfYk2xEpbE}, {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-08 10:32:13.684 +05:30 01cda18e-571b-4fef-b1aa-801bb759844b INF Executing endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetDocNo (Sang.Transactions.Api)' 2025-12-08 10:32:13.715 +05:30 01cda18e-571b-4fef-b1aa-801bb759844b 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-08 10:32:14.257 +05:30 01cda18e-571b-4fef-b1aa-801bb759844b INF Executing OkObjectResult, writing value of type 'Sang.Service.Common.ApiResponse.ApiResponse'. 2025-12-08 10:32:14.301 +05:30 01cda18e-571b-4fef-b1aa-801bb759844b INF Executed action Sang.Transactions.Api.Controllers.TransactionController.GetDocNo (Sang.Transactions.Api) in 580.3286ms 2025-12-08 10:32:14.302 +05:30 01cda18e-571b-4fef-b1aa-801bb759844b INF Executed endpoint 'Sang.Transactions.Api.Controllers.TransactionController.GetDocNo (Sang.Transactions.Api)' 2025-12-08 10:32:14.303 +05:30 01cda18e-571b-4fef-b1aa-801bb759844b INF HTTP Response: StatusCode: 200 Headers: {X-Correlation-Id: 9137066f-ef7b-4077-950f-2045c17936e0}, {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-08 10:32:14.313 +05:30 01cda18e-571b-4fef-b1aa-801bb759844b 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 805.8552ms 2025-12-08 10:43:13.083 +05:30 INF Application is shutting down...