Service log
Download today
19,828 matching entries
| Timestamp | Level | Message |
|---|---|---|
| 2026-10-10 10:52:38 | Error | Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle d5064777-6a50-4c28-b5e0-cdd8f825ea09 | Request 783650] 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:096c30c9-2efa-4520-82d9-947412131804 Error Number:4060,State:1,Class:11 |
| 2026-10-10 10:52:35 | Error | Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle 104ec7d6-5599-46c0-b8c2-73d62dbda908 | Request 893332] 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:096c30c9-2efa-4520-82d9-947412131804 Error Number:4060,State:1,Class:11 |
| 2026-10-10 10:52:24 | Information | Discovered 1 active NPHIES customers |
| 2026-10-10 10:52:24 | Information | Poll cycle "eb132808-d553-4f96-a792-ab8c4fc570df" starting |
| 2026-10-10 10:49:42 | Information | Poll cycle "97dae216-a268-4894-96cd-2426e9655a40" Completed. Customers: 1 |
| 2026-10-10 10:49:42 | Error | Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle 710024b4-2e20-4d18-a4a4-01486b000b7c | Request 929012] 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:fe412bfa-13cc-4f08-b49b-248b2ad143fb Error Number:4060,State:1,Class:11 |
| 2026-10-10 10:49:42 | Error | Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle 3ae30f4e-c3ca-44a2-856b-c5ae0f037a98 | Request 480781] 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:fe412bfa-13cc-4f08-b49b-248b2ad143fb Error Number:4060,State:1,Class:11 |
| 2026-10-10 10:49:38 | Error | Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle 4e92ac47-2f5f-410c-a1ae-e75c12df3bb1 | Request 472260] 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:fe412bfa-13cc-4f08-b49b-248b2ad143fb Error Number:4060,State:1,Class:11 |
| 2026-10-10 10:49:24 | Information | Discovered 1 active NPHIES customers |
| 2026-10-10 10:49:24 | Information | Poll cycle "97dae216-a268-4894-96cd-2426e9655a40" starting |
| 2026-10-10 10:46:40 | Information | Poll cycle "acef3258-594c-4931-bcf4-aae09d04b32b" Completed. Customers: 1 |
| 2026-10-10 10:46:40 | Error | Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle 0fd39b11-4fe8-43ef-ab3c-1b87f6223699 | Request 535247] 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:048c119b-9b59-4694-aa7d-8ee22a353362 Error Number:4060,State:1,Class:11 |
| 2026-10-10 10:46:39 | Error | Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle 4bff1692-f1fd-4355-bbaf-fb3da051355a | Request 386013] 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:048c119b-9b59-4694-aa7d-8ee22a353362 Error Number:4060,State:1,Class:11 |
| 2026-10-10 10:46:37 | Error | Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle 31bb6dad-4157-4dee-a60b-e115e09f883a | Request 924708] 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:048c119b-9b59-4694-aa7d-8ee22a353362 Error Number:4060,State:1,Class:11 |
| 2026-10-10 10:46:24 | Information | Discovered 1 active NPHIES customers |
| 2026-10-10 10:46:24 | Information | Poll cycle "acef3258-594c-4931-bcf4-aae09d04b32b" starting |
| 2026-10-10 10:43:40 | Information | Poll cycle "2588db61-21d6-4b49-bba2-13a30b28eecd" Completed. Customers: 1 |
| 2026-10-10 10:43:40 | Error | Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle c7cb331c-f7e1-465d-84c4-1eab1f3d866a | Request 797239] 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:b2a619d3-0a38-41a3-ad44-f85a45db4e3f Error Number:4060,State:1,Class:11 |
| 2026-10-10 10:43:38 | Error | Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle 12569e42-8147-4b01-bdaa-8d40f0b51cad | Request 501111] 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:b2a619d3-0a38-41a3-ad44-f85a45db4e3f Error Number:4060,State:1,Class:11 |
| 2026-10-10 10:43:36 | Error | Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle 4e697cfd-60cb-42a3-b615-5887601ff8cc | Request 531878] 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:b2a619d3-0a38-41a3-ad44-f85a45db4e3f Error Number:4060,State:1,Class:11 |
| 2026-10-10 10:43:24 | Information | Discovered 1 active NPHIES customers |
| 2026-10-10 10:43:24 | Information | Poll cycle "2588db61-21d6-4b49-bba2-13a30b28eecd" starting |
| 2026-10-10 10:40:37 | Information | Poll cycle "816817f4-6842-4d1f-8038-ee83d71962df" Completed. Customers: 1 |
| 2026-10-10 10:40:37 | Error | Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle 20885e54-be68-447e-be9f-c493230bc0e4 | Request 411543] 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:72b12736-f984-4b27-96fd-3755538c4e23 Error Number:4060,State:1,Class:11 |
| 2026-10-10 10:40:37 | Error | Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle f7faf646-9a58-4e49-8a19-053a96740372 | Request 632827] 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:72b12736-f984-4b27-96fd-3755538c4e23 Error Number:4060,State:1,Class:11 |
| 2026-10-10 10:40:35 | Error | Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle 09332b92-2006-46df-a559-3444e73b4754 | Request 531856] 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:72b12736-f984-4b27-96fd-3755538c4e23 Error Number:4060,State:1,Class:11 |
| 2026-10-10 10:40:24 | Information | Discovered 1 active NPHIES customers |
| 2026-10-10 10:40:24 | Information | Poll cycle "816817f4-6842-4d1f-8038-ee83d71962df" starting |
| 2026-10-10 10:37:45 | Information | Poll cycle "621deee2-f4ab-49c9-812c-e89ee07efb11" Completed. Customers: 1 |
| 2026-10-10 10:37:45 | Error | Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle 66f3b0cd-9094-4dae-9594-eaba24abc049 | Request 578968] 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:010e3080-f937-45bc-97e6-95e276bda654 Error Number:4060,State:1,Class:11 |
| 2026-10-10 10:37:40 | Error | Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle 1622bd03-4187-481e-bc5a-600c4ce98ca7 | Request 918292] 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:010e3080-f937-45bc-97e6-95e276bda654 Error Number:4060,State:1,Class:11 |
| 2026-10-10 10:37:37 | Error | Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle 88007992-e383-4ef7-879d-fdce188fd676 | Request 724692] 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:010e3080-f937-45bc-97e6-95e276bda654 Error Number:4060,State:1,Class:11 |
| 2026-10-10 10:37:24 | Information | Discovered 1 active NPHIES customers |
| 2026-10-10 10:37:24 | Information | Poll cycle "621deee2-f4ab-49c9-812c-e89ee07efb11" starting |
| 2026-10-10 10:34:41 | Information | Poll cycle "4179d338-3b61-46d3-a15a-778a27349cc9" Completed. Customers: 1 |
| 2026-10-10 10:34:41 | Error | Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle ea21cd7b-fd14-480c-a95c-acc6bbbca8b9 | Request 497543] 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:fc8c4850-d67b-4df8-b1a3-aeb15327769e Error Number:4060,State:1,Class:11 |
| 2026-10-10 10:34:41 | Error | Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType claim-response [Bundle 1705c70e-1b1d-41f8-b69d-fb1009e76cc2 | Request 340965] 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:fc8c4850-d67b-4df8-b1a3-aeb15327769e Error Number:4060,State:1,Class:11 |
| 2026-10-10 10:34:39 | Error | Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle e3297029-c5bb-427f-a8a8-4b55ed2c3d78 | Request 396302] 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:fc8c4850-d67b-4df8-b1a3-aeb15327769e Error Number:4060,State:1,Class:11 |
| 2026-10-10 10:34:25 | Information | Discovered 1 active NPHIES customers |
| 2026-10-10 10:34:24 | Information | Loaded 157 denial codes from C:\inetpub\wwwroot\NphiesAutoPollService\Data\DenialCodes.json |
| 2026-10-10 10:34:24 | Information | Poll cycle "4179d338-3b61-46d3-a15a-778a27349cc9" starting |
| 2026-10-10 10:34:24 | Information | NPHIES Poll Background Service starting |
| 2026-10-10 10:34:24 | Information | Restored 10 cycle(s) from diagnostics history (cumulative 15) |
| 2026-10-10 07:05:18 | Information | NPHIES Poll Background Service stopped |
| 2026-10-10 07:05:18 | Information | Poll cycle "72711d24-1fee-4e2f-ae80-485a390b5f56" Completed. Customers: 1 |
| 2026-10-10 07:05:18 | Error | Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType priorauth-response [Bundle e3e3341d-1bdd-49b7-b092-9cd896cef484 | Request 268067] System.Threading.Tasks.TaskCanceledException: The operation was canceled. ---> System.Threading.Tasks.TaskCanceledException: The operation was canceled. ---> System.IO.IOException: Unable to read data from the transport connection: The I/O operation has been aborted because of either a thread exit or an application request.. ---> System.Net.Sockets.SocketException (995): The I/O operation has been aborted because of either a thread exit or an application request. --- End of inner exception stack trace --- at System.Net.Sockets.Socket.AwaitableSocketAsyncEventArgs.ThrowException(SocketError error, CancellationToken cancellationToken) at System.Net.Sockets.Socket.AwaitableSocketAsyncEventArgs.System.Threading.Tasks.Sources.IValueTaskSource<System.Int32>.GetResult(Int16 token) at System.Net.Security.SslStream.EnsureFullTlsFrameAsync[TIOAdapter](CancellationToken cancellationToken, Int32 estimatedSize) at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token) at System.Net.Security.SslStream.ReadAsyncInternal[TIOAdapter](Memory`1 buffer, CancellationToken cancellationToken) at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token) at System.Net.Http.HttpConnection.InitialFillAsync(Boolean async) at System.Net.Http.HttpConnection.SendAsync(HttpRequestMessage request, Boolean async, CancellationToken cancellationToken) --- End of inner exception stack trace --- at System.Net.Http.HttpConnection.SendAsync(HttpRequestMessage request, Boolean async, CancellationToken cancellationToken) at System.Net.Http.HttpConnectionPool.SendWithVersionDetectionAndRetryAsync(HttpRequestMessage request, Boolean async, Boolean doRequestAuth, CancellationToken cancellationToken) at System.Net.Http.RedirectHandler.SendAsync(HttpRequestMessage request, Boolean async, CancellationToken cancellationToken) at Microsoft.Extensions.Http.Logging.LoggingHttpMessageHandler.<SendCoreAsync>g__Core|5_0(HttpRequestMessage request, Boolean useAsync, CancellationToken cancellationToken) at Microsoft.Extensions.Http.Logging.LoggingScopeHttpMessageHandler.<SendCoreAsync>g__Core|5_0(HttpRequestMessage request, Boolean useAsync, CancellationToken cancellationToken) at System.Net.Http.HttpClient.<SendAsync>g__Core|83_0(HttpRequestMessage request, HttpCompletionOption completionOption, CancellationTokenSource cts, Boolean disposeCts, CancellationTokenSource pendingRequestsCts, CancellationToken originalCancellationToken) --- End of inner exception stack trace --- at System.Net.Http.HttpClient.HandleFailure(Exception e, Boolean telemetryStarted, HttpResponseMessage response, CancellationTokenSource cts, CancellationToken cancellationToken, CancellationTokenSource pendingRequestsCts) at System.Net.Http.HttpClient.<SendAsync>g__Core|83_0(HttpRequestMessage request, HttpCompletionOption completionOption, CancellationTokenSource cts, Boolean disposeCts, CancellationTokenSource pendingRequestsCts, CancellationToken originalCancellationToken) at NphiesAutoPollService.Services.NphiesApiClient.SendAsync(NphiesCustomer customer, String mode, String serviceUrl, String fhirJson, String sentWrapperJson, HttpClient client, StringContent content, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesApiClient.cs:line 107 at NphiesAutoPollService.Services.NphiesApiClient.SendMiddlewareAsync(NphiesCustomer customer, NphiesSettings settings, String fhirJson, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesApiClient.cs:line 94 at NphiesAutoPollService.Services.NphiesApiClient.SendPollRequestAsync(NphiesCustomer customer, String fhirJson, CancellationToken cancellationToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesApiClient.cs:line 32 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 290 at NphiesAutoPollService.Services.NphiesPollBackgroundService.ExecutePollCycleAsync(CancellationToken stoppingToken) in D:\Projects\Repos\mKamalNitco\nphiesAutoPoll\NphiesAutoPollService\Services\NphiesPollBackgroundService.cs:line 163 |
| 2026-10-10 07:05:18 | Information | Discovered 1 active NPHIES customers |
| 2026-10-10 07:05:18 | Information | Poll cycle "72711d24-1fee-4e2f-ae80-485a390b5f56" starting |
| 2026-10-10 07:02:30 | Information | Poll cycle "6ae13da3-04a1-430b-b481-a9d00cb9b93c" Completed. Customers: 1 |
| 2026-10-10 07:02:30 | Error | Poll failed for Branch 9 (Al-Kholood Medical Company - AlHaj), PollType communication-request [Bundle ce3fbe72-ccfb-4143-a844-9da639a7820d | Request 298250] 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:e1ab02d8-deec-4037-8fdd-94778c45e3cd Error Number:4060,State:1,Class:11 |