Auto restarting failed work units - Version 9 Processflows - Need help

Legacy Contributor

Hi guys,

 

We are trying to create a processflow to look for failed workunits and use webrun node to trigger a restart on those failed work units in Processflow Designer v9. We aren't sure how to utilize the web run node to trigger this - which web program and success string needs to be used in the web run to restart a work unit>

Has anyone in the community create a pf to achieve this? If yes, will you be able to guide us or share the processflow with us?

Any help is appreciated. Thanks a lot!!

 

Regards,

Arun Ravi Kumar M 

d-hofmann

We are actually using LBI Smart Note, that runs hourly during work hours.

Perhaps it will help. If it does, please share your process.



Here's the sql:



SELECT DISTINCT

PFIWU.PFIWORKUNIT,

LEFT(SEM.MESSAGE,CHARINDEX (':', SEM.MESSAGE)) AS MESSAGE

FROM ipa_prod.PFIWORKUNIT PFIWU

JOIN ipa_prod.PFIERRORMESSAGE PFIEM ON PFIWU.PFIWORKUNIT = PFIEM.PFIWORKUNIT

JOIN ipa_prod.S$PFIEM SEM ON PFIEM.UNIQUEID = SEM.UNIQUEID

WHERE SEM.MESSAGE LIKE '%LHCInvalidSessionException%'

AND PFIWU.EXECUTIONSTARTDATE > DATEADD(hh,-1,SYSDATETIME())

0911060553270289.pdf