Database Execution Failure

Table 1. iAutomate Installer: Scenario 6
Issue Description Installation (Final Submission) – Database execution failure
Modules Impacted iAutomate Installer

Resolution Steps:

  1. If the failure is due to database, check the error.
  2. If the error is “Violation of UNIQUE KEY constraint 'IX_CodeMaster'. Cannot insert duplicate key in object 'dbo.CodeMaster'. The duplicate key value is (secret manager).”, then it is issue due to multiple times execution of DB scripts.
  3. To resolve this error, go to iAutomateDB database and run below command.
    IF EXISTS (SELECT 1 FROM CodeMaster WHERE Code='secret manager')
BEGIN
DELETE FROM CodeMaster WHERE Code='secret manager'
END
GO
  4. After executing the above script, run the installer again.
  5. If the same issue persists, then perform the above steps again.