Jive Forum Admin Console Not Showing More Than 65500 Users In User Summary.
(Doc ID 1083375.1)
Last updated on FEBRUARY 04, 2022
Applies to:
Oracle WebCenter Portal - Version 11.1.1.6.0 and laterInformation in this document applies to any platform.
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:
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 |