Jump to content

Error when trying to delete users


Mcsirl
 Share

Recommended Posts

Hi Guys,

 

Im getting the following error when trying to delete users (either single users or multiple)

 

I am on V8.9 (Build 8990) 

 

The error is Error Code = The statement has been terminated. Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression., StackTrace = at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at Passwordstate.User.DeleteUserAccount(String strUserID, String strFirstName, String strSurname)

 

I get this either when clicking on the arrow beside the user and clicking delete or seleting Delete from the "Process Selected Items" dropdown at the bottom of the user page.

 

Can you help ?

 

THanks

Alan

 

 

PasswordState User Deletion error.jpg

Link to comment
Share on other sites

Hi Alan,

 

We've reviewed the code, and we think this could possibly be a bug. Can you try updating the SQL Code below with the correct UserID, and then execute with SQL Server Management Studio - does this allow you to delete the account after that?

USE Passwordstate

DELETE FROM [AccessRequestApprovers] WHERE AccessRequestID IN (SELECT AccessRequestID FROM [AccessRequests] WHERE UserID = 'xxxx')
DELETE FROM [AccessRequests] WHERE (UserID = 'xxxx')

 

Regards

Click Studios

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...