Can't create admin account during initial setup

Hi, I'm new to setting up JIRA. I'm just trying to install it and run it on my local machine. I've been following all the steps but can't seem to get past the attached image. I've tried installing with the H2 embedded database then changing to the postgreSQL one, and I've tried setting up the postgreSQL one initially, and still get the same issue. Could anyone explain what I might be doing wrong in terms I might understand? cheeky


(to be clear, I input all the data and then the red error at the top appears)


1 answer

0 vote

What shows in the Atlassian-JIRA.log?

Did you reset the db between resets?

I did delete/drop the database and then recreate it before each re-installation of JIRA. Here's the error at the end of the log file:

[c.a.j.bc.dataimport.DefaultDataImportService] Error importing data: java.lang.RuntimeException: Could not get unique fields for table 'AO_21D670_WHITELIST_RULES'
java.lang.RuntimeException: Could not get unique fields for table 'AO_21D670_WHITELIST_RULES'
at com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.doCleanup(
at com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.cleanup(
at com.atlassian.activeobjects.backup.ActiveObjectsBackup.clear(
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.removeActiveObjects(
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(
at com.atlassian.jira.startup.DatabaseInitialImporter.importInitialData(
at com.atlassian.jira.startup.DatabaseInitialImporter.importInitialData(
at com.atlassian.jira.web.action.setup.SetupDatabase.doDefault(
... 3 filtered
at java.lang.reflect.Method.invoke(
at webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(
at webwork.util.InjectionUtils.invoke(
... 2 filtered
at com.atlassian.jira.action.JiraActionSupport.execute(
... 7 filtered
at javax.servlet.http.HttpServlet.service(
... 52 filtered
at com.atlassian.greenhopper.jira.filters.ClassicBoardRouter.doFilter(
... 7 filtered
at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(
... 58 filtered
... 1 filtered
... 36 filtered
at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(
... 10 filtered
at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(
... 4 filtered
at com.atlassian.web.servlet.plugin.LocationCleanerFilter.doFilter(
... 29 filtered
at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(
... 28 filtered
at java.util.concurrent.ThreadPoolExecutor.runWorker(
at java.util.concurrent.ThreadPoolExecutor$
at org.apache.tomcat.util.threads.TaskThread$
Caused by: org.postgresql.util.PSQLException: ERROR: column am.amcanorder does not exist
Position: 407
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(
at org.postgresql.core.v3.QueryExecutorImpl.processResults(
at org.postgresql.core.v3.QueryExecutorImpl.execute(
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(
at org.postgresql.jdbc2.AbstractJdbc2DatabaseMetaData.getIndexInfo(
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getIndexInfo(
at org.apache.commons.dbcp2.DelegatingDatabaseMetaData.getIndexInfo(
... 277 more
2017-01-25 22:03:51,422 http-nio-8080-exec-10 WARN anonymous 1323x80x1 oxgls1 /secure/SetupDatabase!default.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Unknown import type for build number: 70100
2017-01-25 22:03:51,422 http-nio-8080-exec-10 WARN anonymous 1323x80x1 oxgls1 /secure/SetupDatabase!default.jspa [c.a.j.p.d.dao.impl.CachingOrganizationDaoImpl] onImportCompleted - clearing cache !!
2017-01-25 22:03:51,425 http-nio-8080-exec-10 INFO anonymous 1323x80x1 oxgls1 /secure/SetupDatabase!default.jspa [c.a.j.bc.dataimport.DefaultDataImportService] JIRA Data Import has finished.
2017-01-25 22:03:51,425 http-nio-8080-exec-10 ERROR anonymous 1323x80x1 oxgls1 /secure/SetupDatabase!default.jspa [c.a.jira.startup.DatabaseInitialImporter]
2017-01-25 22:03:51,426 http-nio-8080-exec-10 ERROR anonymous 1323x80x1 oxgls1 /secure/SetupDatabase!default.jspa [c.a.jira.startup.DatabaseInitialImporter] Error importing data: java.lang.RuntimeException: Could not get unique fields for table 'AO_21D670_WHITELIST_RULES'
2017-01-25 22:03:55,030 http-nio-8080-exec-5 INFO anonymous 1323x98x1 oxgls1 /secure/SetupApplicationProperties.jspa [c.a.j.w.action.setup.SetupApplicationProperties] Re-indexing is 100% complete. Current index:
2017-01-25 22:03:55,034 http-nio-8080-exec-5 INFO anonymous 1323x98x1 oxgls1 /secure/SetupApplicationProperties.jspa [c.a.j.issue.index.DefaultIndexManager] ReindexAll in foreground: {indexIssues=true, indexChangeHistory=true, indexComments=true, indexWorklogs=true, forceReloadFromDatabase=false}
2017-01-25 22:04:19,987 http-nio-8080-exec-10 WARN anonymous 1324x102x1 oxgls1 /secure/SetupLicense.jspa [c.a.jira.application.ApplicationConfigurationHelper] There are no writable directories to create the default group for the new license.

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Bridget Sauer
Published Thursday in Marketplace Apps

Calling all developers––You're invited to Atlas Camp 2018

 Atlas Camp   is our developer event which will take place in Barcelona, Spain  from the 6th -7th of   September . This is a great opportunity to meet other developers and get n...

126 views 0 5
Read article

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