Projects: Deleting In planning projects (error messages- nothing shown) Trace shows Database issue

Good day,

I am getting an error message (with no information) when I tried to delete an in planning project,  The trace is showing some issues with table.  I am unfamiliar with troubleshooting these types of issues.  Please see the trace details below.

Any assistance we would greatly appreciated.  These are projects entered prior to the upgrade to 2023R2.

Thank you.

Evan

System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.

   at System.ThrowHelper.ThrowKeyNotFoundException()

   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)

   at PX.Data.ReferentialIntegrity.Merging.ReferenceMerger.MergeReferences(IEnumerable`1 mergingTypes, Func`2 getReferencesFor, Boolean childrenSubstitution)

   at PX.Data.ReferentialIntegrity.Merging.ReferenceMerger.MergeReferences(IReadOnlyDictionary`2 collectedReferences)

   at PX.Data.ReferentialIntegrity.Merging.TableMergedReferencesInspector.<>c__DisplayClass3_0.<.ctor>b__0(Task _)

   at System.Threading.Tasks.ContinuationResultTaskFromTask`1.InnerInvoke()

   at System.Threading.Tasks.Task.Execute()

System.AggregateException: One or more errors occurred. ---> System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.

   at System.ThrowHelper.ThrowKeyNotFoundException()

   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)

   at PX.Data.ReferentialIntegrity.Merging.ReferenceMerger.MergeReferences(IEnumerable`1 mergingTypes, Func`2 getReferencesFor, Boolean childrenSubstitution)

   at PX.Data.ReferentialIntegrity.Merging.ReferenceMerger.MergeReferences(IReadOnlyDictionary`2 collectedReferences)

   at PX.Data.ReferentialIntegrity.Merging.TableMergedReferencesInspector.<>c__DisplayClass3_0.<.ctor>b__0(Task _)

   at System.Threading.Tasks.ContinuationResultTaskFromTask`1.InnerInvoke()

   at System.Threading.Tasks.Task.Execute()

   --- End of inner exception stack trace ---

   at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)

   at PX.Data.ReferentialIntegrity.Merging.TableMergedReferencesInspector.<>c.<.ctor>b__3_1(Task`1 mergeTask)

   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()

   at System.Threading.Tasks.Task.Execute()

---> (Inner Exception #0) System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.

   at System.ThrowHelper.ThrowKeyNotFoundException()

   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)

   at PX.Data.ReferentialIntegrity.Merging.ReferenceMerger.MergeReferences(IEnumerable`1 mergingTypes, Func`2 getReferencesFor, Boolean childrenSubstitution)

   at PX.Data.ReferentialIntegrity.Merging.ReferenceMerger.MergeReferences(IReadOnlyDictionary`2 collectedReferences)

   at PX.Data.ReferentialIntegrity.Merging.TableMergedReferencesInspector.<>c__DisplayClass3_0.<.ctor>b__0(Task _)

   at System.Threading.Tasks.ContinuationResultTaskFromTask`1.InnerInvoke()

   at System.Threading.Tasks.Task.Execute()<---

   at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)

   at PX.Data.ReferentialIntegrity.Merging.TableMergedReferencesInspector.GetIncomingReferencesApplicableTo(Type bqlTable)

   at PX.Data.ReferentialIntegrity.Attributes.Handlers.ParentDeletingHandler.GetReferencesToHandle(Type tableToHandle, IEnumerable`1 alreadyHandledDescendants)

   at PX.Data.ReferentialIntegrity.Attributes.Handlers.ParentDeletingHandler.HandleImpl()

   at PX.Data.ReferentialIntegrity.Attributes.PXReferentialIntegrityCheckAttribute.HandleChildrenRows(PXCache cache, Object parentRow, Boolean persisting)

   at PX.Data.PXCache.AttributeHandlersSquasher`1.<>c__DisplayClass2_0`1.<To>b__0(PXCache cache, TArgs args)

   at PX.Data.PXCache.OnRowDeleting(Object item, Boolean externalCall)

   at PX.Data.PXCache`1.Delete(Object data, Boolean bypassinterceptor)

   at PX.Data.PXParentAttribute.RowDeleted(PXCache sender, PXRowDeletedEventArgs e)

   at PX.Data.PXRowDeleted.Invoke(PXCache sender, PXRowDeletedEventArgs e)

   at PX.Data.PXCache.OnRowDeleted(Object item, Boolean externalCall)

   at PX.Data.PXCache`1.Delete(Object data, Boolean bypassinterceptor)

   at PX.Data.PXSelectBase`1.Delete(Table item)

   at PX.Objects.PM.ProjectEntry.<delete>b__192_0()

   at PX.Concurrency.CancellationIgnorantExtensions.RunWithCancellationViaThreadAbort(Action method, CancellationToken cancellationToken)

   at PX.Concurrency.CancellationIgnorantExtensions.<>c__DisplayClass1_0.<ToCancellationViaThreadAbort>b__0(CancellationToken cancellationToken)

   at PX.Concurrency.Internal.PXLongOperationPars.PopAndRunDelegate(CancellationToken cancellationToken)

   at PX.Concurrency.Internal.RuntimeLongOperationManager.PerformOperation(PXLongOperationPars p)

System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.

   at System.ThrowHelper.ThrowKeyNotFoundException()

   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)

   at PX.Data.ReferentialIntegrity.Merging.ReferenceMerger.MergeReferences(IEnumerable`1 mergingTypes, Func`2 getReferencesFor, Boolean childrenSubstitution)

   at PX.Data.ReferentialIntegrity.Merging.ReferenceMerger.MergeReferences(IReadOnlyDictionary`2 collectedReferences)

   at PX.Data.ReferentialIntegrity.Merging.TableMergedReferencesInspector.<>c__DisplayClass3_0.<.ctor>b__0(Task _)

   at System.Threading.Tasks.ContinuationResultTaskFromTask`1.InnerInvoke()

   at System.Threading.Tasks.Task.Execute()

System.AggregateException: One or more errors occurred. ---> System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.

   at System.ThrowHelper.ThrowKeyNotFoundException()

   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)

   at PX.Data.ReferentialIntegrity.Merging.ReferenceMerger.MergeReferences(IEnumerable`1 mergingTypes, Func`2 getReferencesFor, Boolean childrenSubstitution)

   at PX.Data.ReferentialIntegrity.Merging.ReferenceMerger.MergeReferences(IReadOnlyDictionary`2 collectedReferences)

   at PX.Data.ReferentialIntegrity.Merging.TableMergedReferencesInspector.<>c__DisplayClass3_0.<.ctor>b__0(Task _)

   at System.Threading.Tasks.ContinuationResultTaskFromTask`1.InnerInvoke()

   at System.Threading.Tasks.Task.Execute()

   --- End of inner exception stack trace ---

   at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)

   at PX.Data.ReferentialIntegrity.Merging.TableMergedReferencesInspector.<>c.<.ctor>b__3_1(Task`1 mergeTask)

   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()

   at System.Threading.Tasks.Task.Execute()

---> (Inner Exception #0) System.Collections.Generic.KeyNotFoundException: The given key was not present in the dictionary.

   at System.ThrowHelper.ThrowKeyNotFoundException()

   at System.Collections.Generic.Dictionary`2.get_Item(TKey key)

   at PX.Data.ReferentialIntegrity.Merging.ReferenceMerger.MergeReferences(IEnumerable`1 mergingTypes, Func`2 getReferencesFor, Boolean childrenSubstitution)

   at PX.Data.ReferentialIntegrity.Merging.ReferenceMerger.MergeReferences(IReadOnlyDictionary`2 collectedReferences)

   at PX.Data.ReferentialIntegrity.Merging.TableMergedReferencesInspector.<>c__DisplayClass3_0.<.ctor>b__0(Task _)

   at System.Threading.Tasks.ContinuationResultTaskFromTask`1.InnerInvoke()

   at System.Threading.Tasks.Task.Execute()<---

   at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)

   at PX.Data.ReferentialIntegrity.Merging.TableMergedReferencesInspector.GetIncomingReferencesApplicableTo(Type bqlTable)

   at PX.Data.ReferentialIntegrity.Attributes.Handlers.ParentDeletingHandler.GetReferencesToHandle(Type tableToHandle, IEnumerable`1 alreadyHandledDescendants)

   at PX.Data.ReferentialIntegrity.Attributes.Handlers.ParentDeletingHandler.HandleImpl()

   at PX.Data.ReferentialIntegrity.Attributes.PXReferentialIntegrityCheckAttribute.HandleChildrenRows(PXCache cache, Object parentRow, Boolean persisting)

   at PX.Data.PXCache.AttributeHandlersSquasher`1.<>c__DisplayClass2_0`1.<To>b__0(PXCache cache, TArgs args)

   at PX.Data.PXCache.OnRowDeleting(Object item, Boolean externalCall)

   at PX.Data.PXCache`1.Delete(Object data, Boolean bypassinterceptor)

   at PX.Data.PXParentAttribute.RowDeleted(PXCache sender, PXRowDeletedEventArgs e)

   at PX.Data.PXRowDeleted.Invoke(PXCache sender, PXRowDeletedEventArgs e)

   at PX.Data.PXCache.OnRowDeleted(Object item, Boolean externalCall)

   at PX.Data.PXCache`1.Delete(Object data, Boolean bypassinterceptor)

   at PX.Data.PXSelectBase`1.Delete(Table item)

   at PX.Objects.PM.ProjectEntry.<delete>b__192_0()

   at PX.Concurrency.CancellationIgnorantExtensions.RunWithCancellationViaThreadAbort(Action method, CancellationToken cancellationToken)

   at PX.Concurrency.CancellationIgnorantExtensions.<>c__DisplayClass1_0.<ToCancellationViaThreadAbort>b__0(CancellationToken cancellationToken)

   at PX.Concurrency.Internal.PXLongOperationPars.PopAndRunDelegate(CancellationToken cancellationToken)

   at PX.Concurrency.Internal.RuntimeLongOperationManager.PerformOperation(PXLongOperationPars p)