Installing Confluence with MSSQL

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

This widget could not be displayed.

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

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 !

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
Community showcase
Posted Monday in Confluence

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

280 views 2 4
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you