首页 文章

数据库错误 - ORA-00904:“UM_MAPPED_ATTRIBUTE_DOMAIN”:标识符无效

提问于
浏览
0

我们正在尝试在Oracle RAC数据库上部署WSO2 GREG 4.6 . 如说明中所述,我们运行了oracle_rac.sql dbscript来创建模式,但是当我们尝试启动应用程序时,它会因多个数据库错误而失败

[2014-03-11 21:42:58,366]错误 - 数据库错误 - ORA-00904:“UM_MAPPED_ATTRIBUTE_DOMAIN”:标识符无效

java.sql.SQLSyntaxErrorException:ORA-00904:“UM_MAPPED_ATTRIBUTE_DOMAIN”:标识符无效

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1046)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3694)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1354)
at org.wso2.carbon.user.core.claim.dao.ClaimDAO.addClaimMapping(ClaimDAO.java:227)
at org.wso2.carbon.user.core.claim.dao.ClaimDAO.addCliamMappings(ClaimDAO.java:140)
at org.wso2.carbon.user.core.common.DefaultRealm.populateProfileAndClaimMaps(DefaultRealm.java:420)
at org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRealm.java:101)
at org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:223)
at org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:101)
at org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:114)
at org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:70)
at org.wso2.carbon.user.core.internal.BundleCheckActivator.start(BundleCheckActivator.java:61)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:711)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:702)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:683)
at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:381)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:390)
at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1176)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:559)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:544)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:457)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:243)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:438)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:1)
at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230)
at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:340)

[2014-03-11 21:42:58,373] ERROR - 无法初始化领域 . org.wso2.carbon.user.core.UserStoreException:数据库错误 - ORA-00904:“UM_MAPPED_ATTRIBUTE_DOMAIN”:标识符无效

at org.wso2.carbon.user.core.claim.dao.ClaimDAO.addClaimMapping(ClaimDAO.java:261)
at org.wso2.carbon.user.core.claim.dao.ClaimDAO.addCliamMappings(ClaimDAO.java:140)
at org.wso2.carbon.user.core.common.DefaultRealm.populateProfileAndClaimMaps(DefaultRealm.java:420)
at org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRealm.java:103)
at org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:223)
at org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:101)
at org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:115)
at org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:71)
at org.wso2.carbon.user.core.internal.BundleCheckActivator.start(BundleCheckActivator.java:61)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:711)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:702)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:683)
at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:381)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:390)
at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1176)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:559)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:545)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:458)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:243)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:438)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:1)
at org.eclipse.osgi.framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230)
at org.eclipse.osgi.framework.eventmgr.EventManager$EventThread.run(EventManager.java:340)

引起:java.sql.SQLSyntaxErrorException:ORA-00904:“UM_MAPPED_ATTRIBUTE_DOMAIN”:标识符无效

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1046)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3694)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1354)
at org.wso2.carbon.user.core.claim.dao.ClaimDAO.addClaimMapping(ClaimDAO.java:227)
at org.wso2.carbon.user.core.claim.dao.ClaimDAO.addCliamMappings(ClaimDAO.java:140)
at org.wso2.carbon.user.core.common.DefaultRealm.populateProfileAndClaimMaps(DefaultRealm.java:420)
at org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRealm.java:101)
at org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:223)
at org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:101)
at org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:114)
at org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:70)
at org.wso2.carbon.user.core.internal.BundleCheckActivator.start(BundleCheckActivator.java:61)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:711)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:702)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:683)
at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:381)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:390)
at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1176)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:559)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:544)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:457)
... 5 more

[2014-03-11 21:42:58,375] ERROR - 无法启动用户管理器核心包org.wso2.carbon.user.core.UserStoreException:无法初始化领域 . org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:231)位于org.wso2的org.wso2.carbon.user.core.common.DefaultRealmService . (DefaultRealmService.java:101) . carbon.user.core.common.DefaultRealmService . (DefaultRealmService.java:114)位于org.wso2.carbon.user.core的org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:70) .internal.BundleCheckActivator.start(BundleCheckActivator.java:61)位于org.eclipse.osgi.framework.internal.core的org.eclipse.osgi.framework.internal.core.BundleContextImpl $ 1.run(BundleContextImpl.java:711) . BundleContextImpl.startActivator(BundleContextImpl.java:702)org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:683)org.eclipse.osgi.framework.internal.core.BundleHost.startWorker( BundleHost.java:381)org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:390)org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framewo) rk.java:1176)org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:559)org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java: 545)org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:458)org.eclipse.osgi.framework.internal.core.StartLevelManager.doSetStartLevel(StartLevelManager.java:243)at org位于org.eclipse.osgi的org.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:1)的.eclipse.osgi.framework.internal.core.StartLevelManager.dispatchEvent(StartLevelManager.java:438) .framework.eventmgr.EventManager.dispatchEvent(EventManager.java:230)at or.e.eclipse.osgi.framework.eventmgr.EventManager $ EventThread.run(EventManager.java:340)引起:org.wso2.carbon.user.core .UserStoreException:数据库错误 - ORA-00904:“UM_MAPPED_ATTRIBUTE_DOMAIN”:标识符无效

at org.wso2.carbon.user.core.claim.dao.ClaimDAO.addClaimMapping(ClaimDAO.java:261)
at org.wso2.carbon.user.core.claim.dao.ClaimDAO.addCliamMappings(ClaimDAO.java:140)
at org.wso2.carbon.user.core.common.DefaultRealm.populateProfileAndClaimMaps(DefaultRealm.java:420)
at org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRealm.java:103)
at org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:223)
at org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:101)
at org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:115)
at org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:71)
... 15 more

引起:java.sql.SQLSyntaxErrorException:ORA-00904:“UM_MAPPED_ATTRIBUTE_DOMAIN”:标识符无效

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1046)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1336)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3613)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3694)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1354)
at org.wso2.carbon.user.core.claim.dao.ClaimDAO.addClaimMapping(ClaimDAO.java:227)
at org.wso2.carbon.user.core.claim.dao.ClaimDAO.addCliamMappings(ClaimDAO.java:140)
at org.wso2.carbon.user.core.common.DefaultRealm.populateProfileAndClaimMaps(DefaultRealm.java:420)
at org.wso2.carbon.user.core.common.DefaultRealm.init(DefaultRealm.java:101)
at org.wso2.carbon.user.core.common.DefaultRealmService.initializeRealm(DefaultRealmService.java:223)
at org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:101)
at org.wso2.carbon.user.core.common.DefaultRealmService.<init>(DefaultRealmService.java:114)
at org.wso2.carbon.user.core.internal.Activator.startDeploy(Activator.java:70)
at org.wso2.carbon.user.core.internal.BundleCheckActivator.start(BundleCheckActivator.java:61)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl$1.run(BundleContextImpl.java:711)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.startActivator(BundleContextImpl.java:702)
at org.eclipse.osgi.framework.internal.core.BundleContextImpl.start(BundleContextImpl.java:683)
at org.eclipse.osgi.framework.internal.core.BundleHost.startWorker(BundleHost.java:381)
at org.eclipse.osgi.framework.internal.core.AbstractBundle.resume(AbstractBundle.java:390)
at org.eclipse.osgi.framework.internal.core.Framework.resumeBundle(Framework.java:1176)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:559)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.resumeBundles(StartLevelManager.java:544)
at org.eclipse.osgi.framework.internal.core.StartLevelManager.incFWSL(StartLevelManager.java:457)
... 5 more

[2014-03-11 21:43:12,809] INFO - 跳过TLD . URI:http://tiles.apache.org/tags-tiles已定义

我们错过了一些步骤吗?

谢谢 .

1 回答

  • 0

    我认为,WSO2产品不附带已更新的 oracle_rac.sql 脚本文件(基本上是Carbon 4.2.0之后的版本) . 有4.2.0的数据库架构更改..但这些更改尚未与 oracle_rac.sql 合并 . 因此你不能使用它 . 但 oracle.sql 文件工作正常...所以如果你只是比较 oracle.sqloracle_rac.sql 文件 . 您可以编辑 oracle_rac.sql 文件并使其正常工作 . 我建议1st获取 oracle.sql 文件并更新它以支持 oracle_rac .

    然后突出了我所看到的不同

    oracle.sql 文件中,您可以找到以下内容

    以1 NOCACHE开始增加1次

    oracle_rac.sql 中,您可以将其更改为以下内容

    以1缓存20顺序开始增加1

    希望这会对你有所帮助 .

相关问题