Recurrence flow running forever

(1) Share

Report

Posted on by Kameshm05

306 Moderator

Hi Community,

I have created a recurrence flow with SQL and SharePoint Connector. Here my requirement is to copy data from SQL DB to SharePoint List, When copying 100s of rows there is no issue, but in my case, there are more than 2000 rows in the SQL table. There was no issue for the test run, though the flow runs forever in the regular run.

Thanks in advance

Categories:

General topics

I have the same question (0)

All responses (6)

Answers (0)

lbendlin 8,551 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Do you see the sharepoint list growing over time or is nothing being copied?

Was this reply helpful? Yes No
Kameshm05 306 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @lbendlin ,
Thanks for the response. By the way, there is no data is copied to SharePoint as of now.

Was this reply helpful? Yes No
lbendlin 8,551 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

That would mean something else in your flow is not working as expected. Check the flow history for clues.

Was this reply helpful? Yes No
Kameshm05 306 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @lbendlin ,

The flow is running successfully sometimes, sometimes it's running forever.

Thanks

Was this reply helpful? Yes No
grogank 30 on at

Like (0)

Report
Copy link

Link copied!

I'm having this same issue. Test flow only takes 20-30 minutes, and when the recurrence runs it takes like 70+ hours or just runs indefinitely until I cancel it.

Was this reply helpful? Yes No
tidedbryant 47 on at

Like (0)

Report
Copy link

Link copied!

Are you able to profile the SQL database when your flow executes? Are you reading from a table that is in use by another Flow and/or Application? I imagine you'd get a timeout if there were transaction locks but worth checking.

Was this reply helpful? Yes No