RRDI Data Warehouse Setup Error: Cannot run program "db2set": java.io.IOException: error=2, No such file or directory
Hello there,
I didn't see any similar case on JAZZ.net so why i am going to post this topic and asking for a solution, hope anyone interested will solve together.
I have installed RRDI 2.0.4 and setup the RRDI' JTS successfully,
and also fine with copying the db2 drivers and setting up the RICM and the problem came here, the RIDW.
I have input all the fields with correct informations, actually it's as same as the RICM values,
but i have encountered an error after clicked the Verify Button: com.ibm.rational.rrdi.setup.db.common.RRDIDBException: ERROR: Cannot run program "db2set": java.io.IOException: error=2, No such file or directory
I have enabled the trace log and you may find it below,
hope someone would help and i am appreciated with it.
*i am using a db user "db2inst1" to authenticate with the database DW, i have tested the db2set command is able to run on db2inst1 session
*General Exception from GUI: CRRRA0131E: An error happened when validating the database. 'com.ibm.rational.rrdi.setup.db.common.RRDIDBException: ERROR: Cannot run program "db2set": java.io.IOException: error=2, No such file or directory'.
Environment Details:
RHEL 6.3
WAS/IHS/PLG 8.5.0.2
CLM 4.0.4
RRDI 2.0.4
DB2 10.1
Exception in DEBUG MODE:
10/23/2013 19:04:37,213 DEBUG com.ibm.rational.rrdi.setup.dw.RRDIDWDB2Parameters : OS Name: Linux; OS User: wasadmin
10/23/2013 19:04:37,213 DEBUG com.ibm.rational.rrdi.setup.dw.RRDIDWDB2Parameters : validateDB2Param(StringBuilder message)
10/23/2013 19:04:37,213 DEBUG com.ibm.rational.rrdi.setup.db.common.RRDIDBConnection : islocalDBServer()
10/23/2013 19:04:37,213 DEBUG com.ibm.rational.rrdi.setup.dw.RRDIDWDB2Parameters : validateDB2DBSETParams("DB2_SKIPDELETED", "ON", "SE")
10/23/2013 19:04:37,216 ERROR com.ibm.rational.rrdi.setup.db.common.RRDIDBException : ERROR: Cannot run program "db2set": java.io.IOException: error=2, No such file or directory
10/23/2013 19:04:37,217 DEBUG com.ibm.rational.rrdi.setup.db.common.RRDIDBException : SQL Statement: db2set DB2_SKIPDELETED
class com.ibm.rational.rrdi.setup.db.common.RRDIDBException
com.ibm.rational.rrdi.setup.dw.RRDIDWDB2Parameters.validateDB2DBSETParams(RRDIDWDB2Parameters.java:603)
com.ibm.rational.rrdi.setup.dw.RRDIDWDB2Parameters.validateDB2Param(RRDIDWDB2Parameters.java:165)
com.ibm.rational.rrdi.setup.dw.RRDIDWStorageAndMemoryValidation.validateDBParams(RRDIDWStorageAndMemoryValidation.java:1097)
com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService.validateDatabase(EnterpriseDataWarehouseStepService.java:423)
com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService.handleActions(EnterpriseDataWarehouseStepService.java:718)
com.ibm.rational.rrdi.setup.steps.AbstractStepService.doPost(AbstractStepService.java:222)
com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService.doPost(EnterpriseDataWarehouseStepService.java:732)
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:336)
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)
10/23/2013 19:04:37,217 ERROR com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService : com.ibm.rational.rrdi.setup.db.common.RRDIDBException: ERROR: Cannot run program "db2set": java.io.IOException: error=2, No such file or directory
com.ibm.rational.rrdi.setup.db.common.RRDIDBException: ERROR: Cannot run program "db2set": java.io.IOException: error=2, No such file or directory
at com.ibm.rational.rrdi.setup.dw.RRDIDWDB2Parameters.validateDB2DBSETParams(RRDIDWDB2Parameters.java:603)
at com.ibm.rational.rrdi.setup.dw.RRDIDWDB2Parameters.validateDB2Param(RRDIDWDB2Parameters.java:165)
at com.ibm.rational.rrdi.setup.dw.RRDIDWStorageAndMemoryValidation.validateDBParams(RRDIDWStorageAndMemoryValidation.java:1097)
at com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService.validateDatabase(EnterpriseDataWarehouseStepService.java:423)
at com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService.handleActions(EnterpriseDataWarehouseStepService.java:718)
at com.ibm.rational.rrdi.setup.steps.AbstractStepService.doPost(AbstractStepService.java:222)
at com.ibm.rational.rrdi.setup.steps.EnterpriseDataWarehouseStepService.doPost(EnterpriseDataWarehouseStepService.java:732)
at com.ibm.team.jfs.app.servlet.AppContainerServlet.dispatchRequest(AppContainerServlet.java:176)
at com.ibm.team.jfs.app.servlet.AppContainerServlet.service(AppContainerServlet.java:281)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.eclipse.equinox.http.servlet.internal.ServletRegistration.service(ServletRegistration.java:61)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.processAlias(ProxyServlet.java:126)
at org.eclipse.equinox.http.servlet.internal.ProxyServlet.service(ProxyServlet.java:76)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.eclipse.equinox.servletbridge.BridgeServlet.service(BridgeServlet.java:120)
at com.ibm.team.repository.server.servletbridge.JazzServlet.service(JazzServlet.java:68)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at com.ibm.team.repository.server.servletbridge.BridgeFilter.processDelegate(BridgeFilter.java:133)
at com.ibm.team.repository.server.servletbridge.BridgeFilter.doFilter(BridgeFilter.java:154)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
at org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:336)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:307)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
at java.lang.Thread.run(Thread.java:736)
Accepted answer
Hello Yue,
are you running the RRDI setup application with the db2inst1 Linux user?
If not is the user that is running the RRDI setup able to launch db2set?
It could be a file permission or PATH environment variable issue.
Best Regards
Francesco
are you running the RRDI setup application with the db2inst1 Linux user?
If not is the user that is running the RRDI setup able to launch db2set?
It could be a file permission or PATH environment variable issue.
Best Regards
Francesco
One other answer
Hello Francesco,
Thank you very much and you have pointed out a positive troubleshooting direction.
I am running the RRDI' JTS Tomcat with wasadmin,
i have set the db2 environment variable on wasadmin using a same login session during the setup, so why the db2set is still not effective.
I have set up the following to ~/.bashrc and re-login to my wasadmin session, db2set is able to run in the RRDI setup wizard.
if [ -f /home/db2inst1/sqllib/db2profile ]; then
. /home/db2inst1/sqllib/db2profile
fi