It's all about the answers!

Ask a question

SQL error when configuring warehouse connection in RRDI with Orace


Krzysztof Kaźmierczyk (7.5k478103) | asked May 10 '13, 5:26 a.m.
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?

2 answers



permanent link
Matthieu Leroux (6571614) | answered May 15 '13, 7:38 a.m.
JAZZ DEVELOPER
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

Comments
Krzysztof Kaźmierczyk commented May 15 '13, 8:11 a.m. | edited May 15 '13, 8:11 a.m.

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


Karl Weinert commented May 16 '13, 7:37 a.m.
JAZZ DEVELOPER

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


permanent link
Krzysztof Kaźmierczyk (7.5k478103) | answered May 16 '13, 5:14 a.m.
I was trying to run following command:
GRANT SELECT ON DBA_TABLESPACES TO <user>;
But it didn't fix the issue :(

Comments
Karl Weinert commented May 16 '13, 7:35 a.m.
JAZZ DEVELOPER

Can you paste in your connection details


Krzysztof Kaźmierczyk commented May 16 '13, 8:16 a.m.

Karl,
what is the reason you want my connection details? Are you especially interested in any particular setting?


Karl Weinert commented May 16 '13, 8:24 a.m.
JAZZ DEVELOPER

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.


Krzysztof Kaźmierczyk commented May 16 '13, 10:11 a.m.

We have tested it. Anyway please notice, that Oracle is case insensitive as default.

Your answer


Register or to post 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.