ESET plugin for Kaseya VSA is breaking VSA database

[macosxgeek 0]

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 

[Marcos 5,277]

Please contact customer care as this is an issue that hardly anyone will be able to comment on this forum.

[macosxgeek 0]

@Marcos

Thank you very much. Will do.

--
Best regards
macosxgeek