11:57:00.258 DB.GetCustomers: System.Data.Entity.Core.EntityCommandExecutionException: The data reader is incompatible with the specified 'CashlessCateringModel.VC_API_GetCypadCustomers_Result'. A member of the type, 'Person_Left', does not have a corresponding column in the data reader with the same name. at System.Data.Entity.Core.Query.InternalTrees.ColumnMapFactory.GetMemberOrdinalFromReader(DbDataReader storeDataReader, EdmMember member, EdmType currentType, Dictionary`2 renameList) at System.Data.Entity.Core.Query.InternalTrees.ColumnMapFactory.GetColumnMapsForType(DbDataReader storeDataReader, EdmType edmType, Dictionary`2 renameList) at System.Data.Entity.Core.Query.InternalTrees.ColumnMapFactory.CreateColumnMapFromReaderAndType(DbDataReader storeDataReader, EdmType edmType, EntitySet entitySet, Dictionary`2 renameList) at System.Data.Entity.Core.Query.InternalTrees.ColumnMapFactory.CreateFunctionImportStructuralTypeColumnMap(DbDataReader storeDataReader, FunctionImportMappingNonComposable mapping, Int32 resultSetIndex, EntitySet entitySet, StructuralType baseStructuralType) at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.FunctionColumnMapGenerator.System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.IColumnMapGenerator.CreateColumnMap(DbDataReader reader) at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.CreateColumnMap(DbDataReader storeDataReader, Int32 resultSetIndex) at System.Data.Entity.Core.Objects.ObjectContext.MaterializedDataRecord[TElement](EntityCommand entityCommand, DbDataReader storeReader, Int32 resultSetIndex, ReadOnlyCollection`1 entitySets, EdmType[] edmTypes, ShaperFactory`1 shaperFactory, MergeOption mergeOption, Boolean streaming) at System.Data.Entity.Core.Objects.ObjectContext.CreateFunctionObjectResult[TElement](EntityCommand entityCommand, ReadOnlyCollection`1 entitySets, EdmType[] edmTypes, ExecutionOptions executionOptions) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass161_0`1.b__1() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass161_0`1.b__0() at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, ExecutionOptions executionOptions, ObjectParameter[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, MergeOption mergeOption, ObjectParameter[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, ObjectParameter[] parameters) at VeriCoolAPI.Entities.VC_API_GetCypadCustomers() in C:\TFS\team-LegacyCollection\VeriCool Utilities\VeriCool.API\VeriCoolAPI\VeriCoolAPI\CCDB.Context.cs:line 140 at VeriCoolAPI.DB.GetCustomers(RequestCustomerArgs args) in C:\TFS\team-LegacyCollection\VeriCool Utilities\VeriCool.API\VeriCoolAPI\VeriCoolAPI\DBLogic.cs:line 159 at VeriCoolAPI.Service1.RequestCustomers(RequestCustomerArgs Args) in C:\TFS\team-LegacyCollection\VeriCool Utilities\VeriCool.API\VeriCoolAPI\VeriCoolAPI\Service.svc.cs:line 160 12:03:35.474 DB.GetCustomers: System.Data.Entity.Core.EntityCommandExecutionException: The data reader is incompatible with the specified 'CashlessCateringModel.VC_API_GetCypadCustomers_Result'. A member of the type, 'Person_Left', does not have a corresponding column in the data reader with the same name. at System.Data.Entity.Core.Query.InternalTrees.ColumnMapFactory.GetMemberOrdinalFromReader(DbDataReader storeDataReader, EdmMember member, EdmType currentType, Dictionary`2 renameList) at System.Data.Entity.Core.Query.InternalTrees.ColumnMapFactory.GetColumnMapsForType(DbDataReader storeDataReader, EdmType edmType, Dictionary`2 renameList) at System.Data.Entity.Core.Query.InternalTrees.ColumnMapFactory.CreateColumnMapFromReaderAndType(DbDataReader storeDataReader, EdmType edmType, EntitySet entitySet, Dictionary`2 renameList) at System.Data.Entity.Core.Query.InternalTrees.ColumnMapFactory.CreateFunctionImportStructuralTypeColumnMap(DbDataReader storeDataReader, FunctionImportMappingNonComposable mapping, Int32 resultSetIndex, EntitySet entitySet, StructuralType baseStructuralType) at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.FunctionColumnMapGenerator.System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.IColumnMapGenerator.CreateColumnMap(DbDataReader reader) at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.CreateColumnMap(DbDataReader storeDataReader, Int32 resultSetIndex) at System.Data.Entity.Core.Objects.ObjectContext.MaterializedDataRecord[TElement](EntityCommand entityCommand, DbDataReader storeReader, Int32 resultSetIndex, ReadOnlyCollection`1 entitySets, EdmType[] edmTypes, ShaperFactory`1 shaperFactory, MergeOption mergeOption, Boolean streaming) at System.Data.Entity.Core.Objects.ObjectContext.CreateFunctionObjectResult[TElement](EntityCommand entityCommand, ReadOnlyCollection`1 entitySets, EdmType[] edmTypes, ExecutionOptions executionOptions) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass161_0`1.b__1() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass161_0`1.b__0() at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, ExecutionOptions executionOptions, ObjectParameter[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, MergeOption mergeOption, ObjectParameter[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, ObjectParameter[] parameters) at VeriCoolAPI.Entities.VC_API_GetCypadCustomers() in C:\TFS\team-LegacyCollection\VeriCool Utilities\VeriCool.API\VeriCoolAPI\VeriCoolAPI\CCDB.Context.cs:line 140 at VeriCoolAPI.DB.GetCustomers(RequestCustomerArgs args) in C:\TFS\team-LegacyCollection\VeriCool Utilities\VeriCool.API\VeriCoolAPI\VeriCoolAPI\DBLogic.cs:line 159 at VeriCoolAPI.Service1.RequestCustomers(RequestCustomerArgs Args) in C:\TFS\team-LegacyCollection\VeriCool Utilities\VeriCool.API\VeriCoolAPI\VeriCoolAPI\Service.svc.cs:line 160 12:09:45.435 DB.GetCustomers: System.Data.Entity.Core.EntityCommandExecutionException: The data reader is incompatible with the specified 'CashlessCateringModel.VC_API_GetCypadCustomers_Result'. A member of the type, 'Person_Left', does not have a corresponding column in the data reader with the same name. at System.Data.Entity.Core.Query.InternalTrees.ColumnMapFactory.GetMemberOrdinalFromReader(DbDataReader storeDataReader, EdmMember member, EdmType currentType, Dictionary`2 renameList) at System.Data.Entity.Core.Query.InternalTrees.ColumnMapFactory.GetColumnMapsForType(DbDataReader storeDataReader, EdmType edmType, Dictionary`2 renameList) at System.Data.Entity.Core.Query.InternalTrees.ColumnMapFactory.CreateColumnMapFromReaderAndType(DbDataReader storeDataReader, EdmType edmType, EntitySet entitySet, Dictionary`2 renameList) at System.Data.Entity.Core.Query.InternalTrees.ColumnMapFactory.CreateFunctionImportStructuralTypeColumnMap(DbDataReader storeDataReader, FunctionImportMappingNonComposable mapping, Int32 resultSetIndex, EntitySet entitySet, StructuralType baseStructuralType) at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.FunctionColumnMapGenerator.System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.IColumnMapGenerator.CreateColumnMap(DbDataReader reader) at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.CreateColumnMap(DbDataReader storeDataReader, Int32 resultSetIndex) at System.Data.Entity.Core.Objects.ObjectContext.MaterializedDataRecord[TElement](EntityCommand entityCommand, DbDataReader storeReader, Int32 resultSetIndex, ReadOnlyCollection`1 entitySets, EdmType[] edmTypes, ShaperFactory`1 shaperFactory, MergeOption mergeOption, Boolean streaming) at System.Data.Entity.Core.Objects.ObjectContext.CreateFunctionObjectResult[TElement](EntityCommand entityCommand, ReadOnlyCollection`1 entitySets, EdmType[] edmTypes, ExecutionOptions executionOptions) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass161_0`1.b__1() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass161_0`1.b__0() at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, ExecutionOptions executionOptions, ObjectParameter[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, MergeOption mergeOption, ObjectParameter[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, ObjectParameter[] parameters) at VeriCoolAPI.Entities.VC_API_GetCypadCustomers() in C:\TFS\team-LegacyCollection\VeriCool Utilities\VeriCool.API\VeriCoolAPI\VeriCoolAPI\CCDB.Context.cs:line 140 at VeriCoolAPI.DB.GetCustomers(RequestCustomerArgs args) in C:\TFS\team-LegacyCollection\VeriCool Utilities\VeriCool.API\VeriCoolAPI\VeriCoolAPI\DBLogic.cs:line 159 at VeriCoolAPI.Service1.RequestCustomers(RequestCustomerArgs Args) in C:\TFS\team-LegacyCollection\VeriCool Utilities\VeriCool.API\VeriCoolAPI\VeriCoolAPI\Service.svc.cs:line 160 12:10:42.384 DB.GetCustomers: System.Data.Entity.Core.EntityCommandExecutionException: The data reader is incompatible with the specified 'CashlessCateringModel.VC_API_GetCypadCustomers_Result'. A member of the type, 'Person_Left', does not have a corresponding column in the data reader with the same name. at System.Data.Entity.Core.Query.InternalTrees.ColumnMapFactory.GetMemberOrdinalFromReader(DbDataReader storeDataReader, EdmMember member, EdmType currentType, Dictionary`2 renameList) at System.Data.Entity.Core.Query.InternalTrees.ColumnMapFactory.GetColumnMapsForType(DbDataReader storeDataReader, EdmType edmType, Dictionary`2 renameList) at System.Data.Entity.Core.Query.InternalTrees.ColumnMapFactory.CreateColumnMapFromReaderAndType(DbDataReader storeDataReader, EdmType edmType, EntitySet entitySet, Dictionary`2 renameList) at System.Data.Entity.Core.Query.InternalTrees.ColumnMapFactory.CreateFunctionImportStructuralTypeColumnMap(DbDataReader storeDataReader, FunctionImportMappingNonComposable mapping, Int32 resultSetIndex, EntitySet entitySet, StructuralType baseStructuralType) at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.FunctionColumnMapGenerator.System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.IColumnMapGenerator.CreateColumnMap(DbDataReader reader) at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.CreateColumnMap(DbDataReader storeDataReader, Int32 resultSetIndex) at System.Data.Entity.Core.Objects.ObjectContext.MaterializedDataRecord[TElement](EntityCommand entityCommand, DbDataReader storeReader, Int32 resultSetIndex, ReadOnlyCollection`1 entitySets, EdmType[] edmTypes, ShaperFactory`1 shaperFactory, MergeOption mergeOption, Boolean streaming) at System.Data.Entity.Core.Objects.ObjectContext.CreateFunctionObjectResult[TElement](EntityCommand entityCommand, ReadOnlyCollection`1 entitySets, EdmType[] edmTypes, ExecutionOptions executionOptions) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass161_0`1.b__1() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass161_0`1.b__0() at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, ExecutionOptions executionOptions, ObjectParameter[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, MergeOption mergeOption, ObjectParameter[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, ObjectParameter[] parameters) at VeriCoolAPI.Entities.VC_API_GetCypadCustomers() in C:\TFS\team-LegacyCollection\VeriCool Utilities\VeriCool.API\VeriCoolAPI\VeriCoolAPI\CCDB.Context.cs:line 140 at VeriCoolAPI.DB.GetCustomers(RequestCustomerArgs args) in C:\TFS\team-LegacyCollection\VeriCool Utilities\VeriCool.API\VeriCoolAPI\VeriCoolAPI\DBLogic.cs:line 159 at VeriCoolAPI.Service1.RequestCustomers(RequestCustomerArgs Args) in C:\TFS\team-LegacyCollection\VeriCool Utilities\VeriCool.API\VeriCoolAPI\VeriCoolAPI\Service.svc.cs:line 160 12:35:57.217 DB.GetCustomers: System.Data.Entity.Core.EntityCommandExecutionException: The data reader is incompatible with the specified 'CashlessCateringModel.VC_API_GetCypadCustomers_Result'. A member of the type, 'Person_Left', does not have a corresponding column in the data reader with the same name. at System.Data.Entity.Core.Query.InternalTrees.ColumnMapFactory.GetMemberOrdinalFromReader(DbDataReader storeDataReader, EdmMember member, EdmType currentType, Dictionary`2 renameList) at System.Data.Entity.Core.Query.InternalTrees.ColumnMapFactory.GetColumnMapsForType(DbDataReader storeDataReader, EdmType edmType, Dictionary`2 renameList) at System.Data.Entity.Core.Query.InternalTrees.ColumnMapFactory.CreateColumnMapFromReaderAndType(DbDataReader storeDataReader, EdmType edmType, EntitySet entitySet, Dictionary`2 renameList) at System.Data.Entity.Core.Query.InternalTrees.ColumnMapFactory.CreateFunctionImportStructuralTypeColumnMap(DbDataReader storeDataReader, FunctionImportMappingNonComposable mapping, Int32 resultSetIndex, EntitySet entitySet, StructuralType baseStructuralType) at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.FunctionColumnMapGenerator.System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.IColumnMapGenerator.CreateColumnMap(DbDataReader reader) at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.CreateColumnMap(DbDataReader storeDataReader, Int32 resultSetIndex) at System.Data.Entity.Core.Objects.ObjectContext.MaterializedDataRecord[TElement](EntityCommand entityCommand, DbDataReader storeReader, Int32 resultSetIndex, ReadOnlyCollection`1 entitySets, EdmType[] edmTypes, ShaperFactory`1 shaperFactory, MergeOption mergeOption, Boolean streaming) at System.Data.Entity.Core.Objects.ObjectContext.CreateFunctionObjectResult[TElement](EntityCommand entityCommand, ReadOnlyCollection`1 entitySets, EdmType[] edmTypes, ExecutionOptions executionOptions) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass161_0`1.b__1() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass161_0`1.b__0() at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, ExecutionOptions executionOptions, ObjectParameter[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, MergeOption mergeOption, ObjectParameter[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, ObjectParameter[] parameters) at VeriCoolAPI.Entities.VC_API_GetCypadCustomers() in C:\TFS\team-LegacyCollection\VeriCool Utilities\VeriCool.API\VeriCoolAPI\VeriCoolAPI\CCDB.Context.cs:line 140 at VeriCoolAPI.DB.GetCustomers(RequestCustomerArgs args) in C:\TFS\team-LegacyCollection\VeriCool Utilities\VeriCool.API\VeriCoolAPI\VeriCoolAPI\DBLogic.cs:line 159 at VeriCoolAPI.Service1.RequestCustomers(RequestCustomerArgs Args) in C:\TFS\team-LegacyCollection\VeriCool Utilities\VeriCool.API\VeriCoolAPI\VeriCoolAPI\Service.svc.cs:line 160 12:35:57.263 RequestTransactions: b3b2af20-bf70-46a3-838b-4163074203ab 12:35:57.263 ExternalID: 12:35:57.264 StartDate: 11/23/2021 11:59:59 PM 12:35:57.264 EndDate: 11/24/2021 12:00:00 AM 12:35:57.264 BalanceImport: True 12:35:57.270 Exception Getting/Processing transactions, ex: An error occurred while executing the command definition. See the inner exception for details., inner: Procedure or function VC_API_GetCypadTransactions has too many arguments specified. 12:55:33.844 DB.GetCustomers: System.Data.Entity.Core.EntityCommandExecutionException: The data reader is incompatible with the specified 'CashlessCateringModel.VC_API_GetCypadCustomers_Result'. A member of the type, 'Person_Left', does not have a corresponding column in the data reader with the same name. at System.Data.Entity.Core.Query.InternalTrees.ColumnMapFactory.GetMemberOrdinalFromReader(DbDataReader storeDataReader, EdmMember member, EdmType currentType, Dictionary`2 renameList) at System.Data.Entity.Core.Query.InternalTrees.ColumnMapFactory.GetColumnMapsForType(DbDataReader storeDataReader, EdmType edmType, Dictionary`2 renameList) at System.Data.Entity.Core.Query.InternalTrees.ColumnMapFactory.CreateColumnMapFromReaderAndType(DbDataReader storeDataReader, EdmType edmType, EntitySet entitySet, Dictionary`2 renameList) at System.Data.Entity.Core.Query.InternalTrees.ColumnMapFactory.CreateFunctionImportStructuralTypeColumnMap(DbDataReader storeDataReader, FunctionImportMappingNonComposable mapping, Int32 resultSetIndex, EntitySet entitySet, StructuralType baseStructuralType) at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.FunctionColumnMapGenerator.System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.IColumnMapGenerator.CreateColumnMap(DbDataReader reader) at System.Data.Entity.Core.EntityClient.Internal.EntityCommandDefinition.CreateColumnMap(DbDataReader storeDataReader, Int32 resultSetIndex) at System.Data.Entity.Core.Objects.ObjectContext.MaterializedDataRecord[TElement](EntityCommand entityCommand, DbDataReader storeReader, Int32 resultSetIndex, ReadOnlyCollection`1 entitySets, EdmType[] edmTypes, ShaperFactory`1 shaperFactory, MergeOption mergeOption, Boolean streaming) at System.Data.Entity.Core.Objects.ObjectContext.CreateFunctionObjectResult[TElement](EntityCommand entityCommand, ReadOnlyCollection`1 entitySets, EdmType[] edmTypes, ExecutionOptions executionOptions) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass161_0`1.b__1() at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass161_0`1.b__0() at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, ExecutionOptions executionOptions, ObjectParameter[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, MergeOption mergeOption, ObjectParameter[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteFunction[TElement](String functionName, ObjectParameter[] parameters) at VeriCoolAPI.Entities.VC_API_GetCypadCustomers() in C:\TFS\team-LegacyCollection\VeriCool Utilities\VeriCool.API\VeriCoolAPI\VeriCoolAPI\CCDB.Context.cs:line 140 at VeriCoolAPI.DB.GetCustomers(RequestCustomerArgs args) in C:\TFS\team-LegacyCollection\VeriCool Utilities\VeriCool.API\VeriCoolAPI\VeriCoolAPI\DBLogic.cs:line 159 at VeriCoolAPI.Service1.RequestCustomers(RequestCustomerArgs Args) in C:\TFS\team-LegacyCollection\VeriCool Utilities\VeriCool.API\VeriCoolAPI\VeriCoolAPI\Service.svc.cs:line 160 13:05:37.235 RequestTransactions: 4cfc9f54-08f0-4603-999f-fa25fc040d1d 13:05:37.235 ExternalID: 13:05:37.235 StartDate: 2/1/2021 1:05:28 PM 13:05:37.235 EndDate: 2/28/2021 1:05:28 PM 13:05:37.236 BalanceImport: False 13:05:51.691 Exception Getting/Processing transactions, ex: The data reader is incompatible with the specified 'CashlessCateringModel.VC_API_GetCypadTransactions_Result'. A member of the type, 'PLUCode', does not have a corresponding column in the data reader with the same name., inner: No inner Exception Message 13:05:57.304 GetCustomers count: 1506 13:06:51.030 RequestTransactions: 4cfc9f54-08f0-4603-999f-fa25fc040d1d 13:06:51.030 ExternalID: 13:06:51.030 StartDate: 2/1/2021 1:05:28 PM 13:06:51.031 EndDate: 2/28/2021 1:05:28 PM 13:06:51.031 BalanceImport: False 13:07:03.537 Exception Getting/Processing transactions, ex: The data reader is incompatible with the specified 'CashlessCateringModel.VC_API_GetCypadTransactions_Result'. A member of the type, 'PLUCode', does not have a corresponding column in the data reader with the same name., inner: No inner Exception Message 13:11:10.467 GetCustomers count: 1506 13:11:59.081 RequestTransactions: e241e0d9-dd7b-429f-826f-d678244ed91e 13:11:59.082 ExternalID: 13:11:59.082 StartDate: 10/1/2021 12:00:00 AM 13:11:59.083 EndDate: 10/1/2021 12:00:00 AM 13:11:59.083 BalanceImport: False 13:11:59.144 Exception Getting/Processing transactions, ex: The data reader is incompatible with the specified 'CashlessCateringModel.VC_API_GetCypadTransactions_Result'. A member of the type, 'PLUCode', does not have a corresponding column in the data reader with the same name., inner: No inner Exception Message 13:29:00.283 RequestTransactions: be25f62c-7e91-4005-ad6f-8e4137caf215 13:29:00.283 ExternalID: 13:29:00.283 StartDate: 2/1/2021 1:28:19 PM 13:29:00.283 EndDate: 2/28/2021 1:28:19 PM 13:29:00.284 BalanceImport: False 13:29:12.459 Exception Getting/Processing transactions, ex: The data reader is incompatible with the specified 'CashlessCateringModel.VC_API_GetCypadTransactions_Result'. A member of the type, 'PLUCode', does not have a corresponding column in the data reader with the same name., inner: No inner Exception Message 13:29:16.968 RequestTransactions: be25f62c-7e91-4005-ad6f-8e4137caf215 13:29:16.968 ExternalID: 13:29:16.968 StartDate: 2/1/2021 1:28:19 PM 13:29:16.969 EndDate: 2/28/2021 1:28:19 PM 13:29:16.969 BalanceImport: False 13:29:30.016 Exception Getting/Processing transactions, ex: The data reader is incompatible with the specified 'CashlessCateringModel.VC_API_GetCypadTransactions_Result'. A member of the type, 'PLUCode', does not have a corresponding column in the data reader with the same name., inner: No inner Exception Message 13:30:00.520 RequestTransactions: be25f62c-7e91-4005-ad6f-8e4137caf215 13:30:00.521 ExternalID: 13:30:00.521 StartDate: 2/1/2021 1:28:19 PM 13:30:00.521 EndDate: 2/28/2021 1:28:19 PM 13:30:00.521 BalanceImport: False 13:32:41.905 RequestTransactions: 53f5da6c-4bb5-4c24-8d69-2bcf0bcad8e5 13:32:41.905 ExternalID: 13:32:41.905 StartDate: 2/1/2021 1:32:34 PM 13:32:41.906 EndDate: 2/28/2021 1:32:34 PM 13:32:41.906 BalanceImport: False 13:36:03.755 DBServer: DevTestVM 13:36:03.755 DBName: APITestWhitmore 13:36:03.756 UserName: vericool1 13:36:03.756 Password: v3r1c00l1 13:36:03.756 got here 5 13:36:03.762 constring is : data source=DevTestVM;initial catalog=APITestWhitmore;user id=vericool1;password=v3r1c00l1;MultipleActiveResultSets=True;App=EntityFramework 13:36:03.767 Connection String is : metadata=res://*/CCDb.csdl|res://*/CCDb.ssdl|res://*/CCDb.msl;provider=System.Data.SqlClient;provider connection string="data source=DevTestVM;initial catalog=APITestWhitmore;user id=vericool1;password=v3r1c00l1;MultipleActiveResultSets=True;App=EntityFramework" 13:36:03.906 Connection String is : metadata=res://*/CCDb.csdl|res://*/CCDb.ssdl|res://*/CCDb.msl;provider=System.Data.SqlClient;provider connection string="data source=DevTestVM;initial catalog=APITestWhitmore;user id=vericool1;password=v3r1c00l1;MultipleActiveResultSets=True;App=EntityFramework" 13:36:06.109 RequestTransactions: 5c127a8b-7482-4188-9848-5cc4c7d4adff 13:36:06.109 ExternalID: 13:36:06.110 StartDate: 2/1/2021 1:32:34 PM 13:36:06.110 EndDate: 2/28/2021 1:32:34 PM 13:36:06.110 BalanceImport: False 13:40:51.967 RequestTransactions: 4738ee99-07aa-48b1-b20b-4998d67e8c15 13:40:51.967 ExternalID: 13:40:51.967 StartDate: 10/1/2021 12:00:00 AM 13:40:51.968 EndDate: 10/1/2021 12:00:00 AM 13:40:51.968 BalanceImport: False 13:41:05.487 RequestTransactions: 4738ee99-07aa-48b1-b20b-4998d67e8c15 13:41:05.488 ExternalID: 13:41:05.488 StartDate: 10/1/2021 12:00:00 AM 13:41:05.488 EndDate: 10/15/2021 12:00:00 AM 13:41:05.489 BalanceImport: False 13:41:35.495 Exception Getting/Processing transactions, ex: An error occurred while executing the command definition. See the inner exception for details., inner: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. 14:14:47.915 DBServer: DevTestVM 14:14:47.915 DBName: APITestWhitmore 14:14:47.915 UserName: vericool1 14:14:47.916 Password: v3r1c00l1 14:14:47.916 got here 5 14:14:47.929 constring is : data source=DevTestVM;initial catalog=APITestWhitmore;user id=vericool1;password=v3r1c00l1;MultipleActiveResultSets=True;App=EntityFramework 14:14:47.934 Connection String is : metadata=res://*/CCDb.csdl|res://*/CCDb.ssdl|res://*/CCDb.msl;provider=System.Data.SqlClient;provider connection string="data source=DevTestVM;initial catalog=APITestWhitmore;user id=vericool1;password=v3r1c00l1;MultipleActiveResultSets=True;App=EntityFramework" 14:14:48.098 Connection String is : metadata=res://*/CCDb.csdl|res://*/CCDb.ssdl|res://*/CCDb.msl;provider=System.Data.SqlClient;provider connection string="data source=DevTestVM;initial catalog=APITestWhitmore;user id=vericool1;password=v3r1c00l1;MultipleActiveResultSets=True;App=EntityFramework" 14:14:48.719 GetCustomers count: 1506 14:14:51.842 RequestTransactions: 5306d19d-9a3b-4ed8-a36a-977a1d84fd8c 14:14:51.842 ExternalID: 14:14:51.842 StartDate: 11/23/2021 11:59:59 PM 14:14:51.843 EndDate: 11/24/2021 12:00:00 AM 14:14:51.843 BalanceImport: True 14:15:14.688 RequestTransactions: 5306d19d-9a3b-4ed8-a36a-977a1d84fd8c 14:15:14.689 ExternalID: 14:15:14.689 StartDate: 11/23/2021 11:00:00 PM 14:15:14.689 EndDate: 11/24/2021 2:14:47 PM 14:15:14.690 BalanceImport: False 14:24:14.911 GetCustomers count: 1506 14:24:15.842 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:24:15.842 ExternalID: 14:24:15.843 StartDate: 8/31/2021 11:59:59 PM 14:24:15.843 EndDate: 9/1/2021 12:00:00 AM 14:24:15.843 BalanceImport: True 14:24:34.290 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:24:34.291 ExternalID: 14:24:34.291 StartDate: 9/1/2021 12:00:00 AM 14:24:34.291 EndDate: 9/2/2021 12:00:00 AM 14:24:34.292 BalanceImport: False 14:24:34.520 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:24:34.521 ExternalID: 14:24:34.521 StartDate: 9/1/2021 11:00:00 PM 14:24:34.521 EndDate: 9/3/2021 12:00:00 AM 14:24:34.522 BalanceImport: False 14:24:34.910 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:24:34.910 ExternalID: 14:24:34.910 StartDate: 9/2/2021 11:00:00 PM 14:24:34.911 EndDate: 9/4/2021 12:00:00 AM 14:24:34.911 BalanceImport: False 14:24:35.198 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:24:35.199 ExternalID: 14:24:35.199 StartDate: 9/3/2021 11:00:00 PM 14:24:35.199 EndDate: 9/5/2021 12:00:00 AM 14:24:35.200 BalanceImport: False 14:24:35.609 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:24:35.610 ExternalID: 14:24:35.610 StartDate: 9/4/2021 11:00:00 PM 14:24:35.611 EndDate: 9/6/2021 12:00:00 AM 14:24:35.611 BalanceImport: False 14:24:35.947 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:24:35.947 ExternalID: 14:24:35.948 StartDate: 9/5/2021 11:00:00 PM 14:24:35.948 EndDate: 9/7/2021 12:00:00 AM 14:24:35.948 BalanceImport: False 14:24:39.013 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:24:39.014 ExternalID: 14:24:39.014 StartDate: 9/6/2021 11:00:00 PM 14:24:39.014 EndDate: 9/8/2021 12:00:00 AM 14:24:39.014 BalanceImport: False 14:24:46.729 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:24:46.730 ExternalID: 14:24:46.730 StartDate: 9/7/2021 11:00:00 PM 14:24:46.730 EndDate: 9/9/2021 12:00:00 AM 14:24:46.730 BalanceImport: False 14:25:00.460 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:25:00.460 ExternalID: 14:25:00.461 StartDate: 9/8/2021 11:00:00 PM 14:25:00.461 EndDate: 9/10/2021 12:00:00 AM 14:25:00.461 BalanceImport: False 14:25:14.298 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:25:14.298 ExternalID: 14:25:14.298 StartDate: 9/9/2021 11:00:00 PM 14:25:14.299 EndDate: 9/11/2021 12:00:00 AM 14:25:14.299 BalanceImport: False 14:25:29.368 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:25:29.369 ExternalID: 14:25:29.369 StartDate: 9/10/2021 11:00:00 PM 14:25:29.369 EndDate: 9/12/2021 12:00:00 AM 14:25:29.370 BalanceImport: False 14:25:29.824 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:25:29.824 ExternalID: 14:25:29.824 StartDate: 9/11/2021 11:00:00 PM 14:25:29.825 EndDate: 9/13/2021 12:00:00 AM 14:25:29.825 BalanceImport: False 14:25:30.574 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:25:30.574 ExternalID: 14:25:30.575 StartDate: 9/12/2021 11:00:00 PM 14:25:30.575 EndDate: 9/14/2021 12:00:00 AM 14:25:30.575 BalanceImport: False 14:25:47.576 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:25:47.576 ExternalID: 14:25:47.577 StartDate: 9/13/2021 11:00:00 PM 14:25:47.577 EndDate: 9/15/2021 12:00:00 AM 14:25:47.577 BalanceImport: False 14:26:04.767 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:26:04.767 ExternalID: 14:26:04.767 StartDate: 9/14/2021 11:00:00 PM 14:26:04.768 EndDate: 9/16/2021 12:00:00 AM 14:26:04.768 BalanceImport: False 14:26:21.446 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:26:21.446 ExternalID: 14:26:21.446 StartDate: 9/15/2021 11:00:00 PM 14:26:21.447 EndDate: 9/17/2021 12:00:00 AM 14:26:21.447 BalanceImport: False 14:26:39.515 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:26:39.515 ExternalID: 14:26:39.516 StartDate: 9/16/2021 11:00:00 PM 14:26:39.516 EndDate: 9/18/2021 12:00:00 AM 14:26:39.516 BalanceImport: False 14:26:58.903 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:26:58.903 ExternalID: 14:26:58.903 StartDate: 9/17/2021 11:00:00 PM 14:26:58.904 EndDate: 9/19/2021 12:00:00 AM 14:26:58.904 BalanceImport: False 14:26:59.345 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:26:59.345 ExternalID: 14:26:59.345 StartDate: 9/18/2021 11:00:00 PM 14:26:59.346 EndDate: 9/20/2021 12:00:00 AM 14:26:59.346 BalanceImport: False 14:27:00.249 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:27:00.250 ExternalID: 14:27:00.250 StartDate: 9/19/2021 11:00:00 PM 14:27:00.250 EndDate: 9/21/2021 12:00:00 AM 14:27:00.251 BalanceImport: False 14:27:16.476 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:27:16.476 ExternalID: 14:27:16.476 StartDate: 9/20/2021 11:00:00 PM 14:27:16.477 EndDate: 9/22/2021 12:00:00 AM 14:27:16.477 BalanceImport: False 14:27:33.725 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:27:33.726 ExternalID: 14:27:33.726 StartDate: 9/21/2021 11:00:00 PM 14:27:33.726 EndDate: 9/23/2021 12:00:00 AM 14:27:33.726 BalanceImport: False 14:27:52.336 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:27:52.336 ExternalID: 14:27:52.336 StartDate: 9/22/2021 11:00:00 PM 14:27:52.337 EndDate: 9/24/2021 12:00:00 AM 14:27:52.337 BalanceImport: False 14:28:12.850 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:28:12.851 ExternalID: 14:28:12.851 StartDate: 9/23/2021 11:00:00 PM 14:28:12.851 EndDate: 9/25/2021 12:00:00 AM 14:28:12.852 BalanceImport: False 14:28:31.684 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:28:31.684 ExternalID: 14:28:31.685 StartDate: 9/24/2021 11:00:00 PM 14:28:31.685 EndDate: 9/26/2021 12:00:00 AM 14:28:31.685 BalanceImport: False 14:28:32.076 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:28:32.077 ExternalID: 14:28:32.077 StartDate: 9/25/2021 11:00:00 PM 14:28:32.077 EndDate: 9/27/2021 12:00:00 AM 14:28:32.078 BalanceImport: False 14:28:32.857 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:28:32.857 ExternalID: 14:28:32.857 StartDate: 9/26/2021 11:00:00 PM 14:28:32.858 EndDate: 9/28/2021 12:00:00 AM 14:28:32.858 BalanceImport: False 14:28:52.383 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:28:52.383 ExternalID: 14:28:52.383 StartDate: 9/27/2021 11:00:00 PM 14:28:52.384 EndDate: 9/29/2021 12:00:00 AM 14:28:52.384 BalanceImport: False 14:29:11.568 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:29:11.568 ExternalID: 14:29:11.568 StartDate: 9/28/2021 11:00:00 PM 14:29:11.569 EndDate: 9/30/2021 12:00:00 AM 14:29:11.569 BalanceImport: False 14:29:31.753 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:29:31.754 ExternalID: 14:29:31.754 StartDate: 9/29/2021 11:00:00 PM 14:29:31.754 EndDate: 10/1/2021 12:00:00 AM 14:29:31.755 BalanceImport: False 14:29:53.570 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:29:53.571 ExternalID: 14:29:53.571 StartDate: 9/30/2021 11:00:00 PM 14:29:53.571 EndDate: 10/2/2021 12:00:00 AM 14:29:53.571 BalanceImport: False 14:30:13.851 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:30:13.852 ExternalID: 14:30:13.852 StartDate: 10/1/2021 11:00:00 PM 14:30:13.852 EndDate: 10/3/2021 12:00:00 AM 14:30:13.853 BalanceImport: False 14:30:14.083 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:30:14.084 ExternalID: 14:30:14.084 StartDate: 10/2/2021 11:00:00 PM 14:30:14.084 EndDate: 10/4/2021 12:00:00 AM 14:30:14.084 BalanceImport: False 14:30:14.981 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:30:14.982 ExternalID: 14:30:14.982 StartDate: 10/3/2021 11:00:00 PM 14:30:14.982 EndDate: 10/5/2021 12:00:00 AM 14:30:14.983 BalanceImport: False 14:30:33.582 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:30:33.583 ExternalID: 14:30:33.583 StartDate: 10/4/2021 11:00:00 PM 14:30:33.584 EndDate: 10/6/2021 12:00:00 AM 14:30:33.584 BalanceImport: False 14:30:53.869 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:30:53.869 ExternalID: 14:30:53.869 StartDate: 10/5/2021 11:00:00 PM 14:30:53.870 EndDate: 10/7/2021 12:00:00 AM 14:30:53.870 BalanceImport: False 14:31:15.041 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:31:15.041 ExternalID: 14:31:15.042 StartDate: 10/6/2021 11:00:00 PM 14:31:15.045 EndDate: 10/8/2021 12:00:00 AM 14:31:15.045 BalanceImport: False 14:31:36.418 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:31:36.418 ExternalID: 14:31:36.419 StartDate: 10/7/2021 11:00:00 PM 14:31:36.419 EndDate: 10/9/2021 12:00:00 AM 14:31:36.419 BalanceImport: False 14:31:58.091 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:31:58.091 ExternalID: 14:31:58.092 StartDate: 10/8/2021 11:00:00 PM 14:31:58.092 EndDate: 10/10/2021 12:00:00 AM 14:31:58.092 BalanceImport: False 14:31:58.425 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:31:58.425 ExternalID: 14:31:58.426 StartDate: 10/9/2021 11:00:00 PM 14:31:58.426 EndDate: 10/11/2021 12:00:00 AM 14:31:58.426 BalanceImport: False 14:31:59.658 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:31:59.659 ExternalID: 14:31:59.659 StartDate: 10/10/2021 11:00:00 PM 14:31:59.659 EndDate: 10/12/2021 12:00:00 AM 14:31:59.660 BalanceImport: False 14:32:20.318 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:32:20.319 ExternalID: 14:32:20.319 StartDate: 10/11/2021 11:00:00 PM 14:32:20.319 EndDate: 10/13/2021 12:00:00 AM 14:32:20.320 BalanceImport: False 14:32:41.723 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:32:41.723 ExternalID: 14:32:41.724 StartDate: 10/12/2021 11:00:00 PM 14:32:41.724 EndDate: 10/14/2021 12:00:00 AM 14:32:41.724 BalanceImport: False 14:33:04.477 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:33:04.477 ExternalID: 14:33:04.477 StartDate: 10/13/2021 11:00:00 PM 14:33:04.478 EndDate: 10/15/2021 12:00:00 AM 14:33:04.478 BalanceImport: False 14:33:26.979 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:33:26.979 ExternalID: 14:33:26.980 StartDate: 10/14/2021 11:00:00 PM 14:33:26.980 EndDate: 10/16/2021 12:00:00 AM 14:33:26.981 BalanceImport: False 14:33:49.532 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:33:49.532 ExternalID: 14:33:49.533 StartDate: 10/15/2021 11:00:00 PM 14:33:49.533 EndDate: 10/17/2021 12:00:00 AM 14:33:49.533 BalanceImport: False 14:33:49.871 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:33:49.871 ExternalID: 14:33:49.871 StartDate: 10/16/2021 11:00:00 PM 14:33:49.872 EndDate: 10/18/2021 12:00:00 AM 14:33:49.872 BalanceImport: False 14:33:50.899 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:33:50.900 ExternalID: 14:33:50.900 StartDate: 10/17/2021 11:00:00 PM 14:33:50.900 EndDate: 10/19/2021 12:00:00 AM 14:33:50.901 BalanceImport: False 14:34:13.769 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:34:13.770 ExternalID: 14:34:13.770 StartDate: 10/18/2021 11:00:00 PM 14:34:13.771 EndDate: 10/20/2021 12:00:00 AM 14:34:13.771 BalanceImport: False 14:34:35.251 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:34:35.251 ExternalID: 14:34:35.252 StartDate: 10/19/2021 11:00:00 PM 14:34:35.252 EndDate: 10/21/2021 12:00:00 AM 14:34:35.252 BalanceImport: False 14:34:58.276 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:34:58.276 ExternalID: 14:34:58.276 StartDate: 10/20/2021 11:00:00 PM 14:34:58.276 EndDate: 10/22/2021 12:00:00 AM 14:34:58.277 BalanceImport: False 14:35:19.764 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:35:19.764 ExternalID: 14:35:19.765 StartDate: 10/21/2021 11:00:00 PM 14:35:19.765 EndDate: 10/23/2021 12:00:00 AM 14:35:19.765 BalanceImport: False 14:35:43.475 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:35:43.475 ExternalID: 14:35:43.476 StartDate: 10/22/2021 11:00:00 PM 14:35:43.476 EndDate: 10/24/2021 12:00:00 AM 14:35:43.476 BalanceImport: False 14:35:43.808 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:35:43.809 ExternalID: 14:35:43.809 StartDate: 10/23/2021 11:00:00 PM 14:35:43.809 EndDate: 10/25/2021 12:00:00 AM 14:35:43.809 BalanceImport: False 14:35:43.915 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:35:43.915 ExternalID: 14:35:43.916 StartDate: 10/24/2021 11:00:00 PM 14:35:43.916 EndDate: 10/26/2021 12:00:00 AM 14:35:43.916 BalanceImport: False 14:35:44.251 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:35:44.251 ExternalID: 14:35:44.252 StartDate: 10/25/2021 11:00:00 PM 14:35:44.252 EndDate: 10/27/2021 12:00:00 AM 14:35:44.252 BalanceImport: False 14:35:44.491 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:35:44.491 ExternalID: 14:35:44.491 StartDate: 10/26/2021 11:00:00 PM 14:35:44.492 EndDate: 10/28/2021 12:00:00 AM 14:35:44.492 BalanceImport: False 14:35:44.680 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:35:44.681 ExternalID: 14:35:44.681 StartDate: 10/27/2021 11:00:00 PM 14:35:44.681 EndDate: 10/29/2021 12:00:00 AM 14:35:44.682 BalanceImport: False 14:35:44.987 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:35:44.987 ExternalID: 14:35:44.988 StartDate: 10/28/2021 11:00:00 PM 14:35:44.988 EndDate: 10/30/2021 12:00:00 AM 14:35:44.988 BalanceImport: False 14:35:45.437 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:35:45.438 ExternalID: 14:35:45.438 StartDate: 10/29/2021 11:00:00 PM 14:35:45.439 EndDate: 10/31/2021 12:00:00 AM 14:35:45.439 BalanceImport: False 14:35:45.641 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:35:45.642 ExternalID: 14:35:45.642 StartDate: 10/30/2021 11:00:00 PM 14:35:45.643 EndDate: 11/1/2021 12:00:00 AM 14:35:45.643 BalanceImport: False 14:35:46.569 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:35:46.570 ExternalID: 14:35:46.570 StartDate: 10/31/2021 11:00:00 PM 14:35:46.570 EndDate: 11/2/2021 12:00:00 AM 14:35:46.571 BalanceImport: False 14:36:11.164 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:36:11.165 ExternalID: 14:36:11.165 StartDate: 11/1/2021 11:00:00 PM 14:36:11.165 EndDate: 11/3/2021 12:00:00 AM 14:36:11.166 BalanceImport: False 14:36:37.419 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:36:37.420 ExternalID: 14:36:37.420 StartDate: 11/2/2021 11:00:00 PM 14:36:37.421 EndDate: 11/4/2021 12:00:00 AM 14:36:37.421 BalanceImport: False 14:37:06.972 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:37:06.973 ExternalID: 14:37:06.973 StartDate: 11/3/2021 11:00:00 PM 14:37:06.973 EndDate: 11/5/2021 12:00:00 AM 14:37:06.974 BalanceImport: False 14:37:33.444 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:37:33.444 ExternalID: 14:37:33.444 StartDate: 11/4/2021 11:00:00 PM 14:37:33.445 EndDate: 11/6/2021 12:00:00 AM 14:37:33.445 BalanceImport: False 14:38:03.049 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:38:03.049 ExternalID: 14:38:03.049 StartDate: 11/5/2021 11:00:00 PM 14:38:03.050 EndDate: 11/7/2021 12:00:00 AM 14:38:03.050 BalanceImport: False 14:38:03.347 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:38:03.347 ExternalID: 14:38:03.347 StartDate: 11/6/2021 11:00:00 PM 14:38:03.348 EndDate: 11/8/2021 12:00:00 AM 14:38:03.348 BalanceImport: False 14:38:04.615 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:38:04.615 ExternalID: 14:38:04.616 StartDate: 11/7/2021 11:00:00 PM 14:38:04.616 EndDate: 11/9/2021 12:00:00 AM 14:38:04.616 BalanceImport: False 14:38:33.129 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:38:33.130 ExternalID: 14:38:33.130 StartDate: 11/8/2021 11:00:00 PM 14:38:33.130 EndDate: 11/10/2021 12:00:00 AM 14:38:33.130 BalanceImport: False 14:38:58.933 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:38:58.934 ExternalID: 14:38:58.934 StartDate: 11/9/2021 11:00:00 PM 14:38:58.934 EndDate: 11/11/2021 12:00:00 AM 14:38:58.935 BalanceImport: False 14:39:25.232 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:39:25.233 ExternalID: 14:39:25.233 StartDate: 11/10/2021 11:00:00 PM 14:39:25.233 EndDate: 11/12/2021 12:00:00 AM 14:39:25.234 BalanceImport: False 14:39:52.192 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:39:52.193 ExternalID: 14:39:52.193 StartDate: 11/11/2021 11:00:00 PM 14:39:52.194 EndDate: 11/13/2021 12:00:00 AM 14:39:52.194 BalanceImport: False 14:40:21.658 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:40:21.658 ExternalID: 14:40:21.659 StartDate: 11/12/2021 11:00:00 PM 14:40:21.659 EndDate: 11/14/2021 12:00:00 AM 14:40:21.659 BalanceImport: False 14:40:22.131 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:40:22.132 ExternalID: 14:40:22.132 StartDate: 11/13/2021 11:00:00 PM 14:40:22.133 EndDate: 11/15/2021 12:00:00 AM 14:40:22.133 BalanceImport: False 14:40:23.125 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:40:23.125 ExternalID: 14:40:23.126 StartDate: 11/14/2021 11:00:00 PM 14:40:23.126 EndDate: 11/16/2021 12:00:00 AM 14:40:23.126 BalanceImport: False 14:40:51.087 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:40:51.088 ExternalID: 14:40:51.088 StartDate: 11/15/2021 11:00:00 PM 14:40:51.088 EndDate: 11/17/2021 12:00:00 AM 14:40:51.089 BalanceImport: False 14:41:19.583 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:41:19.584 ExternalID: 14:41:19.584 StartDate: 11/16/2021 11:00:00 PM 14:41:19.584 EndDate: 11/18/2021 12:00:00 AM 14:41:19.585 BalanceImport: False 14:41:49.587 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:41:49.587 ExternalID: 14:41:49.588 StartDate: 11/17/2021 11:00:00 PM 14:41:49.588 EndDate: 11/19/2021 12:00:00 AM 14:41:49.588 BalanceImport: False 14:42:04.685 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:42:04.685 ExternalID: 14:42:04.686 StartDate: 11/18/2021 11:00:00 PM 14:42:04.686 EndDate: 11/20/2021 12:00:00 AM 14:42:04.686 BalanceImport: False 14:42:04.821 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:42:04.822 ExternalID: 14:42:04.822 StartDate: 11/19/2021 11:00:00 PM 14:42:04.822 EndDate: 11/21/2021 12:00:00 AM 14:42:04.823 BalanceImport: False 14:42:04.908 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:42:04.908 ExternalID: 14:42:04.909 StartDate: 11/20/2021 11:00:00 PM 14:42:04.909 EndDate: 11/22/2021 12:00:00 AM 14:42:04.909 BalanceImport: False 14:42:05.012 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:42:05.012 ExternalID: 14:42:05.012 StartDate: 11/21/2021 11:00:00 PM 14:42:05.013 EndDate: 11/23/2021 12:00:00 AM 14:42:05.013 BalanceImport: False 14:42:05.132 RequestTransactions: 3df76339-3df8-4583-88e1-194c25b37120 14:42:05.132 ExternalID: 14:42:05.132 StartDate: 11/22/2021 11:00:00 PM 14:42:05.133 EndDate: 11/24/2021 2:24:14 PM 14:42:05.133 BalanceImport: False 17:00:01.476 DBServer: DevTestVM 17:00:01.476 DBName: APITestWhitmore 17:00:01.477 UserName: vericool1 17:00:01.477 Password: v3r1c00l1 17:00:01.477 got here 5 17:00:01.488 constring is : data source=DevTestVM;initial catalog=APITestWhitmore;user id=vericool1;password=v3r1c00l1;MultipleActiveResultSets=True;App=EntityFramework 17:00:01.494 Connection String is : metadata=res://*/CCDb.csdl|res://*/CCDb.ssdl|res://*/CCDb.msl;provider=System.Data.SqlClient;provider connection string="data source=DevTestVM;initial catalog=APITestWhitmore;user id=vericool1;password=v3r1c00l1;MultipleActiveResultSets=True;App=EntityFramework" 17:00:01.654 Connection String is : metadata=res://*/CCDb.csdl|res://*/CCDb.ssdl|res://*/CCDb.msl;provider=System.Data.SqlClient;provider connection string="data source=DevTestVM;initial catalog=APITestWhitmore;user id=vericool1;password=v3r1c00l1;MultipleActiveResultSets=True;App=EntityFramework" 17:00:02.339 GetCustomers count: 1506 17:00:03.177 RequestTransactions: 319d2c92-ddb7-4b30-8ffc-97a20657cf33 17:00:03.178 ExternalID: 17:00:03.178 StartDate: 11/18/2021 11:00:00 PM 17:00:03.179 EndDate: 11/20/2021 12:00:00 AM 17:00:03.179 BalanceImport: False 17:00:03.309 RequestTransactions: 319d2c92-ddb7-4b30-8ffc-97a20657cf33 17:00:03.310 ExternalID: 17:00:03.310 StartDate: 11/19/2021 11:00:00 PM 17:00:03.310 EndDate: 11/21/2021 12:00:00 AM 17:00:03.311 BalanceImport: False 17:00:03.423 RequestTransactions: 319d2c92-ddb7-4b30-8ffc-97a20657cf33 17:00:03.423 ExternalID: 17:00:03.424 StartDate: 11/20/2021 11:00:00 PM 17:00:03.424 EndDate: 11/22/2021 12:00:00 AM 17:00:03.424 BalanceImport: False 17:00:04.075 RequestTransactions: 319d2c92-ddb7-4b30-8ffc-97a20657cf33 17:00:04.075 ExternalID: 17:00:04.076 StartDate: 11/21/2021 11:00:00 PM 17:00:04.076 EndDate: 11/23/2021 12:00:00 AM 17:00:04.076 BalanceImport: False 17:00:04.205 RequestTransactions: 319d2c92-ddb7-4b30-8ffc-97a20657cf33 17:00:04.205 ExternalID: 17:00:04.205 StartDate: 11/22/2021 11:00:00 PM 17:00:04.206 EndDate: 11/24/2021 5:00:00 PM 17:00:04.206 BalanceImport: False