You are viewing limited content. For full access, please sign in.

Question

Question

Workflow Query Data stuck

Workflow
Updated February 21, 2024
asked on May 6, 2019

We are on Workflow 10.2 and lately a simple Query Data against a SQL database took anywhere from 12 hours to just waiting days before being terminated.  The database is working properly.  We can query the same data against the database and returns in ms.   The server is running at about 75% CPU and 33% memory.  Any clue as to what might cause this issue?

0 0

Replies

replied on May 6, 2019

What error do you see when it's terminated? Or did you mean you're manually terminating instances?

Database queries activities are queued up so they don't overtax SQL. What other activity do you have on this Workflow server during this time?

It's probably best that you contact your reseller and investigate this issue through Tech Support.

0 0
replied on May 6, 2019

No error since we manually terminate the instances.  You are right that most instances are in "waiting" status.  We just contacted the reseller and awaiting...

0 0
replied on February 21, 2024

Hello Daisy,

Have you resolved this issue?

My issue with Workflow 11 is the same; it does not happen every time, but it does in some workflow instances

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...