User created in AD is unable to log into Bitbucket

Issue Summary

User is added to an AD group and is assigned a Bitbucket license, but the user is unable to login. 

Steps to Reproduce

Not reproducible 

Expected Results

• User is added to AD Security Group.
• The user gets Okta chiclet assigned.
• User syncs to Bitbucket and a license is assigned.
• The user can log into Bitbucket. 

Actual Results

• User is added to AD Security Group.
• The user gets Okta chiclet assigned.
• User syncs to Bitbucket and a license is assigned.
• The user is unable to log into Bitbucket. 

The query results ran by the customer below show that the user is only created in the cwd_user table and not the sta_normal_user table. This is causing the issue:

SELECT * FROM sta_normal_user WHERE name = 'vsetty'
no result

SELECT * FROM cwd_user WHERE user_name = 'vsetty'
4793360 vsetty vsetty 2019-09-17 01:31:21 2021-05-03 06:16:35 vsetty vsetty

After applying the workaround:

SELECT * FROM sta_normal_user WHERE name = 'vsetty' 1151805 vsetty vsetty

Workaround

The customer identified 2 workarounds: 

• Restart Bitbucket.
• As an admin, go to User profile (and that's it, users are able to log in after that).