Restoring JIRA from CLOUD to Server all issues are missing

Question

We are migrating our users on JIRA cloud onto our on JIRA server instance. We followed the KB article and we are faced with 2 issues:

1. All projects are visible on our (temp) local JIRA instance BUT no issues appear under any projects, where are they?

2. We cannot login. We tried sysadmin and admin

Version 7.10.2

Belinda Tinsley · Answer

Thanks, we already tried resetting the login counts too.

We are re-installing and restoring again and this time, enabling the outgoing mail during the setup to see if that will help.

Alexey Matveev · Answer

Try this KB

https://confluence.atlassian.com/jirakb/how-to-reset-failed-login-count-from-jira-application-database-329352344.html

Belinda Tinsley · Answer

https://confluence.atlassian.com/jirakb/disable-captcha-from-the-jira-application-database-333807702.html

How do we disable captcha if this returns 0 records:

SELECT s.* 
FROM   propertyentry e 
       JOIN propertystring s 
         ON e.id = s.id 
WHERE  property_key = 'jira.maximum.authentication.attempts.allowed';