SQL error when configuring warehouse connection in RRDI with Orace
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
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
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
Krzysztof did you run the above command as the user you are trying to use in RRDI?
For example since I used ccm for my ccm tablespace I would log in to sqlpus as ccm
C:\>sqlplus
SQLPlus: Release 11.2.0.2.0 Production on Thu May 16 07:34:58 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter user-name: ccm
Enter password:**
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
GRANT SELECT ON DBA_TABLESPACES TO <user>;
But it didn't fix the issue :(
Comments
Can you paste in your connection details
Karl,
what is the reason you want my connection details? Are you especially interested in any particular setting?
I don't have anything specific, just trying to get a better picture of the problem.
I did see an issue where a customer used the wrong case in the connection details. That seemed to cause an odd error trying to populate the database. So maybe I have that in the back of my mind.
We have tested it. Anyway please notice, that Oracle is case insensitive as default.