2025-07-01 12:24:47.962 +05:30 07e31de8-57e2-4cd9-8b2d-c463702eea53 ERR Login failed for user ''. 2025-07-01 12:24:47.992 +05:30 07e31de8-57e2-4cd9-8b2d-c463702eea53 ERR Token Regeneration failed System.Data.SqlClient.SqlException (0x80131904): Login failed for user ''. at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.WaitForPendingOpen() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.ExecuteProcedureWithResult(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.Authentication.TokenService.RegenerateTokens(String refershToken) at Sang.StockCount.Api.Controllers.TokenController.RegenerateTokens(String refreshToken) ClientConnectionId:829a0713-61fa-4a77-b775-59f1a1d151be Error Number:18456,State:1,Class:14 2025-07-01 13:06:37.607 +05:30 b9bd078f-3abf-4255-9d7e-74550132cecf ERR Error occurred bulk copying into table:t_m_FT011_IMP: System.InvalidOperationException: Column 'sBaseUnit' does not allow DBNull.Value. at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed) at System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col) at System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.BulkCopyForImport(String tableName, DataTable dataTable) 2025-07-01 13:06:37.627 +05:30 b9bd078f-3abf-4255-9d7e-74550132cecf ERR Error occurred during bulk insert for Tag 11. System.InvalidOperationException: Column 'sBaseUnit' does not allow DBNull.Value. at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed) at System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col) at System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.BulkCopyForImport(String tableName, DataTable dataTable) at Sang.StockCount.Api.Repositories.ImportRepository.BulkInsertData(DataTable dataTable, Int32 idOrDocType, String filePath, Boolean isTagImport) 2025-07-01 13:06:37.628 +05:30 b9bd078f-3abf-4255-9d7e-74550132cecf ERR Error occurred performing Tag Import for TagId 11. System.InvalidOperationException: Column 'sBaseUnit' does not allow DBNull.Value. at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed) at System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col) at System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.BulkCopyForImport(String tableName, DataTable dataTable) at Sang.StockCount.Api.Repositories.ImportRepository.BulkInsertData(DataTable dataTable, Int32 idOrDocType, String filePath, Boolean isTagImport) at Sang.StockCount.Api.Repositories.ImportRepository.PerformTagImport(Int32 tagId, String filePath) 2025-07-01 13:06:37.630 +05:30 b9bd078f-3abf-4255-9d7e-74550132cecf ERR Import for tag 11 failed. System.InvalidOperationException: Column 'sBaseUnit' does not allow DBNull.Value. at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed) at System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col) at System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.BulkCopyForImport(String tableName, DataTable dataTable) at Sang.StockCount.Api.Repositories.ImportRepository.BulkInsertData(DataTable dataTable, Int32 idOrDocType, String filePath, Boolean isTagImport) at Sang.StockCount.Api.Repositories.ImportRepository.PerformTagImport(Int32 tagId, String filePath) at Sang.StockCount.Api.Services.ImportExportService.PerformTagImport(Int32 tagId, IFormFile file) at Sang.StockCount.Api.Controllers.ImportExportController.PerformTagImport(Int32 tagId, IFormFile file) 2025-07-01 13:07:25.074 +05:30 744a7d09-5958-4b32-bd2a-dbdd8d94d814 ERR Error occurred bulk copying into table:t_m_FT011_IMP: System.InvalidOperationException: Column 'sBaseUnit' does not allow DBNull.Value. at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed) at System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col) at System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.BulkCopyForImport(String tableName, DataTable dataTable) 2025-07-01 13:07:25.075 +05:30 744a7d09-5958-4b32-bd2a-dbdd8d94d814 ERR Error occurred during bulk insert for Tag 11. System.InvalidOperationException: Column 'sBaseUnit' does not allow DBNull.Value. at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed) at System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col) at System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.BulkCopyForImport(String tableName, DataTable dataTable) at Sang.StockCount.Api.Repositories.ImportRepository.BulkInsertData(DataTable dataTable, Int32 idOrDocType, String filePath, Boolean isTagImport) 2025-07-01 13:07:25.075 +05:30 744a7d09-5958-4b32-bd2a-dbdd8d94d814 ERR Error occurred performing Tag Import for TagId 11. System.InvalidOperationException: Column 'sBaseUnit' does not allow DBNull.Value. at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed) at System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col) at System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.BulkCopyForImport(String tableName, DataTable dataTable) at Sang.StockCount.Api.Repositories.ImportRepository.BulkInsertData(DataTable dataTable, Int32 idOrDocType, String filePath, Boolean isTagImport) at Sang.StockCount.Api.Repositories.ImportRepository.PerformTagImport(Int32 tagId, String filePath) 2025-07-01 13:07:25.076 +05:30 744a7d09-5958-4b32-bd2a-dbdd8d94d814 ERR Import for tag 11 failed. System.InvalidOperationException: Column 'sBaseUnit' does not allow DBNull.Value. at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed) at System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col) at System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.BulkCopyForImport(String tableName, DataTable dataTable) at Sang.StockCount.Api.Repositories.ImportRepository.BulkInsertData(DataTable dataTable, Int32 idOrDocType, String filePath, Boolean isTagImport) at Sang.StockCount.Api.Repositories.ImportRepository.PerformTagImport(Int32 tagId, String filePath) at Sang.StockCount.Api.Services.ImportExportService.PerformTagImport(Int32 tagId, IFormFile file) at Sang.StockCount.Api.Controllers.ImportExportController.PerformTagImport(Int32 tagId, IFormFile file) 2025-07-01 13:57:16.662 +05:30 379203b4-02f5-418e-88ee-87c7f81e83f4 ERR Login failed for user ''. 2025-07-01 13:57:16.681 +05:30 379203b4-02f5-418e-88ee-87c7f81e83f4 ERR Token Regeneration failed System.Data.SqlClient.SqlException (0x80131904): Login failed for user ''. at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.WaitForPendingOpen() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.ExecuteProcedureWithResult(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.Authentication.TokenService.RegenerateTokens(String refershToken) at Sang.StockCount.Api.Controllers.TokenController.RegenerateTokens(String refreshToken) ClientConnectionId:29ebf80f-5102-455c-99be-0b4d0fe7732f Error Number:18456,State:1,Class:14 2025-07-01 14:01:10.731 +05:30 80c130af-cfc6-42c9-8168-4a91bd89a88a ERR Error occurred bulk copying into table:t_m_FT011_IMP: System.InvalidOperationException: Column 'sUnit' does not allow DBNull.Value. at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed) at System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col) at System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.BulkCopyForImport(String tableName, DataTable dataTable) 2025-07-01 14:01:10.734 +05:30 80c130af-cfc6-42c9-8168-4a91bd89a88a ERR Error occurred during bulk insert for Tag 11. System.InvalidOperationException: Column 'sUnit' does not allow DBNull.Value. at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed) at System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col) at System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.BulkCopyForImport(String tableName, DataTable dataTable) at Sang.StockCount.Api.Repositories.ImportRepository.BulkInsertData(DataTable dataTable, Int32 idOrDocType, String filePath, Boolean isTagImport) 2025-07-01 14:01:10.735 +05:30 80c130af-cfc6-42c9-8168-4a91bd89a88a ERR Error occurred performing Tag Import for TagId 11. System.InvalidOperationException: Column 'sUnit' does not allow DBNull.Value. at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed) at System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col) at System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.BulkCopyForImport(String tableName, DataTable dataTable) at Sang.StockCount.Api.Repositories.ImportRepository.BulkInsertData(DataTable dataTable, Int32 idOrDocType, String filePath, Boolean isTagImport) at Sang.StockCount.Api.Repositories.ImportRepository.PerformTagImport(Int32 tagId, String filePath) 2025-07-01 14:01:10.737 +05:30 80c130af-cfc6-42c9-8168-4a91bd89a88a ERR Import for tag 11 failed. System.InvalidOperationException: Column 'sUnit' does not allow DBNull.Value. at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed) at System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col) at System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.BulkCopyForImport(String tableName, DataTable dataTable) at Sang.StockCount.Api.Repositories.ImportRepository.BulkInsertData(DataTable dataTable, Int32 idOrDocType, String filePath, Boolean isTagImport) at Sang.StockCount.Api.Repositories.ImportRepository.PerformTagImport(Int32 tagId, String filePath) at Sang.StockCount.Api.Services.ImportExportService.PerformTagImport(Int32 tagId, IFormFile file) at Sang.StockCount.Api.Controllers.ImportExportController.PerformTagImport(Int32 tagId, IFormFile file) 2025-07-01 14:02:49.670 +05:30 02ad2b00-7d11-42a0-86d5-84d0061249e3 ERR Error occurred bulk copying into table:t_m_FT011_IMP: System.InvalidOperationException: Column 'sUnit' does not allow DBNull.Value. at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed) at System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col) at System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.BulkCopyForImport(String tableName, DataTable dataTable) 2025-07-01 14:02:49.671 +05:30 02ad2b00-7d11-42a0-86d5-84d0061249e3 ERR Error occurred during bulk insert for Tag 11. System.InvalidOperationException: Column 'sUnit' does not allow DBNull.Value. at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed) at System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col) at System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.BulkCopyForImport(String tableName, DataTable dataTable) at Sang.StockCount.Api.Repositories.ImportRepository.BulkInsertData(DataTable dataTable, Int32 idOrDocType, String filePath, Boolean isTagImport) 2025-07-01 14:02:49.672 +05:30 02ad2b00-7d11-42a0-86d5-84d0061249e3 ERR Error occurred performing Tag Import for TagId 11. System.InvalidOperationException: Column 'sUnit' does not allow DBNull.Value. at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed) at System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col) at System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.BulkCopyForImport(String tableName, DataTable dataTable) at Sang.StockCount.Api.Repositories.ImportRepository.BulkInsertData(DataTable dataTable, Int32 idOrDocType, String filePath, Boolean isTagImport) at Sang.StockCount.Api.Repositories.ImportRepository.PerformTagImport(Int32 tagId, String filePath) 2025-07-01 14:02:49.673 +05:30 02ad2b00-7d11-42a0-86d5-84d0061249e3 ERR Import for tag 11 failed. System.InvalidOperationException: Column 'sUnit' does not allow DBNull.Value. at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed) at System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col) at System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.BulkCopyForImport(String tableName, DataTable dataTable) at Sang.StockCount.Api.Repositories.ImportRepository.BulkInsertData(DataTable dataTable, Int32 idOrDocType, String filePath, Boolean isTagImport) at Sang.StockCount.Api.Repositories.ImportRepository.PerformTagImport(Int32 tagId, String filePath) at Sang.StockCount.Api.Services.ImportExportService.PerformTagImport(Int32 tagId, IFormFile file) at Sang.StockCount.Api.Controllers.ImportExportController.PerformTagImport(Int32 tagId, IFormFile file) 2025-07-01 14:03:50.686 +05:30 19589ca8-25df-42f5-9362-ae6dcffc5494 ERR Error occurred bulk copying into table:t_m_FT011_IMP: System.InvalidOperationException: Column 'sUnit' does not allow DBNull.Value. at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed) at System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col) at System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.BulkCopyForImport(String tableName, DataTable dataTable) 2025-07-01 14:03:50.687 +05:30 19589ca8-25df-42f5-9362-ae6dcffc5494 ERR Error occurred during bulk insert for Tag 11. System.InvalidOperationException: Column 'sUnit' does not allow DBNull.Value. at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed) at System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col) at System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.BulkCopyForImport(String tableName, DataTable dataTable) at Sang.StockCount.Api.Repositories.ImportRepository.BulkInsertData(DataTable dataTable, Int32 idOrDocType, String filePath, Boolean isTagImport) 2025-07-01 14:03:50.687 +05:30 19589ca8-25df-42f5-9362-ae6dcffc5494 ERR Error occurred performing Tag Import for TagId 11. System.InvalidOperationException: Column 'sUnit' does not allow DBNull.Value. at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed) at System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col) at System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.BulkCopyForImport(String tableName, DataTable dataTable) at Sang.StockCount.Api.Repositories.ImportRepository.BulkInsertData(DataTable dataTable, Int32 idOrDocType, String filePath, Boolean isTagImport) at Sang.StockCount.Api.Repositories.ImportRepository.PerformTagImport(Int32 tagId, String filePath) 2025-07-01 14:03:50.688 +05:30 19589ca8-25df-42f5-9362-ae6dcffc5494 ERR Import for tag 11 failed. System.InvalidOperationException: Column 'sUnit' does not allow DBNull.Value. at System.Data.SqlClient.SqlBulkCopy.ConvertValue(Object value, _SqlMetaData metadata, Boolean isNull, Boolean& isSqlType, Boolean& coercedToDataFeed) at System.Data.SqlClient.SqlBulkCopy.ReadWriteColumnValueAsync(Int32 col) at System.Data.SqlClient.SqlBulkCopy.CopyColumnsAsync(Int32 col, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyRowsAsync(Int32 rowsSoFar, Int32 totalRows, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsyncContinued(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.CopyBatchesAsync(BulkCopySimpleResultSet internalResults, String updateBulkCommandText, CancellationToken cts, TaskCompletionSource`1 source) at System.Data.SqlClient.SqlBulkCopy.WriteToServerInternalRestContinuedAsync(BulkCopySimpleResultSet internalResults, CancellationToken cts, TaskCompletionSource`1 source) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.BulkCopyForImport(String tableName, DataTable dataTable) at Sang.StockCount.Api.Repositories.ImportRepository.BulkInsertData(DataTable dataTable, Int32 idOrDocType, String filePath, Boolean isTagImport) at Sang.StockCount.Api.Repositories.ImportRepository.PerformTagImport(Int32 tagId, String filePath) at Sang.StockCount.Api.Services.ImportExportService.PerformTagImport(Int32 tagId, IFormFile file) at Sang.StockCount.Api.Controllers.ImportExportController.PerformTagImport(Int32 tagId, IFormFile file) 2025-07-01 14:09:06.574 +05:30 58b4c855-7f11-4b05-bf09-37c99578e498 ERR Error occurred while excecuting procedure:xsp_m_FT011_GS: System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (258): The wait operation timed out. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning(Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, String endMethod) at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult) at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) ClientConnectionId:66eb4654-1913-4c81-aef5-d0e972f1f819 Error Number:-2,State:0,Class:11 2025-07-01 14:09:06.576 +05:30 58b4c855-7f11-4b05-bf09-37c99578e498 ERR Error getting Summary for tagId 11. System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (258): The wait operation timed out. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning(Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, String endMethod) at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult) at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.StockCount.Api.Repositories.TagRepository.GetTagSummary(Int32 tagId) ClientConnectionId:66eb4654-1913-4c81-aef5-d0e972f1f819 Error Number:-2,State:0,Class:11 2025-07-01 14:09:06.578 +05:30 58b4c855-7f11-4b05-bf09-37c99578e498 ERR Error Getting TagList11 from database System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (258): The wait operation timed out. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning(Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, String endMethod) at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult) at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.StockCount.Api.Repositories.TagRepository.GetTagSummary(Int32 tagId) at Sang.StockCount.Api.Services.TagService.<>c__DisplayClass16_0.<b__1>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecute[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, Int32 groupId, String searchString) ClientConnectionId:66eb4654-1913-4c81-aef5-d0e972f1f819 Error Number:-2,State:0,Class:11 2025-07-01 14:09:06.580 +05:30 58b4c855-7f11-4b05-bf09-37c99578e498 ERR SQL Exception occurred for TagId 11. System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (258): The wait operation timed out. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning(Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, String endMethod) at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult) at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.StockCount.Api.Repositories.TagRepository.GetTagSummary(Int32 tagId) at Sang.StockCount.Api.Services.TagService.<>c__DisplayClass16_0.<b__1>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecute[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, Int32 groupId, String searchString) at Sang.StockCount.Api.Services.TagService.GetTagSummary(TagSummaryRequest summaryRequest) at Sang.StockCount.Api.Controllers.TagController.GetTagSummary(TagSummaryRequest summaryRequest) ClientConnectionId:66eb4654-1913-4c81-aef5-d0e972f1f819 Error Number:-2,State:0,Class:11 2025-07-01 14:09:26.639 +05:30 9e73ade2-2357-4055-b208-5ee24b53cca5 ERR Error occurred while excecuting procedure:xsp_m_FT011_GS: System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (258): The wait operation timed out. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning(Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, String endMethod) at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult) at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) ClientConnectionId:1a4a2207-4467-4865-bbd5-ce3d2a98c2c3 Error Number:-2,State:0,Class:11 2025-07-01 14:09:26.640 +05:30 9e73ade2-2357-4055-b208-5ee24b53cca5 ERR Error getting Summary for tagId 11. System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (258): The wait operation timed out. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning(Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, String endMethod) at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult) at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.StockCount.Api.Repositories.TagRepository.GetTagSummary(Int32 tagId) ClientConnectionId:1a4a2207-4467-4865-bbd5-ce3d2a98c2c3 Error Number:-2,State:0,Class:11 2025-07-01 14:09:26.642 +05:30 9e73ade2-2357-4055-b208-5ee24b53cca5 ERR Error Getting TagList11 from database System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (258): The wait operation timed out. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning(Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, String endMethod) at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult) at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.StockCount.Api.Repositories.TagRepository.GetTagSummary(Int32 tagId) at Sang.StockCount.Api.Services.TagService.<>c__DisplayClass16_0.<b__1>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecute[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, Int32 groupId, String searchString) ClientConnectionId:1a4a2207-4467-4865-bbd5-ce3d2a98c2c3 Error Number:-2,State:0,Class:11 2025-07-01 14:09:26.643 +05:30 9e73ade2-2357-4055-b208-5ee24b53cca5 ERR SQL Exception occurred for TagId 11. System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (258): The wait operation timed out. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning(Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, String endMethod) at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult) at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.StockCount.Api.Repositories.TagRepository.GetTagSummary(Int32 tagId) at Sang.StockCount.Api.Services.TagService.<>c__DisplayClass16_0.<b__1>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecute[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, Int32 groupId, String searchString) at Sang.StockCount.Api.Services.TagService.GetTagSummary(TagSummaryRequest summaryRequest) at Sang.StockCount.Api.Controllers.TagController.GetTagSummary(TagSummaryRequest summaryRequest) ClientConnectionId:1a4a2207-4467-4865-bbd5-ce3d2a98c2c3 Error Number:-2,State:0,Class:11 2025-07-01 14:09:51.751 +05:30 c8d43d72-af5e-4668-bb66-91222ad6770f ERR Error occurred while excecuting procedure:xsp_m_FT011_GS: System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (258): The wait operation timed out. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning(Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, String endMethod) at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult) at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) ClientConnectionId:66eb4654-1913-4c81-aef5-d0e972f1f819 Error Number:-2,State:0,Class:11 2025-07-01 14:09:51.752 +05:30 c8d43d72-af5e-4668-bb66-91222ad6770f ERR Error getting Summary for tagId 11. System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (258): The wait operation timed out. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning(Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, String endMethod) at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult) at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.StockCount.Api.Repositories.TagRepository.GetTagSummary(Int32 tagId) ClientConnectionId:66eb4654-1913-4c81-aef5-d0e972f1f819 Error Number:-2,State:0,Class:11 2025-07-01 14:09:51.754 +05:30 c8d43d72-af5e-4668-bb66-91222ad6770f ERR Error Getting TagList11 from database System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (258): The wait operation timed out. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning(Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, String endMethod) at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult) at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.StockCount.Api.Repositories.TagRepository.GetTagSummary(Int32 tagId) at Sang.StockCount.Api.Services.TagService.<>c__DisplayClass16_0.<b__1>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecute[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, Int32 groupId, String searchString) ClientConnectionId:66eb4654-1913-4c81-aef5-d0e972f1f819 Error Number:-2,State:0,Class:11 2025-07-01 14:09:51.755 +05:30 c8d43d72-af5e-4668-bb66-91222ad6770f ERR SQL Exception occurred for TagId 11. System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (258): The wait operation timed out. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning(Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, String endMethod) at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult) at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.StockCount.Api.Repositories.TagRepository.GetTagSummary(Int32 tagId) at Sang.StockCount.Api.Services.TagService.<>c__DisplayClass16_0.<b__1>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecute[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, Int32 groupId, String searchString) at Sang.StockCount.Api.Services.TagService.GetTagSummary(TagSummaryRequest summaryRequest) at Sang.StockCount.Api.Controllers.TagController.GetTagSummary(TagSummaryRequest summaryRequest) ClientConnectionId:66eb4654-1913-4c81-aef5-d0e972f1f819 Error Number:-2,State:0,Class:11 2025-07-01 14:10:11.797 +05:30 f9e7c5af-708a-4f86-a7c4-704cc274d071 ERR Error occurred while excecuting procedure:xsp_m_FT011_GS: System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (258): The wait operation timed out. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning(Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, String endMethod) at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult) at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) ClientConnectionId:1a4a2207-4467-4865-bbd5-ce3d2a98c2c3 Error Number:-2,State:0,Class:11 2025-07-01 14:10:11.799 +05:30 f9e7c5af-708a-4f86-a7c4-704cc274d071 ERR Error getting Summary for tagId 11. System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (258): The wait operation timed out. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning(Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, String endMethod) at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult) at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.StockCount.Api.Repositories.TagRepository.GetTagSummary(Int32 tagId) ClientConnectionId:1a4a2207-4467-4865-bbd5-ce3d2a98c2c3 Error Number:-2,State:0,Class:11 2025-07-01 14:10:11.801 +05:30 f9e7c5af-708a-4f86-a7c4-704cc274d071 ERR Error Getting TagList11 from database System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (258): The wait operation timed out. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning(Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, String endMethod) at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult) at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.StockCount.Api.Repositories.TagRepository.GetTagSummary(Int32 tagId) at Sang.StockCount.Api.Services.TagService.<>c__DisplayClass16_0.<b__1>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecute[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, Int32 groupId, String searchString) ClientConnectionId:1a4a2207-4467-4865-bbd5-ce3d2a98c2c3 Error Number:-2,State:0,Class:11 2025-07-01 14:10:11.803 +05:30 f9e7c5af-708a-4f86-a7c4-704cc274d071 ERR SQL Exception occurred for TagId 11. System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. ---> System.ComponentModel.Win32Exception (258): The wait operation timed out. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.ThrowExceptionAndWarning(Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParserStateObject.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.CheckThrowSNIException() at System.Data.SqlClient.SqlCommand.InternalEndExecuteReader(IAsyncResult asyncResult, String endMethod) at System.Data.SqlClient.SqlCommand.EndExecuteReaderInternal(IAsyncResult asyncResult) at System.Data.SqlClient.SqlCommand.EndExecuteReader(IAsyncResult asyncResult) at System.Threading.Tasks.TaskFactory`1.FromAsyncCoreLogic(IAsyncResult iar, Func`2 endFunction, Action`1 endAction, Task`1 promise, Boolean requiresSynchronization) --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.Service.Common.CommonService.CommonEntityService.FetchDataTableFromProcedure(String procedureName, SqlParameter[] parameters) at Sang.StockCount.Api.Repositories.TagRepository.GetTagSummary(Int32 tagId) at Sang.StockCount.Api.Services.TagService.<>c__DisplayClass16_0.<b__1>d.MoveNext() --- End of stack trace from previous location --- at Sang.Service.Common.CommonService.MemoryRequestCache.GetOrExecute[T](String key, Func`1 action, Int32 pageNumber, Int32 pageSize, Int32 cacheEntryLifeTime, String column, Int32 groupId, String searchString) at Sang.StockCount.Api.Services.TagService.GetTagSummary(TagSummaryRequest summaryRequest) at Sang.StockCount.Api.Controllers.TagController.GetTagSummary(TagSummaryRequest summaryRequest) ClientConnectionId:1a4a2207-4467-4865-bbd5-ce3d2a98c2c3 Error Number:-2,State:0,Class:11