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
12:33 p.m.
New subject: [JBoss JIRA] Assigned: (JBPORTAL-1375) Bug creating jbp tables using Oracle as the database server
[ http://jira.jboss.com/jira/browse/JBPORTAL-1375?page=all ]
Chris Laprun reassigned JBPORTAL-1375:
--------------------------------------
Assignee: Chris Laprun (was: Julien Viet)
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
--
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
12:33 p.m.
New subject: [JBoss JIRA] Commented: (JBPORTAL-1375) Bug creating jbp tables using Oracle as the database server
[ http://jira.jboss.com/jira/browse/JBPORTAL-1375?page=comments#action_1236... ]
Chris Laprun commented on JBPORTAL-1375:
----------------------------------------
What do you mean by: "fix the Hibernate mappings again I would guess"?
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: Julien Viet
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
--
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
12:33 p.m.
New subject: [JBoss JIRA] Updated: (JBPORTAL-1375) Bug creating jbp tables using Oracle as the database server
[ http://jira.jboss.com/jira/browse/JBPORTAL-1375?page=all ]
Chris Laprun updated JBPORTAL-1375:
-----------------------------------
Component/s: Portal WSRP
(was: Portal Server)
Fix Version/s: 2.6 Final
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
--
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
1:53 p.m.
New subject: [JBoss JIRA] Commented: (JBPORTAL-1375) Bug creating jbp tables using Oracle as the database server
[ http://jira.jboss.com/jira/browse/JBPORTAL-1375?page=comments#action_1236... ]
Prabhat Jha commented on JBPORTAL-1375:
---------------------------------------
Chris, I have asked Alex K. to crate a database for you to play with on oracle9i instance
we have. I will send you the details once I have it.
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
--
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
2:31 p.m.
New subject: [JBoss JIRA] Commented: (JBPORTAL-1375) Bug creating jbp tables using Oracle as the database server
[ http://jira.jboss.com/jira/browse/JBPORTAL-1375?page=comments#action_1236... ]
Prabhat Jha commented on JBPORTAL-1375:
---------------------------------------
Chris,
Please try this:
<connection-url>jdbc:oracle:thin:@dev20.qa.atl.jboss.com:qa</connection-url>
<driver-class>YOUR_DRIVER_CLASS</driver-class>
<user-name>portal_playground</user-name>
<password>PING_ME</password>
In qa labs, drivers are in /opt/jdbc-drivers. If you don't find one that's
mentioned in this issue, you may have to download yourself. Please let me know if you have
any trouble accesssing it.
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
--
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
10:55 p.m.
New subject: [JBoss JIRA] Resolved: (JBPORTAL-1375) Bug creating jbp tables using Oracle as the database server
[ http://jira.jboss.com/jira/browse/JBPORTAL-1375?page=all ]
Chris Laprun resolved JBPORTAL-1375.
------------------------------------
Resolution: Cannot Reproduce Bug
Cannot reproduce with the head version of Portal and:
[SettingsFactory] RDBMS: Oracle, version: Oracle9i Enterprise Edition Release 9.2.0.1.0 -
Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
23:49:25,711 INFO [SettingsFactory] JDBC driver: Oracle JDBC driver, version: 10.2.0.2.0
23:49:25,712 INFO [Dialect] Using dialect: org.hibernate.dialect.Oracle9Dialect
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
--
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
6978
days inactive
6988
days old
6 comments
3 participants
participants (3)
-
Chris Laprun (JIRA) -
Prabhat Jha (JIRA)
-
Stephen Westbom (JIRA)