Need a solution to restart a Workflow automatically | Community
Skip to main content
O
Ofattah
Level 2
June 12, 2021
Solved

Need a solution to restart a Workflow automatically

  • June 12, 2021
  • 2 replies
  • 5999 views

Hello Everyone,

So far you were very helpful and I really appreciate that!

I'm a new user of Adobe Campaign Classic and I'm facing a problem with some of my workflows.

Some of the workflows I made stops from running because of an error ; ORA-210000  (timeout occurred)

The problem is not due to our database since it's running and there's no issue with it.

My question is, is there any workflow I can build that can restart the workflows that stop from running, please?

Thanks.

 

 

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
Best answer by LaurentLam
Sorry but you should ask your neolane administrator / neolane developper a hand on it: the error message you get doesn't seem related to the code. there is no code line 22 and no variable called "AnyName" has been used...

2 replies

LaurentLam
LaurentLam
Level 5
June 13, 2021

You could build a workflow that will scan all the "production" workflows status and use api command like:

Restart (adobe.com)

You create a workflow with the query activity linked to a JS activity.

In the JS, you use a query def function with "vars.targetSchema" as schema declaration: it will select automatically the content of your previous query activity

Data oriented APIs | Adobe Campaign

 

Then you loop on the query result in order to execute your restart function

 

Netherless, you have a connection issue with the DB and your AC instance and you should spend time to investigate the root cause as restarting automatically workflows due to this problem is for having a better resilience while the issue is addressed

O
OfattahAuthor
Level 2
June 17, 2021

Hi @laurentlam 

It seems that this code doesn't like me. It's still making errors 

Here's my code box in case.

 

 

I can't thank you enough for your time and help

Jonathon_wodnicki
Community Advisor
Jonathon_wodnickiCommunity Advisor
Community Advisor
June 14, 2021

Hi,

 

It's not normal to have db connection regularly die at random.

If the db is fine try adjusting client settings?

 

Thanks,

-Jon

O
OfattahAuthor
Level 2
June 14, 2021

Hi @jonathon_wodnicki 

Thank you so much for your response.

Yes, it's not normal. It happens with a workflow that turns every 8min. We thought that it's due to its frequency. What do you think?

 

Thanks

 

Terms & ConditionsAccessibility statement

Loading footer...