Levels
Nothing ticked means every level.

Service log

Download today 16,420 matching entries
Timestamp Level Message
2026-10-31 16:00:20 Information 
Parsed 10 claim responses for poll type claim-response
2026-10-31 16:00:18 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle c76ecb48-4e52-49af-a2cf-785b4225811d | Request 644398]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.CompleteLogin(Boolean enlistOK)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, TimeoutTimer timeout, Boolean withFailover)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, DbConnectionPoolGroupProviderInfo providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken, IDbConnectionPool pool, Func`3 accessTokenCallback, SspiContextProvider sspiContextProvider)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionPoolGroupProviderInfo poolGroupProviderInfo, IDbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.CreatePooledConnection(DbConnection owningConnection, IDbConnectionPool pool, DbConnectionPoolKey poolKey, DbConnectionOptions options, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.WaitForPendingOpen()
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:37f29326-eab6-408d-bce5-8d47d95c07d7
Error Number:4060,State:1,Class:11
2026-10-31 16:00:07 Information 
Discovered 2 active NPHIES customers
2026-10-31 16:00:07 Information 
Poll cycle "f36b90a3-2c24-48e4-afd4-1df486a9e6d8" starting
2026-10-31 15:57:39 Information 
Poll cycle "3024c624-27cc-43a2-a141-e62ed70a1189" Completed. Customers: 2
2026-10-31 15:57:39 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType communication-request [Bundle b96c63d0-cfd8-471e-b468-02467022ef62 | Request 508762]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:4b40a91a-8ee3-4c92-b142-3d66075982b3
Error Number:4060,State:1,Class:11
2026-10-31 15:57:38 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType claim-response [Bundle 2314d518-fa8a-4a87-b492-5aaf2911c97a | Request 711102]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:4b40a91a-8ee3-4c92-b142-3d66075982b3
Error Number:4060,State:1,Class:11
2026-10-31 15:57:35 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType priorauth-response [Bundle 3d51cfa6-7370-4c5d-bfec-69f3d0a3be97 | Request 222729]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:4b40a91a-8ee3-4c92-b142-3d66075982b3
Error Number:4060,State:1,Class:11
2026-10-31 15:57:35 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle 73be323b-1816-4e8c-89bc-138947e6bdb1 | Request 999842]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:4b40a91a-8ee3-4c92-b142-3d66075982b3
Error Number:4060,State:1,Class:11
2026-10-31 15:57:34 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle 5da73cf7-400b-4c0b-82d3-1b28581a5690 | Request 135887]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:4b40a91a-8ee3-4c92-b142-3d66075982b3
Error Number:4060,State:1,Class:11
2026-10-31 15:57:24 Information 
Parsed 10 claim responses for poll type claim-response
2026-10-31 15:57:17 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle be133174-4524-4cf8-8a93-2471336a13ee | Request 370644]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.CompleteLogin(Boolean enlistOK)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, TimeoutTimer timeout, Boolean withFailover)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, DbConnectionPoolGroupProviderInfo providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken, IDbConnectionPool pool, Func`3 accessTokenCallback, SspiContextProvider sspiContextProvider)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionPoolGroupProviderInfo poolGroupProviderInfo, IDbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.CreatePooledConnection(DbConnection owningConnection, IDbConnectionPool pool, DbConnectionPoolKey poolKey, DbConnectionOptions options, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.WaitForPendingOpen()
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:edbc749f-ec8f-4f10-9dc6-5a17ac482961
Error Number:4060,State:1,Class:11
2026-10-31 15:57:07 Information 
Discovered 2 active NPHIES customers
2026-10-31 15:57:07 Information 
Poll cycle "3024c624-27cc-43a2-a141-e62ed70a1189" starting
2026-10-31 15:54:37 Information 
Poll cycle "8e00f257-c9d0-470d-94ec-1b8ee989c65b" Completed. Customers: 2
2026-10-31 15:54:37 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType communication-request [Bundle 3ba6f14a-5508-445b-9e64-98cb9b747424 | Request 490762]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:65dc85d1-05f7-410e-bd8a-01bc8f3b786f
Error Number:4060,State:1,Class:11
2026-10-31 15:54:36 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType claim-response [Bundle 2f69081d-3927-45da-8b74-866ab96c7a2f | Request 799471]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:65dc85d1-05f7-410e-bd8a-01bc8f3b786f
Error Number:4060,State:1,Class:11
2026-10-31 15:54:35 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType priorauth-response [Bundle abb59fdf-0088-4318-8650-29ce02021013 | Request 645632]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:65dc85d1-05f7-410e-bd8a-01bc8f3b786f
Error Number:4060,State:1,Class:11
2026-10-31 15:54:35 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle 97d41089-e827-4a67-bd1f-2d0934c97b49 | Request 779919]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:65dc85d1-05f7-410e-bd8a-01bc8f3b786f
Error Number:4060,State:1,Class:11
2026-10-31 15:54:34 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle e1f4c3c8-f10c-4132-9282-682d5038979b | Request 837905]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:65dc85d1-05f7-410e-bd8a-01bc8f3b786f
Error Number:4060,State:1,Class:11
2026-10-31 15:54:24 Information 
Parsed 10 claim responses for poll type claim-response
2026-10-31 15:54:17 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle 6bbdf508-bf03-4eaf-b9e5-ec84f7be6fce | Request 225064]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.CompleteLogin(Boolean enlistOK)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, TimeoutTimer timeout, Boolean withFailover)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, DbConnectionPoolGroupProviderInfo providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken, IDbConnectionPool pool, Func`3 accessTokenCallback, SspiContextProvider sspiContextProvider)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionPoolGroupProviderInfo poolGroupProviderInfo, IDbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.CreatePooledConnection(DbConnection owningConnection, IDbConnectionPool pool, DbConnectionPoolKey poolKey, DbConnectionOptions options, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.WaitForPendingOpen()
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:fa41e525-4c10-4b93-a572-57eaabd19bea
Error Number:4060,State:1,Class:11
2026-10-31 15:54:07 Information 
Discovered 2 active NPHIES customers
2026-10-31 15:54:07 Information 
Poll cycle "8e00f257-c9d0-470d-94ec-1b8ee989c65b" starting
2026-10-31 15:51:38 Information 
Poll cycle "58e86865-47b0-4b46-be10-2eea8bd560b3" Completed. Customers: 2
2026-10-31 15:51:38 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType communication-request [Bundle 2dbfcf1f-ee5f-4a07-85c4-cf05920f7ca4 | Request 233818]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:7c9057bb-b284-410a-b1d3-46f811dea2d5
Error Number:4060,State:1,Class:11
2026-10-31 15:51:37 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType claim-response [Bundle 75ff1b24-7d7c-4426-8a73-9e5c73caf414 | Request 282421]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:7c9057bb-b284-410a-b1d3-46f811dea2d5
Error Number:4060,State:1,Class:11
2026-10-31 15:51:37 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType priorauth-response [Bundle 3e05ca0a-511c-4896-b195-8acb3196a502 | Request 466775]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:7c9057bb-b284-410a-b1d3-46f811dea2d5
Error Number:4060,State:1,Class:11
2026-10-31 15:51:36 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle 6b736423-a5cc-4491-9718-b5bd6133b6d4 | Request 345368]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:7c9057bb-b284-410a-b1d3-46f811dea2d5
Error Number:4060,State:1,Class:11
2026-10-31 15:51:36 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle 6e8981d6-94b6-4faf-af5e-e79f1370ea20 | Request 408054]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:7c9057bb-b284-410a-b1d3-46f811dea2d5
Error Number:4060,State:1,Class:11
2026-10-31 15:51:26 Information 
Parsed 10 claim responses for poll type claim-response
2026-10-31 15:51:17 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle ee48f562-7686-48f2-bd05-bc940c87e335 | Request 279578]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.CompleteLogin(Boolean enlistOK)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, TimeoutTimer timeout, Boolean withFailover)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, DbConnectionPoolGroupProviderInfo providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken, IDbConnectionPool pool, Func`3 accessTokenCallback, SspiContextProvider sspiContextProvider)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionPoolGroupProviderInfo poolGroupProviderInfo, IDbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.CreatePooledConnection(DbConnection owningConnection, IDbConnectionPool pool, DbConnectionPoolKey poolKey, DbConnectionOptions options, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.WaitForPendingOpen()
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:eddd8b4f-1203-4456-8ae6-948af9c7a5b5
Error Number:4060,State:1,Class:11
2026-10-31 15:51:07 Information 
Discovered 2 active NPHIES customers
2026-10-31 15:51:07 Information 
Poll cycle "58e86865-47b0-4b46-be10-2eea8bd560b3" starting
2026-10-31 15:48:33 Information 
Poll cycle "d54c5259-5f42-4763-8fe2-991cabd4986b" Completed. Customers: 2
2026-10-31 15:48:33 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType communication-request [Bundle 68344445-467d-4861-8e06-8877faf69d22 | Request 313415]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:cbb88b5c-a282-4db9-b7af-d4654c9768c3
Error Number:4060,State:1,Class:11
2026-10-31 15:48:33 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType claim-response [Bundle 8790df99-44bc-4ec5-8f23-09cc80674d41 | Request 469388]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.CompleteLogin(Boolean enlistOK)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, TimeoutTimer timeout, Boolean withFailover)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, DbConnectionPoolGroupProviderInfo providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken, IDbConnectionPool pool, Func`3 accessTokenCallback, SspiContextProvider sspiContextProvider)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionPoolGroupProviderInfo poolGroupProviderInfo, IDbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.CreatePooledConnection(DbConnection owningConnection, IDbConnectionPool pool, DbConnectionPoolKey poolKey, DbConnectionOptions options, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.WaitForPendingOpen()
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:cbb88b5c-a282-4db9-b7af-d4654c9768c3
Error Number:4060,State:1,Class:11
2026-10-31 15:48:22 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType priorauth-response [Bundle 3285d5c8-8ccb-47a9-a596-f0c763435875 | Request 945879]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:ce241a21-20b3-44dd-93af-6636b98b779c
Error Number:4060,State:1,Class:11
2026-10-31 15:48:21 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle c26faa7e-5b11-41aa-a198-a66a80996ebe | Request 689361]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:ce241a21-20b3-44dd-93af-6636b98b779c
Error Number:4060,State:1,Class:11
2026-10-31 15:48:19 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle 58f41e7e-ce51-4c4d-9229-884b40ac8ef6 | Request 858716]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:ce241a21-20b3-44dd-93af-6636b98b779c
Error Number:4060,State:1,Class:11
2026-10-31 15:48:19 Information 
Parsed 10 claim responses for poll type claim-response
2026-10-31 15:48:18 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle eb91c043-2459-4052-9f3c-a953c0304978 | Request 128817]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.CompleteLogin(Boolean enlistOK)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, TimeoutTimer timeout, Boolean withFailover)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, DbConnectionPoolGroupProviderInfo providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken, IDbConnectionPool pool, Func`3 accessTokenCallback, SspiContextProvider sspiContextProvider)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionPoolGroupProviderInfo poolGroupProviderInfo, IDbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.CreatePooledConnection(DbConnection owningConnection, IDbConnectionPool pool, DbConnectionPoolKey poolKey, DbConnectionOptions options, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.WaitForPendingOpen()
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:ce241a21-20b3-44dd-93af-6636b98b779c
Error Number:4060,State:1,Class:11
2026-10-31 15:48:07 Information 
Discovered 2 active NPHIES customers
2026-10-31 15:48:07 Information 
Poll cycle "d54c5259-5f42-4763-8fe2-991cabd4986b" starting
2026-10-31 15:45:35 Information 
Poll cycle "2b98e3ea-923b-402e-8d67-dbd578a99c63" Completed. Customers: 2
2026-10-31 15:45:35 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType communication-request [Bundle cb1c76c3-6008-4dd8-86a5-54f3f6065256 | Request 994308]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:06751ae8-34a0-41cc-a0dc-98793b37c6d4
Error Number:4060,State:1,Class:11
2026-10-31 15:45:34 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType claim-response [Bundle 4b20a6d5-cdf1-4713-b86b-053a974a3162 | Request 495827]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:06751ae8-34a0-41cc-a0dc-98793b37c6d4
Error Number:4060,State:1,Class:11
2026-10-31 15:45:33 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType priorauth-response [Bundle f6f182a8-8afb-4a50-bf85-140939b71723 | Request 913964]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:06751ae8-34a0-41cc-a0dc-98793b37c6d4
Error Number:4060,State:1,Class:11
2026-10-31 15:45:32 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle 7d4d3941-e343-42c9-85ed-87b729a35983 | Request 455107]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, SqlCommand command, Boolean callerHasConnectionLock, Boolean asyncClose)
   at Microsoft.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at Microsoft.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.CompleteLogin(Boolean enlistOK)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, TimeoutTimer timeout, Boolean withFailover)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
   at Microsoft.Data.SqlClient.Connection.SqlConnectionInternal..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, DbConnectionPoolGroupProviderInfo providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken, IDbConnectionPool pool, Func`3 accessTokenCallback, SspiContextProvider sspiContextProvider)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionPoolGroupProviderInfo poolGroupProviderInfo, IDbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.CreatePooledConnection(DbConnection owningConnection, IDbConnectionPool pool, DbConnectionPoolKey poolKey, DbConnectionOptions options, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.WaitForPendingOpen()
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:06751ae8-34a0-41cc-a0dc-98793b37c6d4
Error Number:4060,State:1,Class:11
2026-10-31 15:45:21 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle e750a54b-5694-495d-ad63-162dd69c9f6d | Request 523202]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:d0bd4568-3d09-411e-954a-59676cd0444d
Error Number:4060,State:1,Class:11