My Oracle Support Banner

WebCenter Sites tries to rename SystemUsers table to tx[i]SystemUsers and fails due to ORA-04043: object SYSTEMUSERS does not exist (Doc ID 1944297.1)

Last updated on JULY 07, 2017

Applies to:

Oracle WebCenter Sites - Version 11.1.1.8.0 and later
Information in this document applies to any platform.

Symptoms

SystemUsers table is missing from the environment, and it was noticed that tons of tx[i]SystemUsers table were created (i is integer >=2).

Additionally, it seems that every time the server restarts, Sites is trying to rename SystemUsers table to tx[i]SystemUsers and this fails due to "ORA-04043: object SYSTEMUSERS does not exist".

Sample errors:

[2014-11-11 14:31:04,348 UTC] [ERROR] [http-bio-8180-exec-1] [fatwire.logging.cs.db] SQLException in prepared execute on table SystemUsers: SELECT * FROM SystemUsers
java.sql.SQLException: ORA-00942: table or view does not exist

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:799)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1039)
    at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1132)
    at oracle.jdbc.driver.OracleStatement.doScrollExecuteCommon(OracleStatement.java:4055)
    at oracle.jdbc.driver.OraclePreparedStatement.doScrollPstmtExecuteUpdate(OraclePreparedStatement.java:10763)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3283)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
    at COM.FutureTense.Servlet.JDBCTable.executeQuery_trans_logic(JDBCTable.java:1718)
    at COM.FutureTense.Servlet.JDBCTable.executeQuery_trans(JDBCTable.java:1652)
    at COM.FutureTense.Servlet.JDBCTable.executeQuery(JDBCTable.java:1475)
    at COM.FutureTense.Servlet.JDBCTable.SelectRow(JDBCTable.java:1048)
    at COM.FutureTense.Common.ftDBTable.selectTo(ftDBTable.java:2238)
    at COM.FutureTense.Common.ftDBTable.recreate(ftDBTable.java:3546)
    at COM.FutureTense.Access.ftUsers.updateDB(ftUsers.java:136)
    at COM.FutureTense.Access.StandardUsers.getUserID(ftUsers.java:472)
    at COM.FutureTense.Access.AccessEngine.doLogin(AccessEngine.java:424)
    at COM.FutureTense.Access.AccessEngine.doLogin(AccessEngine.java:403)
    at COM.FutureTense.Common.ftAppLogic.checkLogin(ftAppLogic.java:3262)
    at COM.FutureTense.Common.ContentServer._doCheckLogin(ContentServer.java:590)
    at COM.FutureTense.Common.ContentServer.execute(ContentServer.java:458)
...
[2014-11-11 14:31:06,053 UTC] [ERROR] [http-bio-8180-exec-4] [fatwire.logging.cs.db] SQLException executing statement: rename SystemUsers to tx59SystemUsers
java.sql.SQLException: ORA-04043: object SYSTEMUSERS does not exist

    at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
    at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:207)
    at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:946)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
    at oracle.jdbc.driver.OracleStatement.executeUpdateInternal(OracleStatement.java:1614)
    at oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:1579)
    at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
    at org.apache.tomcat.dbcp.dbcp.DelegatingStatement.executeUpdate(DelegatingStatement.java:228)
    at COM.FutureTense.Servlet.JDBCConn._executeDDLTrans(JDBCConn.java:1411)
    at COM.FutureTense.Servlet.JDBCConn.executeDDL(JDBCConn.java:1296)
    at COM.FutureTense.Common.ftDBTable.renameTable(ftDBTable.java:3498)
    at COM.FutureTense.Common.ftDBTable.recreate(ftDBTable.java:3574)
    at COM.FutureTense.Access.ftUsers.updateDB(ftUsers.java:136)
    at COM.FutureTense.Access.StandardUsers.getUserID(ftUsers.java:472)
    at COM.FutureTense.Access.AccessEngine.doLogin(AccessEngine.java:424)
    at COM.FutureTense.Access.AccessEngine.doLogin(AccessEngine.java:403)
    at COM.FutureTense.Common.ftAppLogic.checkLogin(ftAppLogic.java:3262)
    at COM.FutureTense.Common.ContentServer._doCheckLogin(ContentServer.java:590)
    at COM.FutureTense.Common.ContentServer.execute(ContentServer.java:458)

 

Changes

The db user was recently given additional roles/privileges (e.g. DBA role) that allow the user to access multiple db schemas.

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.