Thursday 22 February 2018

Run Informatica Workflow on specific node



We had a recent scenario where we need to run a informatica workflow on particular node due to database connectivity issues from other nodes

We were having  three nodes (nodeA,nodeB and nodeC ) running on a grid. The session must be run on node A because that is where we didnt having db connectivity issues . Selecting nodeA, in the Resources option on the General tab did not force the session to run on nodeA , rather it randomly chooses all three nodes for running session, sometimes node A, other times node B.





Cause

This behavior occurs when the IgnoreResourceRequirement Integration Service property is enabled.

Solution


To resolve this set IgnoreResourceRequirement to "No" as per below

  1. In the Administration Console, select the Integration Service. 
  2. Under the Properties tab select Advanced Properties > Edit . 
  3. Clear the IgnoreResourceRequirements property. 
  4. Restart the Integration Service.
  5. Run the workflow.


2 comments:

  1. The kicker paddles are lined up to allow them to} push against the notches on the three discs. The second shaft additionally supports a collection of linked stoppers, tooth that lock into the notches on the discs. While this global health disaster continues to evolve, it can be be} helpful to look to past pandemics to raised perceive how to to|tips on how to} reply today. "Woman sues 점보카지노 Isle after she's denied $42 million from slot malfunction".

    ReplyDelete