User Profile Details Are Not Visible
Symptoms
After upgrading to Confluence v3.0.x, cannot view content on user home pages, and there is a similar error on the network section in user profile:
Error occurred durng template rendering: Invocation of method 'renderConfluenceMacro' in class com.atlassian.confluence.themes.GlobalHelper threw exception
org.springframework.transaction.UnexpectedRollbackException
Transaction rolled back because it has been marked as rollback-only at /template/includes/personal-sidebar.vm[line 30, column 25]. Contact your administrator for assistance.
Logs contain errors like:
2009-07-21 11:38:13,081 ERROR [http-8082-2] [atlassian.confluence.servlet.ConfluenceServletDispatcher] sendError Could not execute action
-- referer: http://<Your Base URL>/display/<~Username>/Home | url: /users/viewfollow.action | userName: <Username>
org.springframework.jdbc.BadSqlGrammarException: Hibernate operation: Could not execute query; bad SQL grammar []; nested exception is java.sql.SQLException: Invalid object name 'FOLLOW_CONNECTIONS'.
Caused by: java.sql.SQLException: Invalid object name 'FOLLOW_CONNECTIONS'.
Cause
When upgrading to Confluence v3.0.x, the DB schema could not be updated successfully to add a new table FOLLOW_CONNECTIONS, responsible for the above functionality and for the new social networking features introduced since v3.0.x.
This can be caused by an inappropriate upgrade, for which the SQL dump is restored after the upgrade job, as detailed in Upgrade Troubleshooting:
Error rendering macro 'excerpt-include'
No link could be created for 'Troubleshooting Upgrades'.
Resolution
Last modified on Mar 30, 2016
Powered by Confluence and Scroll Viewport.