-
Title
The INSERT statement conflicted with the FOREIGN KEY constraint -
Description
When opening ApexSQL Audit main GUI an unexpected error comes up when you try to select any of the options inside the application.
While running the ApexSQL.Audit.Installer to reset the connection to the Central Repository database, the following error comes up
The INSERT statement conflicted with the FOREIGN KEY constraint. The conflict occurred in database "ApexSQLCRD" table "ApexSQLAudit.EncryptionKey", column "ID".
-
Cause
This issue is caused by an interruption of the archiving process of the Central Repository Database due to space error or other cause that breaks the encryption of the Central Repository. -
Resolution
- Connect to the SQL Server Instance where the Central Repository Database resides.
- Right click the ApexSQLCrd database and bring it offline.
- Delete or move the database
- Run the ApexSQ.Audit.Installer.exe as admin (this is located in C:\Program Files\ApexSQL\ApexSQL Audit)
- Setup a new Central Repository Database.
- Open the main GUI and validate the application is running correctly.
Note: With this process all auditing configuration will be lost, be sure to have a previous backup of the auditing configuration saved. Another workaround is to rename any of the existing ApexSqlCrd archives existing in the same SQL Server to "ApexSqlCrd" and the connect via the main GUI, this way the auditing configuration will not be lost.