My Oracle Support Banner

Adding/Removing a User Via The OWB 11g Repository Assistant Fails with java.lang.Exception and ORA-00904: "FROZEN": invalid identifier (Doc ID 1398197.1)

Last updated on FEBRUARY 22, 2023

Applies to:

Oracle Warehouse Builder - Version 11.1 and later
Information in this document applies to any platform.

Symptoms

The OWB 11g Repository Assistant fails to  create a new user showing the following error message:

The workspace user installation failed on user(s):
USERNAME:
java.lang.Exception: SQLException
Persistent Layer Error: SQL Exception
Class Name: CMPPersist.
Method Name: queryObjNameInfo.
Persistent Layer Error Message: ORA-00904: "FROZEN": invalid identifier
SELECT elementid, classname, name, logicalname, uoid, classname, notm, editable, customerrenamable, customerdeletable, seeded, frozen, UpdateTimestamp, strongTypeName, aggregatedSignature, iconObject, signature, OwningFolder, ACLContainer from TreeView_V where owningFolder is null.


The reposinst.log file shows the following:

[CreateNewUser]: User has been created or Altered.
[processFileTokens] ... I am in processFileTokens ...
-token name = SECUSER; -token type = 12
Before processing SECUSER Token
... I am in processSecUserToken()....
JVM LIMIT DISABLED: 256M
Getting connection
--->set the login info...
Start loader thread...
java.sql.SQLException: ORA-00904: "FROZEN": invalid identifier

at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:194)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:791)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:866)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1186)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3387)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3431)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1203)
at oracle.wh.repos.impl.jdbc.PreparedStatementWrapper.executeQuery(PreparedStatementWrapper.java:64)
at oracle.wh.repos.pdl.foundation.NameInfoMediator.queryObjNameInfo(NameInfoMediator.java:369)
at oracle.wh.repos.pdl.foundation.NameInfoMediator.queryObjNameInfo(NameInfoMediator.java:324)
at oracle.wh.repos.pdl.foundation.NameInfoMediator.queryObjNameInfo(NameInfoMediator.java:265)
at oracle.wh.repos.pdl.foundation.CacheMediator.queryObjNameInfo(CacheMediator.java:4601)
at oracle.wh.repos.pdl.foundation.ComponentAssociationCache.loadEntriesIntoCache(ComponentAssociationCache.java:660)
at oracle.wh.repos.pdl.foundation.ComponentAssociationCache.loadEntriesIntoCache(ComponentAssociationCache.java:650)
at oracle.wh.repos.pdl.foundation.ComponentAssociationCache.retrieveClassTable(ComponentAssociationCache.java:615)
at oracle.wh.repos.pdl.foundation.ComponentAssociationCache.retrieve(ComponentAssociationCache.java:114)
at oracle.wh.repos.pdl.foundation.ComponentAssociationCache.setUpCache(ComponentAssociationCache.java:60)
at oracle.wh.repos.pdl.foundation.CacheMediator.setUpCaches(CacheMediator.java:223)
at oracle.wh.repos.pdl.transaction.TransactionManager.setupServices(TransactionManager.java:292)
at oracle.wh.repos.pdl.transaction.TransactionManager.connectToRepository(TransactionManager.java:705)
at oracle.wh.repos.pdl.transaction.TransactionManager.initializeTransaction(TransactionManager.java:194)
at oracle.wh.repos.pdl.transaction.TransactionManager.makeConnection(TransactionManager.java:136)
at oracle.wh.repos.pdl.security.UserManager.startConnAndCtrler(UserManager.java:1779)
at oracle.wh.repos.pdl.security.UserManager.registerOrUnRegOWBUserFromReposAssist(UserManager.java:1691)
at oracle.wh.repos.pdl.security.UserManager.registerOWBUserFromReposAssist(UserManager.java:1670)
at oracle.wh.repos.impl.seed.StandAloneUserRegistration.register(StandAloneUserRegistration.java:34)
at oracle.wh.service.impl.assistant.ProcessEngine.processSecUserToken(ProcessEngine.java:1304)
at oracle.wh.service.impl.assistant.ProcessEngine.processFileTokens(ProcessEngine.java:758)
at oracle.wh.service.impl.assistant.ProcessEngine.createWorkspaceUser(ProcessEngine.java:474)
at oracle.wh.ui.install.assistant.wizards.AssistantWizardDefinition$1.runTask(AssistantWizardDefinition.java:610)
at oracle.ewt.thread.TaskScheduler.runTask(Unknown Source)
at oracle.ewt.thread.TaskScheduler.processTask(Unknown Source)
at oracle.ewt.thread.TaskScheduler$TaskQueue.run(Unknown Source)
at oracle.ewt.timer.Timer.doRun(Unknown Source)
at oracle.ewt.timer.Timer.run(Unknown Source)
at java.lang.Thread.run(Thread.java:595)
SQLException
Persistent Layer Error:SQL Exception..
Class Name: CMPPersist.
Method Name: queryObjNameInfo.
Persistent Layer Error Message: ORA-00904: "FROZEN": invalid identifier
SELECT elementid, classname, name, logicalname, uoid, classname, notm, editable, customerrenamable, customerdeletable, seeded, frozen, UpdateTimestamp, strongTypeName, aggregatedSignature, iconObject, signature, OwningFolder, ACLContainer from TreeView_V where owningFolder is null.

at oracle.wh.repos.pdl.foundation.NameInfoMediator.queryObjNameInfo(NameInfoMediator.java:442)
at oracle.wh.repos.pdl.foundation.NameInfoMediator.queryObjNameInfo(NameInfoMediator.java:324)
at oracle.wh.repos.pdl.foundation.NameInfoMediator.queryObjNameInfo(NameInfoMediator.java:265)
at oracle.wh.repos.pdl.foundation.CacheMediator.queryObjNameInfo(CacheMediator.java:4601)
at oracle.wh.repos.pdl.foundation.ComponentAssociationCache.loadEntriesIntoCache(ComponentAssociationCache.java:660)
at oracle.wh.repos.pdl.foundation.ComponentAssociationCache.loadEntriesIntoCache(ComponentAssociationCache.java:650)
at oracle.wh.repos.pdl.foundation.ComponentAssociationCache.retrieveClassTable(ComponentAssociationCache.java:615)
at oracle.wh.repos.pdl.foundation.ComponentAssociationCache.retrieve(ComponentAssociationCache.java:114)
at oracle.wh.repos.pdl.foundation.ComponentAssociationCache.setUpCache(ComponentAssociationCache.java:60)
at oracle.wh.repos.pdl.foundation.CacheMediator.setUpCaches(CacheMediator.java:223)
at oracle.wh.repos.pdl.transaction.TransactionManager.setupServices(TransactionManager.java:292)
at oracle.wh.repos.pdl.transaction.TransactionManager.connectToRepository(TransactionManager.java:705)
at oracle.wh.repos.pdl.transaction.TransactionManager.initializeTransaction(TransactionManager.java:194)
at oracle.wh.repos.pdl.transaction.TransactionManager.makeConnection(TransactionManager.java:136)
at oracle.wh.repos.pdl.security.UserManager.startConnAndCtrler(UserManager.java:1779)
at oracle.wh.repos.pdl.security.UserManager.registerOrUnRegOWBUserFromReposAssist(UserManager.java:1691)
at oracle.wh.repos.pdl.security.UserManager.registerOWBUserFromReposAssist(UserManager.java:1670)
at oracle.wh.repos.impl.seed.StandAloneUserRegistration.register(StandAloneUserRegistration.java:34)
at oracle.wh.service.impl.assistant.ProcessEngine.processSecUserToken(ProcessEngine.java:1304)
at oracle.wh.service.impl.assistant.ProcessEngine.processFileTokens(ProcessEngine.java:758)
at oracle.wh.service.impl.assistant.ProcessEngine.createWorkspaceUser(ProcessEngine.java:474)
at oracle.wh.ui.install.assistant.wizards.AssistantWizardDefinition$1.runTask(AssistantWizardDefinition.java:610)
at oracle.ewt.thread.TaskScheduler.runTask(Unknown Source)
at oracle.ewt.thread.TaskScheduler.processTask(Unknown Source)
at oracle.ewt.thread.TaskScheduler$TaskQueue.run(Unknown Source)
at oracle.ewt.timer.Timer.doRun(Unknown Source)
at oracle.ewt.timer.Timer.run(Unknown Source)
at java.lang.Thread.run(Thread.java:595)

Changes

 

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


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