My Oracle Support Banner

Jive Forum Admin Console Not Showing More Than 65500 Users In User Summary. (Doc ID 1083375.1)

Last updated on FEBRUARY 25, 2019

Applies to:

Oracle WebCenter Portal - Version 11.1.1.6.0 and later
Information in this document applies to any platform.
Document checked for relevance: 09-January-2013

Symptoms


Create more than 65500 users in a jive instance.
Browse to the admin page and choose to review user /group information.
In the "user summary" when moving over the 65500 user, the page displays as
blank.

The following error is seen in the jive log:

Jan 10, 2010 11:00:23 PM com.jivesoftware.base.Log error
SEVERE: Bigger type length than Maximum
java.sql.SQLException: Bigger type length than Maximum
at
oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:70)
at
oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:112)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:173)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:229)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:403)
at
oracle.jdbc.driver.T4CMAREngine.buffer2Value(T4CMAREngine.java:2242)
at
oracle.jdbc.driver.T4CMAREngine.unmarshalUB2(T4CMAREngine.java:1090)
at oracle.jdbc.driver.T4C8TTIrxh.unmarshalV10(T4C8TTIrxh.java:115)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:650)
at
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)

at
oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1011)
at
oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:314)
at
oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:228)
at
weblogic.jdbc.wrapper.ResultSet_oracle_jdbc_driver_OracleResultSetImpl.next(Unknown Source)
at
com.jivesoftware.base.database.DbUserManager.users(DbUserManager.java:329)
at
com.jivesoftware.base.UserManagerProxy.users(UserManagerProxy.java:104)
(...)
<Jan 10, 2010 11:02:14 PM EST> <Error> <JDBC> <BEA-001112> <Test "SELECT 1
FROM DUAL" set up for pool "JDBC Dicussion Forums" failed with exception:
"java.sql.SQLException: OALL8 is in an inconsistent state".>



Steps to Reproduce
==================
1. Create a new OWC Discussion 10.1.3.4 instance.

2. Make sure your OWC Discussion has more than 65500 users.

3. Browse to the owc_discussion/admin page and select the Users/Groups link

4. You should be able to see all the users. Click the last page link.

5. It displays completely blank. So, click the former one... --> ERROR IN LOGS

6. You now will see 0 users. This is the problem!!

7. Tweak the URL back to:
http://<HOST>:<PORT>/owc_discussions/admin/users-main.jsp?start=1
... and things start to work back again (eventually).

Changes

Add more than 65500 users in OWC Discussions

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.