It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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)

 

1 answer

1 accepted

0 votes
Answer accepted
Andy Heinzer Atlassian Team Sep 12, 2019

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

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

The add-in you’ve been waiting for: Jira Cloud for Excel 🙌

Introducing Jira Cloud for Excel Here at the product integrations team at Atlassian, we are thrilled to announce the new Jira Cloud for Excel add-in! This add-in lets you export Jira data directly ...

872 views 6 24
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you