Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

(1 Rating)
facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

ERROR: "Cannot create the connection to the PowerCenter repository. Verify that the user account has permission to access the repository and restart the PowerCenter Repository Service" when importing connection in TDM 9.5.1
Problem Description

In Test Data Management (TDM) 9.5.1, when importing connection, it fails with the following error:

Cannot create the connection to the PowerCenter repository. Verify that the user account has permission to access the repository and restart the PowerCenter Repository Service.

In log.log, the following is displayed:

[2013-04-04 03:06:20.834] INFO  http-bio-22043-exec-16       System.out      Here
[2013-04-04 03:06:21.042] INFO  http-bio-22043-exec-16       System.out                                                        ====================================================== [DEBUG] [com.informatica.powercenter.sdk.
mapfwk.util.Logger.debug(Unknown Source)]
[2013-04-04 03:06:21.050] INFO  http-bio-22043-exec-16       System.out                                                        SystemCommand::Run this.workingdirectory [DEBUG] [com.informatica.powercenter.sdk.mapfwk.util.Logger.debug(Unknown Source)]
[2013-04-04 03:06:21.052] INFO  http-bio-22043-exec-16       System.out       Command executing is : [DEBUG] [com.informatica.powercenter.sdk.mapfwk.util.Logger.debug(Unknown Source)]
[2013-04-04 03:06:21.055] INFO  http-bio-22043-exec-16       System.out       "D:\IServers\1-202249251\9.5/server\bin\pmrep"  [DEBUG] [com.informatica.powercenter.sdk.mapfwk.util.Logger.debug(Unknown Source)]
[2013-04-04 03:06:22.053] INFO  http-bio-22043-exec-16       System.out     Result of SystemCommand is 0 [DEBUG] [com.informatica.powercenter.sdk.mapfwk.util.Logger.debug(Unknown Source)]
[2013-04-04 03:06:22.057] INFO  http-bio-22043-exec-16       System.out                                                        ================================================= [DEBUG] [com.informatica.powercenter.sdk.mapfwk.util.Logger.debug(Unknown Source)]
[2013-04-04 03:06:22.060] INFO  http-bio-22043-exec-16       System.out                                                        SystemCommand::Run this.workingdirectory [DEBUG] [com.informatica.powercenter.sdk.mapfwk.util.Logger.debug(Unknown Source)]
[2013-04-04 03:06:22.063] INFO  http-bio-22043-exec-16       System.out       Command executing is : [DEBUG] [com.informatica.powercenter.sdk.mapfwk.util.Logger.debug(Unknown Source)]
[2013-04-04 03:06:22.066] INFO  http-bio-22043-exec-16       System.out     "D:\IServers\1-202249251\9.5/server\bin\pmrep"
Connect -r pc_tdm952 -n Administrator -x ***** -h 10.65.48.162 -o 6005 -s Native  [DEBUG] [com.informatica.powercenter.sdk.mapfwk.util.Logger.debug(Unknown Source)]
[2013-04-04 03:09:23.581] INFO  http-bio-22043-exec-16       System.out     Result of SystemCommand is 1 [DEBUG] [com.informatica.powercenter.sdk.mapfwk.util.Logger.debug(Unknown Source)]
[2013-04-04 03:09:23.588] ERROR http-bio-22043-exec-16       System.err                                                        com.informatica.core.exception.ConfigurationException: [CONNECTION_0011]
Cannot create the connection to the PowerCenter repository.
Verify that the user account has permission to access the repository and restart the PowerCenter Repository Service. 
[2013-04-04 03:09:23.590] ERROR http-bio-22043-exec-16       System.err                      at com.informatica.ilm.pdmds.core.domains.service.impl.
ConnectionManagementServiceImpl.connectRepo(ConnectionManagementServiceImpl.java:1689)
[2013-04-04 03:09:23.590] ERROR http-bio-22043-exec-16       System.err                                 at com.informatica.ilm.pdmds.core.domains.service.impl.
ConnectionManagementServiceImpl.getPCConnections(ConnectionManagementServiceImpl.java:1391)
[2013-04-04 03:09:23.591] ERROR http-bio-22043-exec-16       System.err                                                         at com.informatica.ilm.pdmds.core.domains.service.impl.
ConnectionManagementServiceImpl.importConnections(ConnectionManagementServiceImpl.java:1251)
[2013-04-04 03:09:23.592] ERROR http-bio-22043-exec-16       System.err                                                         at com.informatica.ilm.pdmds.client.web.admin.
ConnectionController.importConnection(ConnectionController.java:483)
[2013-04-04 03:09:23.592] ERROR http-bio-22043-exec-16       System.err                                                         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
[2013-04-04 03:09:23.593] ERROR http-bio-22043-exec-16       System.err                                                         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
[2013-04-04 03:09:23.593] ERROR http-bio-22043-exec-16       System.err                                                         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
[2013-04-04 03:09:23.593] ERROR http-bio-22043-exec-16       System.err                                                         at java.lang.reflect.Method.invoke(Method.java:597)
[2013-04-04 03:09:23.594] ERROR http-bio-22043-exec-16       System.err                                                         at org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)
[2013-04-04 03:09:23.594] ERROR http-bio-22043-exec-16       System.err                                                         at org.springframework.web.servlet.mvc.annotation.
AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:426)
[2013-04-04 03:09:23.598] ERROR http-bio-22043-exec-16       System.err                                                         at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:414)
[2013-04-04 03:09:23.599] ERROR http-bio-22043-exec-16       System.err                                                         at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
[2013-04-04 03:09:23.599] ERROR http-bio-22043-exec-16       System.err                                                         at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
[2013-04-04 03:09:23.600] ERROR http-bio-22043-exec-16       System.err                                                         at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)
[2013-04-04 03:09:23.600] ERROR http-bio-22043-exec-16       System.err                                                         at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)
[2013-04-04 03:09:23.601] ERROR http-bio-22043-exec-16       System.err                                                         at javax.servlet.http.HttpServlet.service(HttpServlet.java:755)
[2013-04-04 03:09:23.601] ERROR http-bio-22043-exec-16       System.err                                                         at javax.servlet.http.HttpServlet.service(HttpServlet.java:848)
[2013-04-04 03:09:23.602] ERROR http-bio-22043-exec-16       System.err                                                         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
[2013-04-04 03:09:23.602] ERROR http-bio-22043-exec-16       System.err                                                         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
[2013-04-04 03:09:23.603] ERROR http-bio-22043-exec-16       System.err                                                         at org.tuckey.web.filters.urlrewrite.RuleChain.handleRewrite(RuleChain.java:176)
[2013-04-04 03:09:23.605] ERROR http-bio-22043-exec-16       System.err                                                         at org.tuckey.web.filters.urlrewrite.RuleChain.doRules(RuleChain.java:145)
[2013-04-04 03:09:23.605] ERROR http-bio-22043-exec-16       System.err                                                         at org.tuckey.web.filters.urlrewrite.UrlRewriter.processRequest(UrlRewriter.java:92)
[2013-04-04 03:09:23.606] ERROR http-bio-22043-exec-16       System.err                                                         at org.tuckey.web.filters.urlrewrite.UrlRewriteFilter.doFilter(UrlRewriteFilter.java:381)
[2013-04-04 03:09:23.606] ERROR http-bio-22043-exec-16       System.err                                                         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
[2013-04-04 03:09:23.607] ERROR http-bio-22043-exec-16       System.err                                                         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
[2013-04-04 03:09:23.608] ERROR http-bio-22043-exec-16       System.err                                                         at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)
[2013-04-04 03:09:23.609] ERROR http-bio-22043-exec-16       System.err                                                         at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
[2013-04-04 03:09:23.609] ERROR http-bio-22043-exec-16       System.err                                                         at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:243)
[2013-04-04 03:09:23.610] ERROR http-bio-22043-exec-16       System.err                                                         at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
[2013-04-04 03:09:23.610] ERROR http-bio-22043-exec-16       System.err                                                         at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:224)
[2013-04-04 03:09:23.611] ERROR http-bio-22043-exec-16       System.err                                                         at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:169)
[2013-04-04 03:09:23.613] ERROR http-bio-22043-exec-16       System.err                                                         at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:581)
[2013-04-04 03:09:23.614] ERROR http-bio-22043-exec-16       System.err                                                         at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
[2013-04-04 03:09:23.614] ERROR http-bio-22043-exec-16       System.err                                                         at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
[2013-04-04 03:09:23.615] ERROR http-bio-22043-exec-16       System.err                                                         at org.eclipse.virgo.web.tomcat.support.ApplicationNameTrackingValve.invoke(ApplicationNameTrackingValve.java:33)
[2013-04-04 03:09:23.616] ERROR http-bio-22043-exec-16       System.err                                                         at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
[2013-04-04 03:09:23.617] ERROR http-bio-22043-exec-16       System.err                                                         at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
[2013-04-04 03:09:23.618] ERROR http-bio-22043-exec-16       System.err                                                         at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
[2013-04-04 03:09:23.618] ERROR http-bio-22043-exec-16       System.err                                                         at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:987)
[2013-04-04 03:09:23.618] ERROR http-bio-22043-exec-16       System.err                                                         at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:579)
[2013-04-04 03:09:23.619] ERROR http-bio-22043-exec-16       System.err                                                         at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:309)
[2013-04-04 03:09:23.620] ERROR http-bio-22043-exec-16       System.err                                                         at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
[2013-04-04 03:09:23.620] ERROR http-bio-22043-exec-16       System.err                                                         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908)
[2013-04-04 03:09:23.620] ERROR http-bio-22043-exec-16       System.err                                                         at java.lang.Thread.run(Thread.java:662)

Cause

​This issue occurs because the port number for the domain provided during installation is wrong. This can be verified by running the pmrep command as in the log.
From the log, you can see the following message:

"D:\IServers\1-202249251\9.5/server\bin\pmrep" Connect -r pc_tdm952 -n Administrator -x ***** -h 10.65.48.162 -o 6005 -s Native  [DEBUG] [com.informatica.powercenter.sdk.mapfwk.util.Logger.debug(Unknown Source)]

Then when running the command in command prompt using pmrep

 

pmrep>Connect -r pc_tdm952 -n Administrator -x Administrator -h 10.65.48.162 -o
6005 -s Native
 [04/04/2013 03:11:34-[REP_12164] Domain-related error: \[[PCSF_46008] Cannot con
nect to gateway to look up service [pc_tdm952]. [FAULT_PCSFTIMEOUTEXCEPTION\]].]
 [04/04/2013 03:12:37-[REP_55115] Still trying to connect to the Repository Serv
ice [pc_tdm952]. The remaining resilience time is 108 seconds.]
 [04/04/2013 03:12:46-[REP_12164] Domain-related error: \[[PCSF_46008] Cannot con
nect to gateway to look up service [pc_tdm952]. [FAULT_PCSFTIMEOUTEXCEPTION\]].]
 [04/04/2013 03:13:51-[REP_55115] Still trying to connect to the Repository Serv
ice [pc_tdm952]. The remaining resilience time is 34 seconds.]
 [04/04/2013 03:14:00-[REP_12164] Domain-related error: \[[PCSF_46008] Cannot con
nect to gateway to look up service [pc_tdm952]. [FAULT_PCSFTIMEOUTEXCEPTION\]].]
 [04/04/2013 03:14:31-[REP_55112] Unable to connect to the Repository Service [p
c_tdm952] since the resilience time is up.]
 [Failed to connect to repository service [pc_tdm952].]
An error occurred while accessing the repository[Failed to connect to repository
 service [pc_tdm952].]
 [04/04/2013 03:14:31-[REP_55102] Failed to connect to repository service [pc_td
m952].]
Repository connection failed.
Failed to execute Connect.

Solution

To resolve this issue, follow the steps below:

  1. Stop the service.
  2. Edit the <TDMHOME>\configuration\SystemPreferences.xml and check for the entry with domain name.
    <?xml version="1.0" encoding="UTF-8" standalone="no"?>
    <!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
    <properties>
    <comment/>
    <entry key="domain.name">D_95</entry>
    <entry key="hibernate.default_schema.isrequired">false</entry>
    <entry key="java.is.authentication.mode.nonuser">false</entry>
    <entry key="jdbc.ispasswordencrypted">true</entry>
    <entry key="domain.port">6005</entry>
    <entry key="jdbc.password">McSO98ZuyV0=</entry>
    <entry key="hibernate.c3p0.max_size">5</entry>
    <entry key="data.profling">true</entry>
    <entry key="org.eclipse.virgo.kernel.home">C:\TDM951_99\TDM</entry>
    <entry key="jdbc.tablespace.isrequired">false</entry>
    <entry key="jdbc.url">jdbc:informatica:oracle://in2k3gcs05:1521;ServiceName=orclnithya;MaxPooledStatements=20;
    CatalogOptions=0;BatchPerformanceWorkaround=true</entry>
    <entry key="jdbc.user">tdm952</entry>
    <entry key="pwc.server.location">D:\IServers\1-202249251\9.5/server</entry>
    <entry key="INFA_HOME">D:\IServers\1-202249251\9.5</entry>
    <entry key="idq.version">9.5.0</entry>
    <entry key="jdbc.driver">com.informatica.jdbc.oracle.OracleDriver</entry>
    <entry key="domain.host">10.65.48.162</entry>
    </properties>
    Here port used is 6005, but in Admin console actual port used is 19251.
  3. Login to Admin console, and get the appropriate port number. Edit the file to point to the correct port number, and save the file.
  4. Start the service.
    Once modified and restarted, import connection will be successful.
More Information
Applies To
Product: Data Archive
Problem Type:
User Type:
Project Phase:
Product Version: Test Data Management 9.5
Database:
Operating System:
Other Software:

Reference
Attachments
Last Modified Date:5/22/2013 4:55 AMID:148103
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)