Hi @ll,
Recently I've installed ESET plugin for Kaseya VSA. I'm running OnPremise version of VSA.
After installation was complete I did re-apply database schema - the process was completed successfully - as expected.
Unfortunately when I'm trying to re-apply database one more time (eg. in order to install another 3rd party plugin for Kaseya VSA) I'm getting following error message:
Fatal MessageSys Error: ESET/index/eset.PK_DeploymentPermissions.sql
System Error [0] Message: Error #1779: Table 'DeploymentPermissions' already has a primary key defined on it.
Could not create constraint. See previous errors. on line 1.
Execution Duration: 12:48:05 AM - 12:48:05 AM
SQL Command: Text:
ALTER TABLE [eset].[DeploymentPermissions] ADD CONSTRAINT [PK_DepIDRoleID] PRIMARY KEY NONCLUSTERED
(
[DeploymentID] ASC,
[RoleUserID] ASC,
[Type] ASC
)
Errors collection contains:
Class: 16
Error #1779: Table 'DeploymentPermissions' already has a primary key defined on it. on line 1.
Error reported by .Net SqlClient Data Provider while connected to VSA-CECE-TESTSQLEXPRESS
Class: 16
Error #1750: Could not create constraint. See previous errors. on line 1.
Error reported by .Net SqlClient Data Provider while connected to VSA-CECE-TESTSQLEXPRESS
, Location: at Hermes.DataManager.ExecuteNonQuery(SqlConnection Conn, SqlCommand Cmd)
at Hermes.DataManager.ExecuteNonQuery(String commandText, CommandType ExecutionComandType)
at Hermes.ExecSQL.Process()
System Error [0] Message: Error #1779: Table 'DeploymentPermissions' already has a primary key defined on it.
Could not create constraint. See previous errors. on line 1.
Execution Duration: 12:48:05 AM - 12:48:05 AM
SQL Command: Text:
ALTER TABLE [eset].[DeploymentPermissions] ADD CONSTRAINT [PK_DepIDRoleID] PRIMARY KEY NONCLUSTERED
(
[DeploymentID] ASC,
[RoleUserID] ASC,
[Type] ASC
)
Errors collection contains:
Class: 16
Error #1779: Table 'DeploymentPermissions' already has a primary key defined on it. on line 1.
Error reported by .Net SqlClient Data Provider while connected to VSA-CECE-TEST\SQLEXPRESS
Class: 16
Error #1750: Could not create constraint. See previous errors. on line 1.
Error reported by .Net SqlClient Data Provider while connected to VSA-CECE-TEST\SQLEXPRESS
, Location: at Hermes.DataManager.ExecuteNonQuery(SqlConnection Conn, SqlCommand Cmd)
at Hermes.DataManager.ExecuteNonQuery(String commandText, CommandType ExecutionComandType)
at Hermes.ExecSQL.Process()
Is it possible that ESET plugin is breaking VSA DB somehow?
Any help would be appreciated.
--
Best regards
macosxgeek