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

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.

Hi Matt,

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

Cheers

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

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

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

0 vote
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

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

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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Apr 13, 2018 in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

374 views 20 10
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