Labels

Tuesday, June 25, 2013

Cannot build directory item for key 'communication_security_passphrase' in TD Params Directory,



We faced this issue due to same server we installed database and ALM 11 software’s, so when we try to access ALM11 we are getting below error.


Solution: - We need to make it HP ALM Quality Center service is manual then once Oracle services started we need to start HP ALM Quality Center service.


 
QC Server on 'XXXXX' is MUTED

status=MUTED, label=QC server is muted due to unrecoverable error, reason=Cannot build directory item for key 'communication_security_passphrase' in TD Params Directory,
StackTrace=
java.sql.SQLNonTransientConnectionException: [Mercury][Oracle JDBC Driver]Error establishing socket to host and port: XXXXXXXX:1521. Reason: Connection refused: connect
at com.mercury.jdbc.oraclebase.dda4.b(Unknown Source)
at com.mercury.jdbc.oraclebase.dda4.a(Unknown Source)
at com.mercury.jdbc.oraclebase.dda3.b(Unknown Source)
at com.mercury.jdbc.oraclebase.dda3.a(Unknown Source)
at com.mercury.jdbc.oracle.OracleImplConnection.a(Unknown Source)
at com.mercury.jdbc.oracle.OracleImplConnection.ab(Unknown Source)
at com.mercury.jdbc.oracle.OracleImplConnection.a(Unknown Source)
at com.mercury.jdbc.oracle.OracleImplConnection.t(Unknown Source)
at com.mercury.jdbc.oraclebase.BaseConnection.a(Unknown Source)
at com.mercury.jdbc.oraclebase.BaseConnection.i(Unknown Source)
at com.mercury.jdbc.oraclebase.BaseConnection.a(Unknown Source)
at com.mercury.jdbc.oraclebase.BaseConnection.a(Unknown Source)
at com.mercury.jdbc.oraclebase.BaseDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at com.mercury.optane.core.db.CTdDriverManager.getConnection(CTdDriverManager.java:81)
wrapped in com.mercury.optane.core.CTdException: 
at com.mercury.optane.core.db.CTdDriverManager.getConnection(CTdDriverManager.java:88)
at com.mercury.optane.core.db.CConnectionPool.newConnection(CConnectionPool.java:836)
at com.mercury.optane.core.db.CConnectionPool.tryToGetConnection(CConnectionPool.java:623)
at com.mercury.optane.core.db.CConnectionPool.getConnection(CConnectionPool.java:390)
at com.mercury.optane.core.db.CConnectionManager.getNotTransactedConnection(CConnectionManager.java:240)
at com.mercury.optane.core.db.CConnectionManager.getConnection(CConnectionManager.java:213)
at com.mercury.optane.core.db.CConnectionManager.getConnection(CConnectionManager.java:167)
at com.mercury.optane.core.db.CDatabaseFieldsInfo.obtainInfo(CDatabaseFieldsInfo.java:142)
wrapped in com.mercury.optane.core.CTdException: Failed to fill table struct for table null in database qcsiteadmin_db@jdbc:mercury:oracle://WIPRO.btcbahamas.com:1521;sid=wiprotst(qcsiteadmin_db)
at com.mercury.optane.core.db.CDatabaseFieldsInfo.obtainInfo(CDatabaseFieldsInfo.java:188)
at com.mercury.optane.core.db.CDatabaseFieldsInfo.<init>(CDatabaseFieldsInfo.java:83)
at com.mercury.optane.core.db.CAbsTablesStructDirectory.createDirectoryItem(CAbsTablesStructDirectory.java:47)
at com.mercury.optane.core.directory.CAbsDirectory$CacheResult.getOrCreate(CAbsDirectory.java:66)
wrapped in com.mercury.optane.core.CTdException: Cannot build directory item for key '[qcsiteadmin_db@jdbc:mercury:oracle://xxx.xxx.com:1521;sid=xxxxt(qcsiteadmin_db)]' in SA Global Struct Dir
at com.mercury.optane.core.directory.CAbsDirectory$CacheResult.getOrCreate(CAbsDirectory.java:77)
at com.mercury.optane.core.directory.CAbsDirectory.getDirectoryItem(CAbsDirectory.java:166)
at com.mercury.optane.core.db.CAbsTablesStructDirectory.getDatabaseFieldsInfo(CAbsTablesStructDirectory.java:27)
at com.mercury.td.saserver.sautil.CSaTablesStructDirectory.getSaDatabaseFieldsInfo(CSaTablesStructDirectory.java:55)
at com.mercury.td.saserver.directory.CDBFetcher.fetchItem(CDBFetcher.java:164)
at com.mercury.td.saserver.directory.CSaAbsDirectoryItem.loadData(CSaAbsDirectoryItem.java:147)
at com.mercury.td.saserver.directory.CSaAbsDirectoryItem.loadData(CSaAbsDirectoryItem.java:142)
at com.mercury.td.saserver.directory.CSaAbsDirectoryItem.refreshFromDb(CSaAbsDirectoryItem.java:219)
at com.mercury.td.saserver.directory.CTdParam.refreshFromDb(CTdParam.java:95)
at com.mercury.td.saserver.directory.CTdParam.<init>(CTdParam.java:59)
at com.mercury.td.saserver.directory.CTdParamsDirectory.createDirectoryItem(CTdParamsDirectory.java:79)
at com.mercury.optane.core.directory.CAbsDirectory$CacheResult.getOrCreate(CAbsDirectory.java:66)
wrapped in com.mercury.optane.core.CTdException: Cannot build directory item for key 'communication_security_passphrase' in TD Params Directory
at com.mercury.optane.core.directory.CAbsDirectory$CacheResult.getOrCreate(CAbsDirectory.java:77)
at com.mercury.optane.core.directory.CAbsDirectory.getDirectoryItem(CAbsDirectory.java:166)
at com.mercury.td.saserver.directory.CSaAbsDirectory.getObject(CSaAbsDirectory.java:91)
at com.mercury.td.saserver.directory.CSaAbsDirectory.getObject(CSaAbsDirectory.java:120)
at com.mercury.td.saserver.directory.CTdParamsDirectory.getAppParam(CTdParamsDirectory.java:123)
at com.mercury.td.saserver.directory.CTdParamsDirectory.getStringAppParam(CTdParamsDirectory.java:219)
at com.mercury.td.site.params.SiteParams.getParam(SiteParams.java:39)
at com.mercury.td.saserver.sautil.SsoInitString.getSsoInitString(SsoInitString.java:20)
at com.mercury.td.init.InitServlet.init(InitServlet.java:105)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1048)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:950)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4122)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4421)
at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeployInternal(TomcatDeployment.java:310)
at org.jboss.web.tomcat.service.deployers.TomcatDeployment.performDeploy(TomcatDeployment.java:142)
at org.jboss.web.deployers.AbstractWarDeployment.start(AbstractWarDeployment.java:461)
at org.jboss.web.deployers.WebModule.startModule(WebModule.java:118)
at org.jboss.web.deployers.WebModule.start(WebModule.java:97)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)
at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:206)
at $Proxy38.start(Unknown Source)
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)
at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)
at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)
at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)
at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:286)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
at org.jboss.system.ServiceController.doChange(ServiceController.java:688)
at org.jboss.system.ServiceController.start(ServiceController.java:460)
at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)
at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)
at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)
at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)
at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)
at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1439)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1157)
at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1178)
at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1098)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:781)
at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:702)
at org.jboss.system.server.profileservice.repository.MainDeployerAdapter.process(MainDeployerAdapter.java:117)
at org.jboss.system.server.profileservice.repository.ProfileDeployAction.install(ProfileDeployAction.java:70)
at org.jboss.system.server.profileservice.repository.AbstractProfileAction.install(AbstractProfileAction.java:53)
at org.jboss.system.server.profileservice.repository.AbstractProfileService.install(AbstractProfileService.java:361)
at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)
at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1631)
at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:934)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1082)
at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:984)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:822)
at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)
at org.jboss.system.server.profileservice.repository.AbstractProfileService.activateProfile(AbstractProfileService.java:306)
at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:271)
at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:461)
at org.jboss.Main.boot(Main.java:221)
at org.jboss.Main$1.run(Main.java:556)
at java.lang.Thread.run(Thread.java:619)

2 comments:

  1. every time manually we need to start SQL service manually ?

    ReplyDelete
    Replies
    1. Chethan ....please change server port number.(8080 to some other number)...then no need to start manually........

      Delete