Analytics Software

We are facing an issue in Informatica:

When tried to connect to repository, it throws the following error:

[PCSF_46008] Cannot connect to domain [Domain_rginformatica] to look up service [coreservices/UserManagementService]

We found tha the Informatica Services 8.6.0 is not starting. From service console, when i start it, it gets down within seconds.

Event Log shows that the errors are logged in catalina.out file. This file shows:

JBoss shutdown was called but port 0 is not accessible. Assuming that the JBoss process is already stopped.
2010-10-17 14:51:40,109 ERROR [[coreservices]] Servlet ReportingServiceServlet threw unload() exception
javax.servlet.ServletException: Servlet.destroy() for servlet ReportingServiceServlet threw exception
at org.apache.catalina.core.StandardWrapper.unload(StandardWrapper.java:1373)
at org.apache.catalina.core.StandardWrapper.stop(StandardWrapper.java:1688)
at org.apache.catalina.core.StandardContext.stop(StandardContext.java:4350)
at org.apache.catalina.core.ContainerBase.removeChild(ContainerBase.java:893)
at org.apache.catalina.startup.HostConfig.undeployApps(HostConfig.java:1180)
at org.apache.catalina.startup.HostConfig.stop(HostConfig.java:1151)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:313)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
at org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1055)
at org.apache.catalina.core.ContainerBase.stop(ContainerBase.java:1067)
at org.apache.catalina.core.StandardEngine.stop(StandardEngine.java:448)
at org.apache.catalina.core.StandardService.stop(StandardService.java:510)
at org.apache.catalina.core.StandardServer.stop(StandardServer.java:734)
at org.apache.catalina.startup.Catalina.stop(Catalina.java:602)
at org.apache.catalina.startup.Catalina.start(Catalina.java:577)
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:585)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Domain service deinit method is called. Aborting the domain service.

The exceptions.log shows:

... 30 more
2011-05-10 11:24:07,421 FATAL [main] [NODE_10016] Node configuration failed to initialize with error: [[PCSF_10375] Failed to fetch [Domain] with error [[informatica][Oracle JDBC Driver][Oracle]ORA-28001: the password has expired
].].
com.informatica.pcsf.common.exception.PCSFConfigException: [PCSF_10375] Failed to fetch [Domain] with error [[informatica][Oracle JDBC Driver][Oracle]ORA-28001: the password has expired
].
at com.informatica.pcsf.common.storage.AbstractDBStorage.read(AbstractDBStorage.java:215)
at com.informatica.pcsf.shared.domain.DomainMetadata.loadDomain(DomainMetadata.java:766)
at com.informatica.pcsf.nodeconfigservice.NodeConfigurationServlet.loadNode(NodeConfigurationServlet.java:256)
at com.informatica.pcsf.nodeconfigservice.NodeConfigurationServlet.init(NodeConfigurationServlet.java:141)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1139)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:966)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3956)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4230)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:760)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:740)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:544)
at org.apache.catalina.startup.HostConfig.deployWAR(HostConfig.java:825)
at org.apache.catalina.startup.HostConfig.deployWARs(HostConfig.java:714)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:490)
at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1138)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:311)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:120)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1022)
at org.apache.catalina.core.StandardHost.start(StandardHost.java:736)
at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1014)
at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:443)
at org.apache.catalina.core.StandardService.start(StandardService.java:448)
at org.apache.catalina.core.StandardServer.start(StandardServer.java:700)
at org.apache.catalina.startup.Catalina.start(Catalina.java:552)
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:585)
at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:295)
at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:433)
Caused by: java.sql.SQLException: [informatica][Oracle JDBC Driver][Oracle]ORA-28001: the password has expired

at com.informatica.jdbc.base.BaseExceptions.createException(Unknown Source)
at com.informatica.jdbc.base.BaseExceptions.getException(Unknown Source)
at com.informatica.jdbc.oracle.OracleImplConnection.connectAndAuthenticate(Unknown Source)

We verified that the Repository Datawarehouse (an Oracle database), the repository user is able to connect and the password has not expired.

However, recently the password was expired and we had reset it to the same password again. Is there anything in the configuration we are missing ??

Please help.

Edited by: muneer.uae on May 10, 2011 1:40 AM