nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Error when I Restore Backup

aolea

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!

Accepted answers

Andy Heinzer

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.

All comments

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.

aolea

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.

Andy Heinzer

aolea

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

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
create a new empty database from one of the supported databases
Stop Jira
connect Jira to this new, empty database (the config tool tends to make this easier to do correctly)
Start Jira again
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.

aolea

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))

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-software

jira-software-server