9:05 a.m.
Bug creating jbp tables using Oracle as the database server
-----------------------------------------------------------
Key: JBPORTAL-1375
URL: http://jira.jboss.com/jira/browse/JBPORTAL-1375
Project: JBoss Portal
Issue Type: Bug
Security Level: Public (Everyone can see)
Components: Portal Server
Affects Versions: 2.6.CR1
Environment: Solaris or Windows XP
Reporter: Stephen Westbom
Assigned To: Julien Viet
Priority: Blocker
09:43:03,493 WARN [EhCacheProvider] Could not find configuration
[org.hibernate.cache.StandardQueryCache]; using defaults.
09:43:03,633 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
09:43:03,633 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not exist
09:43:03,665 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
09:43:03,665 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not exist
09:43:03,680 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
09:43:03,680 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not exist
09:43:03,696 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
09:43:03,696 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not exist
09:43:03,711 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
09:43:03,711 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not exist
09:43:03,711 INFO [Dialect] Using dialect: org.hibernate.dialect.Oracle9Dialect
09:43:03,727 INFO [SchemaExport] Running hbm2ddl schema export
09:43:03,743 INFO [SchemaExport] exporting generated schema to database
09:43:03,743 INFO [NamingHelper] JNDI InitialContext properties:{}
09:43:03,743 INFO [DatasourceConnectionProvider] Using datasource: java:PortalDS
09:43:03,899 ERROR [SchemaExport] Unsuccessful: create table JBP_ENDPOINT_INFO (PK
number(19,0) not null, SD_URL varchar2(255 char) not null, M_URL varchar2(255 char) not
null, PM_URL varchar2(255 char), R_URL varchar2(255 char), WSDL_URL varchar2(255 char),
primary key (PK))
09:43:03,899 ERROR [SchemaExport] ORA-01658: unable to create INITIAL extent for segment
in tablespace RJDATA
09:43:03,915 ERROR [SchemaExport] Unsuccessful: create table JBP_PRODUCER_INFO (PK
number(19,0) not null, ENDPOINT_ID number(19,0) not null unique, REGISTRATION_ID
number(19,0) unique, EXPIRATION_CACHE_SECONDS number(10,0), active number(1,0) not null,
id varchar2(255 char) not null unique, primary key (PK))
09:43:03,915 ERROR [SchemaExport] ORA-01658: unable to create INITIAL extent for segment
in tablespace RJDATA
09:43:03,930 ERROR [SchemaExport] Unsuccessful: create table JBP_REGISTRATION_INFO (PK
number(19,0) not null, CONSUMER_NAME varchar2(255 char) not null, HANDLE varchar2(255
char), STATE raw(255), primary key (PK))
09:43:03,930 ERROR [SchemaExport] ORA-01658: unable to create INITIAL extent for segment
in tablespace RJDATA
09:43:03,946 ERROR [SchemaExport] Unsuccessful: create table JBP_REG_PROPERTY (PK
number(19,0) not null, name varchar2(255 char) not null, value varchar2(255 char) not
null, invalid number(1,0), lang varchar2(255 char), DESC_PK number(19,0) unique, REG_PK
number(19,0) not null, primary key (PK))
09:43:03,946 ERROR [SchemaExport] ORA-01658: unable to create INITIAL extent for segment
in tablespace RJDATA
09:43:03,946 ERROR [SchemaExport] Unsuccessful: create table JBP_REG_PROP_DESC (PK
number(19,0) not null, name varchar2(255 char) not null, type varchar2(255 char) not null,
SCHEMA varchar2(255 char), DESC_VALUE varchar2(255 char), DESC_LOCALE varchar2(255 char),
DESC_RES varchar2(255 char), HINT_VALUE varchar2(255 char), HINT_LOCALE varchar2(255
char), HINT_RES varchar2(255 char), LABEL_VALUE varchar2(255 char), LABEL_LOCALE
varchar2(255 char), LABEL_RES varchar2(255 char), primary key (PK))
09:43:03,946 ERROR [SchemaExport] ORA-01658: unable to create INITIAL extent for segment
in tablespace RJDATA
09:43:03,961 ERROR [SchemaExport] Unsuccessful: create table JBP_REG_PROP_DESC_ALIASES (PK
number(19,0) not null, ALIAS varchar2(255 char) not null, IDX number(10,0) not null,
primary key (PK, IDX))
09:43:03,961 ERROR [SchemaExport] ORA-01658: unable to create INITIAL extent for segment
in tablespace RJDATA
09:43:03,977 ERROR [SchemaExport] Unsuccessful: create table JBP_REG_PROP_DESC_USAGES (PK
number(19,0) not null, USAGE varchar2(255 char) not null, IDX number(10,0) not null,
primary key (PK, IDX))
09:43:03,977 ERROR [SchemaExport] ORA-01658: unable to create INITIAL extent for segment
in tablespace RJDATA
09:43:03,977 ERROR [SchemaExport] Unsuccessful: alter table JBP_PRODUCER_INFO add
constraint FK7282A754747FC32F foreign key (ENDPOINT_ID) references JBP_ENDPOINT_INFO
09:43:03,977 ERROR [SchemaExport] ORA-00942: table or view does not exist
09:43:03,993 ERROR [SchemaExport] Unsuccessful: alter table JBP_PRODUCER_INFO add
constraint FK7282A7544EE0278D foreign key (REGISTRATION_ID) references
JBP_REGISTRATION_INFO
09:43:03,993 ERROR [SchemaExport] ORA-00942: table or view does not exist
09:43:03,993 ERROR [SchemaExport] Unsuccessful: alter table JBP_REG_PROPERTY add
constraint FKC86C78072FBF86B2 foreign key (REG_PK) references JBP_REGISTRATION_INFO
09:43:03,993 ERROR [SchemaExport] ORA-00942: table or view does not exist
09:43:03,993 ERROR [SchemaExport] Unsuccessful: alter table JBP_REG_PROPERTY add
constraint FKC86C78072F43055 foreign key (DESC_PK) references JBP_REG_PROP_DESC
09:43:03,993 ERROR [SchemaExport] ORA-00942: table or view does not exist
09:43:03,993 ERROR [SchemaExport] Unsuccessful: alter table JBP_REG_PROP_DESC_ALIASES add
constraint FKB556AC9AA6289FE7 foreign key (PK) references JBP_REG_PROP_DESC
09:43:03,993 ERROR [SchemaExport] ORA-00942: table or view does not exist
09:43:04,008 ERROR [SchemaExport] Unsuccessful: alter table JBP_REG_PROP_DESC_USAGES add
constraint FKFF0F31B6A6289FE7 foreign key (PK) references JBP_REG_PROP_DESC
09:43:04,008 ERROR [SchemaExport] ORA-00942: table or view does not exist
09:43:04,024 INFO [SchemaExport] schema export complete
09:43:04,165 WARN [JDBCExceptionReporter] SQL Error: 942, SQLState: 42000
09:43:04,165 ERROR [JDBCExceptionReporter] ORA-00942: table or view does not exist
09:43:04,196 WARN [ServiceController] Problem starting service
portal.wsrp:service=ConsumerRegistry
org.hibernate.exception.SQLGrammarException: could not execute query using iterate
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:444)
at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl.java:380)
at org.hibernate.engine.query.HQLQueryPlan.performIterate(HQLQueryPlan.java:224)
at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1192)
at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:46)
at
org.jboss.portal.wsrp.consumer.ConsumerRegistryService.org$jboss$portal$wsrp$consumer$ConsumerRegistryService$startService$aop(ConsumerRegistryService.java:183)
at
org.jboss.portal.wsrp.consumer.ConsumerRegistryService$startService_N522319811864268586.invokeNext(ConsumerRegistryService$startService_N522319811864268586.java)
at org.jboss.aspects.tx.TxPolicy.invokeInCallerTx(TxPolicy.java:126)
at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:195)
at
org.jboss.portal.wsrp.consumer.ConsumerRegistryService$startService_N522319811864268586.invokeNext(ConsumerRegistryService$startService_N522319811864268586.java)
at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:191)
at
org.jboss.portal.wsrp.consumer.ConsumerRegistryService$startService_N522319811864268586.invokeNext(ConsumerRegistryService$startService_N522319811864268586.java)
at
org.jboss.portal.wsrp.consumer.ConsumerRegistryService.startService(ConsumerRegistryService.java)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
at
org.jboss.portal.jems.as.system.AbstractJBossService.start(AbstractJBossService.java:73)
at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.jboss.portal.jems.as.system.JBossServiceModelMBean$ServiceMixin.execute(JBossServiceModelMBean.java:428)
at
org.jboss.portal.jems.as.system.JBossServiceModelMBean$ServiceMixin.startService(JBossServiceModelMBean.java:394)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
at
org.jboss.portal.jems.as.system.JBossServiceModelMBean$5.invoke(JBossServiceModelMBean.java:316)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:995)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:417)
at org.jboss.system.ServiceController.start(ServiceController.java:435)
at org.jboss.system.ServiceController.start(ServiceController.java:435)
at org.jboss.system.ServiceController.start(ServiceController.java:435)
at org.jboss.system.ServiceController.start(ServiceController.java:435)
at org.jboss.system.ServiceController.start(ServiceController.java:435)
at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy4.start(Unknown Source)
at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy160.start(Unknown Source)
at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:197)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
at sun.reflect.GeneratedMethodAccessor114.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy8.deploy(Unknown Source)
at
org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
at
org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
at
org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at
org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:417)
at sun.reflect.GeneratedMethodAccessor12.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy4.start(Unknown Source)
at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at
org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy5.deploy(Unknown Source)
at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
at org.jboss.Main.boot(Main.java:200)
at org.jboss.Main$1.run(Main.java:490)
at java.lang.Thread.run(Thread.java:595)
Caused by: 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:1037)
at
oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:839)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
at
oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3316)
at
oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3361)
at
org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:236)
at org.hibernate.jdbc.AbstractBatcher.getResultSet(AbstractBatcher.java:186)
at org.hibernate.loader.Loader.getResultSet(Loader.java:1668)
at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:421)
... 132 more
09:43:04,211 INFO [NamingHelper] JNDI InitialContext properties:{}
09:43:04,211 INFO [DatasourceConnectionProvider] Using datasource: java:PortalDS
09:43:04,211 INFO [SettingsFactory] RDBMS: Oracle, version: Oracle9i Enterprise Edition
Release 9.2.0.5.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production
09:43:04,211 INFO [SettingsFactory] JDBC driver: Oracle JDBC driver, version: 10.2.0.2.0
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira