Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

Chain Skipping Groups and Commands

Answered
Request Demo

Hello,

I am experiencing an issue with this chain. This is configured so that the right side of the chain will pick up the current year file from the SFTP folder and run it through a couple of transformations. It will then un-import the old file, create, and import the new file or create the new file and import as needed. The left side of the chain is meant to pick up the prior year file, with a conditional statement to set a text result if it is not found. If the file is found, it will run through the same transformations as the right side of the chain and go through the create file steps as needed. 

However, the chain is failing to run through both sides, with the commands usually beginning to skip on the right side when the left side gets to the point shown below. I have tried changing the command connectors back and forth from green and grey, but nothing seems to work. I have also tested each side of the chain individually and they seem to be running then. 

What could be causing this?

0

Comments

6 comments

Date Votes
  • Jeff Hickey

    Hi Talia,

    On the right branch, is there any information in the LOGS tab or a skip condition configured for the Insert Column command? In the screenshots, I see there are at least three Group Nodes that do not have any nodes connected to the Group Start. Cleaning up these Group Nodes may be helpful. This can be done by removing the Group Nodes that are not in use.

    0
  • Tony Scalese

    When I've seen a Command be skipped that logically shoudl run, it's often because it was copied from another existing Command but the inputs were not updated.  You might want to confirm this.

    Also based on your description, it appears you're loading to Wdata.  If that's the case, consider deploying the Load to Wdata Template and using the Run Chain Event to make this Chain easier.  

    0
  • Permanently deleted user

    Jeff Hickey, I do not see any information in the Logs tab, other than:

    This command was not executed due to the result of the previous command or due to being intentionally skipped. 

    There are also no skip conditions configured for this command. I went through and cleaned up the group nodes, but I am still running into this issue. 

    Right:

    Left:

    0
  • Permanently deleted user

    @... I believe the inputs are updated, I deleted the Insert Column command from the right side of the chain and reconfigured it. It looks like the right side of the chain may be working, but the left side is now skipping commands after the Insert Column command. I deleted the Insert Column and List Files commands on the left side and reconfigured those as well, but no luck.

    Right:

    Left:

    0
  • Jeff Hickey

    Since you deleted and added new Insert Column and List Files commands on the left side, double check that commands later in the Chain have also been updated to use the new Insert Column and List Files outputs where necessary. Similar to what Tony mentioned above, the existing commands may be skipping because the inputs need to be updated to use the new Insert Column or List Files outputs.

    0
  • Permanently deleted user

    Jeff Hickey I was able to get the chain working after deleting everything after the Insert Column command and reconfiguring. Thank you for the help!

    0

Please sign in to leave a comment.