Installing jira on MSSQL

[mitchel_mccullough]

Installation of Jira on MSSQL was successful, however once complete, there are a slew of errors in the logs and I receive an "Jira - Internal Error" when visiting the Jira instance. I already have Confluence installed on MSSQL with no issues...not sure why Jira is so finnicky.

2018-07-23 12:43:06,347 http-nio-8080-exec-1 ERROR   -   [o.o.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.getNextSeqId] Fill bank failed, returning null

2018-07-23 12:43:06,528 http-nio-8080-exec-1 ERROR   -   [c.a.j.web.servlet.InternalServerErrorServlet] Cannot render the 500 page for error e37d3b12-76c3-45df-bc7d-cfc4ae81993d

com.opensymphony.module.propertyset.PropertyImplementationException: Failed operation: SetOperation[entityName=jira.properties,entityId=1,propertyKey=jira.sid.key,newType=5,newMapper=TypeMapper[handler=StringPropertyHandler,valueEntity=OSPropertyString]]

at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.propEx(CachingOfBizPropertyEntryStore.java:349)

at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.retry(CachingOfBizPropertyEntryStore.java:335)

at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.setEntry(CachingOfBizPropertyEntryStore.java:155)

at com.atlassian.jira.propertyset.CachingOfBizPropertySet.setImpl(CachingOfBizPropertySet.java:183)

at com.opensymphony.module.propertyset.AbstractPropertySet.set(AbstractPropertySet.java:502)

at com.opensymphony.module.propertyset.AbstractPropertySet.setString(AbstractPropertySet.java:300)

at com.atlassian.jira.config.properties.ApplicationPropertiesStore.setString(ApplicationPropertiesStore.java:200)

at com.atlassian.jira.config.properties.ApplicationPropertiesImpl.setString(ApplicationPropertiesImpl.java:103)

at com.atlassian.jira.license.MultiLicenseStoreImpl.storeServerId(MultiLicenseStoreImpl.java:92)

at com.atlassian.jira.license.LegacyMultiLicenseStore.storeServerId(LegacyMultiLicenseStore.java:101)

at com.atlassian.jira.license.RenaissanceSwitchingMultiLicenseStore.storeServerId(RenaissanceSwitchingMultiLicenseStore.java:63)

at com.atlassian.jira.license.JiraLicenseManagerImpl.getServerId(JiraLicenseManagerImpl.java:81)

at com.atlassian.jira.bc.license.JiraLicenseServiceImpl.getServerId(JiraLicenseServiceImpl.java:66)

at com.atlassian.jira.plugin.navigation.FooterDataProvider.getExternalLinkWithVersionBuildNumAndServerId(FooterDataProvider.java:283)

at com.atlassian.jira.plugin.navigation.FooterDataProvider.dataForUnlicensed(FooterDataProvider.java:256)

at com.atlassian.jira.plugin.navigation.FooterDataProvider.getErrorAndLicenseState(FooterDataProvider.java:220)

at com.atlassian.jira.plugin.navigation.FooterDataProvider.addLicenseInfo(FooterDataProvider.java:157)

at com.atlassian.jira.plugin.navigation.FooterDataProvider.addToMap(FooterDataProvider.java:150)

at com.atlassian.jira.plugin.navigation.FooterModuleDescriptorImpl.addFooterModel(FooterModuleDescriptorImpl.java:74)

at com.atlassian.jira.plugin.navigation.FooterModuleDescriptorImpl.createVelocityParams(FooterModuleDescriptorImpl.java:67)

at com.atlassian.jira.plugin.navigation.FooterModuleDescriptorImpl.getFooterHtml(FooterModuleDescriptorImpl.java:57)

at com.atlassian.jira.plugin.navigation.DefaultPluggableFooter.getFullFooterHtml(DefaultPluggableFooter.java:22)

at com.atlassian.jira.web.servlet.InternalServerErrorHelper.lambda$getFooterContent$0(InternalServerErrorHelper.java:152)

at java.util.Optional.map(Optional.java:215)

at com.atlassian.jira.web.servlet.InternalServerErrorHelper.getFooterContent(InternalServerErrorHelper.java:152)

at com.atlassian.jira.web.servlet.InternalServerErrorHelper.addBasicInfo(InternalServerErrorHelper.java:143)

at com.atlassian.jira.web.servlet.InternalServerErrorHelper.render(InternalServerErrorHelper.java:104)

at com.atlassian.jira.web.servlet.InternalServerErrorHelper.render500ResponsePage(InternalServerErrorHelper.java:48)

at com.atlassian.jira.web.servlet.InternalServerErrorServlet.doRequest(InternalServerErrorServlet.java:14)

at com.atlassian.jira.web.servlet.InternalServerErrorServlet.doGet(InternalServerErrorServlet.java:20)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:622)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:729)

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

Caused by: java.lang.NullPointerException: id

at java.util.Objects.requireNonNull(Objects.java:228)

at com.atlassian.jira.database.IdGeneratingSQLInsertClause.executeWithId(IdGeneratingSQLInsertClause.java:69)

at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore$SetOperation.insert(CachingOfBizPropertyEntryStore.java:634)

at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore$SetOperation.upsert(CachingOfBizPropertyEntryStore.java:625)

at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.lambda$tx$6(CachingOfBizPropertyEntryStore.java:311)

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.tx(CachingOfBizPropertyEntryStore.java:309)

at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.access$300(CachingOfBizPropertyEntryStore.java:67)

at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore$SetOperation.perform(CachingOfBizPropertyEntryStore.java:612)

at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.retry(CachingOfBizPropertyEntryStore.java:321)

... 117 more

2018-07-23 12:43:07,332 http-nio-8080-exec-6 ERROR      [o.o.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.getNextSeqId] Fill bank failed, returning null

2018-07-23 12:43:07,998 http-nio-8080-exec-6 ERROR anonymous 763x345x1 - x.x.x.x  /favicon.ico [o.o.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.getNextSeqId] Fill bank failed, returning null

2018-07-23 12:43:10,201 http-nio-8080-exec-7 ERROR anonymous 763x346x1 - 1x.x.x.x  / [o.o.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.getNextSeqId] Fill bank failed, returning null

2018-07-23 12:43:10,867 http-nio-8080-exec-7 ERROR anonymous 763x346x1 - x.x.x.x / [o.o.core.entity.SequenceUtil] [SequenceUtil.SequenceBank.getNextSeqId] Fill bank failed, returning null

2

[Brant Schroeder · Accepted solution]

I think you are having issues with SET NOCOUNT in MS SQL - https://confluence.atlassian.com/jira062/error-caused-by-set-nocount-in-ms-sql-server-588581346.html

You should double check you MS SQL configurations with this document - https://confluence.atlassian.com/adminjiraserver/connecting-jira-applications-to-sql-server-2012-938846858.html

[mitchel_mccullough]

Brant, 

Thanks very much; that resolved the issue! It appears my Windows Admin didn't uncheck those boxes. 

+1