Stuck Email Interactions

[francis.h]

Hi,

I use the Data table to store keywords. Each row is pipe delimited list of keywords.

The search works fine. The email interaction gets stuck when no keywords are found. In the timeline, the interaction is flagged as, External disconnect type: peer, Workflow disconnect type: client

I have 2 loops.

The outer loop cycles through the rows in the data table. If no record is found or error, break loop.

The inner loop searches for keyword in the email body.

Can anyone provide a clue as to what's going on.

[MelissaBailey]

Use the Set Participant Data action (multiple times) to see how far you get in the flow so you know where the error occurs.

What does your expression look like for searching the email body?

[francis.h]

HI,

Contains(ToString(Email.Message.body),Task.sKeyword,true)

[francis.h]

Hi,

so the problem was the record counter. search the data table based on the loop counter. Since I don't know the number of rows in the table, the loop counter is set sufficiently high.

If the loop counter > number of records it goes down the Not Found. I then continue the loop. This is where the error occurs. I should Exit the loop.

The issue is resolved but I have a couple of questions if anybody knows the answers. It would assist in understanding how Architect works.

Q1 - Why couldn't I continue the loop until max loops. The reason I continued the loop was on the off chance that someone missed an index in the data table.

Q2 - There's a Failure path which I expected for any database lookup errors. Why did this not fire?

Q3 - Why did the flow email interaction get stuck instead of providing some error? Related to (2) I guess.