FK Exception clearing Managed Operation Log

StatusIDPriorityType
Closed25702BlockerBug
ProfileReply
Scott GrossClient

I keep getting:
The DELETE statement conflicted with the REFERENCE constraint "FK_LogStorage_OwnerOperation". The conflict occurred in database "VIPR_Dev", table "dbo.LogStorage", column 'OwnerOperation'.
The statement has been terminated.

any ideas?

Replies

UserDescriptionPosted On
Sasha (Xafari Support)Client

Hello Scott,

Thanks for the ticket.
We apologize for the delayed response.

The reason of the issue is that the structure of LogStorage table and the ManagedOperationStorage table has been changed a bit in Xafari version 10.
The FK_LogStorage_OwnerOperation foreign key of the LogStorage table is no longer needed.
Please, remove it manually in your DB:
Table: dbo.LogStorage
Key: FK_LogStorage_OwnerOperation

On MSSQL Server you can execute the following script:

USE [YOUR_DATABASE]
GO
ALTER TABLE [dbo].[LogStorage] DROP CONSTRAINT [FK_LogStorage_OwnerOperation]
GO

Let us know if you need further assistance.
Regards,
Sasha.

× This ticket is closed.

Write US