Home > Forum > Actions > Delete Timeout

Delete Timeout
0

I have timeout that is no longer needed. I want to delete it.
But aplication runs constantly and in step with timeout there always will be elements.
How to get rid of this timeout. I've tried setting is to always false, but it's still trigered and goes to list.
I have few of them on diffrent steps and they total 10k elements in timeout list.

In reply to: Jacek Wojnar

sorry but I don't understand.
If you add such a condition then simply the timeout will not be added to new documents - that's all.

Why would it kill the whole process?

It's not like that.
This condition is wrong, so every time element will enter this step it gives SQL error.
If i add condition like
SELECT WFD_ID FROM WFElements WHERE 1=0 (so it's also always wrong) TIMEOUT still goes to the list of tieouts.
And System tries in specified time run it.
But timeotu still exist in list so can't be deleted.
I need a solution to remove specific TIMEOUT from Timeout list so i can DELETE TIMEOUT complety.
Now i recive error from Studio.

I use this SQL to list all timeouts:

SELECT
ELM.WFD_Signature,
TIM.TIM_Name,
TIM.TIM_Interval,
TIM.TIM_RepeatCount,
TIM.TIM_WFCONID,
TIM.TIM_InsertingSQL,
TIM.TIM_Description,
DATEDIFF(SECOND, TMO.ETM_StartTimeoutTime, TMO.ETM_TSUpdate) AS Delay,
FROM
WFElementTimeouts TMO
INNER JOIN
WFElements ELM ON TMO.ETM_WFDID = ELM.WFD_ID
INNER JOIN
WFTimeouts TIM ON TMO.ETM_TIMID = TIM.TIM_ID