WELCOME TO THE COMMUNITY
find what you are looking for or ask a new question
Home > Forum > Latest posts

latest posts

In reply to: Jack

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

Hi,
first check the WFConfigurations table but in the TEST database.
In the WFCON_ID column look for these unfound IDs.

Then you will see what attributes are involved. Check their configuration, in particular the tabs: "Style and behavior", "Visibility" and "Editability and requiredness".
FLD is used e.g. in business rules e.g. to set/retrieve values ​​from attributes.

e.g.
SELECT WFCON_PROMPT, * FROM WFConfigurations
WHERE WFCON_ID = 1374