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
  • 6050 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

LaurentLam
LaurentLam
Level 5
June 17, 2021
@ofattah, in workflow query activity you have 2 sections: the query itself (what you've done) and the additional data section... This is in this one you need to add internalName information. If you don't put here an attribute that you are calling in a JS activity... It won't work
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...