2022-02-11T10:44:11.2769449+00:00 [ERR] Failed executing DbCommand ("6"ms) [Parameters=["@__companyGuid_0='?' (DbType = Guid), @__MasterCompanyId_1='?' (DbType = Int64), @__MasterCompanyId_2='?' (DbType = Int64)"], CommandType='Text', CommandTimeout='30']" ""SELECT c.\"CompanyId\" FROM \"Company\" AS c WHERE ((c.\"CompanyGuid\" = @__companyGuid_0) AND ((c.\"CompanyId\" = @__MasterCompanyId_1) OR (c.\"MasterCompanyId\" = @__MasterCompanyId_2))) AND NOT (c.\"IsDeleted\") LIMIT 1" 2022-02-11T10:44:11.2946870+00:00 [ERR] An exception occurred while iterating over the results of a query for context type '"WebX.TLC.DataAccessObjects.TLCDatabaseContext"'." ""Npgsql.PostgresException (0x80004005): 57P01: terminating connection due to administrator command at Npgsql.NpgsqlConnector.g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult() at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.MoveNext() Exception data: Severity: FATAL SqlState: 57P01 MessageText: terminating connection due to administrator command File: postgres.c Line: 3193 Routine: ProcessInterrupts" Npgsql.PostgresException (0x80004005): 57P01: terminating connection due to administrator command at Npgsql.NpgsqlConnector.g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult() at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.MoveNext() Exception data: Severity: FATAL SqlState: 57P01 MessageText: terminating connection due to administrator command File: postgres.c Line: 3193 Routine: ProcessInterrupts 2022-02-11T10:44:11.2959587+00:00 [ERR] Object reference not set to an instance of an object. System.NullReferenceException: Object reference not set to an instance of an object. at WebX.TLC.BusinessObjects.Base.GetCompanyId(Nullable`1 companyGuid) in C:\Users\Administrator\Documents\Dev\TreasuryLiveConnect\Libraries\WebX.TLC.BusinessObjects\Base.cs:line 519 at WebX.TLC.BusinessObjects.TransactionBO.SaveForward(Forward model) in C:\Users\Administrator\Documents\Dev\TreasuryLiveConnect\Libraries\WebX.TLC.BusinessObjects\TransactionBO.cs:line 813 at WebX.TLC.Web.API.Controllers.TransactionController.SaveForward(Forward model) in C:\Users\Administrator\Documents\Dev\TreasuryLiveConnect\API\WebX.TLC.Web.API\Controllers\TransactionController.cs:line 214 at lambda_method11703(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2022-02-11T10:44:18.9013151+00:00 [ERR] Failed executing DbCommand ("1"ms) [Parameters=["@__companyGuid_0='?' (DbType = Guid), @__MasterCompanyId_1='?' (DbType = Int64), @__MasterCompanyId_2='?' (DbType = Int64)"], CommandType='Text', CommandTimeout='30']" ""SELECT c.\"CompanyId\" FROM \"Company\" AS c WHERE ((c.\"CompanyGuid\" = @__companyGuid_0) AND ((c.\"CompanyId\" = @__MasterCompanyId_1) OR (c.\"MasterCompanyId\" = @__MasterCompanyId_2))) AND NOT (c.\"IsDeleted\") LIMIT 1" 2022-02-11T10:44:18.9023673+00:00 [ERR] An exception occurred while iterating over the results of a query for context type '"WebX.TLC.DataAccessObjects.TLCDatabaseContext"'." ""Npgsql.PostgresException (0x80004005): 57P01: terminating connection due to administrator command at Npgsql.NpgsqlConnector.g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult() at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.MoveNext() Exception data: Severity: FATAL SqlState: 57P01 MessageText: terminating connection due to administrator command File: postgres.c Line: 3193 Routine: ProcessInterrupts" Npgsql.PostgresException (0x80004005): 57P01: terminating connection due to administrator command at Npgsql.NpgsqlConnector.g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult() at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.MoveNext() Exception data: Severity: FATAL SqlState: 57P01 MessageText: terminating connection due to administrator command File: postgres.c Line: 3193 Routine: ProcessInterrupts 2022-02-11T10:44:18.9034804+00:00 [ERR] Object reference not set to an instance of an object. System.NullReferenceException: Object reference not set to an instance of an object. at WebX.TLC.BusinessObjects.Base.GetCompanyId(Nullable`1 companyGuid) in C:\Users\Administrator\Documents\Dev\TreasuryLiveConnect\Libraries\WebX.TLC.BusinessObjects\Base.cs:line 519 at WebX.TLC.BusinessObjects.TransactionBO.SaveForward(Forward model) in C:\Users\Administrator\Documents\Dev\TreasuryLiveConnect\Libraries\WebX.TLC.BusinessObjects\TransactionBO.cs:line 813 at WebX.TLC.Web.API.Controllers.TransactionController.SaveForward(Forward model) in C:\Users\Administrator\Documents\Dev\TreasuryLiveConnect\API\WebX.TLC.Web.API\Controllers\TransactionController.cs:line 214 at lambda_method11703(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2022-02-11T10:44:40.3031691+00:00 [ERR] Failed executing DbCommand ("1"ms) [Parameters=["@__companyGuid_0='?' (DbType = Guid), @__MasterCompanyId_1='?' (DbType = Int64), @__MasterCompanyId_2='?' (DbType = Int64)"], CommandType='Text', CommandTimeout='30']" ""SELECT c.\"CompanyId\" FROM \"Company\" AS c WHERE ((c.\"CompanyGuid\" = @__companyGuid_0) AND ((c.\"CompanyId\" = @__MasterCompanyId_1) OR (c.\"MasterCompanyId\" = @__MasterCompanyId_2))) AND NOT (c.\"IsDeleted\") LIMIT 1" 2022-02-11T10:44:40.3043710+00:00 [ERR] An exception occurred while iterating over the results of a query for context type '"WebX.TLC.DataAccessObjects.TLCDatabaseContext"'." ""Npgsql.PostgresException (0x80004005): 57P01: terminating connection due to administrator command at Npgsql.NpgsqlConnector.g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult() at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.MoveNext() Exception data: Severity: FATAL SqlState: 57P01 MessageText: terminating connection due to administrator command File: postgres.c Line: 3193 Routine: ProcessInterrupts" Npgsql.PostgresException (0x80004005): 57P01: terminating connection due to administrator command at Npgsql.NpgsqlConnector.g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult() at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.MoveNext() Exception data: Severity: FATAL SqlState: 57P01 MessageText: terminating connection due to administrator command File: postgres.c Line: 3193 Routine: ProcessInterrupts 2022-02-11T10:44:40.3055088+00:00 [ERR] Object reference not set to an instance of an object. System.NullReferenceException: Object reference not set to an instance of an object. at WebX.TLC.BusinessObjects.Base.GetCompanyId(Nullable`1 companyGuid) in C:\Users\Administrator\Documents\Dev\TreasuryLiveConnect\Libraries\WebX.TLC.BusinessObjects\Base.cs:line 519 at WebX.TLC.BusinessObjects.TransactionBO.SaveForward(Forward model) in C:\Users\Administrator\Documents\Dev\TreasuryLiveConnect\Libraries\WebX.TLC.BusinessObjects\TransactionBO.cs:line 813 at WebX.TLC.Web.API.Controllers.TransactionController.SaveForward(Forward model) in C:\Users\Administrator\Documents\Dev\TreasuryLiveConnect\API\WebX.TLC.Web.API\Controllers\TransactionController.cs:line 214 at lambda_method11703(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2022-02-11T10:44:45.3961563+00:00 [ERR] Failed executing DbCommand ("1"ms) [Parameters=["@__MasterCompanyId_0='?' (DbType = Int64), @__forwardType_1='?' (DbType = Int32), @__request_CompanyGuid_2='?' (DbType = Guid)"], CommandType='Text', CommandTimeout='30']" ""SELECT f.\"ForwardId\", f.\"AutoPremiumValue\", f.\"AutoSpotRate\", f.\"BankId\", f.\"BankMargin\", f.\"CompanyId\", f.\"ContractCategory\", f.\"ContractNo\", f.\"ContractType\", f.\"ConversionValue\", f.\"CreatedById\", f.\"CreatedTimestamp\", f.\"DateofBooking\", f.\"DeliveryEndDate\", f.\"DeliveryStartDate\", f.\"ForwardGuid\", f.\"ForwardNo\", f.\"ForwardType\", f.\"FromCurrencyId\", f.\"HedgeValue\", f.\"IsDeleted\", f.\"MTMValue\", f.\"MasterCompanyId\", f.\"NetRate\", f.\"OrderId\", f.\"OrderReference\", f.\"PremiumValue\", f.\"RateDownside\", f.\"RateUpside\", f.\"Remarks\", f.\"SpotRate\", f.\"Status\", f.\"Strike\", f.\"Term\", f.\"ToCurrencyId\", f.\"TodaysForwardRate\", f.\"TradeType\", f.\"UpdatedById\", f.\"UpdatedTimestamp\", c.\"CompanyId\", c.\"CINNumber\", c.\"CompanyGuid\", c.\"CompanyName\", c.\"ContactId\", c.\"CreatedById\", c.\"CreatedTimestamp\", c.\"CurrencyId\", c.\"DGFTRegistrationNo\", c.\"ExpiresOn\", c.\"ExportLicensee\", c.\"ImportLicensee\", c.\"IsDeleted\", c.\"IsMaster\", c.\"MasterCompanyId\", c.\"Remarks\", c.\"UpdatedById\", c.\"UpdatedTimestamp\", o.\"OrderId\", o.\"BLDate\", o.\"BenchmarkCost\", o.\"ClientId\", o.\"CompanyId\", o.\"CreatedById\", o.\"CreatedTimestamp\", o.\"CreditPeriod\", o.\"CurrencyId\", o.\"DivisionId\", o.\"ExpectedRemittanceDate\", o.\"ExpectedShipmentDate\", o.\"InflowEntity\", o.\"InvoiceNumber\", o.\"IsDeleted\", o.\"MarketingUserId\", o.\"MasterCompanyId\", o.\"NetRate\", o.\"OrderDate\", o.\"OrderGuid\", o.\"OrderNo\", o.\"OrderReference\", o.\"OrderType\", o.\"PremiumValue\", o.\"ProductId\", o.\"Remarks\", o.\"SalesFC\", o.\"SpotBenchmarkRate\", o.\"Status\", o.\"UpdatedById\", o.\"UpdatedTimestamp\", b.\"BankId\", b.\"AccountNo\", b.\"AccountType\", b.\"AddressId\", b.\"BankGuid\", b.\"BankName\", b.\"BranchCode\", b.\"BranchManager\", b.\"CompanyId\", b.\"CreatedById\", b.\"CreatedTimestamp\", b.\"DomesticWorkingCapitalLimit\", b.\"ExportsPostshipmentLimit\", b.\"ExportsPreshipmentLimit\", b.\"ForwardLimit\", b.\"HSCode\", b.\"ImportBorrowingLimit\", b.\"IsDeleted\", b.\"LERLimit\", b.\"LimitSanctionedFrom\", b.\"LimitSanctionedTo\", b.\"MasterCompanyId\", b.\"RM\", b.\"Remarks\", b.\"TreasuryDesk\", b.\"UpdatedById\", b.\"UpdatedTimestamp\", c0.\"CurrencyId\", c0.\"CurrencyCode\", c0.\"CurrencySymbol\", c0.\"CurrencyTitle\", c0.\"CurrencyType\", c0.\"IsActive\", c1.\"CurrencyId\", c1.\"CurrencyCode\", c1.\"CurrencySymbol\", c1.\"CurrencyTitle\", c1.\"CurrencyType\", c1.\"IsActive\" FROM \"Forward\" AS f INNER JOIN \"Company\" AS c ON f.\"CompanyId\" = c.\"CompanyId\" LEFT JOIN \"Order\" AS o ON f.\"OrderId\" = o.\"OrderId\" INNER JOIN \"Bank\" AS b ON f.\"BankId\" = b.\"BankId\" LEFT JOIN \"Currency\" AS c0 ON f.\"FromCurrencyId\" = c0.\"CurrencyId\" LEFT JOIN \"Currency\" AS c1 ON f.\"ToCurrencyId\" = c1.\"CurrencyId\" WHERE (((f.\"MasterCompanyId\" = @__MasterCompanyId_0) AND (f.\"ForwardType\" = @__forwardType_1)) AND (c.\"CompanyGuid\" = @__request_CompanyGuid_2)) AND NOT (f.\"IsDeleted\") ORDER BY f.\"CreatedTimestamp\"" 2022-02-11T10:44:45.3973483+00:00 [ERR] An exception occurred while iterating over the results of a query for context type '"WebX.TLC.DataAccessObjects.TLCDatabaseContext"'." ""Npgsql.PostgresException (0x80004005): 57P01: terminating connection due to administrator command at Npgsql.NpgsqlConnector.g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult() at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.MoveNext() Exception data: Severity: FATAL SqlState: 57P01 MessageText: terminating connection due to administrator command File: postgres.c Line: 3193 Routine: ProcessInterrupts" Npgsql.PostgresException (0x80004005): 57P01: terminating connection due to administrator command at Npgsql.NpgsqlConnector.g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult() at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.MoveNext() Exception data: Severity: FATAL SqlState: 57P01 MessageText: terminating connection due to administrator command File: postgres.c Line: 3193 Routine: ProcessInterrupts 2022-02-11T10:44:45.3984654+00:00 [ERR] Object reference not set to an instance of an object. System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.Dispose() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at WebX.TLC.BusinessObjects.TransactionBO.GetForwards(Nullable`1 forwardType, TableRequest request) in C:\Users\Administrator\Documents\Dev\TreasuryLiveConnect\Libraries\WebX.TLC.BusinessObjects\TransactionBO.cs:line 501 at WebX.TLC.Web.API.Controllers.TransactionController.GetForwards(Nullable`1 forwardType, TableRequest request) in C:\Users\Administrator\Documents\Dev\TreasuryLiveConnect\API\WebX.TLC.Web.API\Controllers\TransactionController.cs:line 165 at lambda_method9853(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2022-02-11T10:44:50.7074118+00:00 [ERR] Failed executing DbCommand ("1"ms) [Parameters=["@__MasterCompanyId_0='?' (DbType = Int64), @__MasterCompanyId_1='?' (DbType = Int64)"], CommandType='Text', CommandTimeout='30']" ""SELECT c.\"CompanyGuid\", c.\"CompanyName\", c0.\"CurrencyId\", c0.\"CurrencyCode\", c0.\"CurrencySymbol\" FROM \"Company\" AS c INNER JOIN \"Currency\" AS c0 ON c.\"CurrencyId\" = c0.\"CurrencyId\" LEFT JOIN \"UserCompany\" AS u ON c.\"CompanyId\" = u.\"CompanyId\" WHERE (c.\"CompanyId\" = @__MasterCompanyId_0) OR (c.\"MasterCompanyId\" = @__MasterCompanyId_1)" 2022-02-11T10:44:50.7085419+00:00 [ERR] An exception occurred while iterating over the results of a query for context type '"WebX.TLC.DataAccessObjects.TLCDatabaseContext"'." ""Npgsql.PostgresException (0x80004005): 57P01: terminating connection due to administrator command at Npgsql.NpgsqlConnector.g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult() at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.MoveNext() Exception data: Severity: FATAL SqlState: 57P01 MessageText: terminating connection due to administrator command File: postgres.c Line: 3193 Routine: ProcessInterrupts" Npgsql.PostgresException (0x80004005): 57P01: terminating connection due to administrator command at Npgsql.NpgsqlConnector.g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult() at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.MoveNext() Exception data: Severity: FATAL SqlState: 57P01 MessageText: terminating connection due to administrator command File: postgres.c Line: 3193 Routine: ProcessInterrupts 2022-02-11T10:44:50.7096711+00:00 [ERR] Object reference not set to an instance of an object. System.NullReferenceException: Object reference not set to an instance of an object. at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.Dispose() at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection) at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source) at WebX.TLC.BusinessObjects.TransactionBO.GetCompanyList() in C:\Users\Administrator\Documents\Dev\TreasuryLiveConnect\Libraries\WebX.TLC.BusinessObjects\TransactionBO.cs:line 34 at WebX.TLC.Web.API.Controllers.TransactionController.GetCompanyList() in C:\Users\Administrator\Documents\Dev\TreasuryLiveConnect\API\WebX.TLC.Web.API\Controllers\TransactionController.cs:line 35 at lambda_method13(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2022-02-11T10:44:56.0758011+00:00 [ERR] Failed executing DbCommand ("1"ms) [Parameters=["@__MasterCompanyId_0='?' (DbType = Int64)"], CommandType='Text', CommandTimeout='30']" ""SELECT b.\"BankId\", b.\"AccountNo\", b.\"AccountType\", b.\"AddressId\", b.\"BankGuid\", b.\"BankName\", b.\"BranchCode\", b.\"BranchManager\", b.\"CompanyId\", b.\"CreatedById\", b.\"CreatedTimestamp\", b.\"DomesticWorkingCapitalLimit\", b.\"ExportsPostshipmentLimit\", b.\"ExportsPreshipmentLimit\", b.\"ForwardLimit\", b.\"HSCode\", b.\"ImportBorrowingLimit\", b.\"IsDeleted\", b.\"LERLimit\", b.\"LimitSanctionedFrom\", b.\"LimitSanctionedTo\", b.\"MasterCompanyId\", b.\"RM\", b.\"Remarks\", b.\"TreasuryDesk\", b.\"UpdatedById\", b.\"UpdatedTimestamp\", c.\"CompanyId\", c.\"CINNumber\", c.\"CompanyGuid\", c.\"CompanyName\", c.\"ContactId\", c.\"CreatedById\", c.\"CreatedTimestamp\", c.\"CurrencyId\", c.\"DGFTRegistrationNo\", c.\"ExpiresOn\", c.\"ExportLicensee\", c.\"ImportLicensee\", c.\"IsDeleted\", c.\"IsMaster\", c.\"MasterCompanyId\", c.\"Remarks\", c.\"UpdatedById\", c.\"UpdatedTimestamp\", a.\"AddressId\", a.\"AddressGuid\", a.\"AddressLine1\", a.\"AddressLine2\", a.\"AddressLine3\", a.\"AddressName\", a.\"AddressType\", a.\"City\", a.\"CountryId\", a.\"CreatedById\", a.\"CreatedTimestamp\", a.\"IsDeleted\", a.\"PostCode\", a.\"Region\", a.\"Remarks\", a.\"UpdatedById\", a.\"UpdatedTimestamp\" FROM \"Bank\" AS b LEFT JOIN \"Company\" AS c ON b.\"CompanyId\" = c.\"CompanyId\" INNER JOIN \"Address\" AS a ON b.\"AddressId\" = a.\"AddressId\" WHERE (b.\"MasterCompanyId\" = @__MasterCompanyId_0) AND NOT (b.\"IsDeleted\")" 2022-02-11T10:44:56.0769211+00:00 [ERR] An exception occurred while iterating over the results of a query for context type '"WebX.TLC.DataAccessObjects.TLCDatabaseContext"'." ""Npgsql.PostgresException (0x80004005): 57P01: terminating connection due to administrator command at Npgsql.NpgsqlConnector.g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult() at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.MoveNext() Exception data: Severity: FATAL SqlState: 57P01 MessageText: terminating connection due to administrator command File: postgres.c Line: 3193 Routine: ProcessInterrupts" Npgsql.PostgresException (0x80004005): 57P01: terminating connection due to administrator command at Npgsql.NpgsqlConnector.g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult() at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.MoveNext() Exception data: Severity: FATAL SqlState: 57P01 MessageText: terminating connection due to administrator command File: postgres.c Line: 3193 Routine: ProcessInterrupts 2022-02-11T10:44:56.0779711+00:00 [ERR] Object reference not set to an instance of an object. System.NullReferenceException: Object reference not set to an instance of an object. at WebX.TLC.BusinessObjects.AdminBO.GetBanks() in C:\Users\Administrator\Documents\Dev\TreasuryLiveConnect\Libraries\WebX.TLC.BusinessObjects\AdminBO.cs:line 1762 at WebX.TLC.Web.API.Controllers.AdminController.GetBanks(DataTableRequest request) in C:\Users\Administrator\Documents\Dev\TreasuryLiveConnect\API\WebX.TLC.Web.API\Controllers\AdminController.cs:line 463 at lambda_method15655(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2022-02-11T10:45:00.9757913+00:00 [ERR] Failed executing DbCommand ("1"ms) [Parameters=["@__MasterCompanyId_0='?' (DbType = Int64)"], CommandType='Text', CommandTimeout='30']" ""SELECT b.\"BankId\", b.\"AccountNo\", b.\"AccountType\", b.\"AddressId\", b.\"BankGuid\", b.\"BankName\", b.\"BranchCode\", b.\"BranchManager\", b.\"CompanyId\", b.\"CreatedById\", b.\"CreatedTimestamp\", b.\"DomesticWorkingCapitalLimit\", b.\"ExportsPostshipmentLimit\", b.\"ExportsPreshipmentLimit\", b.\"ForwardLimit\", b.\"HSCode\", b.\"ImportBorrowingLimit\", b.\"IsDeleted\", b.\"LERLimit\", b.\"LimitSanctionedFrom\", b.\"LimitSanctionedTo\", b.\"MasterCompanyId\", b.\"RM\", b.\"Remarks\", b.\"TreasuryDesk\", b.\"UpdatedById\", b.\"UpdatedTimestamp\", c.\"CompanyId\", c.\"CINNumber\", c.\"CompanyGuid\", c.\"CompanyName\", c.\"ContactId\", c.\"CreatedById\", c.\"CreatedTimestamp\", c.\"CurrencyId\", c.\"DGFTRegistrationNo\", c.\"ExpiresOn\", c.\"ExportLicensee\", c.\"ImportLicensee\", c.\"IsDeleted\", c.\"IsMaster\", c.\"MasterCompanyId\", c.\"Remarks\", c.\"UpdatedById\", c.\"UpdatedTimestamp\", a.\"AddressId\", a.\"AddressGuid\", a.\"AddressLine1\", a.\"AddressLine2\", a.\"AddressLine3\", a.\"AddressName\", a.\"AddressType\", a.\"City\", a.\"CountryId\", a.\"CreatedById\", a.\"CreatedTimestamp\", a.\"IsDeleted\", a.\"PostCode\", a.\"Region\", a.\"Remarks\", a.\"UpdatedById\", a.\"UpdatedTimestamp\" FROM \"Bank\" AS b LEFT JOIN \"Company\" AS c ON b.\"CompanyId\" = c.\"CompanyId\" INNER JOIN \"Address\" AS a ON b.\"AddressId\" = a.\"AddressId\" WHERE (b.\"MasterCompanyId\" = @__MasterCompanyId_0) AND NOT (b.\"IsDeleted\")" 2022-02-11T10:45:00.9768298+00:00 [ERR] An exception occurred while iterating over the results of a query for context type '"WebX.TLC.DataAccessObjects.TLCDatabaseContext"'." ""Npgsql.PostgresException (0x80004005): 57P01: terminating connection due to administrator command at Npgsql.NpgsqlConnector.g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult() at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.MoveNext() Exception data: Severity: FATAL SqlState: 57P01 MessageText: terminating connection due to administrator command File: postgres.c Line: 3193 Routine: ProcessInterrupts" Npgsql.PostgresException (0x80004005): 57P01: terminating connection due to administrator command at Npgsql.NpgsqlConnector.g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult() at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.MoveNext() Exception data: Severity: FATAL SqlState: 57P01 MessageText: terminating connection due to administrator command File: postgres.c Line: 3193 Routine: ProcessInterrupts 2022-02-11T10:45:00.9778948+00:00 [ERR] Object reference not set to an instance of an object. System.NullReferenceException: Object reference not set to an instance of an object. at WebX.TLC.BusinessObjects.AdminBO.GetBanks() in C:\Users\Administrator\Documents\Dev\TreasuryLiveConnect\Libraries\WebX.TLC.BusinessObjects\AdminBO.cs:line 1762 at WebX.TLC.Web.API.Controllers.AdminController.GetBanks(DataTableRequest request) in C:\Users\Administrator\Documents\Dev\TreasuryLiveConnect\API\WebX.TLC.Web.API\Controllers\AdminController.cs:line 463 at lambda_method15655(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) 2022-02-11T10:45:07.8180808+00:00 [ERR] Failed executing DbCommand ("1"ms) [Parameters=["@__MasterCompanyId_0='?' (DbType = Int64)"], CommandType='Text', CommandTimeout='30']" ""SELECT b.\"BankId\", b.\"AccountNo\", b.\"AccountType\", b.\"AddressId\", b.\"BankGuid\", b.\"BankName\", b.\"BranchCode\", b.\"BranchManager\", b.\"CompanyId\", b.\"CreatedById\", b.\"CreatedTimestamp\", b.\"DomesticWorkingCapitalLimit\", b.\"ExportsPostshipmentLimit\", b.\"ExportsPreshipmentLimit\", b.\"ForwardLimit\", b.\"HSCode\", b.\"ImportBorrowingLimit\", b.\"IsDeleted\", b.\"LERLimit\", b.\"LimitSanctionedFrom\", b.\"LimitSanctionedTo\", b.\"MasterCompanyId\", b.\"RM\", b.\"Remarks\", b.\"TreasuryDesk\", b.\"UpdatedById\", b.\"UpdatedTimestamp\", c.\"CompanyId\", c.\"CINNumber\", c.\"CompanyGuid\", c.\"CompanyName\", c.\"ContactId\", c.\"CreatedById\", c.\"CreatedTimestamp\", c.\"CurrencyId\", c.\"DGFTRegistrationNo\", c.\"ExpiresOn\", c.\"ExportLicensee\", c.\"ImportLicensee\", c.\"IsDeleted\", c.\"IsMaster\", c.\"MasterCompanyId\", c.\"Remarks\", c.\"UpdatedById\", c.\"UpdatedTimestamp\", a.\"AddressId\", a.\"AddressGuid\", a.\"AddressLine1\", a.\"AddressLine2\", a.\"AddressLine3\", a.\"AddressName\", a.\"AddressType\", a.\"City\", a.\"CountryId\", a.\"CreatedById\", a.\"CreatedTimestamp\", a.\"IsDeleted\", a.\"PostCode\", a.\"Region\", a.\"Remarks\", a.\"UpdatedById\", a.\"UpdatedTimestamp\" FROM \"Bank\" AS b LEFT JOIN \"Company\" AS c ON b.\"CompanyId\" = c.\"CompanyId\" INNER JOIN \"Address\" AS a ON b.\"AddressId\" = a.\"AddressId\" WHERE (b.\"MasterCompanyId\" = @__MasterCompanyId_0) AND NOT (b.\"IsDeleted\")" 2022-02-11T10:45:07.8191306+00:00 [ERR] An exception occurred while iterating over the results of a query for context type '"WebX.TLC.DataAccessObjects.TLCDatabaseContext"'." ""Npgsql.PostgresException (0x80004005): 57P01: terminating connection due to administrator command at Npgsql.NpgsqlConnector.g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult() at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.MoveNext() Exception data: Severity: FATAL SqlState: 57P01 MessageText: terminating connection due to administrator command File: postgres.c Line: 3193 Routine: ProcessInterrupts" Npgsql.PostgresException (0x80004005): 57P01: terminating connection due to administrator command at Npgsql.NpgsqlConnector.g__ReadMessageLong|194_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage) at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken) at Npgsql.NpgsqlDataReader.NextResult() at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken) at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior) at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObject parameterObject) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.InitializeReader(DbContext _, Boolean result) at Npgsql.EntityFrameworkCore.PostgreSQL.Storage.Internal.NpgsqlExecutionStrategy.Execute[TState,TResult](TState state, Func`3 operation, Func`3 verifySucceeded) at Microsoft.EntityFrameworkCore.Query.Internal.SplitQueryingEnumerable`1.Enumerator.MoveNext() Exception data: Severity: FATAL SqlState: 57P01 MessageText: terminating connection due to administrator command File: postgres.c Line: 3193 Routine: ProcessInterrupts 2022-02-11T10:45:07.8202912+00:00 [ERR] Object reference not set to an instance of an object. System.NullReferenceException: Object reference not set to an instance of an object. at WebX.TLC.BusinessObjects.AdminBO.GetBanks() in C:\Users\Administrator\Documents\Dev\TreasuryLiveConnect\Libraries\WebX.TLC.BusinessObjects\AdminBO.cs:line 1762 at WebX.TLC.Web.API.Controllers.AdminController.GetBanks(DataTableRequest request) in C:\Users\Administrator\Documents\Dev\TreasuryLiveConnect\API\WebX.TLC.Web.API\Controllers\AdminController.cs:line 463 at lambda_method15655(Closure , Object , Object[] ) at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync() at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync() --- End of stack trace from previous location --- at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.g__Awaited|25_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)