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:

  1. Right click My Computer.

  2. Click Properties.

  3. Select the Advanced Tab

  4. Click Environmental Variables...

  5. Click New... under System variables.

  6. 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.

  7. 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