New Installation Oracle Database Error

I have set up a new installation of Confluence 5.3 with an 11G Oracle DB. I have the driver in place, and seem to be able to connect to the DB, and to start configuring it at least in some way, but part-way through the process it fails with:

Error occurred during template rendering: Invocation of method 'getRenderedTemplateHtml' in class com.atlassian.confluence.plugins.soy.VelocityFriendlySoyTemplateRenderer threw exception com.google.template.soy.tofu.SoyTofuException: In template navlinks.templates.appswitcher.switcher: When evaluating "showAppSwitcher()": Error while computing function "showAppSwitcher()": could not read a hi value - you need to populate the table: hibernate_unique_key; nested exception is net.sf.hibernate.id.IdentifierGenerationException: could not read a hi value - you need to populate the table: hibernate_unique_key at /decorators/includes/common-header.vm[line 4, column 49]. Contact your administrator for assistance.

If I attempt to restart the Database process, it will advise me that tables already exist, and I ask that it overwrite the tables, but then I receive the same error. Does anybody know what could be going on here?

EDIT:
Troubling log entries in the Tomcat log:

SEVERE: The web application [] registered the JDBC driver [org.hsqldb.jdbc.JDBCDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

Jun 21, 2013 9:27:36 AM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc

SEVERE: The web application [] registered the JDBC driver [org.postgresql.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

Jun 21, 2013 9:27:36 AM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc

SEVERE: The web application [] registered the JDBC driver [oracle.jdbc.OracleDriver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.

Jun 21, 2013 9:27:36 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

SEVERE: The web application [] appears to have started a thread named [Timer-2] but has failed to stop it. This is very likely to create a memory leak.

Jun 21, 2013 9:27:36 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

SEVERE: The web application [] appears to have started a thread named [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#0] but has failed to stop it. This is very likely to create a memory leak.

Jun 21, 2013 9:27:36 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

SEVERE: The web application [] appears to have started a thread named [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#1] but has failed to stop it. This is very likely to create a memory leak.

Jun 21, 2013 9:27:36 AM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads

SEVERE: The web application [] appears to have started a thread named [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread-#2] but has failed to stop it. This is very likely to create a memory leak.

8 answers

1 accepted

This widget could not be displayed.

Worked with DBA and found that the problem was related to a quota limit set on the Confluence user. Removing this limit resolved the issue, and the database connection process was successful.

This widget could not be displayed.

Hi Matt,

It seems to me a side effect and not the root cause, is there any erro before that in your logs?

Cheers

This widget could not be displayed.

Whats the best log to check for those sorts of errors?

This widget could not be displayed.

There are two log files that you can check, one is the application log atlassian-confluence.log and the other one is the Tomcat log. Tomcat log is catalina.out for linux or stdout.xxxx and stderr.xxx for windows.

You can see more details here: https://confluence.atlassian.com/display/DOC/Working+with+Confluence+Logs

This widget could not be displayed.

log seems to be dominated by JDBC driver issues, I updated the question with a sample.

This widget could not be displayed.
Peter Koczan Atlassian Team Jun 20, 2013

Also make sure that you schema is set up according to the requirements, pay extra attention to the all_objects view in the users' schema: https://confluence.atlassian.com/display/DOC/Database+Setup+for+Oracle

This widget could not be displayed.

I got the driver from:
http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-112010-090769.html

in particular, the one for Oracle Database 11g Release 2 (11.2.0.1.0) JDBC Drivers

This widget could not be displayed.

Oracle is pushing its way harder in cloud software. It had growth of 24% from revenues in cloud and 60% growth in bookings. It will take time for transition from traditional licensing based software to cloud based software offerings, but company will catch up with its competitors. Posted By: http://bit.ly/1geCfP7

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

517 views 7 6
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