27/11/2019 01:23:35 Message : Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression. StackTrace : 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.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows) at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more) at System.Data.SqlClient.SqlDataReader.Read() at FFC_WinSvc.Utility.DataObjectMapper`1.MapResultsToObjectList(IDataReader reader) in D:\Project\FFC-RCCP\RetailCamControlPanel\Footfallcam\Superbug\FFC_WinSvc\Helpers\Utility.cs:line 59 at FFC_WinSvc.Service.SQLService.<>c__5`1.g__GetItemFunction|5_0(SqlDataReader reader) in D:\Project\FFC-RCCP\RetailCamControlPanel\Footfallcam\Superbug\FFC_WinSvc\Service\SQLService.cs:line 64 at FFC_WinSvc.Service.SQLService.GetItemFromRCCPQueryByFunction[T](String command, Func`2 function, Dictionary`2 sqlParameters) in D:\Project\FFC-RCCP\RetailCamControlPanel\Footfallcam\Superbug\FFC_WinSvc\Service\SQLService.cs:line 125 at FFC_WinSvc.Service.SQLService.GetListFromRCCPQuery[T](String command, Dictionary`2 sqlParameters) in D:\Project\FFC-RCCP\RetailCamControlPanel\Footfallcam\Superbug\FFC_WinSvc\Service\SQLService.cs:line 59 at FFC_WinSvc.Service1.GetRecentHealthCheckLog() in D:\Project\FFC-RCCP\RetailCamControlPanel\Footfallcam\Superbug\FFC_WinSvc\Service1.cs:line 1225 Extra Information :