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

This widget could not be displayed.

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

This widget could not be displayed.

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?

This widget could not be displayed.

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 Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

225 views 3 0
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