2025-08-27 08:44:24.5906||DEBUG|InstitutionService.Program|init main function 
2025-08-27 08:44:25.3413|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-08-27 08:44:25.5121|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-08-27 08:44:25.5306|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-08-27 08:44:25.5306|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-08-27 08:44:25.5306|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (0ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-08-27 08:44:25.5504|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2025-08-27 08:44:25.5622|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2025-08-27 08:44:25.6479|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 
2025-08-27 08:44:25.6479|59|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 
2025-08-27 08:44:25.6479|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {c9c391a8-fb28-4fe4-90a1-32757c16a4e0} with creation date 2025-08-27 07:44:25Z, activation date 2025-08-27 07:44:25Z, and expiration date 2025-11-25 07:44:25Z. 
2025-08-27 08:44:25.6621|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {c9c391a8-fb28-4fe4-90a1-32757c16a4e0} may be persisted to storage in unencrypted form. 
2025-08-27 08:44:25.9120|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-08-27 08:44:25.9480|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-27 08:44:25.9480|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 40.1728ms 204  
2025-08-27 08:44:26.2142|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-08-27 08:44:26.3031|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-08-27 08:44:26.3031|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-27 08:44:26.3031|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-08-27 08:44:26.3031|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-08-27 08:44:26.3367|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GenerateCertificate", controller = "Certificate"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GenerateCertificate(Int64, Int64, Int64) on controller InstitutionService.Controllers.CertificateController (InstitutionService). 
2025-08-27 08:44:26.3367|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-08-27 08:44:26.5639|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (28ms) [Parameters=[@__courseId_0='?' (DbType = Int64), @__userId_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [c].[Id], [c].[CertificateId], [c].[CourseId], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[DownloadDate], [c].[InstitutionCode], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[UserId]
FROM [CertificateLogs] AS [c]
WHERE ([c].[CourseId] = @__courseId_0) AND ([c].[UserId] = @__userId_1) 
2025-08-27 08:44:26.6726|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@p11='?' (DbType = Int64), @p0='?' (Size = 4000), @p1='?' (DbType = Int64), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = DateTime2), @p6='?' (Size = 4000), @p7='?' (DbType = Boolean), @p8='?' (DbType = Boolean), @p9='?' (DbType = Int64), @p10='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
UPDATE [CertificateLogs] SET [CertificateId] = @p0, [CourseId] = @p1, [CreatedBy] = @p2, [DateCreated] = @p3, [DateModified] = @p4, [DownloadDate] = @p5, [InstitutionCode] = @p6, [IsActive] = @p7, [IsDeleted] = @p8, [ModifiedBy] = @p9, [UserId] = @p10
WHERE [Id] = @p11;
SELECT @@ROWCOUNT; 
2025-08-27 08:44:26.8388||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 
2025-08-27 08:44:26.8535|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [c].[Id], [c].[Code], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[InstitutionId], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[Name], [c].[Template]
FROM [CertificateTemplates] AS [c]
WHERE [c].[InstitutionId] = @__institutionId_0 
2025-08-27 08:44:28.7894|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000   
2025-08-27 08:44:28.7894|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-27 08:44:28.7894|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-27 08:44:28.7894|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 
2025-08-27 08:44:28.8334|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-08-27 08:44:28.8618|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-08-27 08:44:28.8934|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 91.5349ms 
2025-08-27 08:44:28.8934|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-27 08:44:28.8961|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 106.8031ms 200 application/json; charset=utf-8 
2025-08-27 08:44:29.0395|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000   
2025-08-27 08:44:29.0395|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-27 08:44:29.0395|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-27 08:44:29.0395|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 
2025-08-27 08:44:29.0395|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-08-27 08:44:29.0395|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-08-27 08:44:29.0395|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 4.5854ms 
2025-08-27 08:44:29.0395|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-27 08:44:29.0395|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 8.5062ms 200 application/json; charset=utf-8 
2025-08-27 08:44:30.1122|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 
2025-08-27 08:44:30.1458|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 3808.8239ms 
2025-08-27 08:44:30.1458|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-08-27 08:44:30.1467|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3932.6012ms 200 application/json; charset=utf-8 
2025-08-27 08:44:37.7496|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-08-27 08:44:37.7496|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-27 08:44:37.7496|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 3.4469ms 204  
2025-08-27 08:44:37.9904|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-08-27 08:44:37.9904|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-08-27 08:44:37.9904|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-27 08:44:37.9904|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-08-27 08:44:37.9904|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-08-27 08:44:37.9904|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GenerateCertificate", controller = "Certificate"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GenerateCertificate(Int64, Int64, Int64) on controller InstitutionService.Controllers.CertificateController (InstitutionService). 
2025-08-27 08:44:37.9904|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-08-27 08:44:37.9904|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__courseId_0='?' (DbType = Int64), @__userId_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [c].[Id], [c].[CertificateId], [c].[CourseId], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[DownloadDate], [c].[InstitutionCode], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[UserId]
FROM [CertificateLogs] AS [c]
WHERE ([c].[CourseId] = @__courseId_0) AND ([c].[UserId] = @__userId_1) 
2025-08-27 08:44:37.9904|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p11='?' (DbType = Int64), @p0='?' (Size = 4000), @p1='?' (DbType = Int64), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = DateTime2), @p6='?' (Size = 4000), @p7='?' (DbType = Boolean), @p8='?' (DbType = Boolean), @p9='?' (DbType = Int64), @p10='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
UPDATE [CertificateLogs] SET [CertificateId] = @p0, [CourseId] = @p1, [CreatedBy] = @p2, [DateCreated] = @p3, [DateModified] = @p4, [DownloadDate] = @p5, [InstitutionCode] = @p6, [IsActive] = @p7, [IsDeleted] = @p8, [ModifiedBy] = @p9, [UserId] = @p10
WHERE [Id] = @p11;
SELECT @@ROWCOUNT; 
2025-08-27 08:44:38.0088||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 
2025-08-27 08:44:38.0088|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [c].[Id], [c].[Code], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[InstitutionId], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[Name], [c].[Template]
FROM [CertificateTemplates] AS [c]
WHERE [c].[InstitutionId] = @__institutionId_0 
2025-08-27 08:44:40.7569|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 
2025-08-27 08:44:40.7820|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2786.4784ms 
2025-08-27 08:44:40.7820|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-08-27 08:44:40.7820|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2792.4038ms 200 application/json; charset=utf-8 
2025-08-27 08:44:44.9528|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-08-27 08:44:44.9528|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-27 08:44:44.9528|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.6697ms 204  
2025-08-27 08:44:45.2075|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-08-27 08:44:45.2099|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-08-27 08:44:45.2099|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-27 08:44:45.2099|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-08-27 08:44:45.2099|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-08-27 08:44:45.2099|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GenerateCertificate", controller = "Certificate"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GenerateCertificate(Int64, Int64, Int64) on controller InstitutionService.Controllers.CertificateController (InstitutionService). 
2025-08-27 08:44:45.2099|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-08-27 08:44:45.2279|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__courseId_0='?' (DbType = Int64), @__userId_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [c].[Id], [c].[CertificateId], [c].[CourseId], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[DownloadDate], [c].[InstitutionCode], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[UserId]
FROM [CertificateLogs] AS [c]
WHERE ([c].[CourseId] = @__courseId_0) AND ([c].[UserId] = @__userId_1) 
2025-08-27 08:44:45.2279|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p11='?' (DbType = Int64), @p0='?' (Size = 4000), @p1='?' (DbType = Int64), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = DateTime2), @p6='?' (Size = 4000), @p7='?' (DbType = Boolean), @p8='?' (DbType = Boolean), @p9='?' (DbType = Int64), @p10='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
UPDATE [CertificateLogs] SET [CertificateId] = @p0, [CourseId] = @p1, [CreatedBy] = @p2, [DateCreated] = @p3, [DateModified] = @p4, [DownloadDate] = @p5, [InstitutionCode] = @p6, [IsActive] = @p7, [IsDeleted] = @p8, [ModifiedBy] = @p9, [UserId] = @p10
WHERE [Id] = @p11;
SELECT @@ROWCOUNT; 
2025-08-27 08:44:45.2386||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 
2025-08-27 08:44:45.2386|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [c].[Id], [c].[Code], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[InstitutionId], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[Name], [c].[Template]
FROM [CertificateTemplates] AS [c]
WHERE [c].[InstitutionId] = @__institutionId_0 
2025-08-27 08:44:47.9620|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 
2025-08-27 08:44:47.9871|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2773.1131ms 
2025-08-27 08:44:47.9871|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-08-27 08:44:47.9881|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2780.6358ms 200 application/json; charset=utf-8 
2025-08-27 09:20:25.6420|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:23477/INSTITUTION/iisintegration  0 
2025-08-27 09:20:25.6420|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.678ms 202  
2025-08-27 09:44:11.0458||DEBUG|InstitutionService.Program|init main function 
2025-08-27 09:44:17.2949|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-08-27 09:44:17.7454|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (13ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-08-27 09:44:17.7640|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (12ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-08-27 09:44:17.7640|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT 1 
2025-08-27 09:44:17.7640|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT OBJECT_ID(N'[__EFMigrationsHistory]'); 
2025-08-27 09:44:17.7861|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
SELECT [MigrationId], [ProductVersion]
FROM [__EFMigrationsHistory]
ORDER BY [MigrationId]; 
2025-08-27 09:44:17.7861|20405|INFO|Microsoft.EntityFrameworkCore.Migrations|No migrations were applied. The database is already up to date. 
2025-08-27 09:44:18.2662|50|WARN|Microsoft.AspNetCore.DataProtection.Repositories.EphemeralXmlRepository|Using an in-memory repository. Keys will not be persisted to storage. 
2025-08-27 09:44:18.2662|59|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Neither user profile nor HKLM registry available. Using an ephemeral key repository. Protected data will be unavailable when application exits. 
2025-08-27 09:44:18.2662|58|INFO|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|Creating key {c80a5ef9-f784-4168-8b83-0a1b8b40185c} with creation date 2025-08-27 08:44:18Z, activation date 2025-08-27 08:44:18Z, and expiration date 2025-11-25 08:44:18Z. 
2025-08-27 09:44:18.2662|35|WARN|Microsoft.AspNetCore.DataProtection.KeyManagement.XmlKeyManager|No XML encryptor configured. Key {c80a5ef9-f784-4168-8b83-0a1b8b40185c} may be persisted to storage in unencrypted form. 
2025-08-27 09:44:18.4208|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-08-27 09:44:18.9378|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-27 09:44:18.9378|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 521.8069ms 204  
2025-08-27 09:44:19.2081|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-08-27 09:44:19.4224|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-08-27 09:44:19.4224|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-27 09:44:19.4224|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-08-27 09:44:19.4224|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-08-27 09:44:19.4561|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GenerateCertificate", controller = "Certificate"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GenerateCertificate(Int64, Int64, Int64) on controller InstitutionService.Controllers.CertificateController (InstitutionService). 
2025-08-27 09:44:19.4561|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-08-27 09:44:19.6285|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (28ms) [Parameters=[@__courseId_0='?' (DbType = Int64), @__userId_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [c].[Id], [c].[CertificateId], [c].[CourseId], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[DownloadDate], [c].[InstitutionCode], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[UserId]
FROM [CertificateLogs] AS [c]
WHERE ([c].[CourseId] = @__courseId_0) AND ([c].[UserId] = @__userId_1) 
2025-08-27 09:44:19.7378|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (2ms) [Parameters=[@p11='?' (DbType = Int64), @p0='?' (Size = 4000), @p1='?' (DbType = Int64), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = DateTime2), @p6='?' (Size = 4000), @p7='?' (DbType = Boolean), @p8='?' (DbType = Boolean), @p9='?' (DbType = Int64), @p10='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
UPDATE [CertificateLogs] SET [CertificateId] = @p0, [CourseId] = @p1, [CreatedBy] = @p2, [DateCreated] = @p3, [DateModified] = @p4, [DownloadDate] = @p5, [InstitutionCode] = @p6, [IsActive] = @p7, [IsDeleted] = @p8, [ModifiedBy] = @p9, [UserId] = @p10
WHERE [Id] = @p11;
SELECT @@ROWCOUNT; 
2025-08-27 09:44:19.9744||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 
2025-08-27 09:44:19.9904|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [c].[Id], [c].[Code], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[InstitutionId], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[Name], [c].[Template]
FROM [CertificateTemplates] AS [c]
WHERE [c].[InstitutionId] = @__institutionId_0 
2025-08-27 09:44:27.0922|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 
2025-08-27 09:44:27.1489|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 7690.2305ms 
2025-08-27 09:44:27.1489|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-08-27 09:44:27.1489|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 7943.558ms 200 application/json; charset=utf-8 
2025-08-27 09:44:37.2483|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-08-27 09:44:37.2527|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-27 09:44:37.2527|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 5.6606ms 204  
2025-08-27 09:44:37.4936|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Certificate/GenerateCertificate?courseId=255&userId=339&institutionId=93   
2025-08-27 09:44:37.4936|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-08-27 09:44:37.4982|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-27 09:44:37.4982|1|INFO|Microsoft.AspNetCore.Authorization.DefaultAuthorizationService|Authorization was successful. 
2025-08-27 09:44:37.4982|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-08-27 09:44:37.4982|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "GenerateCertificate", controller = "Certificate"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] GenerateCertificate(Int64, Int64, Int64) on controller InstitutionService.Controllers.CertificateController (InstitutionService). 
2025-08-27 09:44:37.5283|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-08-27 09:44:37.5336|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__courseId_0='?' (DbType = Int64), @__userId_1='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [c].[Id], [c].[CertificateId], [c].[CourseId], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[DownloadDate], [c].[InstitutionCode], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[UserId]
FROM [CertificateLogs] AS [c]
WHERE ([c].[CourseId] = @__courseId_0) AND ([c].[UserId] = @__userId_1) 
2025-08-27 09:44:37.5336|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@p11='?' (DbType = Int64), @p0='?' (Size = 4000), @p1='?' (DbType = Int64), @p2='?' (DbType = Int64), @p3='?' (DbType = DateTime2), @p4='?' (DbType = DateTime2), @p5='?' (DbType = DateTime2), @p6='?' (Size = 4000), @p7='?' (DbType = Boolean), @p8='?' (DbType = Boolean), @p9='?' (DbType = Int64), @p10='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SET NOCOUNT ON;
UPDATE [CertificateLogs] SET [CertificateId] = @p0, [CourseId] = @p1, [CreatedBy] = @p2, [DateCreated] = @p3, [DateModified] = @p4, [DownloadDate] = @p5, [InstitutionCode] = @p6, [IsActive] = @p7, [IsDeleted] = @p8, [ModifiedBy] = @p9, [UserId] = @p10
WHERE [Id] = @p11;
SELECT @@ROWCOUNT; 
2025-08-27 09:44:37.5336||DEBUG|InstitutionService.Core.Services.CertificateService|Certificate Token : System.Collections.Generic.Dictionary`2[System.String,System.String] 
2025-08-27 09:44:37.5450|20101|INFO|Microsoft.EntityFrameworkCore.Database.Command|Executed DbCommand (1ms) [Parameters=[@__institutionId_0='?' (DbType = Int64)], CommandType='Text', CommandTimeout='30']
SELECT TOP(1) [c].[Id], [c].[Code], [c].[CreatedBy], [c].[DateCreated], [c].[DateModified], [c].[InstitutionId], [c].[IsActive], [c].[IsDeleted], [c].[ModifiedBy], [c].[Name], [c].[Template]
FROM [CertificateTemplates] AS [c]
WHERE [c].[InstitutionId] = @__institutionId_0 
2025-08-27 09:44:40.2602|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'CommonBase.Model.SaveResponse'. 
2025-08-27 09:44:40.2857|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService) in 2783.6953ms 
2025-08-27 09:44:40.2857|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.CertificateController.GenerateCertificate (InstitutionService)' 
2025-08-27 09:44:40.2857|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2792.8807ms 200 application/json; charset=utf-8 
2025-08-27 10:09:48.5258|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000   
2025-08-27 10:09:48.5258|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-27 10:09:48.5258|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.6043ms 204  
2025-08-27 10:09:48.7884|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000   
2025-08-27 10:09:48.7884|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-08-27 10:09:48.7884|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-27 10:09:48.7884|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-27 10:09:48.7977|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 
2025-08-27 10:09:48.7977|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-08-27 10:09:48.8194|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-08-27 10:09:48.8299|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 32.0003ms 
2025-08-27 10:09:48.8299|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-27 10:09:48.8299|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 42.2895ms 200 application/json; charset=utf-8 
2025-08-27 10:19:16.6980|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 OPTIONS http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000   
2025-08-27 10:19:16.6980|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-27 10:19:16.6980|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 2.3478ms 204  
2025-08-27 10:19:16.9439|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 GET http://api.skilldorm.com/Institution/api/Institution/Search?Page=1&PageSize=1000   
2025-08-27 10:19:16.9455|2|INFO|Microsoft.AspNetCore.Authentication.JwtBearer.JwtBearerHandler|Successfully validated the token. 
2025-08-27 10:19:16.9455|4|INFO|Microsoft.AspNetCore.Cors.Infrastructure.CorsService|CORS policy execution successful. 
2025-08-27 10:19:16.9455|0|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executing endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-27 10:19:16.9455|3|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Route matched with {action = "SearchInstitution", controller = "Institution"}. Executing controller action with signature System.Threading.Tasks.Task`1[Microsoft.AspNetCore.Mvc.IActionResult] SearchInstitution(Int32, Int32, System.Nullable`1[System.Int64], System.Nullable`1[System.Boolean], System.String) on controller InstitutionService.Controllers.InstitutionController (InstitutionService). 
2025-08-27 10:19:16.9455|10403|INFO|Microsoft.EntityFrameworkCore.Infrastructure|Entity Framework Core 3.1.11 initialized 'AppDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: using lazy-loading proxies  
2025-08-27 10:19:16.9455|1|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor|Executing ObjectResult, writing value of type 'System.Collections.Generic.List`1[[InstitutionService.Data.Model.InstitutionViewModel, InstitutionService.Data, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]]'. 
2025-08-27 10:19:16.9619|2|INFO|Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker|Executed action InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService) in 13.9793ms 
2025-08-27 10:19:16.9619|1|INFO|Microsoft.AspNetCore.Routing.EndpointMiddleware|Executed endpoint 'InstitutionService.Controllers.InstitutionController.SearchInstitution (InstitutionService)' 
2025-08-27 10:19:16.9619|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 18.5682ms 200 application/json; charset=utf-8 
2025-08-27 11:45:16.3022|1|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request starting HTTP/1.1 POST http://127.0.0.1:39373/INSTITUTION/iisintegration  0 
2025-08-27 11:45:16.3022|2|INFO|Microsoft.AspNetCore.Hosting.Diagnostics|Request finished in 0.7548ms 202