Error when I Restore Backup

[amac]

Hi!

I've done a backup and then, when I try to restore an error is produced.

I load Jira web site but when I log in, admin user not exist. I can't reset password neither log in another user.

Is possible reset admin user? I try to reinstall JIRA software but not working

Thanks!

[Andy Heinzer · Accepted solution]

I would be interested to see what the specific error was during the restore.  You can find this in the $JIRAHOME/log/atlassian-jira.log file.   It is possible that the restore only partially completed, and in turn if it did not import your user account/permissions, it is possible that your system could be stuck in this state where you can't login and you have missing data in Jira.

You could follow the steps in https://confluence.atlassian.com/jira/retrieving-the-jira-administrator-192836.html in order to 'break-in' to Jira.  But if you have other data missing because the restore failed, it's probably better to try to identify why that restore failed first, and address that problem, because you are likely going to need to repeat the import steps again anyways once you have fixed the cause of this import problem.

[amac]

Thanks Andrew.

I've created a new user 'localadmin' following the steps in https://confluence.atlassian.com/jira/retrieving-the-jira-administrator-192836.html and  I still without access.

First I shutdown JIRA and Confluence and then access to web console https://confluence.atlassian.com/jirakb/accessing-jira-s-h2-embedded-database-776818136.html I run all scripts but when I start JIRA, I can't access with the user 'localadmin'

I send extract from atlassian-jira.log file

2018-08-03 10:54:07,937 http-nio-8080-exec-25 ERROR      [o.a.c.c.C.[.[localhost].[/].[action]] El Servlet.service() para el servlet [action] en el contexto con ruta [] lanzó la excepción [java.lang.IllegalStateException: User login details can not be reset for this JIRA site.] con causa raíz
java.lang.IllegalStateException: User login details can not be reset for this JIRA site.
 at com.atlassian.jira.web.action.user.ForgotLoginDetails.doExecute(ForgotLoginDetails.java:43)
 at webwork.action.ActionSupport.execute(ActionSupport.java:165)
 at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:63)
 at webwork.interceptor.DefaultInterceptorChain.proceed(DefaultInterceptorChain.java:39)
 at webwork.interceptor.NestedInterceptorChain.proceed(NestedInterceptorChain.java:31)
 ...
 at java.lang.Thread.run(Thread.java:745)2018-08-03 10:54:08,090 http-nio-8080-exec-25 ERROR      [c.a.j.web.servlet.InternalServerErrorServlet] {errorId=5a122d0b-62f7-4201-ace2-081e95cf3682, interpretedMsg=, cause=java.lang.IllegalStateException: User login details can not be reset for this JIRA site., stacktrace=java.lang.IllegalStateException: User login details can not be reset for this JIRA site.
     at com.atlassian.jira.web.action.user.ForgotLoginDetails.doExecute(ForgotLoginDetails.java:43) [classes/:?]
     at webwork.action.ActionSupport.execute(ActionSupport.java:165) [webwork-1.4-atlassian-30.jar:?]
     at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:63) [jira-api-7.11.1.jar:?]
     ...
    , referer=http://localhost:8080/secure/Dashboard.jspa, servletErrorMessage=}
2018-08-03 10:55:45,912 Modification Check:thread-1 INFO      [c.a.jira.startup.JiraStartupLogger] 

Regards.

[Andy Heinzer]

Yeah, that is something I was afraid of.   We don't recommend using the H2 database that comes with Jira.  It really is only used for evaluations, and it's known to be easily corrupted. What I would recommend here would to

1. Find the supported platforms version document that corresponds to your version of Jira.  Here is the Jira 7.11 version: https://confluence.atlassian.com/adminjiraserver/supported-platforms-938846830.html
2. create a new empty database from one of the supported databases
3. Stop Jira
4. connect Jira to this new, empty database (the config tool tends to make this easier to do correctly)
5. Start Jira again
6. perform the XML restore in the setup wizard of Jira

Should this fail again, immediately go to the atlassian-jira.log file to see what errors might have happened during the restore.

Also please let me know what version of Jira your back was made in , and what version of Jira you are trying to restore this to.

[amac]

Hi Andrew,

I made all steps. I create new mysql database and configure Jira to this new.

- I run Jira service and start the import with existing datas.
- I copy backup into C:\Program Files\Atlassian\Application Data\JIRA\caches\indexes
- I copy license JIRA Software

… started importing data...

An error occurs and the data import stops

Error importando datos: com.atlassian.jira.exception.DataAccessException: org.ofbiz.core.entity.GenericDataSourceException: Generic Entity Exception occurred in deleteByAnd (SQL Exception while executing the following:DELETE FROM component (Table 'jiradb.component' doesn't exist))

[amac]

Hi Andrew,

I installed MySql 8, but when I've installed MySql 5.7, I've restore backup without any problem

Thanks for all!!!

[Andy Heinzer]

Thanks for letting us know where the problem was.   The Supported Platforms for Jira do not yet list MySQL 8 as a supported database for Jira.  So that is likely the source of the problem here.

Glad to hear that this is working now :)

[Nic Brough -Adaptavist-]

Are you logging in as an admin from the sire you backed up?  Your previous account on the target Jira will have been scrubbed by the import.

[amac]

Only I have used one account. The user and password is the same before the import and after.

Neither I know how I can do a query from database to get list users.