6 Replies Latest reply on Dec 31, 2019 5:11 AM by Dipti More

    In Spoon Deleting Old Relationships Transformation is working separately but when put into Master Job it stops working?

    Vikas Mishra
      Share This:



      I have created following Spoon Jobs in our Master Job:-

      1)Create IP and Relationships

      2)UnRelate Relationships when Status = Disposed.


      And Transformation for Deletion of Old Relationships when IP Address is updated in Staging Form

      1)UnRelate Relationships when Ip is Updated in Staging Form.


      We have a Staging Form where we have 4 fields of IP Address separately.


      and We are able to create Computer System and 4 IPEndpoint Records for the same.

      We also created Relationships for 4 IPEndpoint Records in BMC.CORE:BMC_HostedAccessPoint(Create IP and Relationships Job).

      And after that we have unrelated (Mark as Deleted =Yes) those records from BMC.CORE:BMC_HostedAccessPoint when Status = Disposed(UnRelate Relationships when Status = Disposed Job).



      Now when we update one of the IP Address field in Staging Form ,New Record of IP gets created in BMC.CORE:BMC_IPEndpoint Form and New Relationship should be formed with BMC.CORE:BMC_HostedAccessPoint. And Old Relationships for IP Address should be deleted.


      So when we run the below Transformation after IP Address is updated in Staging Form it is working fine .

      1)UnRelate Relationships when IP is Updated in Staging Form.

      But when we include the same in the Master Job its not working.



      Please let me know for the same.