It finds it, but after hitting import and choosing "All Time" timeframe, it just takes me back to the main view and doesn't import any hands.
I also tried importing from the postgresql db directly and in that case I see the progress bar, but it never imports any hands and runs indefinitely. I'm also unable to click the "Stop" button:
Code:
{"@t":"2023-07-24T02:20:44.8094020Z","@mt":"Hand2Note version: 4.0.0"}
{"@t":"2023-07-24T02:20:44.8587830Z","@mt":"Enviroment: {\"Model\":\"x86_64\",\"Manufacturer\":\"Apple\",\"Name\":\"iPad\",\"VersionString\":\"16.5\",\"Version\":\"16.5\",\"Platform\":{},\"Idiom\":{},\"DeviceType\":1}"}
{"@t":"2023-07-24T02:21:14.6521430Z","@mt":"Import from database started."}
{"@t":"2023-07-24T02:21:14.6579570Z","@mt":"DISPATCH ImportProgressUpdatedEvent"}
{"@t":"2023-07-24T02:21:14.6653190Z","@mt":"START BUILDING statistics"}
{"@t":"2023-07-24T02:21:14.6654450Z","@mt":"No hands to build in the database"}
{"@t":"2023-07-24T02:21:14.6739680Z","@mt":"DISPATCH ImportProgressUpdatedEvent"}
{"@t":"2023-07-24T02:21:14.7372180Z","@mt":"In UnobservedTaskException Handler:\n System.Threading.Tasks.Task`1[System.ValueTuple`2[System.Int32,System.Int32]] - System.AggregateException: TaskExceptionHolder_UnhandledException (AggregateException_ctor_DefaultMessage (42P01: relation \"public.cash_hand_histories\" does not exist\n\nPOSITION: 21))\n ---> System.AggregateException: AggregateException_ctor_DefaultMessage (42P01: relation \"public.cash_hand_histories\" does not exist\n\nPOSITION: 21)\n ---> Npgsql.PostgresException (0x80004005): 42P01: relation \"public.cash_hand_histories\" does not exist\n\nPOSITION: 21\n at Npgsql.Internal.NpgsqlConnector.<ReadMessage>g__ReadMessageLong|211_0(NpgsqlConnector connector, Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)\n at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming, CancellationToken cancellationToken)\n at Npgsql.NpgsqlDataReader.NextResult()\n at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)\n at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)\n at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior behavior)\n at Hand2NoteCore.Importing.ImportFromDatabaseDialogHelper.GetPt4HandHistories(NpgsqlConnectionStringBuilder connectionString, String databaseRequest)+MoveNext()\n at Hand2NoteCore.Common.Collections.<SplitBy>d__89`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]].MoveNext()\n at System.Linq.Parallel.PartitionedDataSource`1.ContiguousChunkLazyEnumerator[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].MoveNext(List`1& currentElement, Int32& currentKey)\n at System.Linq.Parallel.ForAllOperator`1.ForAllEnumerator`1[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.Int32, System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].MoveNext(List`1& currentElement, Int32& currentKey)\n at System.Linq.Parallel.ForAllSpoolingTask`2[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.Int32, System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].SpoolingWork()\n at System.Linq.Parallel.SpoolingTaskBase.Work()\n at System.Linq.Parallel.QueryTask.BaseWork(Object unused)\n at System.Linq.Parallel.QueryTask.<>c.<.cctor>b__10_0(Object o)\n at System.Threading.Tasks.Task.InnerInvoke()\n at System.Threading.Tasks.Task.<>c.<.cctor>b__273_0(Object obj)\n at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state)\n--- End of stack trace from previous location ---\n at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state)\n at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)\n Exception data:\n Severity: ERROR\n SqlState: 42P01\n MessageText: relation \"public.cash_hand_histories\" does not exist\n Position: 21\n File: parse_relation.c\n Line: 1363\n Routine: parserOpenTable\n Exception_EndOfInnerExceptionStack\n at System.Linq.Parallel.QueryTaskGroupState.QueryEnd(Boolean userInitiatedDispose)\n at System.Linq.Parallel.SpoolingTask.SpoolForAll[List`1,Int32](QueryTaskGroupState groupState, PartitionedStream`2 partitions, TaskScheduler taskScheduler)\n at System.Linq.Parallel.DefaultMergeHelper`2[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.Int32, System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].System.Linq.Parallel.IMergeHelper<TInputOutput>.Execute()\n at System.Linq.Parallel.MergeExecutor`1[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].Execute()\n at System.Linq.Parallel.MergeExecutor`1[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].Execute[Int32](PartitionedStream`2 partitions, Boolean ignoreOutput, ParallelMergeOptions options, TaskScheduler taskScheduler, Boolean isOrdered, CancellationState cancellationState, Int32 queryId)\n at System.Linq.Parallel.PartitionedStreamMerger`1[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].Receive[Int32](PartitionedStream`2 partitionedStream)\n at System.Linq.Parallel.ForAllOperator`1[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].WrapPartitionedStream[Int32](PartitionedStream`2 inputStream, IPartitionedStreamRecipient`1 recipient, Boolean preferStriping, QuerySettings settings)\n at System.Linq.Parallel.UnaryQueryOperator`2.UnaryQueryOperatorResults.ChildResultsRecipient[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].Receive[Int32](PartitionedStream`2 inputStream)\n at System.Linq.Parallel.ScanQueryOperator`1.ScanEnumerableQueryOperatorResults[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].GivePartitionedStream(IPartitionedStreamRecipient`1 recipient)\n at System.Linq.Parallel.UnaryQueryOperator`2.UnaryQueryOperatorResults[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].GivePartitionedStream(IPartitionedStreamRecipient`1 recipient)\n at System.Linq.Parallel.QueryOperator`1[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].GetOpenedEnumerator(Nullable`1 mergeOptions, Boolean suppressOrder, Boolean forEffect, QuerySettings querySettings)\n at System.Linq.Parallel.ForAllOperator`1[[System.Collections.Generic.List`1[[Hand2NoteCore.Importing.HandHistoryFromDatabase, Hand2NoteCore, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].RunSynchronously()\n at System.Linq.ParallelEnumerable.ForAll[List`1](ParallelQuery`1 source, Action`1 action)\n at Hand2NoteCore.Importing.ImportFromDatabaseDialogHelper.ImportFromDatabase(ImportOperation importOperation, DatabaseData databaseData)\n at Hand2NoteCore.Importing.ImportFromDatabaseDialogHelper.<>c__DisplayClass14_1.<ImportDataFromOtherTrackerDatabaseWithDialog>b__1(ImportOperation importOperation)\n at Hand2NoteCore.Importing.ImportHelper.Import(Import import, Action`1 importAction)\n at Hand2NoteCore.AppHelper.<>c__DisplayClass69_0.<ImportHands>b__1()\n at System.Threading.Tasks.Task`1[[System.ValueTuple`2[[System.Int32, System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e],[System.Int32, System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]], System.Private.CoreLib, Version=7.0.0.0, Culture=neutral, PublicKeyToken=7cec85d7bea7798e]].InnerInvoke()\n at System.Threading.Tasks.Task.<>c.<.cctor>b__273_0(Object obj)\n at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state)\n--- End of stack trace from previous location ---\n at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state)\n at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)\n Exception_EndOfInnerExceptionStack","@l":"Error"}
{"@t":"2023-07-24T02:21:14.7382030Z","@mt":"AggregateException_ctor_DefaultMessage (42P01: relation \"public.cash_hand_histories\" does not exist\n\nPOSITION: 21)","@l":"Error"}
{"@t":"2023-07-24T02:21:14.7384860Z","@mt":"System.Linq.Parallel","@l":"Error"}
{"@t":"2023-07-24T02:21:14.7418360Z","@mt":"{}","@l":"Error"}
I only have tournament hands, no cash hands in the DB - not sure if thats leading to issues...