Logs

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle 5ca77443-5ac1-4eb5-9dc9-8f5d08232bda | Request 161938]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:2f19897c-db76-4e60-bd0a-a85ba0539455
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle db1f128b-0a34-490f-88f6-5d729e46a27d | Request 639524]
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:2f19897c-db76-4e60-bd0a-a85ba0539455
Error Number:4060,State:1,Class:11

Discovered 2 active NPHIES customers

Poll cycle "c4145775-23df-4960-a66b-9448c18c63a5" starting

Poll cycle "4982503b-6826-4b5c-a44f-a1c409e84bec" Completed. Customers: 2

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType communication-request [Bundle 822c3fcf-cbe2-4267-96ea-c5aa0d48714e | Request 876175]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:081731e2-26be-4126-ad64-356d5def1260
Error Number:4060,State:1,Class:11

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType claim-response [Bundle 3e7526bf-5955-42a0-a799-2d83fd19c601 | Request 306766]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:081731e2-26be-4126-ad64-356d5def1260
Error Number:4060,State:1,Class:11

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType priorauth-response [Bundle fcae3788-d13a-47ba-a233-c207753c3775 | Request 492629]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:081731e2-26be-4126-ad64-356d5def1260
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle 36d7f087-9903-46c3-a0f2-812fa2e3b58e | Request 160011]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:081731e2-26be-4126-ad64-356d5def1260
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle 9ff4ba81-4c8b-4adc-8e5c-b4497af53b6f | Request 904537]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:081731e2-26be-4126-ad64-356d5def1260
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle fcee93a3-f8b8-47fa-b051-c574291db02a | Request 336037]
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:081731e2-26be-4126-ad64-356d5def1260
Error Number:4060,State:1,Class:11

Discovered 2 active NPHIES customers

Poll cycle "4982503b-6826-4b5c-a44f-a1c409e84bec" starting

Poll cycle "4899ce8c-c542-4291-9682-3bc58f472614" Completed. Customers: 2

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType communication-request [Bundle c57c4646-4bb4-4c8d-8feb-31948d98bcda | Request 154085]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:af5b9947-68e0-4f7e-b645-6af76ffdd225
Error Number:4060,State:1,Class:11

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType claim-response [Bundle b9ef42f7-89d7-471f-83f5-a9fd79919c44 | Request 534540]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:af5b9947-68e0-4f7e-b645-6af76ffdd225
Error Number:4060,State:1,Class:11

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType priorauth-response [Bundle 7bbc9520-f1fa-4dc6-ba73-d1acd0f565c9 | Request 584479]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:af5b9947-68e0-4f7e-b645-6af76ffdd225
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle 22922af3-0d6b-4fc7-b049-9d2d12b5d310 | Request 504619]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:af5b9947-68e0-4f7e-b645-6af76ffdd225
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle 46b0af3a-5063-4ac6-9e62-f5fad508342b | Request 236527]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:af5b9947-68e0-4f7e-b645-6af76ffdd225
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle 89e78ea9-6b7a-4bba-a71d-9336fec68915 | Request 442743]
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:af5b9947-68e0-4f7e-b645-6af76ffdd225
Error Number:4060,State:1,Class:11

Discovered 2 active NPHIES customers

Poll cycle "4899ce8c-c542-4291-9682-3bc58f472614" starting

Poll cycle "d1105351-4127-45f1-8aff-20b41d9e5869" Completed. Customers: 2

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType communication-request [Bundle c1972c26-ac10-463d-ac5b-064601c69682 | Request 708641]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:0d5dc668-d8fe-4427-8d3c-c0cf62a2ebe1
Error Number:4060,State:1,Class:11

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType claim-response [Bundle 5d260bb3-12a1-4ca8-9705-c7f1b9113bc3 | Request 428362]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:0d5dc668-d8fe-4427-8d3c-c0cf62a2ebe1
Error Number:4060,State:1,Class:11

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType priorauth-response [Bundle f2205f1e-a66d-4874-a3c7-9ef1c7ae1c5c | Request 903806]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:0d5dc668-d8fe-4427-8d3c-c0cf62a2ebe1
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle f33693cb-792b-4ce6-bde9-869edae4814d | Request 425187]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:0d5dc668-d8fe-4427-8d3c-c0cf62a2ebe1
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle 27ffd0e2-5d10-4b21-aa3c-65c41e250986 | Request 874526]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:0d5dc668-d8fe-4427-8d3c-c0cf62a2ebe1
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle 53643da7-6b5e-4775-aad3-06d81b511c8a | Request 656117]
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:0d5dc668-d8fe-4427-8d3c-c0cf62a2ebe1
Error Number:4060,State:1,Class:11

Discovered 2 active NPHIES customers

Poll cycle "d1105351-4127-45f1-8aff-20b41d9e5869" starting

Poll cycle "31abfe08-8245-4737-8649-d6ca633179a8" Completed. Customers: 2

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType communication-request [Bundle c86c6cb4-cc9d-430d-9a4d-6429539e6a4e | Request 798364]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:98e8f1f4-6203-4eb9-a766-bcc7191d5668
Error Number:4060,State:1,Class:11

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType claim-response [Bundle 1954de64-cfa3-4418-b3a4-d34387e9e2a3 | Request 763488]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:98e8f1f4-6203-4eb9-a766-bcc7191d5668
Error Number:4060,State:1,Class:11

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType priorauth-response [Bundle eda31d92-a55e-448a-b55b-0e4444ed86a9 | Request 292272]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:98e8f1f4-6203-4eb9-a766-bcc7191d5668
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle 158b2dc9-2c21-4e90-92d3-3f0653a035d7 | Request 140074]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:98e8f1f4-6203-4eb9-a766-bcc7191d5668
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle 6056147a-4356-4463-8bf5-06efe25dbafd | Request 674632]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:98e8f1f4-6203-4eb9-a766-bcc7191d5668
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle e8ea4a13-c7de-4f1e-832b-5598f8d29b78 | Request 624273]
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:98e8f1f4-6203-4eb9-a766-bcc7191d5668
Error Number:4060,State:1,Class:11

Discovered 2 active NPHIES customers

Poll cycle "31abfe08-8245-4737-8649-d6ca633179a8" starting

Poll cycle "812b6dd5-d24e-489b-b0b2-ce1a2d278d9f" Completed. Customers: 2

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType communication-request [Bundle c83c69bb-7c4a-4817-9b48-756cdec3a5b9 | Request 637559]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:bcf7ab9b-ae94-44c1-9af1-8be529a7c15f
Error Number:4060,State:1,Class:11

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType claim-response [Bundle 0bce0a3e-1b95-4bec-82eb-e6987eca4878 | Request 911121]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:bcf7ab9b-ae94-44c1-9af1-8be529a7c15f
Error Number:4060,State:1,Class:11

Poll failed for Branch 40 (فرع تداوي والحياة الطبي), PollType priorauth-response [Bundle dc1de9ac-bad1-4518-bd41-f0df6a6a4dc7 | Request 529907]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:bcf7ab9b-ae94-44c1-9af1-8be529a7c15f
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle 1db27bbf-2c2c-4ccc-9f9d-4072956a07dc | Request 368349]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:bcf7ab9b-ae94-44c1-9af1-8be529a7c15f
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle defa9e20-9de2-416e-8258-08501ec76952 | Request 371455]
Microsoft.Data.SqlClient.SqlException (0x80131904): Cannot open database "NitcoSysLog" requested by the login. The login failed.
Login failed for user 'NitcoWebcenter'.
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.ConnectionPool.WaitHandleDbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 taskCompletionSource, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at Microsoft.Data.SqlClient.SqlConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
   at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, SqlConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry)
   at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry, SqlConnectionOverrides overrides)
   at Microsoft.Data.SqlClient.SqlConnection.InternalOpenAsync(SqlConnectionOverrides overrides, CancellationToken cancellationToken)
--- End of stack trace from previous location ---
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 137
   at NphiesAutoPollService.Services.PollResultPersistenceService.InsertDHSLogAsync(String logMessage, String logResult, String errorMessage, Int64 branchId, String providerCode, Int32 providerType, String requestJson, String responseJson, Nullable`1 requestedId, Nullable`1 bundleId, Decimal netAmount, String serializedRequest, Nullable`1 visitBillCode, Nullable`1 diagHeaderCode, Nullable`1 claimType, Nullable`1 requestDate, String clinicDeptNameAr, String clinicDeptNameEn, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\PollResultPersistenceService.cs:line 175
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ProcessCustomerPollAsync(NphiesCustomer customer, String pollType, String requestJson, Nullable`1 bundleId, Nullable`1 requestedId, INphiesApiClient apiClient, IPollResponseParser responseParser, IRequestItemEnricher requestItemEnricher, IPollResultPersistenceService persistenceService, CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 329
   at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163
ClientConnectionId:bcf7ab9b-ae94-44c1-9af1-8be529a7c15f
Error Number:4060,State:1,Class:11

Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle 0390b3c7-5698-498b-a6ad-d71cbed08e04 | Request 622199]
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:bcf7ab9b-ae94-44c1-9af1-8be529a7c15f
Error Number:4060,State:1,Class:11

Discovered 2 active NPHIES customers

Poll cycle "812b6dd5-d24e-489b-b0b2-ce1a2d278d9f" starting

Poll cycle "9f43f51a-7a80-40bb-9f2a-7e2aa491f21b" Completed. Customers: 2