Jump to content

ESET plugin for Kaseya VSA is breaking VSA database


macosxgeek
 Share

Recommended Posts

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 

Link to comment
Share on other sites

  • Administrators

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

Link to comment
Share on other sites

Guest
This topic is now closed to further replies.
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...