Conflict with the Foreign Key constraint occurs when updating Deep Security SQL Database Schema

- Updated:
- 14 Jul 2017
- Product/Version:
- Deep Security 9.5
- Deep Security 9.6
- Platform:
- N/A N/A

Summary

During the Deep Security Manager (DSM) SQL Database (DB) Schema update, the process may fail showing an error in the DSM console. Upon checking the DSM serverx.log, the following may appear:

The INSERT statement conflicted with the FOREIGN KEY constraint

Details

The error above appears due to missing database constraints. To resolve the issue, follow the article appropriate for your product version:

Rating:

Category:

Troubleshoot

Solution Id:

1117721

Feedback

Did this article help you?

Thank you for your feedback!

What was the problem with this article?

The image(s) in the article did not display properly.

The article did not provide detailed procedure.

The article is hard to understand and follow.

The video did not play properly.

The article did not resolve my issue.

Others. Please specify.

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:

We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.

If you need additional help, you may try to contact the support team. Contact Support

Thanks for voting.

To help us improve the quality of this article, please leave your email here so we can clarify further your feedback, if neccessary:

We will not send you spam or share your email address.

*This form is automated system. General questions, technical, sales, and product-related issues submitted through this form will not be answered.