setup wizard : Cannot add user, all the user directories are read-only

[Anthoni JOURSON]

hello,

i have this message during the setup wizard, I have the following configuration:

windows 2016 server, java 181, sql server 2018, jira 7.011.

I updated the odbc driver but still have the error message. please help me

*********************************************

the file dbconfig.xml

<?xml version="1.0" encoding="UTF-8"?>

-<jira-database-config>

<name>defaultDS</name>

<delegator-name>default</delegator-name>

<database-type>mssql</database-type>

<schema-name>dbo</schema-name>

-<jdbc-datasource>

<url>jdbc:jtds:sqlserver://127.0.0.1:1433/jiradb</url>

<driver-class>net.sourceforge.jtds.jdbc.Driver</driver-class>

<username>jiradbuser</username>

<password>Welcome01</password>

<pool-min-size>20</pool-min-size>

<pool-max-size>20</pool-max-size>

<pool-max-wait>30000</pool-max-wait>

<pool-max-idle>20</pool-max-idle>

<pool-remove-abandoned>true</pool-remove-abandoned>

<pool-remove-abandoned-timeout>300</pool-remove-abandoned-timeout>

</jdbc-datasource>

</jira-database-config>

here is the result of log atlassian-jira.log.

***************************************************

 2019-09-11 13:06:13,847 http-nio-8080-exec-3 ERROR anonymous 786x3x1 p0amnc 0:0:0:0:0:0:0:1 /secure/SetupDatabase!default.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Error importing data: java.lang.IllegalStateException: Could not find column 'EXCLUDE_ISSUE_DETAILS' in previously parsed query!
java.lang.IllegalStateException: Could not find column 'EXCLUDE_ISSUE_DETAILS' in previously parsed query!
at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getFields(DatabaseMetaDataReaderImpl.java:103)
at net.java.ao.schema.ddl.SchemaReader.readFields(SchemaReader.java:123)
at net.java.ao.schema.ddl.SchemaReader.readTable(SchemaReader.java:107)
at net.java.ao.schema.ddl.SchemaReader.access$000(SchemaReader.java:59)
at net.java.ao.schema.ddl.SchemaReader$1.apply(SchemaReader.java:96)
at net.java.ao.schema.ddl.SchemaReader$1.apply(SchemaReader.java:94)
at com.google.common.collect.Iterators$8.transform(Iterators.java:799)
at com.google.common.collect.TransformedIterator.next(TransformedIterator.java:48)
at com.google.common.collect.Iterators.addAll(Iterators.java:362)
at com.google.common.collect.Lists.newArrayList(Lists.java:160)
at com.google.common.collect.Lists.newArrayList(Lists.java:144)
at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:94)
at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:85)
at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:78)
at com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.doCleanup(ActiveObjectsDatabaseCleaner.java:58)
at com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.cleanup(ActiveObjectsDatabaseCleaner.java:45)
at com.atlassian.activeobjects.backup.ActiveObjectsBackup.clear(ActiveObjectsBackup.java:160)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.removeActiveObjects(DefaultDataImportService.java:958)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.performImport(DefaultDataImportService.java:679)
at com.atlassian.jira.bc.dataimport.DefaultDataImportService.doImport(DefaultDataImportService.java:312)
at com.atlassian.jira.startup.DatabaseInitialImporter.importInitialData(DatabaseInitialImporter.java:56)
at com.atlassian.jira.startup.DatabaseInitialImporter.importInitialData(DatabaseInitialImporter.java:48)
at com.atlassian.jira.web.action.setup.SetupDatabase.doDefault(SetupDatabase.java:141)
... 3 filtered
at java.lang.reflect.Method.invoke(Method.java:497)
at webwork.util.InjectionUtils$DefaultInjectionImpl.invoke(InjectionUtils.java:70)
at webwork.util.InjectionUtils.invoke(InjectionUtils.java:56)
... 2 filtered
at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:63)
... 7 filtered
at javax.servlet.http.HttpServlet.service(HttpServlet.java:725)
... 50 filtered
at com.atlassian.greenhopper.jira.filters.ClassicBoardRouter.doFilter(ClassicBoardRouter.java:59)
... 151 filtered
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:745)
2019-09-11 13:06:13,974 http-nio-8080-exec-3 WARN anonymous 786x3x1 p0amnc 0:0:0:0:0:0:0:1 /secure/SetupDatabase!default.jspa [c.a.j.p.d.dao.impl.CachingOrganizationDaoImpl] onImportCompleted - clearing cache !!
2019-09-11 13:06:13,975 http-nio-8080-exec-3 INFO anonymous 786x3x1 p0amnc 0:0:0:0:0:0:0:1 /secure/SetupDatabase!default.jspa [c.a.j.bc.dataimport.DefaultDataImportService] JIRA Data Import has finished.
2019-09-11 13:06:13,976 http-nio-8080-exec-3 ERROR anonymous 786x3x1 p0amnc 0:0:0:0:0:0:0:1 /secure/SetupDatabase!default.jspa [c.a.jira.startup.DatabaseInitialImporter]
2019-09-11 13:06:13,977 http-nio-8080-exec-3 ERROR anonymous 786x3x1 p0amnc 0:0:0:0:0:0:0:1 /secure/SetupDatabase!default.jspa [c.a.jira.startup.DatabaseInitialImporter] Erreur d'importation de données&nbsp;: java.lang.IllegalStateException: Could not find column 'EXCLUDE_ISSUE_DETAILS' in previously parsed query!
2019-09-11 13:11:36,296 http-nio-8080-exec-5 INFO anonymous 791x5x1 p0amnc 0:0:0:0:0:0:0:1 /secure/SetupApplicationProperties.jspa [c.a.j.w.action.setup.SetupApplicationProperties] Re-indexing is 100% complete. Current index:
2019-09-11 13:11:36,306 http-nio-8080-exec-5 INFO anonymous 791x5x1 p0amnc 0:0:0:0:0:0:0:1 /secure/SetupApplicationProperties.jspa [c.a.j.issue.index.DefaultIndexManager] ReindexAll in foreground: {indexIssues=true, indexChangeHistory=true, indexComments=true, indexWorklogs=true, forceReloadFromDatabase=false}
2019-09-11 13:36:07,975 http-nio-8080-exec-10 WARN anonymous 816x10x1 p0amnc 0:0:0:0:0:0:0:1 /secure/SetupLicense.jspa [c.a.jira.application.ApplicationConfigurationHelper] There are no writable directories to create the default group for the new license.
2019-09-11 14:28:15,295 http-nio-8080-exec-22 INFO anonymous 868x20x1 1pvdqdv 0:0:0:0:0:0:0:1 /secure/SetupDatabase!default.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Running JIRA Data Import...
2019-09-11 14:28:15,326 http-nio-8080-exec-22 INFO anonymous 868x20x1 1pvdqdv 0:0:0:0:0:0:0:1 /secure/SetupDatabase!default.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Importing XML data...
2019-09-11 14:28:15,339 http-nio-8080-exec-22 DEBUG anonymous 868x20x1 1pvdqdv 0:0:0:0:0:0:0:1 /secure/SetupDatabase!default.jspa [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] startCleaning
2019-09-11 14:28:15,397 http-nio-8080-exec-22 DEBUG anonymous 868x20x1 1pvdqdv 0:0:0:0:0:0:0:1 /secure/SetupDatabase!default.jspa [c.a.activeobjects.osgi.ActiveObjectsServiceFactory] stopCleaning
2019-09-11 14:28:15,398 http-nio-8080-exec-22 ERROR anonymous 868x20x1 1pvdqdv 0:0:0:0:0:0:0:1 /secure/SetupDatabase!default.jspa [c.a.j.bc.dataimport.DefaultDataImportService] Error importing data: java.lang.IllegalStateException: Could not find column 'EXCLUDE_ISSUE_DETAILS' in previously parsed query!
java.lang.IllegalStateException: Could not find column 'EXCLUDE_ISSUE_DETAILS' in previously parsed query!
at net.java.ao.schema.helper.DatabaseMetaDataReaderImpl.getFields(DatabaseMetaDataReaderImpl.java:103)
at net.java.ao.schema.ddl.SchemaReader.readFields(SchemaReader.java:123)
at net.java.ao.schema.ddl.SchemaReader.readTable(SchemaReader.java:107)
at net.java.ao.schema.ddl.SchemaReader.access$000(SchemaReader.java:59)
at net.java.ao.schema.ddl.SchemaReader$1.apply(SchemaReader.java:96)
at net.java.ao.schema.ddl.SchemaReader$1.apply(SchemaReader.java:94)
at com.google.common.collect.Iterators$8.transform(Iterators.java:799)
at com.google.common.collect.TransformedIterator.next(TransformedIterator.java:48)
at com.google.common.collect.Iterators.addAll(Iterators.java:362)
at com.google.common.collect.Lists.newArrayList(Lists.java:160)
at com.google.common.collect.Lists.newArrayList(Lists.java:144)
at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:94)
at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:85)
at net.java.ao.schema.ddl.SchemaReader.readSchema(SchemaReader.java:78)
at com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.doCleanup(ActiveObjectsDatabaseCleaner.java:58)
at com.atlassian.activeobjects.backup.ActiveObjectsDatabaseCleaner.cleanup(ActiveObjectsDatabaseCleaner.java:45)
at com.atlassian.activeobjects.backup.ActiveObjectsBackup.clear(ActiveObjectsBackup.java:160)

[Andy Heinzer · Accepted solution]

Hi Anthoni,

I understand you are trying to setup Jira 7.0.11 with a MS SQL 2016 database, but are unable to complete this setup.  When I see this specific error that the user accounts cannot be created because the user directories are read only, this error message is rather misleading.  It is true that Jira cannot create that admin account, but it tends to be because of a problem with the database configuration or SQL permissions of the account Jira is trying to use just doesn't have the ability to write that data to the expected table in the database.

Is there a particular reason you are using that version of Jira (7.0.11) with that database type?  Is this part of an upgrade/migration?  I ask because Jira didn't officially start supporting MS SQL 2016 until recently (Jira 7.9 supported platforms is the first to list that specific database version.)

If you're set on using 7.0.11 version of Jira, please see the Jira 7.0 supported platforms page to find a supported database type/version.  From there, you can then find the corresponding guide in Connecting Jira to a database in order to make sure that you have setup both the database and Jira in a manner that we know will work for that application.  Provided you can use a supported database for your version of Jira and follow the corresponding setup guide, you should be able to then get past this specific error.

Please let me know if you have any questions or concerns about these steps.

Andy