Installing Confluence with MSSQL

[Riika Lempiainen]

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

[Shannon S · Accepted solution]

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]

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]

Hi Riika,

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

Kind Regards,
Shannon