Hi,

I upgraded jiveforums from 5.0.5 version to 5.5.29 version in test region.

I don't see any categories/forums on the home page. I see data in the database.

I have thrree jiveforums applications running on same server using same jvm but different context roots.

Below is the error I see when the application started.

[11/3/09 8:43:46:757 CST] 00000020 WebGroup      A   SRVE0169I: Loading Web Module: Jive Forums 5.5.
[11/3/09 8:43:48:276 CST] 00000020 ProxoolFacade I org.logicalcobwebs.proxool.ProxoolFacade registerConnectionPool Proxool 0.9.0RC3 (10-Jan-2007 01:38)
[11/3/09 8:43:51:406 CST] 00000020 Jive-INFO     I   Startup content found 'true' for query: SELECT count(*) from jiveID
[11/3/09 8:43:51:410 CST] 00000020 Jive-INFO     I   Startup content found 'true' for query: SELECT count(*) from jiveUser
[11/3/09 8:43:51:412 CST] 00000020 Jive-INFO     I   Startup content found 'true' for query: SELECT count(*) from jiveCategory
[11/3/09 8:43:51:424 CST] 00000020 Jive-INFO     I   Startup content found 'true' for query: SELECT count(*) from jiveProfileField
[11/3/09 8:43:51:428 CST] 00000020 Jive-INFO     I   Startup content found 'true' for query: SELECT count(*) from jiveVersion
[11/3/09 8:43:52:099 CST] 00000020 DefaultConfig I com.opensymphony.webwork.config.DefaultConfiguration <init> Loading global messages from jive_forums_i18n
[11/3/09 8:43:52:100 CST] 00000020 DefaultConfig I com.opensymphony.webwork.config.DefaultConfiguration <init> Loading global messages from jive_forums_admin_i18n
[11/3/09 8:43:52:101 CST] 00000020 DefaultConfig I com.opensymphony.webwork.config.DefaultConfiguration <init> Loading global messages from jive_profiles_i18n
[11/3/09 8:43:52:102 CST] 00000020 DefaultConfig I com.opensymphony.webwork.config.DefaultConfiguration <init> Loading global messages from custom_i18n
[11/3/09 8:43:52:103 CST] 00000020 DefaultConfig I com.opensymphony.webwork.config.DefaultConfiguration <init> Loading global messages from jive_forums_setup
[11/3/09 8:43:52:303 CST] 00000020 Jive-INFO     I   Starting Jive Forums Silver 5.5.29 using jiveHome dir of: /opt/jiveHome/corp
[11/3/09 8:43:55:174 CST] 00000026 Jive-ERR      E   <Null Message>
                                 java.util.NoSuchElementException
at java.util.LinkedList.getFirst(LinkedList.java:128)
at com.jivesoftware.forum.database.DbForumCategory.refreshCategoryTree(DbForumCategory.java:2899)
at com.jivesoftware.forum.database.DbForumCategory.init(DbForumCategory.java:287)
at com.jivesoftware.forum.database.DbForumCategory.<init>(DbForumCategory.java:244)
at com.jivesoftware.forum.database.DatabaseCacheManager.getForumCategory(DatabaseCacheManager.java:307)
at com.jivesoftware.forum.database.DbForumFactory.getRootForumCategory(DbForumFactory.java:659)
at com.jivesoftware.forum.database.DbTagManager$TagWorker.run(DbTagManager.java:80)
at com.jivesoftware.util.TaskEngine$GuardedRunnable.run(TaskEngine.java:424)
at com.jivesoftware.util.TaskEngine$TaskEngineWorker.run(TaskEngine.java:352)

[11/3/09 8:43:55:177 CST] 00000026 Jive-ERR      E   <Null Message>
                                 java.lang.NullPointerException
at com.jivesoftware.forum.database.DbTagManager$TagWorker.run(DbTagManager.java:81)
at com.jivesoftware.util.TaskEngine$GuardedRunnable.run(TaskEngine.java:424)
at com.jivesoftware.util.TaskEngine$TaskEngineWorker.run(TaskEngine.java:352)

[11/3/09 8:43:55:282 CST] 00000020 ServletWrappe A   SRVE0242I: [inttstJiveCorp] [/mboards/corp] [JiveServlet]: Initialization successful.
[11/3/09 8:43:55:299 CST] 00000020 ServletWrappe A   SRVE0242I: [inttstJiveCorp] [/mboards/corp] [dataexportservlet]: Initialization successful.
[11/3/09 8:43:55:307 CST] 00000020 ServletWrappe A   SRVE0242I: [inttstJiveCorp] [/mboards/corp] [ThemeServlet]: Initialization successful.

After running upgrade utility:

[11/3/09 8:46:05:881 CST] 0000002f ServletWrappe A   SRVE0242I: [inttstJiveCorp] [/mboards/corp] [/upgrade/upgrade.jsp]: Initialization successful.
[11/3/09 8:47:44:602 CST] 0000002f ServletWrappe A   SRVE0242I: [inttstJiveCorp] [/mboards/corp] [/upgrade/status.jsp]: Initialization successful.
[11/3/09 8:47:44:840 CST] 00000032 Jive-INFO     I   Starting filter upgrade task
[11/3/09 8:47:44:842 CST] 00000032 Jive-INFO     I   Upgrade task: not adding HostNameFilter - already exists
[11/3/09 8:47:44:844 CST] 00000032 Jive-INFO     I   Finishing filter upgrade task
[11/3/09 8:47:58:451 CST] 00000031 Jive-INFO     I   Page cache initialized with maximum size: 1000 and expiration: 30 seconds
[11/3/09 8:48:02:460 CST] 00000031 ServletWrappe A   SRVE0242I: [inttstJiveCorp] [/mboards/corp] [/main.jsp]: Initialization successful.
[11/3/09 8:48:03:035 CST] 00000031 Jive-WARN     W   LftRgt cache returned null for categoryID 1. Refreshing LftRgt cache.
[11/3/09 8:48:03:048 CST] 00000031 ActionCompone E com.opensymphony.webwork.components.ActionComponent executeAction Could not execute action: //tag-cloud
                                 java.util.NoSuchElementException
at java.util.LinkedList.getFirst(LinkedList.java:128)
at com.jivesoftware.forum.database.DbForumCategory.refreshCategoryTree(DbForumCategory.java:2899)
at com.jivesoftware.forum.database.DbForumCategory.getLftRgtValues(DbForumCategory.java:3162)
at com.jivesoftware.forum.database.SQLGenerator.getTagListSQL(SQLGenerator.java:233)
at com.jivesoftware.forum.database.DbForumCategory.getTags(DbForumCategory.java:3486)
at com.jivesoftware.forum.proxy.ForumCategoryProxy.getTags(ForumCategoryProxy.java:88)
at com.jivesoftware.forum.action.TagCloudAction.execute(TagCloudAction.java:54)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

Let me know if you need more info. Please advise as to what needs to be done to fix the issue.