Skip to main content
April 15, 2024
Question

Insufficient time to complete process

  • April 15, 2024
  • 8 replies
  • 0 views

hello! Does anyone know why I get this error some days at night?

    8 replies

    konduruc733182
    April 15, 2024

    Hello [mention:d9737c9b566a47159485a573139116ad:e9ed411860ed4f2ba0265705b8793d05] 

    Could you please share the details on whats configured in "Get Next Batch of Transactions" node. Looks like a Task error.

    April 15, 2024

    Hi Konduru, I'm trying to run a stored procedure, this happens a few days in the week, its like the system stops and couldn't complete the process. The process itself has no error. 

    konduruc733182
    April 15, 2024

    Have you tried running the Stored Procedure from Data base and tried if you see any possible errors? Please try running your SP in an expression rule and check for an error. Also what is the node that you are using to evaluate/run your Stored procedure. Could you please share your Process model image.

    shubhama926776
    Brainy
    April 15, 2024

     [mention:d9737c9b566a47159485a573139116ad:e9ed411860ed4f2ba0265705b8793d05] "The 'Get next Batch of Transactions' Script Task is taking more time to evaluate the expression. Could you share the code from the Script Task and the Process Model Snapshot to help understand the looping flows being used?"

    harshk1671
    April 15, 2024

    You can increase 'Timeout' property of 'Execute Stored Procedure'. Or try tuning SP to reduce executions time.

    prakhars0731
    April 15, 2024

    increase the timeout let's see how much time it is taking than you can work on optimizing it more

    karthikk538
    April 15, 2024

    Hi,

    1. Is this happening for each and every execution or its intermittent?

    2. Can you try by limiting your query output or pull the data in batches and merge?

    3. Try adding indexes on columns on which you applying filters to get the data in this script task.

    April 16, 2024

    Hi, its intermittent. This happens a couple days of the week.