SQL error when configuring warehouse connection in RRDI with Orace
![]()
Hello all,
When configuring RRDI with Orace during datawarehouse setup I get following error: CRRRA0131E: An error happened when validating the database. 'com.ibm.rational.rrdi.setup.db.common.RRDIDBException: ERROR: ORA-00942: table or view does not exist '. When enabled tracing in log4j.properties: log4j.category.com.ibm.rationa I am getting following error: 05/10/2013 11:10:31,640 DEBUG com.ibm.rational.rrdi.setup.db.common.RRDIDBException : SQL Statement: SELECT CASE WHEN EXISTS (SELECT TABLESPACE_NAME FROM DBA_TABLESPACES WHERE TABLESPACE_NAME='VSTR_IDX' AND CONTENTS='PERMANENT') THEN 'true' ELSE 'false' END AS DOES_EXIST FROM DUAL class com.ibm.rational.rrdi.setup.db.common.RRDIDBException com.ibm.rational.rrdi.setup.dw.RRDIDWStorageAndMemoryValidation.OracletableSpaceExists(RRDIDWStorageAndMemoryValidation.java:540) com.ibm.rational.rrdi.setup.dw.RRDIDWStorageAndMemoryValidation.OracleValidateTablespaces(RRDIDWStorageAndMemoryValidation.java:481) com.ibm.rational.rrdi.setup.dw.RRDIDWStorageAndMemoryValidation.validateTableSpaces(RRDIDWStorageAndMemoryValidation.java:202) com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService.validateDatabase(EnterpriseDataWarehouseStepService.java:322) com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService.handleActions(EnterpriseDataWarehouseStepService.java:571) com.ibm.rational.rrdi.setup.steps.AbstractStepService.doPost(AbstractStepService.java:222) com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService.doPost(EnterpriseDataWarehouseStepService.java:585) com.ibm.team.jfs.app.servlet.AppContainerServlet.dispatchRequest(AppContainerServlet.java:176) com.ibm.team.jfs.app.servlet.AppContainerServlet.service(AppContainerServlet.java:281) javax.servlet.http.HttpServlet.service(HttpServlet.java:722) org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61) org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126) org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:76) javax.servlet.http.HttpServlet.service(HttpServlet.java:722) org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:120) com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:68) javax.servlet.http.HttpServlet.service(HttpServlet.java:722) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) com.ibm.team.repository.server.servletbridge.BridgeFilter.processDelegate(BridgeFilter.java:133) com.ibm.team.repository.server.servletbridge.BridgeFilter.doFilter(BridgeFilter.java:154) org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243) org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210) org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224) org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169) org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472) org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168) org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98) org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:309) org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118) org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407) org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987) org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579) org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307) java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) java.lang.Thread.run(Thread.java:736) When I run this SQL command in SQL prompt I am getting following result: SQL> SELECT CASE WHEN EXISTS (SELECT TABLESPACE_NAME FROM DBA_TABLESPACES WHERE TABLESPACE_NAME='VSTR_IDX' AND CONTENTS='PERMANENT') THEN 'true' ELSE 'false' EN D AS DOES_EXIST FROM DUAL; DOES_ ----- true Any ideas? |
2 answers
Your answer
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.