Logs

Discovered 2 active NPHIES customers

Poll cycle "6fac06af-21c1-4e19-8cc9-2d5ea923f3b0" starting

Poll cycle "8d20e8ec-83eb-4126-9d5d-487df728b4c9" Completed. Customers: 2

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType communication-request [Bundle b4db443f-846a-4359-97b6-16dfe2e2d565 | Request 566696]
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:e0d8231d-b733-439e-af1b-cec34edcdb5f
Error Number:4060,State:1,Class:11

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType claim-response [Bundle e17ffa6b-57ab-4bc1-aeeb-d6ac8f937a5d | Request 115337]
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:e0d8231d-b733-439e-af1b-cec34edcdb5f
Error Number:4060,State:1,Class:11

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType priorauth-response [Bundle a976d27f-c62a-46b2-b013-c30a3ad4e7e8 | Request 168918]
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:e0d8231d-b733-439e-af1b-cec34edcdb5f
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle f21ffeaa-3222-4feb-b592-1bb045860f50 | Request 506124]
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:e0d8231d-b733-439e-af1b-cec34edcdb5f
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle f4c9cb40-c1e6-4215-823f-0401ab69b934 | Request 158441]
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:e0d8231d-b733-439e-af1b-cec34edcdb5f
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle 90d2e18b-2f54-435a-bbe7-f77d5be3722b | Request 815078]
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.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.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:e0d8231d-b733-439e-af1b-cec34edcdb5f
Error Number:4060,State:1,Class:11

Discovered 2 active NPHIES customers

Poll cycle "8d20e8ec-83eb-4126-9d5d-487df728b4c9" starting

Poll cycle "8c3f4126-68c2-4742-8469-4f78dfc34812" Completed. Customers: 2

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType communication-request [Bundle 50b7c368-af29-4922-bb31-fc7141c5c170 | Request 584927]
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:f37509c9-3f6f-43eb-b0a4-b2ecbe664d81
Error Number:4060,State:1,Class:11

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType claim-response [Bundle 2d2db8d5-8562-4ee9-9b79-42ddbfe3e5c2 | Request 709029]
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:f37509c9-3f6f-43eb-b0a4-b2ecbe664d81
Error Number:4060,State:1,Class:11

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType priorauth-response [Bundle 685e05e2-3a24-4cfc-8972-d514cd1f257f | Request 118451]
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:f37509c9-3f6f-43eb-b0a4-b2ecbe664d81
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle be7f00af-ca63-4b72-8c0d-9f5da62481d1 | Request 926708]
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:f37509c9-3f6f-43eb-b0a4-b2ecbe664d81
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle ef487286-70cc-48cd-9dfd-00194aa54ea4 | Request 389673]
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:f37509c9-3f6f-43eb-b0a4-b2ecbe664d81
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle 36a532c3-e551-46e1-a66e-706e49797a60 | Request 399463]
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:f37509c9-3f6f-43eb-b0a4-b2ecbe664d81
Error Number:4060,State:1,Class:11

Discovered 2 active NPHIES customers

Poll cycle "8c3f4126-68c2-4742-8469-4f78dfc34812" starting

Poll cycle "d417fa38-4d37-49c6-88f7-1e1feac6cc4c" Completed. Customers: 2

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType communication-request [Bundle b0dbb401-be14-45ca-86b0-35777fe1ace7 | Request 999035]
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:0ba9dfd0-44e7-4d3e-8632-0c82c2cf28a5
Error Number:4060,State:1,Class:11

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType claim-response [Bundle fc399131-3a0f-4e97-9fdd-7a356ecdfa27 | Request 452748]
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:0ba9dfd0-44e7-4d3e-8632-0c82c2cf28a5
Error Number:4060,State:1,Class:11

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType priorauth-response [Bundle 305d20ad-3e15-4aab-8f36-0b05b0e7c7d4 | Request 202425]
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:0ba9dfd0-44e7-4d3e-8632-0c82c2cf28a5
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle f02bcae4-1aa1-41e0-96a6-be88658dc135 | Request 605220]
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:0ba9dfd0-44e7-4d3e-8632-0c82c2cf28a5
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle 86dd6412-3fdc-4c83-8032-c7f9e25e3aaf | Request 825712]
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:0ba9dfd0-44e7-4d3e-8632-0c82c2cf28a5
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle 6959faee-1ab6-491b-a658-95957a1d9807 | Request 807582]
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:0ba9dfd0-44e7-4d3e-8632-0c82c2cf28a5
Error Number:4060,State:1,Class:11

Discovered 2 active NPHIES customers

Poll cycle "d417fa38-4d37-49c6-88f7-1e1feac6cc4c" starting

Poll cycle "ba5b1b1e-e0f5-4eb8-8699-77dbfee8ad87" Completed. Customers: 2

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType communication-request [Bundle a2b77113-9ef0-4537-98c1-451e9fdf294e | Request 967696]
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:00e7bcad-3b8d-476b-85d3-980c57ae6292
Error Number:4060,State:1,Class:11

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType claim-response [Bundle bc1bbf4f-ea1e-4774-bff4-7e6184f8a091 | Request 828292]
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:00e7bcad-3b8d-476b-85d3-980c57ae6292
Error Number:4060,State:1,Class:11

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType priorauth-response [Bundle f3183c8a-370c-4a36-86e4-46f58aef40a4 | Request 651141]
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:00e7bcad-3b8d-476b-85d3-980c57ae6292
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle 295aff8d-f3cb-4035-aa13-d6e94949666c | Request 316109]
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:00e7bcad-3b8d-476b-85d3-980c57ae6292
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle 99db1d22-11cb-4936-8d47-4b003f1147ba | Request 779485]
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:00e7bcad-3b8d-476b-85d3-980c57ae6292
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle 54fd166a-3ad9-4736-af5b-b67c2160e3e2 | Request 899001]
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:00e7bcad-3b8d-476b-85d3-980c57ae6292
Error Number:4060,State:1,Class:11

Discovered 2 active NPHIES customers

Poll cycle "ba5b1b1e-e0f5-4eb8-8699-77dbfee8ad87" starting

Poll cycle "0acf804f-e580-42bb-9711-054fb6b0b271" Completed. Customers: 2

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType communication-request [Bundle c75c2cc7-d754-41b1-8b8a-48c1dd5d50e3 | Request 539818]
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:cb78e6b4-9212-486f-9a89-1153503e377b
Error Number:4060,State:1,Class:11

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType claim-response [Bundle 509c88c7-4d9f-4bc0-a437-0f3070149528 | Request 915677]
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:cb78e6b4-9212-486f-9a89-1153503e377b
Error Number:4060,State:1,Class:11

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType priorauth-response [Bundle af0ee23f-8658-43d3-96f7-e1668c081470 | Request 275382]
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:cb78e6b4-9212-486f-9a89-1153503e377b
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle 441eae4b-fd85-4a8f-a3a7-8d9997be4f7f | Request 703659]
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:cb78e6b4-9212-486f-9a89-1153503e377b
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle bb55e166-5857-4db4-94a9-6a8e270c0017 | Request 699182]
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:cb78e6b4-9212-486f-9a89-1153503e377b
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle efbd4432-71f7-4982-95ba-28826339401b | Request 913259]
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:cb78e6b4-9212-486f-9a89-1153503e377b
Error Number:4060,State:1,Class:11

Discovered 2 active NPHIES customers

Poll cycle "0acf804f-e580-42bb-9711-054fb6b0b271" starting

Poll cycle "4797c7ae-1765-4cba-8a2c-347f943ff541" Completed. Customers: 2

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType communication-request [Bundle 8f87efaf-bbf2-41eb-ab2f-91850218e653 | Request 397414]
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:bfe6403a-3be0-4503-bd22-8e1359a1e8f5
Error Number:4060,State:1,Class:11

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType claim-response [Bundle 06e11793-d5d1-4754-9fdf-c42d70ce3549 | Request 891685]
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:bfe6403a-3be0-4503-bd22-8e1359a1e8f5
Error Number:4060,State:1,Class:11