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

Last updated on JANUARY 09, 2013

Applies to:

Oracle WebCenter Portal - Version 10.1.3.2.0 to 10.1.3 [Release AS10gR3]
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

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms