Levels
Nothing ticked means every level.

Service log

Download today 22,404 matching entries
Timestamp Level Message
2026-11-01 04:48:25 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle 347fbe58-1e05-42fb-9a57-4c276e39cdac | Request 702334]
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:ea851588-479d-4b67-97de-1513f8eb63f9
Error Number:4060,State:1,Class:11
2026-11-01 04:48:15 Information 
Discovered 2 active NPHIES customers
2026-11-01 04:48:15 Information 
Poll cycle "feddb653-54f6-4901-93b5-709453e30f7c" starting
2026-11-01 04:45:27 Information 
Poll cycle "e16092cc-d1b7-40c2-9b1e-6a29717b1f30" Completed. Customers: 2
2026-11-01 04:45:27 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType communication-request [Bundle 4abdccf7-51aa-412d-9aca-f205b79f772d | Request 960967]
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:4fb5e644-6ef1-4dad-b935-7bae00d620bb
Error Number:4060,State:1,Class:11
2026-11-01 04:45:26 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType claim-response [Bundle 485d3f99-123f-4db0-9393-582eab1d6539 | Request 439806]
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:4fb5e644-6ef1-4dad-b935-7bae00d620bb
Error Number:4060,State:1,Class:11
2026-11-01 04:45:26 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType priorauth-response [Bundle a755413e-b58c-4aee-945b-e4e5441dce44 | Request 420505]
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:4fb5e644-6ef1-4dad-b935-7bae00d620bb
Error Number:4060,State:1,Class:11
2026-11-01 04:45:26 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle b7da0f9b-3bba-4e66-9504-e937fc9f9077 | Request 482382]
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:4fb5e644-6ef1-4dad-b935-7bae00d620bb
Error Number:4060,State:1,Class:11
2026-11-01 04:45:25 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle 36ed7e92-971e-47fe-9c1a-fc30892b10c2 | Request 515148]
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:4fb5e644-6ef1-4dad-b935-7bae00d620bb
Error Number:4060,State:1,Class:11
2026-11-01 04:45:25 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle f97d85d0-9243-4409-bae0-6d0867ccfe8c | Request 529659]
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:4fb5e644-6ef1-4dad-b935-7bae00d620bb
Error Number:4060,State:1,Class:11
2026-11-01 04:45:15 Information 
Discovered 2 active NPHIES customers
2026-11-01 04:45:15 Information 
Poll cycle "e16092cc-d1b7-40c2-9b1e-6a29717b1f30" starting
2026-11-01 04:42:43 Information 
Poll cycle "21108ec2-2c79-4442-8bff-66a1a3565d27" Completed. Customers: 2
2026-11-01 04:42:43 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType communication-request [Bundle a388047b-3ab1-4305-a3a4-ccdf33abc851 | Request 412796]
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:3cc800f2-b23a-47ba-8114-8b17c8b0a221
Error Number:4060,State:1,Class:11
2026-11-01 04:42:43 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType claim-response [Bundle 0de49c00-f196-4879-b135-465961ff5990 | Request 621554]
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:3cc800f2-b23a-47ba-8114-8b17c8b0a221
Error Number:4060,State:1,Class:11
2026-11-01 04:42:43 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType priorauth-response [Bundle 4015aac3-ddbf-4c65-b439-16455ab0e0ec | Request 573797]
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:3cc800f2-b23a-47ba-8114-8b17c8b0a221
Error Number:4060,State:1,Class:11
2026-11-01 04:42:26 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle 7a000f46-e30a-4663-9d27-048f6fc857da | Request 341373]
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:8187604a-dc9d-4485-91a9-ee6957b43b8f
Error Number:4060,State:1,Class:11
2026-11-01 04:42:25 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle cb944ab9-15ec-4118-8ab4-f9cd715a30b2 | Request 460477]
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:8187604a-dc9d-4485-91a9-ee6957b43b8f
Error Number:4060,State:1,Class:11
2026-11-01 04:42:25 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle b41bb940-70a7-4c56-8742-890850b63099 | Request 621569]
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:8187604a-dc9d-4485-91a9-ee6957b43b8f
Error Number:4060,State:1,Class:11
2026-11-01 04:42:15 Information 
Discovered 2 active NPHIES customers
2026-11-01 04:42:15 Information 
Poll cycle "21108ec2-2c79-4442-8bff-66a1a3565d27" starting
2026-11-01 04:39:27 Information 
Poll cycle "ee541334-f8fa-40ea-8174-32b653f63ce9" Completed. Customers: 2
2026-11-01 04:39:27 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType communication-request [Bundle dd4d23f2-76f0-432b-85d7-7a01cf139505 | Request 549024]
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:5fc38b67-ae68-4b7c-9e40-89647141b3a5
Error Number:4060,State:1,Class:11
2026-11-01 04:39:27 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType claim-response [Bundle ad84ec48-96ca-4efd-8e8f-8ac80c1a8fbe | Request 350472]
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.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, 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.ProviderBase.DbConnectionClosed.TryOpenConnection(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:5fc38b67-ae68-4b7c-9e40-89647141b3a5
Error Number:4060,State:1,Class:11
2026-11-01 04:39:27 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType priorauth-response [Bundle c269d593-a631-49bb-a413-1faa4bd2e3ff | Request 214913]
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.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, 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.ProviderBase.DbConnectionClosed.TryOpenConnection(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:5fc38b67-ae68-4b7c-9e40-89647141b3a5
Error Number:4060,State:1,Class:11
2026-11-01 04:39:26 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle 81ad9c6a-2ee1-46eb-9fea-e3b08ec18c5a | Request 232192]
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.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, 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.ProviderBase.DbConnectionClosed.TryOpenConnection(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:5fc38b67-ae68-4b7c-9e40-89647141b3a5
Error Number:4060,State:1,Class:11
2026-11-01 04:39:26 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle 36c0b195-d8c7-4690-90da-cabbfe1a291f | Request 256558]
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.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, 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.ProviderBase.DbConnectionClosed.TryOpenConnection(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:5fc38b67-ae68-4b7c-9e40-89647141b3a5
Error Number:4060,State:1,Class:11
2026-11-01 04:39:25 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle ea436be6-75bf-4a86-8240-c0e381c6b0d8 | Request 833554]
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:5fc38b67-ae68-4b7c-9e40-89647141b3a5
Error Number:4060,State:1,Class:11
2026-11-01 04:39:15 Information 
Discovered 2 active NPHIES customers
2026-11-01 04:39:15 Information 
Poll cycle "ee541334-f8fa-40ea-8174-32b653f63ce9" starting
2026-11-01 04:36:43 Information 
Poll cycle "1b6c3636-f732-4fca-abbe-b504fc3bdcf6" Completed. Customers: 2
2026-11-01 04:36:43 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType communication-request [Bundle 711e66f7-ef01-4c93-9a09-8aada00132c6 | Request 210931]
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.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, 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.ProviderBase.DbConnectionClosed.TryOpenConnection(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:827c735f-3766-41eb-9f88-4aa4d78c5c70
Error Number:4060,State:1,Class:11
2026-11-01 04:36:43 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType claim-response [Bundle 267c37c3-0bc8-4a33-84fa-639e3ba02dc4 | Request 755888]
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.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, 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.ProviderBase.DbConnectionClosed.TryOpenConnection(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:827c735f-3766-41eb-9f88-4aa4d78c5c70
Error Number:4060,State:1,Class:11
2026-11-01 04:36:42 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType priorauth-response [Bundle 3136016e-9616-4bd3-a76f-e10104397925 | Request 374427]
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:827c735f-3766-41eb-9f88-4aa4d78c5c70
Error Number:4060,State:1,Class:11
2026-11-01 04:36:28 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle debad1af-39bb-4ebe-bc75-e8cdcce99504 | Request 739329]
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.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, 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.ProviderBase.DbConnectionClosed.TryOpenConnection(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:6aab82c9-d086-4209-92b6-b2932edf207a
Error Number:4060,State:1,Class:11
2026-11-01 04:36:27 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle eff94470-4e19-428d-819d-7bf6de0ede17 | Request 192158]
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.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, 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.ProviderBase.DbConnectionClosed.TryOpenConnection(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:6aab82c9-d086-4209-92b6-b2932edf207a
Error Number:4060,State:1,Class:11
2026-11-01 04:36:27 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle dfcf410c-4e49-4428-b662-8dc607e5c995 | Request 968018]
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:6aab82c9-d086-4209-92b6-b2932edf207a
Error Number:4060,State:1,Class:11
2026-11-01 04:36:15 Information 
Discovered 2 active NPHIES customers
2026-11-01 04:36:15 Information 
Poll cycle "1b6c3636-f732-4fca-abbe-b504fc3bdcf6" starting
2026-11-01 04:33:27 Information 
Poll cycle "99f909f5-e3ea-4367-a4bd-d65a3d7baecc" Completed. Customers: 2
2026-11-01 04:33:27 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType communication-request [Bundle df1150fc-48ab-488d-9835-340242178cb5 | Request 303068]
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.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, 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.ProviderBase.DbConnectionClosed.TryOpenConnection(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:76bd1c79-b108-48fa-b974-da0f58164bc0
Error Number:4060,State:1,Class:11
2026-11-01 04:33:27 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType claim-response [Bundle 9ff0df56-7b5a-40fc-9222-391fcd878ebf | Request 538865]
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.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, 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.ProviderBase.DbConnectionClosed.TryOpenConnection(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:76bd1c79-b108-48fa-b974-da0f58164bc0
Error Number:4060,State:1,Class:11
2026-11-01 04:33:26 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType priorauth-response [Bundle e4568fe9-2985-4716-bfa9-bd7a0831d8c3 | Request 874317]
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.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, 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.ProviderBase.DbConnectionClosed.TryOpenConnection(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:76bd1c79-b108-48fa-b974-da0f58164bc0
Error Number:4060,State:1,Class:11
2026-11-01 04:33:26 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle 63d3e17e-5770-4dfa-8011-921bcb804ea2 | Request 961474]
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.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, 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.ProviderBase.DbConnectionClosed.TryOpenConnection(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:76bd1c79-b108-48fa-b974-da0f58164bc0
Error Number:4060,State:1,Class:11
2026-11-01 04:33:25 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle 3e1fc4ce-2c05-476f-bfa1-6ae3ce641c62 | Request 115476]
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.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, 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.ProviderBase.DbConnectionClosed.TryOpenConnection(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:76bd1c79-b108-48fa-b974-da0f58164bc0
Error Number:4060,State:1,Class:11
2026-11-01 04:33:25 Error 
Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle 0dd39694-94a0-4a51-a73d-24ce01333bbb | Request 638624]
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:76bd1c79-b108-48fa-b974-da0f58164bc0
Error Number:4060,State:1,Class:11
2026-11-01 04:33:15 Information 
Discovered 2 active NPHIES customers
2026-11-01 04:33:15 Information 
Poll cycle "99f909f5-e3ea-4367-a4bd-d65a3d7baecc" starting
2026-11-01 04:30:27 Information 
Poll cycle "af946ed2-c192-424b-84be-13cd80aa8ffb" Completed. Customers: 2
2026-11-01 04:30:27 Error 
Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType communication-request [Bundle 2dca14ee-93af-401e-b726-3f536085b4ec | Request 425743]
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.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, 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.ProviderBase.DbConnectionClosed.TryOpenConnection(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:c5bb3230-3e06-4966-8c94-5253c0d2cc8a
Error Number:4060,State:1,Class:11