Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Error when first initialization of SQL server DB

Ahmad Behzadi
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
August 12, 2018

Hi,

I installed Jira successfully and started the first wizard. after defining database (Local SQL Server) it gets error and redirects me to

[HostURL}/secure/errors.jsp

I see some tables are created in SQL Server Database. but can't open jira on browser. I removed Jira Home Directory and restarted the service. It got the same error exactly after I fill DB information.

 

Here is the log file:

    
    Database configuration OK
    
    ___ Database Configuration ________________
    
         Loading entityengine.xml from                 : file:/C:/Program%20Files/Atlassian/JIRA/atlassian-jira/WEB-INF/classes/entityengine.xml
         Entity model field type name                  : mssql
         Entity model schema name                      : dbo
         Database Version                              : Microsoft SQL Server - 13.00.1601
         Database Driver                               : Microsoft JDBC Driver 6.2 for SQL Server - 6.2.1.0
         Database URL                                  : jdbc:sqlserver://localhost:1433;jaasConfigurationName=SQLJDBCDriver;serverPreparedStatementDiscardThreshold=10;enablePrepareOnFirstPreparedStatementCall=false;fips=false;socketTimeout=0;authentication=NotSpecified;authenticationScheme=nativeAuthentication;xopenStates=false;sendTimeAsDatetime=true;trustStoreType=JKS;trustServerCertificate=false;TransparentNetworkIPResolution=true;serverNameAsACE=false;sendStringParametersAsUnicode=true;selectMethod=direct;responseBuffering=adaptive;queryTimeout=-1;packetSize=8000;multiSubnetFailover=false;loginTimeout=15;lockTimeout=-1;lastUpdateCount=true;encrypt=false;disableStatementPooling=true;databaseName=Jira;columnEncryptionSetting=Disabled;applicationName=Microsoft JDBC Driver for SQL Server;applicationIntent=readwrite;
         Database JDBC config                          : mssql jdbc:sqlserver://;serverName=localhost;portNumber=1433;databaseName=Jira
    
2018-08-12 15:40:14,452 http-nio-8085-exec-23 ERROR anonymous 940x10x1 fvsr82 0:0:0:0:0:0:0:1 /secure/SetupDatabase.jspa [c.a.jira.appconsistency.JiraSetupConfig] Unable to load values for CacheKey[entityName=jira.properties,entityId=1]
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:332)
    at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.resolve(CachingOfBizPropertyEntryStore.java:105)
    at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.getEntry(CachingOfBizPropertyEntryStore.java:123)
    at com.atlassian.jira.propertyset.CachingOfBizPropertySet.get(CachingOfBizPropertySet.java:189)
    at com.opensymphony.module.propertyset.AbstractPropertySet.getString(AbstractPropertySet.java:305)
    at com.atlassian.jira.config.properties.ApplicationPropertiesStore.getStringFromDb(ApplicationPropertiesStore.java:234)
    at com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getString(ApplicationPropertiesImpl.java:54)
    at com.atlassian.jira.appconsistency.JiraSetupConfig.isSetup(JiraSetupConfig.java:29)
    at com.atlassian.jira.instance.InstanceStateProvider.isInstalling(InstanceStateProvider.java:88)
    at com.atlassian.jira.instance.InstanceStateProvider.currentState(InstanceStateProvider.java:64)
    at com.atlassian.jira.startup.mode.DefaultStartupModeReference.determineStartupMode(DefaultStartupModeReference.java:33)
    at com.atlassian.jira.startup.mode.DefaultStartupModeReference.initialise(DefaultStartupModeReference.java:26)
    at com.atlassian.jira.startup.DefaultJiraLauncher.recordStartupMode(DefaultJiraLauncher.java:153)
    at com.atlassian.jira.startup.DefaultJiraLauncher.lambda$postDbLaunch$2(DefaultJiraLauncher.java:140)
    at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.runPostDbSetupRunnables(DatabaseConfigurationManagerImpl.java:286)
    at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.activateDatabase(DatabaseConfigurationManagerImpl.java:279)
    at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.activateDatabase(DatabaseConfigurationManagerImpl.java:243)
    at com.atlassian.jira.web.action.setup.SetupDatabase.doExecute(SetupDatabase.java:207)
    ... 1 filtered
    at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:63)
    ... 7 filtered
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
    ... 45 filtered
    at com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:66)
    ... 1 filtered
    at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:64)
    ... 31 filtered
    at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)
    ... 24 filtered
    at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)
    ... 24 filtered
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Unknown Source)
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 dbo.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:211)
    at com.atlassian.cache.memory.DelegatingCache.get(DelegatingCache.java:162)
    ... 159 more
Caused by: com.querydsl.core.QueryException: Caught SQLServerException for select O_S_PROPERTY_ENTRY.property_key, O_S_PROPERTY_ENTRY.propertytype
from dbo.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:472)
    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:284)
    at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.access$200(CachingOfBizPropertyEntryStore.java:64)
    at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore$PropertySetData.loadPropertyKeysAndTypes(CachingOfBizPropertyEntryStore.java:466)
    at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore$PropertySetData.<init>(CachingOfBizPropertyEntryStore.java:426)
    at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.loadPropertySetData(CachingOfBizPropertyEntryStore.java:270)
    at com.atlassian.cache.memory.MemoryCacheManager$3$1.load(MemoryCacheManager.java:207)

...

    at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4739)
    at com.atlassian.cache.memory.DelegatingCache.get(DelegatingCache.java:177)
    ... 161 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)
    ... 181 more
2018-08-12 15:40:14,471 http-nio-8085-exec-23 ERROR      [o.a.c.c.C.[.[localhost].[/].[action]] Servlet.service() for servlet [action] in context with path [] threw exception [com.opensymphony.module.propertyset.PropertyImplementationException: Unable to load values for CacheKey[entityName=jira.properties,entityId=1]] with root cause
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.SQLServerConnection.executeCommand(SQLServerConnection.java:2478)
    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)
    at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore$PropertySetData.lambda$loadPropertyKeysAndTypes$2(CachingOfBizPropertyEntryStore.java:472)
    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.config.database.DatabaseConfigurationManagerImpl.runPostDbSetupRunnables(DatabaseConfigurationManagerImpl.java:286)
    at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.activateDatabase(DatabaseConfigurationManagerImpl.java:279)
    at com.atlassian.jira.config.database.DatabaseConfigurationManagerImpl.activateDatabase(DatabaseConfigurationManagerImpl.java:243)
    at com.atlassian.jira.web.action.setup.SetupDatabase.doExecute(SetupDatabase.java:207)
    ... 1 filtered
    at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:63)
    ... 7 filtered
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
    ... 45 filtered
    at com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:66)
    ... 1 filtered
    at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:64)
    ... 31 filtered
    at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)
    ... 24 filtered
    at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)
    ... 24 filtered
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Unknown Source)
2018-08-12 15:40:14,481 http-nio-8085-exec-23 ERROR      [c.atlassian.instrumentation.Instrument] Unable to snapshot thread local operations (implementation of OpTimerFactory is not a ThreadLocalOpTimerFactory): null
2018-08-12 15:40:14,542 http-nio-8085-exec-23 ERROR      [c.a.j.web.servlet.InternalServerErrorServlet] {errorId=20372fcd-c8a7-4095-b972-24370d30bbdd, interpretedMsg=, cause=com.opensymphony.module.propertyset.PropertyImplementationException: Unable to load values for CacheKey[entityName=jira.properties,entityId=1], stacktrace=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:332) [classes/:?]
        at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.resolve(CachingOfBizPropertyEntryStore.java:105) [classes/:?]
        at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.getType(CachingOfBizPropertyEntryStore.java:133) [classes/:?]
        at com.atlassian.jira.propertyset.CachingOfBizPropertySet.exists(CachingOfBizPropertySet.java:139) [classes/:?]
        at com.atlassian.jira.config.properties.ApplicationPropertiesStore.getOption(ApplicationPropertiesStore.java:158) [classes/:?]
        at com.atlassian.jira.config.properties.ApplicationPropertiesImpl.getOption(ApplicationPropertiesImpl.java:88) [classes/:?]

    ...

        at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-coyote.jar:8.5.29]
        at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source) [?:1.8.0_181]
        at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source) [?:1.8.0_181]
        at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util.jar:8.5.29]
        at java.lang.Thread.run(Unknown Source) [?:1.8.0_181]
    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 dbo.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:211) [atlassian-cache-memory-3.2.0.jar:?]
        at com.atlassian.cache.memory.DelegatingCache.get(DelegatingCache.java:162) [atlassian-cache-memory-3.2.0.jar:?]
        at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore.resolve(CachingOfBizPropertyEntryStore.java:103) [classes/:?]
        ... 154 more
    Caused by: com.querydsl.core.QueryException: Caught SQLServerException for select O_S_PROPERTY_ENTRY.property_key, O_S_PROPERTY_ENTRY.propertytype
        from dbo.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) [querydsl-sql-4.1.4.jar:?]
        at com.querydsl.sql.Configuration.translate(Configuration.java:459) [querydsl-sql-4.1.4.jar:?]
        at com.querydsl.sql.AbstractSQLQuery.fetch(AbstractSQLQuery.java:502) [querydsl-sql-4.1.4.jar:?]
        at com.atlassian.jira.propertyset.CachingOfBizPropertyEntryStore$PropertySetData.lambda$loadPropertyKeysAndTypes$2(CachingOfBizPropertyEntryStore.java:472) [classes/:?]
        at com.atlassian.jira.database.DefaultQueryDslAccessor$1.lambda$executeQuery$0(DefaultQueryDslAccessor.java:85) [classes/:?]
        at com.atlassian.jira.database.DatabaseAccessorImpl.executeQuery(DatabaseAccessorImpl.java:68) [classes/:?]
        at com.atlassian.jira.database.DefaultQueryDslAccessor$1.executeQuery(DefaultQueryDslAccessor.java:84) [classes/:?]

...

        at com.google.common.cache.LocalCache$Segment.lockedGetOrLoad(LocalCache.java:2282) [closure-compiler-v20151216.jar:?]
        at com.google.common.cache.LocalCache$Segment.get(LocalCache.java:2197) [closure-compiler-v20151216.jar:?]
        at com.google.common.cache.LocalCache.get(LocalCache.java:3937) [closure-compiler-v20151216.jar:?]
        at com.google.common.cache.LocalCache$LocalManualCache.get(LocalCache.java:4739) [closure-compiler-v20151216.jar:?]
        at com.atlassian.cache.memory.DelegatingCache.get(DelegatingCache.java:177) [atlassian-cache-memory-3.2.0.jar:?]
        ... 156 more
    Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'entity_name'.
        at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:258) [mssql-jdbc-6.2.1.jre8.jar:?]
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1535) [mssql-jdbc-6.2.1.jre8.jar:?]
        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:467) [mssql-jdbc-6.2.1.jre8.jar:?]
        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:409) [mssql-jdbc-6.2.1.jre8.jar:?]
        at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:7151) [mssql-jdbc-6.2.1.jre8.jar:?]
        at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:2478) [mssql-jdbc-6.2.1.jre8.jar:?]
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:219) [mssql-jdbc-6.2.1.jre8.jar:?]
        at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:199) [mssql-jdbc-6.2.1.jre8.jar:?]
        at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:331) [mssql-jdbc-6.2.1.jre8.jar:?]
        at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) [commons-dbcp2-2.1.jar:2.1]
        at org.apache.commons.dbcp2.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:83) [commons-dbcp2-2.1.jar:2.1]
        at com.querydsl.sql.AbstractSQLQuery.fetch(AbstractSQLQuery.java:446) [querydsl-sql-4.1.4.jar:?]
        ... 176 more
    , referer=http://localhost:8085/secure/SetupDatabase.jspa, servletErrorMessage=}
2018-08-12 15:44:42,754 http-nio-8085-exec-4 WARN anonymous 944x12x1 fvsr82 0:0:0:0:0:0:0:1 /secure/errors.jsp [c.a.jira.security.JiraSecurityFilter] Rejecting security-sensitive request that bypassed Johnson filter: /secure/errors.jsp

How can I fix the error?

 

1 answer

0 votes
Alexis Robert
Community Champion
August 12, 2018

Hello @Ahmad Behzadi,

 

based on this thread with the same error encountered, it might have to do with user permissions. 

Are you sure your SQL user has enough permissions ? It needs the following: 

 

  1. Give this user full create, read and write permissions for the database tables. Confluence must be able to create its own schema. Refer to the SQL Server documentation for how to do this. 

 

Let me know if this helps,

 

—Alexis

Viktor Gubanov June 24, 2019

It doesn't help! I have the same problem.

Suggest an answer

Log in or Sign up to answer