Error,Processor,<no principal>,An error occurred while updating the entries. The DELETE statement conflicted with the REFERENCE constraint "FK_dbo.Ews

[mike_meirovitz]

Hi,

Our customer in Chile is facing an exception in SmartConnector. See below.

2022-08-01 15:13:46.3962,Debug,EwsServe,admin,{"Response":{"GetNotificationResponse":{"SubscriptionId":"9E7521CC227D4575940D79DE08DCB36E","NotificationId":"5D101BBCB88D42E79D6B230371F7358B","MoreDataAvailable":false,"MoreDataRef":null,"Events":{"AlarmEvents":null},"version":"1.2"}},"Duration":"448"},
2022-08-01 15:13:46.6080,Error,Processor,<no principal>,An error occurred while updating the entries. See the inner exception for details.
An error occurred while updating the entries. See the inner exception for details.
The DELETE statement conflicted with the REFERENCE constraint "FK_dbo.EwsNotifications_dbo.EwsSubscriptions_SubscriptionId". The conflict occurred in database "SmartConnector.Service", table "dbo.EwsNotifications", column 'SubscriptionId'.
The statement has been terminated.
at System.Data.Entity.Internal.InternalContext.SaveChanges()
at System.Data.Entity.Internal.LazyInternalContext.SaveChanges()
at Mongoose.Service.Data.MongooseDbContext.SaveChanges()
at Mongoose.Service.Data.MongooseDbContext.Mongoose.Common.Data.IDataSource<Mongoose.Ews.Server.Data.EwsContainerItem>.Save()
at Mongoose.Ews.Server.Data.EwsServerDataAdapter.Purge_Internal(Boolean purgeUsers)
at SmartConnector.EBOOPCClient.SetupProcessor.Execute_Subclass()
at Mongoose.Process.Processor.Execute(CancellationToken token, ProcessorExecutionMode mode)
,["EBO-OPC Client Setup Processor"],

Can you please advise?

See the attached SmartConnector log file.

Thank you.

Mike