Overview

After upgrading from Jive On-premise 9.0.6 to 9.0.7 the following error is thrown when accessing the Overview page in the Admin Console:

Jive SBS Admin Error
An error occurred while generating this page. Please check the logs for more information.

While the following is noted in the sbs logs:

java.lang.ClassCastException: java.lang.Integer cannot be cast to java.lang.Long at com.jivesoftware.community.impl.DbForumThread.loadFromDb_aroundBody4(DbForumThread.java:812)
at com.jivesoftware.community.impl.DbForumThread$AjcClosure5.run(DbForumThread.java:1)
at org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_Abstract TransactionAspect$1$2a73e96cproceed(AbstractTransactionAspect.aj:60)
at org.springframework.transaction.aspectj.AbstractTransactionAspect$AbstractTransactionAspect$1.proceedWithInvocation(AbstractT ransactionAspect.aj:66)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:26 7)
at org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_Abstract TransactionAspect$1$2a73e96c(AbstractTransactionAspect.aj:64)
at com.jivesoftware.community.impl.DbForumThread.loadFromDb(DbForumThread.java:784)
at com.jivesoftware.community.impl.DbForumThread.<init>(DbForumThread.java:221)
at com.jivesoftware.community.impl.DbForumManager.lambda$0(DbForumManager.java:226)
at java.lang.Iterable.forEach(Iterable.java:75)
at com.jivesoftware.community.impl.DbForumManager.getThreads_aroundBody6(DbForumManager.java:217)
at com.jivesoftware.community.impl.DbForumManager$AjcClosure7.run(DbForumManager.java:1)
at org.springframework.transaction.aspectj.AbstractTransactionAspect.ajc$around$org_springframework_transaction_aspectj_Abstract TransactionAspect$1$2a73e96cproceed(AbstractTransactionAspect.aj:60)

Information

Environment

Jive Interactive Intranet-Jive Core-On-Premise 9.0.7

Reproduction Steps

Follow these steps to reproduce the issue and check if it exists in your environment:

1. Upgrade from Jive 9.0.6 to 9.0.7.
2. Access the overview page in the admin console:
   
   • Current Behaviour: Jive SBS Admin Error is raised.
   • Expected Result: No errors are raised.

Root Cause

This is a known defect in the Jive release 9.0.7.0.

The problem is with the DbForumThread.java where Jive tries to read from the database the table jivethreadlatest, column messagecount (which is an integer value in the customer's database (Postgres)) and tries to cast this Integer into Long which does not work and results in an exception.

Process

Upgrade to Jive On-premise 9.0.7.1 to resolve this issue. For more information, refer to JVHOPLE-3770.

Confirmation

Accessing the overview page in the admin console shows no errors and the page loads correctly.