Set Time To Resolve Flow Servicenow

[mdshahvez11]

• I ran a Flow that loads data from a staging table to the Case table.

• Now in the flow context list , the Set Time To Resolve are showing as "In Queue" without flow name  in the Flow Context.
• If the state is Error or complete in that scenario the flow name is available.

• Out of ~26,000 Set Time To Resolve flow records:

  • Some are in "In Queue", some in "Error", some marked "Complete".

  • Cases which I have loaded are still being updated, but no actual change is happening in the values.

  • Number of Set Time To Resolve flow items "In Queue" is increasing gradually.
    
    
    can anyone tell why and what exactly causing this retrigger .
    and how to handle this.

    
    
    

[GlideFather]

@mdshahvez11 it looks like it is being processed.

Can you share some details on the staging table? My staging table was on sys_table_row and with that I didn't need the flow for the data transformation. 

Is this the first run or the flow was working and this is incident from normal?

[mdshahvez11]

@GlideFather 

All the transformed records which are in dummy table or staging table have been successfully moved to case tables.

And all the cases got created successfully,As expected.

However from.in between this flow that is Set Time to Resolve trigger mat be bcz of the updates on the cases and it getting queue in system context flow .list

That list is keep getting bigger.

And in case table records are getting updated as just now.

But nthg getting update in the data inside records.

[GlideFather]

Oh, I am not familiar with the Set Time to Resolve. When moving data perhaps there is some recursion with BR or another scripts 😕

Are you able to get any insight from sys_log?