2025-10-30 16:27:36.3259||DEBUG|PaymentSystem.Program|init main function 
2025-10-30 16:27:40.6676||INFO|Hangfire.SqlServer.SqlServerObjectsInstaller|Start installing Hangfire SQL objects... 
2025-10-30 16:27:41.1596||INFO|Hangfire.SqlServer.SqlServerObjectsInstaller|Hangfire SQL objects installed. 
2025-10-30 16:27:41.1870||INFO|Hangfire.BackgroundJobServer|Starting Hangfire Server using job storage: 'SQL Server: VLIV-EFTDB01@RCPaySL-Live' 
2025-10-30 16:27:41.1870||INFO|Hangfire.BackgroundJobServer|Using the following options for SQL Server job storage: Queue poll interval: 00:00:00. 
2025-10-30 16:27:41.1870||INFO|Hangfire.BackgroundJobServer|Using the following options for Hangfire Server:
    Worker count: 20
    Listening queues: 'default'
    Shutdown timeout: 00:00:15
    Schedule polling interval: 00:00:15 
2025-10-30 16:27:41.3462||INFO|Hangfire.Server.BackgroundServerProcess|Server vliv-eftapp01:11128:fe8fa86d successfully announced in 99.4869 ms 
2025-10-30 16:27:41.3527||INFO|Hangfire.Server.BackgroundServerProcess|Server vliv-eftapp01:11128:fe8fa86d is starting the registered dispatchers: ServerWatchdog, ServerJobCancellationWatcher, ExpirationManager, CountersAggregator, Worker, DelayedJobScheduler, RecurringJobScheduler... 
2025-10-30 16:27:41.3665||INFO|Hangfire.Server.BackgroundServerProcess|Server vliv-eftapp01:11128:fe8fa86d all the dispatchers started 
2025-10-30 16:27:43.0258|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Amount' on entity type 'BlackList'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 
2025-10-30 16:27:43.0258|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Amount' on entity type 'FeeReversal'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 
2025-10-30 16:27:43.0414|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'FeeAmount' on entity type 'FeeTransactionLog'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 
2025-10-30 16:27:43.0414|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Amount' on entity type 'FeeTransactionLogStaging'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 
2025-10-30 16:27:43.0414|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'FeeAmount' on entity type 'PaymentBatch'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 
2025-10-30 16:27:43.0414|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'TotalAmount' on entity type 'PaymentBatch'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 
2025-10-30 16:27:43.0565|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Amount' on entity type 'PaymentItem'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 
2025-10-30 16:27:43.0565|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'CorporateFeeAmount' on entity type 'PaymentItem'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 
2025-10-30 16:27:43.0565|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'CreditAmount' on entity type 'PaymentItem'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 
2025-10-30 16:27:43.0565|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'CustomerFeeAmount' on entity type 'PaymentItem'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 
2025-10-30 16:27:43.0565|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'CorporateFeeAmount' on entity type 'PaymentItemStaging'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 
2025-10-30 16:27:43.0707|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'CreditedAmount' on entity type 'PaymentItemStaging'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 
2025-10-30 16:27:43.0707|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'CustomerFeeAmount' on entity type 'PaymentItemStaging'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 
2025-10-30 16:27:43.0707|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Amount' on entity type 'PaymentReversal'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 
2025-10-30 16:27:43.0707|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Amount' on entity type 'PaymentSummaryByBank'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 
2025-10-30 16:27:43.0707|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Credit' on entity type 'Statement'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 
2025-10-30 16:27:43.0707|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'Debit' on entity type 'Statement'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 
2025-10-30 16:27:43.0707|30000|WARN|Microsoft.EntityFrameworkCore.Model.Validation|No type was specified for the decimal column 'TotalAmount' on entity type 'UploadStaging'. This will cause values to be silently truncated if they do not fit in the default precision and scale. Explicitly specify the SQL server column type that can accommodate all the values using 'HasColumnType()'. 
2025-10-30 16:27:43.1233|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 16:27:43.1233|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 16:27:43.1233|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 16:27:43.1233|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 16:27:43.1233|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 16:27:44.5063|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-10-30 16:27:44.5255|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (9ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-10-30 16:27:44.5255|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-10-30 16:27:44.5255|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (37ms) [Parameters=[@__xDate_0='?' (DbType = DateTime2)], CommandType='Text', CommandTimeout='30']
SELECT [p].[Id], [p].[ApprovalStatus], [p].[BatchDescription], [p].[BatchReference], [p].[CorporateId], [p].[CreatedBy], [p].[CurrencyId], [p].[DateCreated], [p].[DateModified], [p].[Fee], [p].[FeeAmount], [p].[FinalResponseCode], [p].[FinalResponseDescription], [p].[InProgress], [p].[InitialResponseCode], [p].[InitialResponseDescription], [p].[IsActive], [p].[IsDeleted], [p].[IsReversed], [p].[LastReQueryDate], [p].[ModifiedBy], [p].[PaymentMode], [p].[PaymentReference], [p].[PaymentStatus], [p].[PaymentTypeId], [p].[RetryCount], [p].[SourceAccount], [p].[SourceAccountName], [p].[SuspenseAccount], [p].[TotalAmount], [p].[TotalItem], [p].[TransactionDate], [p].[TransactionRef], [p].[TransactionStatus], [p].[UploadStagingId], [p].[UserType], [p].[UserTypeId]
FROM [PaymentBatch] AS [p]
WHERE ([p].[TransactionStatus] = 9) AND ([p].[TransactionDate] <= @__xDate_0) 
2025-10-30 16:27:44.5255|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (27ms) [Parameters=[@__defaultDate_0='?' (DbType = DateTime2), @__today_1='?' (DbType = DateTime2), @__today_2='?' (DbType = DateTime2)], CommandType='Text', CommandTimeout='30']
SELECT [p].[Id], [p].[ApprovalStatus], [p].[BatchDescription], [p].[BatchReference], [p].[CorporateId], [p].[CreatedBy], [p].[CurrencyId], [p].[DateCreated], [p].[DateModified], [p].[Fee], [p].[FeeAmount], [p].[FinalResponseCode], [p].[FinalResponseDescription], [p].[InProgress], [p].[InitialResponseCode], [p].[InitialResponseDescription], [p].[IsActive], [p].[IsDeleted], [p].[IsReversed], [p].[LastReQueryDate], [p].[ModifiedBy], [p].[PaymentMode], [p].[PaymentReference], [p].[PaymentStatus], [p].[PaymentTypeId], [p].[RetryCount], [p].[SourceAccount], [p].[SourceAccountName], [p].[SuspenseAccount], [p].[TotalAmount], [p].[TotalItem], [p].[TransactionDate], [p].[TransactionRef], [p].[TransactionStatus], [p].[UploadStagingId], [p].[UserType], [p].[UserTypeId]
FROM [PaymentBatch] AS [p]
WHERE ([p].[TransactionStatus] = 5) AND ((([p].[TransactionDate] > @__defaultDate_0) AND ([p].[TransactionDate] < @__today_1)) OR ([p].[DateCreated] < @__today_2)) 
2025-10-30 16:27:44.5411|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (7ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-10-30 16:27:44.5960|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (32ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2025-10-30 16:27:44.6169|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2025-10-30 16:27:45.1125||INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|User profile not available. Using 'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\ASP.NET\4.0.30319.0\AutoGenKeys\S-1-5-82-405065765-51968188-4129435083-1865239232-3978796933\DataProtection' as key repository and Windows DPAPI to encrypt keys at rest. 
2025-10-30 16:27:45.1221|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {4f3e0547-da5b-4b09-b8d6-25cd818d5d67} with creation date 2025-10-30 16:27:45Z, activation date 2025-10-30 16:27:45Z, and expiration date 2026-01-28 16:27:45Z. 
2025-10-30 16:27:45.4661|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/Statistics?CorporateId=207&Days=30   
2025-10-30 16:27:45.4661|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/PaymentService/api/PaymentType/List?isActive=true&institutionId=79   
2025-10-30 16:27:46.3436|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-30 16:27:46.3436|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-30 16:27:46.3546|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 888.6832ms 204  
2025-10-30 16:27:46.3546|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 888.6887ms 204  
2025-10-30 16:27:46.3822|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/Statistics?CorporateId=207&Days=30   
2025-10-30 16:27:46.3822|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/PaymentService/api/PaymentType/List?isActive=true&institutionId=79   
2025-10-30 16:27:46.6548|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-30 16:27:46.6548|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-30 16:27:46.6548|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-30 16:27:46.6548|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-30 16:27:46.6680|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-10-30 16:27:46.6680|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-10-30 16:27:46.6680|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'PaymentService.Controllers.PaymentTypeController.List (PaymentService)' 
2025-10-30 16:27:46.6680|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService)' 
2025-10-30 16:27:46.7004|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "List", controller = "PaymentType"}. Executing controller action with signature Microsoft.AspNetCore.Mvc.IActionResult List(Boolean, Int64, Int64) on controller PaymentService.Controllers.PaymentTypeController (PaymentService). 
2025-10-30 16:27:46.7004|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetPaymentStatistics", controller = "Payment"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetPaymentStatistics(Int64, System.String, System.String, Int32) on controller PaymentService.Controllers.PaymentController (PaymentService). 
2025-10-30 16:27:46.7312|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 16:27:46.7312|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 16:27:46.9380|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (180ms) [Parameters=[@__CorporateId_1='?' (DbType = Int64), @__InstitutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT [p].[Name], [p].[Code], [p].[Id], [p].[IsActive], [p].[AllowPartialPayment], [p].[Default], [p].[InstitutionId], @__CorporateId_1 AS [CorporateId]
FROM [PaymentTypes] AS [p]
WHERE (([p].[IsActive] = CAST(1 AS bit)) AND ([p].[IsDeleted] = CAST(0 AS bit))) AND (([p].[InstitutionId] = @__InstitutionId_0) OR ([p].[InstitutionId] = CAST(0 AS bigint))) 
2025-10-30 16:27:47.2110|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[PaymentService.Data.Model.PaymentStatisticsViewModel, PaymentService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-10-30 16:27:47.2110|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[System.Collections.Generic.List`1[[PaymentService.Data.Model.PaymentTypeModel, PaymentService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]]'. 
2025-10-30 16:27:47.2332|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action PaymentService.Controllers.PaymentTypeController.List (PaymentService) in 528.3408ms 
2025-10-30 16:27:47.2332|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService) in 526.9217ms 
2025-10-30 16:27:47.2332|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'PaymentService.Controllers.PaymentTypeController.List (PaymentService)' 
2025-10-30 16:27:47.2332|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService)' 
2025-10-30 16:27:47.2332|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 858.0825ms 200 application/json; charset=utf-8 
2025-10-30 16:27:47.2332|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 858.1594ms 200 application/json; charset=utf-8 
2025-10-30 16:29:43.9155|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/PendingQueue/207?StartDate=2025-10-30&EndDate=2025-10-30&UploadStatus=2&Page=1&PageSize=100   
2025-10-30 16:29:43.9155|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-30 16:29:43.9155|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 7.9891ms 204  
2025-10-30 16:29:43.9296|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/PendingQueue/207?StartDate=2025-10-30&EndDate=2025-10-30&UploadStatus=2&Page=1&PageSize=100   
2025-10-30 16:29:43.9296|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-30 16:29:43.9296|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-30 16:29:43.9296|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-10-30 16:29:43.9296|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'PaymentService.Controllers.PaymentController.GetPendingPaymentQueue (PaymentService)' 
2025-10-30 16:29:43.9508|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetPendingPaymentQueue", controller = "Payment"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetPendingPaymentQueue(Int64, System.String, System.String, System.String, Int32, Int32, Int32) on controller PaymentService.Controllers.PaymentController (PaymentService). 
2025-10-30 16:29:43.9508|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 16:29:44.2269|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[CorporatePay.Common.Model.PagedModel`1[[PaymentService.Data.Model.PaymentDetailModel, PaymentService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], CorporatePay.Common, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-10-30 16:29:44.2421|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action PaymentService.Controllers.PaymentController.GetPendingPaymentQueue (PaymentService) in 290.0522ms 
2025-10-30 16:29:44.2421|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'PaymentService.Controllers.PaymentController.GetPendingPaymentQueue (PaymentService)' 
2025-10-30 16:29:44.2421|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 317.1891ms 200 application/json; charset=utf-8 
2025-10-30 16:30:12.3071|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 16:30:12.3071|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 16:31:47.3579|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/Statistics?CorporateId=207&Days=30   
2025-10-30 16:31:47.3579|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-30 16:31:47.3579|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 7.5113ms 204  
2025-10-30 16:31:47.3725|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/Statistics?CorporateId=207&Days=30   
2025-10-30 16:31:47.3725|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-30 16:31:47.3725|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-30 16:31:47.3725|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-10-30 16:31:47.3725|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService)' 
2025-10-30 16:31:47.3899|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetPaymentStatistics", controller = "Payment"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetPaymentStatistics(Int64, System.String, System.String, Int32) on controller PaymentService.Controllers.PaymentController (PaymentService). 
2025-10-30 16:31:47.3899|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 16:31:47.5752|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[PaymentService.Data.Model.PaymentStatisticsViewModel, PaymentService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-10-30 16:31:47.5803|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService) in 186.3956ms 
2025-10-30 16:31:47.5803|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService)' 
2025-10-30 16:31:47.5803|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 211.2709ms 200 application/json; charset=utf-8 
2025-10-30 16:35:12.5375|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 16:35:12.5375|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 16:40:12.6592|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 16:40:12.6592|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 16:45:12.8522|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 16:45:12.8522|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 16:46:55.3579|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/Statistics?CorporateId=207&Days=30   
2025-10-30 16:46:55.3623|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-30 16:46:55.3623|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 6.7734ms 204  
2025-10-30 16:46:55.3623|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/Statistics?CorporateId=207&Days=30   
2025-10-30 16:46:55.3765|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-30 16:46:55.3765|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-30 16:46:55.3765|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-10-30 16:46:55.3765|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService)' 
2025-10-30 16:46:55.3765|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetPaymentStatistics", controller = "Payment"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetPaymentStatistics(Int64, System.String, System.String, Int32) on controller PaymentService.Controllers.PaymentController (PaymentService). 
2025-10-30 16:46:55.3765|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 16:46:55.5396|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[PaymentService.Data.Model.PaymentStatisticsViewModel, PaymentService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-10-30 16:46:55.5396|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService) in 159.7822ms 
2025-10-30 16:46:55.5396|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'PaymentService.Controllers.PaymentController.GetPaymentStatistics (PaymentService)' 
2025-10-30 16:46:55.5500|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 176.8308ms 200 application/json; charset=utf-8 
2025-10-30 16:49:52.0769|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/PendingQueue/207?StartDate=2025-10-30&EndDate=2025-10-30&UploadStatus=2&Page=1&PageSize=100   
2025-10-30 16:49:52.0810|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-30 16:49:52.0810|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 6.6438ms 204  
2025-10-30 16:49:52.0810|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/PendingQueue/207?StartDate=2025-10-30&EndDate=2025-10-30&UploadStatus=2&Page=1&PageSize=100   
2025-10-30 16:49:52.0971|1|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Failed to validate the token. Microsoft.IdentityModel.Tokens.SecurityTokenExpiredException: IDX10223: Lifetime validation failed. The token is expired. ValidTo: 'System.DateTime', Current time: 'System.DateTime'.
   at Microsoft.IdentityModel.Tokens.Validators.ValidateLifetime(Nullable`1 notBefore, Nullable`1 expires, SecurityToken securityToken, TokenValidationParameters validationParameters)
   at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateLifetime(Nullable`1 notBefore, Nullable`1 expires, JwtSecurityToken jwtToken, TokenValidationParameters validationParameters)
   at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateTokenPayload(JwtSecurityToken jwtToken, TokenValidationParameters validationParameters)
   at System.IdentityModel.Tokens.Jwt.JwtSecurityTokenHandler.ValidateToken(String token, TokenValidationParameters validationParameters, SecurityToken& validatedToken)
   at Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler.HandleAuthenticateAsync()
2025-10-30 16:49:52.2831|7|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Bearer was not authenticated. Failure message: IDX10223: Lifetime validation failed. The token is expired. ValidTo: 'System.DateTime', Current time: 'System.DateTime'. 
2025-10-30 16:49:52.2831|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-30 16:49:52.2831|2|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization failed. 
2025-10-30 16:49:52.2831|12|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|AuthenticationScheme: Bearer was challenged. 
2025-10-30 16:49:52.2831|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 204.2405ms 401  
2025-10-30 16:49:56.6265|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://rcpayapi.mof.gov.sl/PaymentService/api/Payment/PendingQueue/207?StartDate=2025-10-30&EndDate=2025-10-30&UploadStatus=2&Page=1&PageSize=100   
2025-10-30 16:49:56.6307|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-10-30 16:49:56.6307|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-10-30 16:49:56.6307|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-10-30 16:49:56.6307|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'PaymentService.Controllers.PaymentController.GetPendingPaymentQueue (PaymentService)' 
2025-10-30 16:49:56.6307|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GetPendingPaymentQueue", controller = "Payment"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GetPendingPaymentQueue(Int64, System.String, System.String, System.String, Int32, Int32, Int32) on controller PaymentService.Controllers.PaymentController (PaymentService). 
2025-10-30 16:49:56.6307|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 16:49:56.7086|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CorporatePay.Common.Model.Response`1[[CorporatePay.Common.Model.PagedModel`1[[PaymentService.Data.Model.PaymentDetailModel, PaymentService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], CorporatePay.Common, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-10-30 16:49:56.7086|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action PaymentService.Controllers.PaymentController.GetPendingPaymentQueue (PaymentService) in 72.6239ms 
2025-10-30 16:49:56.7086|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'PaymentService.Controllers.PaymentController.GetPendingPaymentQueue (PaymentService)' 
2025-10-30 16:49:56.7086|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 89.3645ms 200 application/json; charset=utf-8 
2025-10-30 16:50:13.0381|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 16:50:13.0503|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 16:55:13.1880|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 16:55:13.1880|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 17:00:13.3737|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 17:00:13.3737|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 17:05:13.5009|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 17:05:13.5414|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 17:10:13.6803|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 17:10:13.6803|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.10 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-10-30 17:10:34.6167|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:45016/PAYMENTSERVICE/iisintegration  0 
2025-10-30 17:10:34.6167|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.4104ms 202  
2025-10-30 17:10:34.6167||INFO|Hangfire.Server.BackgroundServerProcess|Server vliv-eftapp01:11128:fe8fa86d caught stopping signal... 
2025-10-30 17:10:34.6299||INFO|Hangfire.Server.BackgroundServerProcess|Server vliv-eftapp01:11128:fe8fa86d caught stopped signal... 
2025-10-30 17:10:35.6741||INFO|Hangfire.Server.BackgroundServerProcess|Server vliv-eftapp01:11128:fe8fa86d All dispatchers stopped 
2025-10-30 17:10:35.6882||INFO|Hangfire.Server.BackgroundServerProcess|Server vliv-eftapp01:11128:fe8fa86d successfully reported itself as stopped in 6.7879 ms 
2025-10-30 17:10:35.6882||INFO|Hangfire.Server.BackgroundServerProcess|Server vliv-eftapp01:11128:fe8fa86d has been stopped in total 1063.568 ms