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
l.rrdi.setup=TRACE, stdout, RRDI.LOG
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?
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
Hi Krzys,
can you try to run SELECT TABLESPACE_NAME FROM DBA_TABLESPACES with the user you specify in the datawarehouse configuration page from sql plus or other oracle query tool?
if you are getting the same error message, it might be a right issue
Hope this helps.
Matthieu
can you try to run SELECT TABLESPACE_NAME FROM DBA_TABLESPACES with the user you specify in the datawarehouse configuration page from sql plus or other oracle query tool?
if you are getting the same error message, it might be a right issue
Hope this helps.
Matthieu
Comments
I was trying to run following command:
GRANT SELECT ON DBA_TABLESPACES TO <user>;
But it didn't fix the issue :(
GRANT SELECT ON DBA_TABLESPACES TO <user>;
But it didn't fix the issue :(