OBIA 7964 Cannot connect to the Integration Service . [PCSF_46007] No gateway connectivity is provided for domain [Domain_dom].

(Doc ID 1998650.1)

Last updated on FEBRUARY 01, 2017

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.4 and later
Information in this document applies to any platform.

Symptoms

You are in the process of upgrading from OBIA 7.9.6 to OBIA 7.9.6.4 for Informatica PowerCenter Users. Informatica was upgraded from 8.6 to 9.5.1 last year while staying on OBIA 7.9.6. And now you have successfully upgraded to DAC11g, before upgrading the Data Warehouse Schema and Migrating Data for Oracle Database.

Reference documents:
1. Oracle BI Applications Upgrade Guide for Informatica PowerCenter Users Release 7.9.6.4
2. Oracle BU Applications Release Notes 7.9.6.3 and 7.9.6.4
3. <Note 1581473.1> BI Apps 7.9.6.4 Release Known Issues

You are facing an issue while upgrading the data warehouse from version 7.9.6 to 7.9.6.1, section 6.9.7

Section 6.9.7.2 Migrating Data into the Upgraded Data Warehouse

Step 7: If you are using Oracle EBS R12, R12.1.1, or R12.1.2, in Informatica Workflow Manager, navigate to the folder UPGRADE_796_7961_ORAR12 and execute first the UPGRADE_DIMENSIONS workflows and then the UPGRADE_FACTS workflow.

The Issue: While running the workflows as mentioned in the above step, we encounter following error:

Cannot connect to the Integration Service "IntegrationServiceName " . [PCSF_46007] No gateway connectivity is provided for domain [Domain_dom].


Where the "IntegrationServiceName" is the name of the integration services provided with the out of box upgrade repository, and there are two of them:

  1. IntegrationService_Upgrade
  2. Int_Svc_UPGRADE

These two integration services are not registered or associated to any Repository Service. As per the ref document 1 above, following the Section 6.9.1, the upgrade repository was restored using Informatica Administrator, but the document does not mention associating this upgrade repository to any integration service required to run workflows. The above mentioned workflows won't run until this upgrade repository service has correct integration services assigned to it.

The upgrade document doesn't mention which integration services should be attached prior to running these workflows.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms