Cannot install JIRA, 500/503 error during database connection

[Nick Eichenberg]

Hello, trying to install JIRA and having nothing but issues. Doing a setup myself install, specifying our SQL Server 2014 DB. Able to get to the DB step, then I type in the information, click test, the test works, so I click next. It says 'setting up database connection' or something of that sort, runs for about 15-20 seconds, then the page reloads to a 503 error, and I can never get the setup to come back up again. This is the log when I try to start JIRA now :

2018-02-12 10:35:13,468 JIRA-Bootstrap INFO [c.a.j.config.database.SystemDatabaseConfigurationLoader] Reading database configuration from C:\Atlassian\Application Data\JIRA\dbconfig.xml
2018-02-12 10:35:13,968 JIRA-Bootstrap WARN [c.a.j.config.properties.ApplicationPropertiesStore] Exception getting property 'jira.extension.container.provider' from database. Using default
2018-02-12 10:35:14,843 JIRA-Bootstrap ERROR [c.a.jira.startup.ComponentContainerLauncher] A fatal error occurred during initialisation. JIRA has been locked.
com.opensymphony.module.propertyset.PropertyImplementationException: Unable to load values for CacheKey[entityName=jira.properties,entityId=1]
 at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.propEx(CachingOfBizPropertyEntryStore.java:349)
 at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.resolve(CachingOfBizPropertyEntryStore.java:117)
 at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.getType(CachingOfBizPropertyEntryStore.java:149)
 at com.atlassian.jira.propertyset.CachingOfBizPropertySet.exists(CachingOfBizPropertySet.java:139)
 at com.atlassian.jira.config.properties.ApplicationPropertiesStore.getOption(ApplicationPropertiesStore.java:158)
 at com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getOption(ApplicationPropertiesImpl.java:88)
 at com.atlassian.jira.crowd.embedded.ofbiz.SwitchingUserDao.<init>(SwitchingUserDao.java:51)
 ... 3 filtered
 at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
 at org.picocontainer.injectors.AbstractInjector.newInstance(AbstractInjector.java:145)
 at org.picocontainer.injectors.ConstructorInjector$1.run(ConstructorInjector.java:342)
 at org.picocontainer.injectors.AbstractInjector$ThreadLocalCyclicDependencyGuard.observe(AbstractInjector.java:270)
 at org.picocontainer.injectors.ConstructorInjector.getComponentInstance(ConstructorInjector.java:364)
 at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(AbstractBehavior.java:64)
 at org.picocontainer.behaviors.Stored.getComponentInstance(Stored.java:91)
 at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(AbstractBehavior.java:64)
 at org.picocontainer.behaviors.Locked.getComponentInstance(Locked.java:40)
 at org.picocontainer.DefaultPicoContainer.getInstance(DefaultPicoContainer.java:698)
 at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:646)
 at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:631)
 at org.picocontainer.parameters.BasicComponentParameter$1.resolveInstance(BasicComponentParameter.java:118)
 at org.picocontainer.parameters.ComponentParameter$1.resolveInstance(ComponentParameter.java:136)
 at org.picocontainer.injectors.SingleMemberInjector.getParameter(SingleMemberInjector.java:78)
 at org.picocontainer.injectors.ConstructorInjector$CtorAndAdapters.getParameterArguments(ConstructorInjector.java:309)
 at org.picocontainer.injectors.ConstructorInjector$1.run(ConstructorInjector.java:335)
 at org.picocontainer.injectors.AbstractInjector$ThreadLocalCyclicDependencyGuard.observe(AbstractInjector.java:270)
 at org.picocontainer.injectors.ConstructorInjector.getComponentInstance(ConstructorInjector.java:364)
 at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(AbstractBehavior.java:64)
 at org.picocontainer.behaviors.Stored.getComponentInstance(Stored.java:91)
 at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(AbstractBehavior.java:64)
 at org.picocontainer.behaviors.Locked.getComponentInstance(Locked.java:40)
 at org.picocontainer.DefaultPicoContainer.getInstance(DefaultPicoContainer.java:698)
 at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:646)
 at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:631)
 at org.picocontainer.parameters.BasicComponentParameter$1.resolveInstance(BasicComponentParameter.java:118)
 at org.picocontainer.parameters.ComponentParameter$1.resolveInstance(ComponentParameter.java:136)
 at org.picocontainer.injectors.SingleMemberInjector.getParameter(SingleMemberInjector.java:78)
 at org.picocontainer.injectors.ConstructorInjector$CtorAndAdapters.getParameterArguments(ConstructorInjector.java:309)
 at org.picocontainer.injectors.ConstructorInjector$1.run(ConstructorInjector.java:335)
 at org.picocontainer.injectors.AbstractInjector$ThreadLocalCyclicDependencyGuard.observe(AbstractInjector.java:270)
 at org.picocontainer.injectors.ConstructorInjector.getComponentInstance(ConstructorInjector.java:364)
 at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(AbstractBehavior.java:64)
 at org.picocontainer.behaviors.Stored.getComponentInstance(Stored.java:91)
 at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(AbstractBehavior.java:64)
 at org.picocontainer.behaviors.Locked.getComponentInstance(Locked.java:40)
 at org.picocontainer.DefaultPicoContainer.getInstance(DefaultPicoContainer.java:698)
 at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:646)
 at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:631)
 at org.picocontainer.parameters.BasicComponentParameter$1.resolveInstance(BasicComponentParameter.java:118)
 at org.picocontainer.parameters.ComponentParameter$1.resolveInstance(ComponentParameter.java:136)
 at org.picocontainer.injectors.SingleMemberInjector.getParameter(SingleMemberInjector.java:78)
 at org.picocontainer.injectors.ConstructorInjector$CtorAndAdapters.getParameterArguments(ConstructorInjector.java:309)
 at org.picocontainer.injectors.ConstructorInjector$1.run(ConstructorInjector.java:335)
 at org.picocontainer.injectors.AbstractInjector$ThreadLocalCyclicDependencyGuard.observe(AbstractInjector.java:270)
 at org.picocontainer.injectors.ConstructorInjector.getComponentInstance(ConstructorInjector.java:364)
 at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(AbstractBehavior.java:64)
 at org.picocontainer.behaviors.Stored.getComponentInstance(Stored.java:91)
 at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(AbstractBehavior.java:64)
 at org.picocontainer.behaviors.Locked.getComponentInstance(Locked.java:40)
 at org.picocontainer.DefaultPicoContainer.getInstance(DefaultPicoContainer.java:698)
 at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:646)
 at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:631)
 at org.picocontainer.parameters.BasicComponentParameter$1.resolveInstance(BasicComponentParameter.java:118)
 at org.picocontainer.parameters.ComponentParameter$1.resolveInstance(ComponentParameter.java:136)
 at org.picocontainer.injectors.SingleMemberInjector.getParameter(SingleMemberInjector.java:78)
 at org.picocontainer.injectors.ConstructorInjector$CtorAndAdapters.getParameterArguments(ConstructorInjector.java:309)
 at org.picocontainer.injectors.ConstructorInjector$1.run(ConstructorInjector.java:335)
 at org.picocontainer.injectors.AbstractInjector$ThreadLocalCyclicDependencyGuard.observe(AbstractInjector.java:270)
 at org.picocontainer.injectors.ConstructorInjector.getComponentInstance(ConstructorInjector.java:364)
 at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(AbstractBehavior.java:64)
 at org.picocontainer.behaviors.Stored.getComponentInstance(Stored.java:91)
 at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(AbstractBehavior.java:64)
 at org.picocontainer.behaviors.Locked.getComponentInstance(Locked.java:40)
 at org.picocontainer.DefaultPicoContainer.getInstance(DefaultPicoContainer.java:698)
 at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:646)
 at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:631)
 at org.picocontainer.parameters.BasicComponentParameter$1.resolveInstance(BasicComponentParameter.java:118)
 at org.picocontainer.parameters.ComponentParameter$1.resolveInstance(ComponentParameter.java:136)
 at org.picocontainer.injectors.SingleMemberInjector.getParameter(SingleMemberInjector.java:78)
 at org.picocontainer.injectors.ConstructorInjector$CtorAndAdapters.getParameterArguments(ConstructorInjector.java:309)
 at org.picocontainer.injectors.ConstructorInjector$1.run(ConstructorInjector.java:335)
 at org.picocontainer.injectors.AbstractInjector$ThreadLocalCyclicDependencyGuard.observe(AbstractInjector.java:270)
 at org.picocontainer.injectors.ConstructorInjector.getComponentInstance(ConstructorInjector.java:364)
 at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(AbstractBehavior.java:64)
 at org.picocontainer.behaviors.Stored.getComponentInstance(Stored.java:91)
 at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(AbstractBehavior.java:64)
 at org.picocontainer.behaviors.Locked.getComponentInstance(Locked.java:40)
 at org.picocontainer.DefaultPicoContainer.getInstance(DefaultPicoContainer.java:698)
 at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:646)
 at org.picocontainer.DefaultPicoContainer.getComponent(DefaultPicoContainer.java:631)
 at org.picocontainer.parameters.BasicComponentParameter$1.resolveInstance(BasicComponentParameter.java:118)
 at org.picocontainer.parameters.ComponentParameter$1.resolveInstance(ComponentParameter.java:136)
 at org.picocontainer.injectors.SingleMemberInjector.getParameter(SingleMemberInjector.java:78)
 at org.picocontainer.injectors.ConstructorInjector$CtorAndAdapters.getParameterArguments(ConstructorInjector.java:309)
 at org.picocontainer.injectors.ConstructorInjector$1.run(ConstructorInjector.java:335)
 at org.picocontainer.injectors.AbstractInjector$ThreadLocalCyclicDependencyGuard.observe(AbstractInjector.java:270)
 at org.picocontainer.injectors.ConstructorInjector.getComponentInstance(ConstructorInjector.java:364)
 at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(AbstractBehavior.java:64)
 at org.picocontainer.behaviors.Stored.getComponentInstance(Stored.java:91)
 at org.picocontainer.behaviors.AbstractBehavior.getComponentInstance(AbstractBehavior.java:64)
 at org.picocontainer.behaviors.Locked.getComponentInstance(Locked.java:40)
 at org.picocontainer.DefaultPicoContainer.getLocalInstance(DefaultPicoContainer.java:605)
 at org.picocontainer.DefaultPicoContainer.getComponents(DefaultPicoContainer.java:586)
 at com.atlassian.jira.component.CachingMutablePicoContainer.getComponents(CachingMutablePicoContainer.java:193)
 at com.atlassian.jira.ComponentManager.runInitializingComponents(ComponentManager.java:289)
 at com.atlassian.jira.ComponentManager.initialise(ComponentManager.java:159)
 at com.atlassian.jira.startup.ComponentContainerLauncher.populateFullPicoContainer(ComponentContainerLauncher.java:50)
 at com.atlassian.jira.startup.ComponentContainerLauncher.start(ComponentContainerLauncher.java:30)
 at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$postDbLaunch$2(DefaultJiraLauncher.java:138)
 at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrEnqueue(DatabaseConfigurationManagerImpl.java:304)
 at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.doNowOrWhenDatabaseActivated(DatabaseConfigurationManagerImpl.java:199)
 at com.atlassian.jira.startup.DefaultJiraLauncher.postDbLaunch(DefaultJiraLauncher.java:135)
 at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$start$0(DefaultJiraLauncher.java:102)
 at com.atlassian.jira.util.devspeed.JiraDevSpeedTimer.run(JiraDevSpeedTimer.java:31)
 at com.atlassian.jira.startup.DefaultJiraLauncher.start(DefaultJiraLauncher.java:100)
 at com.atlassian.jira.startup.LauncherContextListener.initSlowStuff(LauncherContextListener.java:157)
 at java.lang.Thread.run(Thread.java:745)
Caused by: com.atlassian.cache.CacheException: com.querydsl.core.QueryException: Caught SQLServerException for select O_S_PROPERTY_ENTRY.property_key, O_S_PROPERTY_ENTRY.propertytype
from jiraschema.propertyentry O_S_PROPERTY_ENTRY
where O_S_PROPERTY_ENTRY.entity_name = ? and O_S_PROPERTY_ENTRY.entity_id = ?
order by O_S_PROPERTY_ENTRY.id desc
 at com.atlassian.cache.memory.DelegatingCache.get(DelegatingCache.java:217)
 at com.atlassian.cache.memory.DelegatingCache.get(DelegatingCache.java:168)
 ... 117 more
Caused by: com.querydsl.core.QueryException: Caught SQLServerException for select O_S_PROPERTY_ENTRY.property_key, O_S_PROPERTY_ENTRY.propertytype
from jiraschema.propertyentry O_S_PROPERTY_ENTRY
where O_S_PROPERTY_ENTRY.entity_name = ? and O_S_PROPERTY_ENTRY.entity_id = ?
order by O_S_PROPERTY_ENTRY.id desc
 at com.querydsl.sql.DefaultSQLExceptionTranslator.translate(DefaultSQLExceptionTranslator.java:50)
 at com.querydsl.sql.Configuration.translate(Configuration.java:459)
 at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore$PropertySetData.lambda$loadPropertyKeysAndTypes$2(CachingOfBizPropertyEntryStore.java:489)
 at com.atlassian.jira.database.DefaultQueryDslAccessor$1.lambda$executeQuery$0(DefaultQueryDslAccessor.java:85)
 at com.atlassian.jira.database.DatabaseAccessorImpl.executeQuery(DatabaseAccessorImpl.java:68)
 at com.atlassian.jira.database.DefaultQueryDslAccessor$1.executeQuery(DefaultQueryDslAccessor.java:84)
 at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.query(CachingOfBizPropertyEntryStore.java:301)
 at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.access$200(CachingOfBizPropertyEntryStore.java:67)
 at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore$PropertySetData.loadPropertyKeysAndTypes(CachingOfBizPropertyEntryStore.java:483)
 at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore$PropertySetData.<init>(CachingOfBizPropertyEntryStore.java:443)
 at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.loadPropertySetData(CachingOfBizPropertyEntryStore.java:287)
 at com.atlassian.cache.memory.MemoryCacheManager$3$1.load(MemoryCacheManager.java:211)
 at com.atlassian.cache.memory.DelegatingCache.lambda$get$0(DelegatingCache.java:168)
 at com.atlassian.cache.memory.DelegatingCache.lambda$get$1(DelegatingCache.java:196)
 at com.google.common.cache.LocalCache$LocalManualCache$1.load(LocalCache.java:4742)
 at com.google.common.cache.LocalCache$LoadingValueReference.loadFuture(LocalCache.java:3527)
 at com.google.common.cache.LocalCache$Segment.loadSync(LocalCache.java:2319)
 at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282)
 at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197)
 at com.google.common.cache.LocalCache.get(LocalCache.java:3937)
 at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4739)
 at com.atlassian.cache.memory.DelegatingCache.get(DelegatingCache.java:183)
 ... 119 more
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'entity_name'.
 at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1535)
 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:467)
 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:409)
 at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7151)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:219)
 at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:199)
 at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:331)
 at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
 at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83)
 at com.querydsl.sql.AbstractSQLQuery.fetch(AbstractSQLQuery.java:446)
 ... 139 more
2018-02-12 10:35:14,890 JIRA-Bootstrap ERROR [c.a.jira.health.HealthChecks] We couldn't start JIRA
2018-02-12 10:35:14,890 JIRA-Bootstrap ERROR [c.a.jira.health.HealthChecks] An error occurred while trying to start JIRA. We can't give you any more detail right now, we suggest checking the logs for more detail and contacting our support team.
 See our documentation for more information on contacting our support team and creating a support zip.
2018-02-12 10:35:14,890 JIRA-Bootstrap INFO [c.a.jira.startup.DatabaseLauncher] Database transactions enabled: true
2018-02-12 10:35:14,890 JIRA-Bootstrap INFO [c.a.jira.startup.DatabaseLauncher] Using JIRA's default for database transaction isolation level: 2
2018-02-12 10:35:14,921 JIRA-Bootstrap INFO [c.a.jira.startup.JiraStartupLogger] 

Any ideas???

[somethingblue · Accepted solution]

Hi Nick,

• Can you confirm the collation is correct per Connecting JIRA applications to SQL Server 2014

In addition please provide the output of the following:

SELECT collation_name
FROM   sys.databases
WHERE  NAME = (SELECT Db_name() AS [Current Database]);

SELECT DISTINCT C.collation_name
FROM   sys.tables AS T
       INNER JOIN sys.columns C
               ON T.object_id = C.object_id
WHERE collation_name IS NOT NULL;

As another test please do the following:

1. Take an XML backup of your current instance which is working fine with MSSQL 2008
2. Create a new empty database in MSSQL 2014 as mentioned in Connecting JIRA applications to SQL Server 2014
3. Stop JIRA and connect the empty database to your JIRA instance using Using the JIRA application configuration tool
4. Place the generated XML backup in import folder in JIRA Home.
5. Start JIRA and complete the setup process.
6. Restore XML BACKUP. Only execute step 2 from the documentation.
7. Once restoration is completed try accessing JIRA now to see if everything is imported correctly at your end.

Let us know the results and we'll go from there.

Cheers,

Branden

[Nick Eichenberg]

That was it!  Our SQL Dev setup BitBucket first which asked for a different collation and didn't notice it was different for JIRA.  Thank you very much, we're working now!