It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

0 votes
Answer 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 votes
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
Community showcase
Published in Confluence

Introducing Confluence Cloud and Jira Software Cloud Premium

Wherever you are in your team’s journey , our goal is to support your big ambitions. We’re a cloud-first company with the mission of unleashing the potential of every team, and to address the range ...

640 views 4 17
Read article

Community Events

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

Find an event

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

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you