Forums

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

Installing Confluence with MSSQL

Riika Lempiainen
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!
July 31, 2017

Hello,

I'm trying to install Confluence using a MSSQL.

Tables are created in the database, but then the installation fails.

The content of atlassian-confluence.log is this:

 

2017-07-31 22:38:00,970 INFO [localhost-startStop-1] [com.atlassian.confluence.lifecycle] info Starting Confluence 6.3.1 [build 7202 based on commit hash 57e26a1771e14e3fb96fd7cebe99a87f17d4379c] - synchrony version 1.0.0-release-confluence_6.1-a1ab321e
2017-07-31 22:38:08,496 WARN [localhost-startStop-1] [com.atlassian.config.ApplicationConfig] setApplicationHome Application home does not exist. Creating directory: C:\Program Files\Atlassian\Application Data\Confluence\shared-home
2017-07-31 22:38:08,614 INFO [localhost-startStop-1] [atlassian.confluence.cluster.DefaultClusterConfigurationHelper] lambda$populateExistingClusterSetupConfig$1 Populating setup configuration if running with Cluster mode...
2017-07-31 22:38:08,618 WARN [localhost-startStop-1] [atlassian.confluence.cluster.DefaultClusterConfigurationHelper] lambda$populateExistingClusterSetupConfig$1 Could not find shared config file.
2017-07-31 22:38:11,010 INFO [localhost-startStop-1] [atlassian.plugin.manager.DefaultPluginManager] earlyStartup Plugin system earlyStartup begun
2017-07-31 22:38:19,484 INFO [localhost-startStop-1] [atlassian.plugin.manager.DefaultPluginManager] logTime Plugin system earlyStartup ended
2017-07-31 22:38:19,487 INFO [localhost-startStop-1] [atlassian.plugin.manager.DefaultPluginManager] lateStartup Plugin system lateStartup begun
2017-07-31 22:38:21,226 INFO [localhost-startStop-1] [atlassian.plugin.manager.DefaultPluginManager] logTime Plugin system lateStartup ended
2017-07-31 22:38:22,449 INFO [localhost-startStop-1] [com.atlassian.confluence.lifecycle] init Confluence is ready to serve
2017-07-31 22:39:18,309 INFO [http-nio-8090-exec-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization started
2017-07-31 22:39:27,267 INFO [http-nio-8090-exec-1] [com.atlassian.confluence.lifecycle] <init> Loading EhCache cache manager
2017-07-31 22:39:53,958 INFO [http-nio-8090-exec-1] [springframework.web.context.ContextLoader] initWebApplicationContext Root WebApplicationContext: initialization completed in 35648 ms
2017-07-31 22:39:54,003 INFO [http-nio-8090-exec-1] [atlassian.plugin.manager.DefaultPluginManager] shutdown Preparing to shut down the plugin system
2017-07-31 22:39:54,004 INFO [http-nio-8090-exec-1] [atlassian.plugin.manager.DefaultPluginManager] shutdown Shutting down the plugin system
2017-07-31 22:39:54,111 INFO [http-nio-8090-exec-1] [atlassian.plugin.manager.DefaultPluginManager] earlyStartup Plugin system earlyStartup begun
2017-07-31 22:39:54,388 WARN [http-nio-8090-exec-1] [osgi.container.felix.ExportsBuilder] getUrlClassPath Cannot deep scan non file 'http://felix.extensions:9/'
-- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | traceId: 001edf38ba63627e | userName: anonymous | action: setupstandarddb
2017-07-31 22:40:54,748 WARN [ThreadPoolAsyncTaskExecutor::Thread 34] [spring.scanner.util.ProductFilterUtil] detectProduct Couldn't detect product, will use ProductFilter.ALL
-- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | traceId: 001edf38ba63627e | userName: anonymous | action: setupstandarddb
2017-07-31 22:40:54,932 WARN [ThreadPoolAsyncTaskExecutor::Thread 24] [spring.scanner.util.ProductFilterUtil] detectProduct Couldn't detect product, will use ProductFilter.ALL
-- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | traceId: 001edf38ba63627e | userName: anonymous | action: setupstandarddb
2017-07-31 22:40:58,569 WARN [ThreadPoolAsyncTaskExecutor::Thread 53] [spring.scanner.util.ProductFilterUtil] detectProduct Couldn't detect product, will use ProductFilter.ALL
-- referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | url: /setup/setupstandarddb.action | traceId: 001edf38ba63627e | userName: anonymous | action: setupstandarddb
2017-07-31 22:41:28,837 INFO [http-nio-8090-exec-1] [atlassian.plugin.manager.DefaultPluginManager] logTime Plugin system earlyStartup ended
2017-07-31 22:41:41,889 WARN [Navlink Plugin Executor:thread-2] [confluence.impl.vcache.SynchronousExternalCache] lambda$get$11 Failed to read entry from cache 'com.atlassian.bandana.BandanaPersister': Failed due to UNCLASSIFIED_FAILURE
-- url: /setup/setupstandarddb.action | referer: http://localhost:8090/setup/setupstandarddb-start.action?database=mssql | traceId: 001edf38ba63627e | userName: anonymous | action: setupstandarddb
2017-07-31 22:41:46,332 ERROR [http-nio-8090-exec-5] [engine.jdbc.spi.SqlExceptionHelper] logExceptions Invalid object name 'BANDANA'.
-- url: /bootstrap/selectsetupstep.action | traceId: 0099c6f03f7874a6 | userName: anonymous
2017-07-31 22:41:46,350 WARN [http-nio-8090-exec-5] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
->[com.atlassian.confluence.setup.bandana.ConfluenceDaoBandanaPersister.retrieve]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT,readOnly (Session #365397703)
-- url: /bootstrap/selectsetupstep.action | traceId: 0099c6f03f7874a6 | userName: anonymous
2017-07-31 22:41:46,382 WARN [http-nio-8090-exec-5] [confluence.impl.vcache.SynchronousExternalCache] lambda$get$11 Failed to read entry from cache 'com.atlassian.bandana.BandanaPersister': Failed due to UNCLASSIFIED_FAILURE
-- url: /bootstrap/selectsetupstep.action | traceId: 0099c6f03f7874a6 | userName: anonymous
2017-07-31 22:41:46,449 ERROR [http-nio-8090-exec-5] [engine.jdbc.spi.SqlExceptionHelper] logExceptions Invalid object name 'BANDANA'.
-- url: /bootstrap/selectsetupstep.action | traceId: 0099c6f03f7874a6 | userName: anonymous
2017-07-31 22:41:46,450 WARN [http-nio-8090-exec-5] [confluence.impl.hibernate.ConfluenceHibernateTransactionManager] doRollback Performing rollback. Transactions:
->[com.atlassian.confluence.setup.bandana.ConfluenceDaoBandanaPersister.retrieve]: PROPAGATION_REQUIRED,ISOLATION_DEFAULT,readOnly (Session #951166940)
-- url: /bootstrap/selectsetupstep.action | traceId: 0099c6f03f7874a6 | userName: anonymous
2017-07-31 22:41:46,474 ERROR [http-nio-8090-exec-5] [atlassian.confluence.servlet.ConfluenceServletDispatcher] sendError Could not execute action
-- url: /bootstrap/selectsetupstep.action | traceId: 0099c6f03f7874a6 | userName: anonymous
java.util.concurrent.CompletionException: org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet

1 answer

1 accepted

0 votes
Answer accepted
Shannon S
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
August 1, 2017

Hello Riika!

Have a look at this knowledge base article and give the resolution a try, and let us know how things go!

- Confluence Throws an Invalid Object Name Banana Error

Kind Regards,
Shannon

Riika Lempiainen
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 1, 2017

It is now working :)

Following https://confluence.atlassian.com/doc/database-setup-for-sql-server-9258.html, after creating the confluence database I did this:

  ALTER DATABASE confluence_db COLLATE SQL_Latin1_General_CP1_CS_AS

  ALTER DATABASE confluence_db
  SET READ_COMMITTED_SNAPSHOT ON
  WITH ROLLBACK IMMEDIATE;

Then, instead of making the confluence user owner of the database, I did this (from https://yiengly.wordpress.com/tag/confluence/)

Databases > confluence > Security > Users
Right click and select New user…
User name: usrConfluence
Login name: Browse to find and select usrConfluence
Default schema: dbo
Role Members:
db_datareader
db_datawriter
db_ddladmin
db_owner

Thanks !

Shannon S
Atlassian Team
Atlassian Team members are employees working across the company in a wide variety of roles.
August 1, 2017

Hi Riika,

Glad to hear you were able to resolve the issue! Take care :) 

Kind Regards,
Shannon

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events