A team member pointed out that this may be coming back from SQLEXPRESS.  Investigating that....

Well, the DB is SQLEXPRESS, but after shrinking DB, the issue is still happening, so I don't think that it's related.

Also, we have other SalesForce Readers which are working correctly.  It seems to be limited to pulling these types of records (User object).

Hi Randy,

Please try restarting the server.

I'm still seeing similar issues after server restart.

Here's the full log from Errors.txt:

2022-09-09 14:07:04:422 - System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpResponse.Redirect(String url, Boolean endResponse)
at System.Web.HttpResponse.Redirect(String url)
at Realisable.IManWebUI.DesignPage.Page_Load(Object sender, EventArgs e)

2022-09-09 14:07:21:628 - System.IO.FileNotFoundException: Could not load file or assembly 'Sage.Reporting.Engine.Integration, Version=1.0.0.5, Culture=neutral, PublicKeyToken=0a4a2ad97614f98d' or one of its dependencies. The system cannot find the file specified.
File name: 'Sage.Reporting.Engine.Integration, Version=1.0.0.5, Culture=neutral, PublicKeyToken=0a4a2ad97614f98d'
at System.Reflection.RuntimeAssembly.GetExportedTypes(RuntimeAssembly assembly, ObjectHandleOnStack retTypes)
at System.Reflection.RuntimeAssembly.GetExportedTypes()
at Realisable.Connectors.CustomConnectorLoader.LoadAddin(String connectorFileName)
at Realisable.Connectors.MetaPresenterInterop.MetaPresenterInterop.LoadConnector(String assemblyFile)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

2022-09-09 14:07:22:003 - System.IO.FileNotFoundException: Could not load file or assembly 'Sage.Reporting.Engine.Integration, Version=1.0.0.5, Culture=neutral, PublicKeyToken=0a4a2ad97614f98d' or one of its dependencies. The system cannot find the file specified.
File name: 'Sage.Reporting.Engine.Integration, Version=1.0.0.5, Culture=neutral, PublicKeyToken=0a4a2ad97614f98d'
at System.Reflection.RuntimeAssembly.GetExportedTypes(RuntimeAssembly assembly, ObjectHandleOnStack retTypes)
at System.Reflection.RuntimeAssembly.GetExportedTypes()
at Realisable.Connectors.CustomConnectorLoader.LoadAddin(String connectorFileName)
at Realisable.Connectors.MetaPresenterInterop.MetaPresenterInterop.LoadConnector(String assemblyFile)

WRN: Assembly binding logging is turned OFF.
To enable assembly bind failure logging, set the registry value [HKLM\Software\Microsoft\Fusion!EnableLog] (DWORD) to 1.
Note: There is some performance penalty associated with assembly bind failure logging.
To turn this feature off, remove the registry value [HKLM\Software\Microsoft\Fusion!EnableLog].

2022-09-09 14:07:43:697 - System.Threading.Tasks.TaskSchedulerException: An exception was thrown by a TaskScheduler. ---> System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown.
at System.Threading.Thread.StartInternal(IPrincipal principal, StackCrawlMark& stackMark)
at System.Threading.Thread.Start(StackCrawlMark& stackMark)
at System.Threading.Thread.Start(Object parameter)
at System.Threading.Tasks.ThreadPoolTaskScheduler.QueueTask(Task task)
at System.Threading.Tasks.Task.ScheduleAndStart(Boolean needsProtection)
--- End of inner exception stack trace ---
at System.Threading.Tasks.Task.ScheduleAndStart(Boolean needsProtection)
at System.Threading.Tasks.Task.InternalStartNew(Task creatingTask, Delegate action, Object state, CancellationToken cancellationToken, TaskScheduler scheduler, TaskCreationOptions options, InternalTaskOptions internalOptions, StackCrawlMark& stackMark)
at System.Threading.Tasks.TaskFactory.StartNew(Action action)
at Realisable.Connectors.Salesforce.OldMetaDescriber.c__DisplayClass10_0.b__0(ChildRelationshipSmall relationship)
at System.Collections.Generic.List`1.ForEach(Action`1 action)
at Realisable.Connectors.Salesforce.OldMetaDescriber.GenerateDescriptions(DescribeSObjectResultSmall sObjectDescribe, CancellationTokenSource cts)
at Realisable.Connectors.Salesforce.OldMetaDescriber.GenerateDescriptions(String importId, Boolean isWrite, String lastQueried)
at Realisable.Connectors.Salesforce.RestMetaDataRetriever.GenerateMetaForImport(String importId, Boolean isWrite, String lastQueried)
at Realisable.Connectors.Salesforce.SyncedMetaRetriever.GenerateMetaForImport(String importId)
at Realisable.Connectors.Salesforce.PullMetaExtender.set_ImportType(String value)
at Realisable.Connectors.MetaPresenterInterop.MetaPresenterInterop.SetImportType(Boolean isReader, String assembly, String importId)

2022-09-09 14:11:11:536 - Realisable.Data.Transform.ReaderReadException: An error occurred whilst reading the source data. Error - Error writing log entry to message service for transform [UserReader]. Error - Could not load file or assembly 'System.Messaging, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Not enough storage is available to process this command. (Exception from HRESULT: 0x80070008). ---> Realisable.Data.Transform.AuditMessageException: Error writing log entry to message service for transform [UserReader]. Error - Could not load file or assembly 'System.Messaging, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. Not enough storage is available to process this command. (Exception from HRESULT: 0x80070008)
at Realisable.Data.Transform.TransformAuditController.WriteToMessageLog(ErrorEntry logEntry)
at Realisable.Data.Transform.TransformAuditController.WriteAuditLog(ErrorEntry logEntry)
at Realisable.Data.Transform.TransformAuditController.WriteAuditLog(String transformId, ErrorEntry logEntry)
at Realisable.Data.Transform.ReadStrategyCustomReaderHelper.LogException(String transformId, Exception exception, ITransformAuditController auditController)
at Realisable.Data.Transform.ReadStrategyCustomReader.ProcessSingleSource(BlockingQueue`1 transactionQueue, String systemId)
at Realisable.Data.Transform.ReadStrategyCustomReader.c__DisplayClass6_0.b__0(String systemId)
at System.Collections.Generic.List`1.ForEach(Action`1 action)
at Realisable.Data.Transform.ReadStrategyCustomReader.ReadData(BlockingQueue`1 transactionQueue)
at Realisable.Data.Transform.ReadStrategy.ReadData()
--- End of inner exception stack trace ---
at Realisable.Data.Transform.ReadStrategy.Read()
at Realisable.Data.Transform.TransformRead.Process()
at Realisable.Data.Transform.TransformControllerInterop.Process()

When I run the reader I opened Task Manager so I could watch the memory usage.  it stays steady in the mid 20s and never jumps more than 1 percentage.

Hello?