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)
every time manually we need to start SQL service manually ?
ReplyDeleteChethan ....please change server port number.(8080 to some other number)...then no need to start manually........
Deleteawesome post presented by you..your writing style is fabulous and keep update with your blogs Hadoop Administration Online Course
ReplyDeleteThis comment has been removed by the author.
ReplyDelete