Skip to Content

Correlation is a very important feature of BPM. It is often used in scenarios where more then one systems are delivering data to XI. I have come across different runtime behaviors of BPM with respect to correlation. With the help of this blog I would like to share my experience about this behavior of BPM.

 

I have taken a very basic scenario to explain this concept.

Two files are delivered to XI. First file consists of Employee PsNo and Name while the second file consists of PsNo, Salary and Cadre. In this scenario both the information is merged based on the PsNo and delivered in form of third file to the ftp

  imageBPM Design:- 

Step 1) First receive Step:- abstract asynchronous interface to receive first file.

Step 2) Second Receive Step:- abstract asynchronous interface to receive second file.

Step 3) Transformation Step:- To merge the files received in the first and the second step.

Step 4) Send Step:- abstract asynchronous interface to send the merged file.

 

image

 

We know that whenever a receive step is encountered a process instance is generated.

But, in this case we have two receive steps. We want to have the same process instance for both the receive steps. Hence we need to correlate the data that is received in first and second receive step.

 

Steps to define correlation:-

 

Step1)

 

Switch Container window to Correlation List.

Define a Correlation Name in the Correlation List.

image

Step 2)

 

Switch the Graphical Definition to Correlation Editor.

Select the Correlation Name that you defined in the previous step.

Define a variable in the Correlation Container. Its type should be same as that of the field on which you want to define the correlation.

Select the message interfaces on which you want to define correlation in the Involved Messages area.

In the Properties area, for each message interface that is involved select the field from the message type for which you want to define correlation.

 

image

 

We will now see the runtime behavior of BPM.

 

Case 1:-

 

In this case the first file is placed on the ftp. As the First Receive step is encountered a process instance for the BPM is triggered. As the second file is not yet placed on the ftp the Second receive step will wait for the file and hence the BPM appears in the wait state.

Go to SXI_MONITOR  to check the status of BPM.

 

image

 

When the second file (with the same PsNo as that of First file) is placed on the ftp, a new process instance would not be triggered, instead the file is delivered to the Second receive step. This is possible because of correlation. The data is then merged in the mapping and the merged file is placed on the ftp.

 

 

image

 

Case 2:-

 

In this case the second file is placed without the first file being placed on the ftp. The file adapter picks up the second file. However as there is no process instance triggered for this file by the first receive step, message will go into SYSFAIL.

 

image

 

image

 

Case 3:-

 

In case if both the files have different PsNo, and the first file will be placed before the second file, a process instance will be triggered for the first file but it will keep waiting for the second file and the BPM will appear in the wait state. The file adapter will pick up the second file but the message will go into SYSFAIL as no process instance is triggered for it.

 

image

 

This behavior is encountered because the correlation is defined on the field PsNo.

To report this post you need to login first.

8 Comments

You must be Logged on to comment or reply to a post.

    1. Milan Thaker Post author
      Hey Anand,
        AS we have two independent channels for the two files, second file will be picked up by the file adapter. But since the first file is not picked, there is no active bpm instance for the second file. Hence it will go in Sysfail.

      (0) 
  1. Manish Singh
    During the migration process problems have been reported for this blog. The blog content may look corrupt due to not supported HTML code on this platform. Please adjust the blog content manually before moving it to an official community.
    (0) 
  2. minhaj uddin
    What if there are multiple lines in each of the files. Now since the Correlation is defined on PsNo will the check be 1:1 i.e. PsNO of each line of the first file is compared against PsNO of each line of the second file? This example refers to the case when there is only one PsNo in both the files so am a bit confused over here.
    Thanks!
    (0) 

Leave a Reply