Deleted object would be re-saved by cascade (remove deleted object from associations)

Survey Management
1

Could anyone give me some insight why I am getting broken interviews:

deleted object would be re-saved by cascade (remove deleted object from associations)[WB.Core.BoundedContexts.Headquarters.Views.Interview.InterviewGps#85899] at NHibernate.Impl.SessionImpl.ForceFlush(EntityEntry entityEntry)
at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.EntityIsTransient(SaveOrUpdateEvent event)
at NHibernate.Event.Default.DefaultSaveOrUpdateEventListener.OnSaveOrUpdate(SaveOrUpdateEvent event)
at NHibernate.Impl.SessionImpl.FireSaveOrUpdate(SaveOrUpdateEvent event)
at NHibernate.Impl.SessionImpl.SaveOrUpdate(String entityName, Object obj)
at NHibernate.Engine.CascadingAction.SaveUpdateCascadingAction.Cascade(IEventSource session, Object child, String entityName, Object anything, Boolean isCascadeDeleteEnabled)
at NHibernate.Engine.Cascade.CascadeToOne(Object parent, Object child, IType type, CascadeStyle style, Object anything, Boolean isCascadeDeleteEnabled)
at NHibernate.Engine.Cascade.CascadeCollectionElements(Object parent, Object child, CollectionType collectionType, CascadeStyle style, IType elemType, Object anything, Boolean isCascadeDeleteEnabled)
at NHibernate.Engine.Cascade.CascadeCollection(Object parent, Object child, CascadeStyle style, Object anything, CollectionType type)
at NHibernate.Engine.Cascade.CascadeOn(IEntityPersister persister, Object parent, Object anything)
at NHibernate.Event.Default.AbstractFlushingEventListener.CascadeOnFlush(IEventSource session, IEntityPersister persister, Object key, Object anything)
at NHibernate.Event.Default.AbstractFlushingEventListener.PrepareEntityFlushes(IEventSource session)
at NHibernate.Event.Default.AbstractFlushingEventListener.FlushEverythingToExecutions(FlushEvent event)
at NHibernate.Event.Default.DefaultFlushEventListener.OnFlush(FlushEvent event)
at NHibernate.Impl.SessionImpl.Flush()
at NHibernate.Impl.SessionImpl.BeforeTransactionCompletion(ITransaction tx)
at NHibernate.Transaction.AdoTransaction.Commit()
at WB.Infrastructure.Native.Storage.Postgre.UnitOfWork.Dispose()
at Autofac.Core.Disposer.Dispose(Boolean disposing)
at Autofac.Util.Disposable.Dispose()
at Autofac.Core.Lifetime.LifetimeScope.Dispose(Boolean disposing)
at Autofac.Util.Disposable.Dispose()
at WB.Core.BoundedContexts.Headquarters.Implementation.UnitOfWorkInScopeExecutor.Execute(Action1 action, String workspace) at WB.Core.GenericSubdomains.Portable.NamedLocker.RunWithLock(String name, Action body) at WB.Core.Infrastructure.CommandBus.Implementation.CommandService.ExecuteImpl(ICommand command, String origin, CancellationToken cancellationToken) at WB.Core.Infrastructure.CommandBus.Implementation.CommandService.Execute(ICommand command, String origin) at WB.Core.BoundedContexts.Headquarters.Implementation.Synchronization.InterviewPackagesService.<>c__DisplayClass22_0.b__0(IServiceLocator serviceLocator) at WB.Core.BoundedContexts.Headquarters.Implementation.UnitOfWorkInScopeExecutor.Execute(Action1 action, String workspace)
at WB.Core.BoundedContexts.Headquarters.Implementation.Synchronization.InterviewPackagesService.ProcessPackage(InterviewPackage interview)

Regards
Danie

2

The error is related to a database inconsistency.
This may be the result of deleting something in one table while it’s being referenced in another table.
Have you deleted anything ? or did any manual manipulation to the DB?

3

HI Sergiy,
That makes sense, Yes I got assistance and there were records deleted due to a bad sector on the drive that became corrupt.

Regards
Danie

4

Hi Sergiy,
This same error is now on other servers where the DB has not been touched, are you aware of any such cases reported by anyone else?

5

What version of Survey Solutions do you use?
Could you update your installation to the latest one and reprocess the sync package?