[jboss-jira] [JBoss JIRA] Assigned: (JBPORTAL-1375) Bug creating jbp tables using Oracle as the database server

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 WSRP Affects Versions: 2.6.CR1 Environment: Solaris or Windows XP Reporter: Stephen Westbom Assigned To: Chris Laprun Priority: Blocker Fix For: 2.6 Final 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