topic Re: Can't activate users in Get Started Discussions

Can't activate users

Raven91 — Sun, 07 Jul 2024 12:43:55 GMT

A while back apparently a user became inactive on our Databricks platform from unknown reason.

So far everything we tried haven't worked:

Delete and manually re-create the user
Delete and let SSO to create the user on login
Use Databricks CLI - shows no errors but does not take effect.

The CLI does work on other users, just this one does not updates with the command:
databricks users update USER_ID --json '{"active":true,"userName":"email@domain.com"}'
This command works for other users and deactivates active user (with "false" value) and then reactive it.

Any ideas how to resolve this issue? this is a major blocker

Re: Can't activate users

Raven91 — Mon, 08 Jul 2024 12:14:45 GMT

Hi @Retired_mod, Thank you for replying!

This issue is related to the Community Edition.

Thanks!

Re: Can't activate users

Raven91 — Wed, 10 Jul 2024 14:23:05 GMT

Hi @Retired_mod
Just checking if you've got any insights on this issue?
I've continued to try various options but anything I thought haven't effected the user.

Thanks,
Ofer.

Re: Can't activate users

Raven91 — Tue, 16 Jul 2024 09:27:48 GMT

Trying to bump this, anyone got any insights to this issue?

Re: Can't activate users

Jürg — Tue, 16 Jul 2024 15:54:15 GMT

Hi there,

We are facing exactly the same issue over here. Two users suddenly set to inactive, reactivation with python script does not work... even with PAT of account admin...

Help is much apprechiated!

Re: Can't activate users

ebr92 — Tue, 23 Jul 2024 11:30:13 GMT

Same issue here. Any ideas why and how to fix it? Deleting/adding user is not working.

Re: Can't activate users

Raven91 — Wed, 24 Jul 2024 07:05:02 GMT

@ebr92
No leads so far. Still waiting for hopefully anyone from the community will have any lead.

Tried anything with relation to deleting/adding as you mentioned, but nothing helped. the user is re-created with the same ID eventually and remains inactive

@Retired_mod Any chance you've got a lead on this?

Re: Can't activate users

Raven91 — Wed, 24 Jul 2024 07:07:01 GMT

the action works for 99% of the users, but just those two doesn't work.

They're regular users, not admins or something.

The action finishes as other - successful - but there's no actual change

Re: Can't activate users

bencsik — Thu, 08 Aug 2024 16:56:12 GMT

Anyone solve this issue. I am facing the same with only 1 user stuck as inactive.

Re: Can't activate users

ebr92 — Fri, 09 Aug 2024 06:14:09 GMT

One of my team member has solved this issue.

Users account is disabled on the Databricks account-level hence has no access to workspace.

We have fixed this issue by using Databricks Rest API and running the script (API call via Databricks CLI).

Re: Can't activate users

bencsik — Fri, 09 Aug 2024 11:51:03 GMT

I have scripts to update users and activation Booleans using api and with python-sdk. There is only one user stuck deactivated out of dozens. We do not share the same issue.

Re: Can't activate users

Raven91 — Sun, 11 Aug 2024 18:19:22 GMT

No clue who marked this as solved.

@ebr92 This is not the solution. I'm using a similar script to create and modify users on databricks account level but it does not work for only this single user. Every user works - besides a single user.

@Retired_mod Any insights?

Anyone else might have any insights?

Re: Can't activate users

AsgerLarsen — Wed, 28 Aug 2024 08:12:50 GMT

I had the same issue on my admin account seamlessly becoming inactive at random.

The problem occurred after helping our platform team testing out a new setup of another databricks workspace.
I was testing the setup logging in as a standard user and an admin user. These roles where given to me by the platform team, and after testing, they removed the roles that I was given, which somehow resulted in my other roles also being affected.

Apparently it has something to do with databricks not being able to handle nested groups in SCIM as mentioned in the bottom of this post.
The platform team changed back the groups and my account was updated as so:

Unfortunately, I don't know exactly how they did this, but I hope this helps narrowing down your problem.

Re: Can't activate users

AsgerLarsen — Wed, 28 Aug 2024 08:33:27 GMT

In addition to this, I had to clear my cache in the browser before I was able to login again.