Learned Knowledge Informatica: "PCSF_46007 No gateway connectivity is provided for domain. ERROR: Cannot connect to Integration Service" when running the PowerCenter 8.1

Monday, February 11, 2008

"PCSF_46007 No gateway connectivity is provided for domain. ERROR: Cannot connect to Integration Service" when running the PowerCenter 8.1

"PCSF_46007 No gateway connectivity is provided for domain. ERROR: Cannot connect to Integration Service" when running the PowerCenter 8.1 pmcmd connect command

Problem Description

When running pmcmd connect command to connect to a domain, the following error is displayed:

PCSF_46007 No gateway connectivity is provided for domain[xxx]. ERROR: Cannot connect to Integration Service [xxx]

The issue is not resolve even when the following command is used to update the Gateway node in the domains.infa file:

Infacmd(.sh) updateGatewayInfo <-domainname|-dn> name_of_domain <-gatewayaddress|-dg> domain_gateway_host:port

Cause

This issue is caused when the domains.infa already contains the entry for the domain and its details but the pmcmd command is not able to find the domains.infa file to read the information.

Solution

To resolve the issue, add the environment variable INFA_DOMAINS_FILE.

To add the environment variable, do the following:

Windows:

Right click My Computer.
Click Properties.
Select the Advanced Tab
Click Environmental Variables...
Click New... under System variables.
Enter the following:
- Variable Name: INFA_DOMAINS_FILE
- Value Name: C:\Informatica\PowerCenter8.1.0\domains.infa.
Note

The domain.infa filename must be included in the path as show above.
Click OK three times.

UNIX:

In a UNIX C shell environment, type the following:

setenv INFA_DOMAINS_FILE /domains.infa

In a UNIX Bourne shell environment, type the following:

INFA_DOMAINS_FILE=/domains.infa
export INFA_DOMAINS_FILE

Applies To

PowerCenter 8.1

10 comments:

Ramana Chittoor said...: This is great information to solve this issue; August 7, 2008 at 6:32 AM
Unknown said...: Hi it does not resolve my issue and still gives the same error; September 22, 2008 at 11:25 PM
Kevyn said...: That environmental variable is already set and is not the cause of the issue in my case. I am still unable to connect.; February 24, 2010 at 1:35 AM
neald said...: Hi it does notaddress my issue. I'm running 8.6.1.; July 29, 2010 at 12:16 AM
Unknown said...: Hi,

Its strange behaiviour sometimes, the variable takes only the path sometimes..\Informatica\PowerCenter8.6.1 or needs the file also \Informatica\PowerCenter8.6.1\domains.infa...both options worked on different envs for me.; August 19, 2010 at 2:50 PM
Unknown said...: also ensure that that the pmcmd's utility path is set in the PATH variable.; August 19, 2010 at 3:00 PM
Workyourowndestiny said...: Gyan Shikha
pmcmd path is important :
if you have 8.6.1 then the value of environment variable should be -
INFA_DOMAINS_FILE-
C:\Informatica\PowerCenter8.6.1\domains.infa; July 16, 2011 at 4:57 AM
Jeremy said...: quite valuable. resolved my issue.; August 8, 2012 at 2:47 AM
meroscript said...: hi i have a problem in access folder when connecting designer:

MSG is : Unable to access the folder
E:\system\clients\powerCenterClient\client\bin\Workspace\testfolder

i installed informatica 9.0.1 on E drive ,; July 4, 2013 at 1:53 AM
Unknown said...: Hi, I did added the env variable like variable Name :INFA_DOMAINS_FILE-
Variable Value =C:\Informatica\PowerCenter8.6.0\domains.infa
and added the path for PMCMD under path as C:\Informatica\PowerCenter8.6.0\server\bin Still I am getting the same error message as pasted below.Can some one help on this would be appreciated .

C:\Informatica\PowerCenter8.6.0\server\bin>pmcmd startworkflow -sv int_01 -d dom
ains -u Administrator -p Administrator -f sreenu WF_1_TGT_COUNTRY

Informatica(r) PMCMD, version [8.6.0], build [178.0613], Windows 32-bit
Copyright (c) Informatica Corporation 1994 - 2008
All Rights Reserved.

Invoked at Fri Mar 13 22:48:12 2015

[PCSF_46007] No gateway connectivity is provided for domain [domains].
ERROR: Cannot connect to Integration Service [int_01].

Completed at Fri Mar 13 22:48:12 2015

C:\Informatica\PowerCenter8.6.0\server\bin>; March 14, 2015 at 1:25 AM