Cannot log into JIRA after upgrade to 5.0.2 w/ Crowd Integration

We just upgraded all of our Atlassian tools this past weekend and have run into a problem where users cannot log into JIRA. Previously we had the JIRA integration with Crowd, but we are seeing errors that seem to state that there's a stale connection within Crowd for JIRA. We had the same problem with Confluence and was able to rectify the problem by resetting the internal Confluence admin account, removing the Crowd integration and logging in locally and then re-establishing the integration with Crowd. The problem is, the initial JIRA (4.1.2) didn't seem to have a local admin account associated with it. So we tried to create a new one and then login locally the same way, but now we can't get in to setup the new Crowd integration.

The errors we are seeing are:

org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1

While Confluence documents how to revert from Crowd to internal directory usage, JIRA's documentation doesn't reference this at all. We need help here badly as we're currently down on this JIRA instance.

3 answers

1 accepted

it was actually a mispelling of the password in the crowd.properties. Pretty simple and stupid on my part. Thanks for helping.

Hi, which version of JIRA / Crowd are you now using? Are you bumping into https://jira.atlassian.com/browse/CWD-2703 that has now been fixed?

There is a table "cwd_directory" in JIRA DB that will have all configured User Directories. By altering the column "directory_position" value in this table, one can bring JIRA back to its own internal directory for authentication

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,331 views 14 20
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot