It's all about the answers!

Ask a question

SQL error when configuring warehouse connection in RRDI with Orace


Krzysztof Kaźmierczyk (7.4k34693) | 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 (6571612) | 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.4k34693) | 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.