hello! Does anyone know why I get this error some days at night?
Discussion posts and replies are publicly visible
Hello romiev8844
Could you please share the details on whats configured in "Get Next Batch of Transactions" node. Looks like a Task error.
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.
romiev8844 "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?"
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.
You can increase 'Timeout' property of 'Execute Stored Procedure'. Or try tuning SP to reduce executions time.
increase the timeout let's see how much time it is taking than you can work on optimizing it more
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.
Hi, its intermittent. This happens a couple days of the week.