Global configuration to stop long running processes | Community
Skip to main content
R
RobertoCervantes
Level 2
June 14, 2024
Solved

Global configuration to stop long running processes

  • June 14, 2024
  • 1 reply
  • 998 views

Hello to all,
we have recently upgraded our Adobe Campaign Classic installation to version 7.3.5. and we see that there are workflows which before when there was a long database query executing more than a certain time it was stopped by the Adobe Campaign app by itself. Now it keeps running with the risk of causing crashes at the database level.

 

Do you know if you can apply some global configuration to the application so that if a certain process takes longer the system stops it on its by itself?

 

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 Manoj_Kumar

Hello @robertocervantes 

 

This happens because of bad query design. There shouldn't be any query that runs for 2 hours. I would look at Adobe Control Panel to see which query is running what data it is querying. I would first kill the PID associated with the query so that it is not creating deadlocks.

 

The only solution is to optimize the queries.

 

My assumption is before the upgrade the queries were timing out and this is not happening anymore.

 

1 reply

ShashankNigam02
Adobe Employee
ShashankNigam02Adobe Employee
Adobe Employee
June 14, 2024

As a best practice, it is recommended to stop all workflows and delivery job before preparing for an upgrade. This is to avoid such issues to happen.

 

Well, it is hard to identify what went wrong during the upgrade in your case.

 

I would recommend that you plan a DB restart (OfCourse during a maintenance window with the help of DBA/Database Team) after stopping nl services on all instances. Once Database is online, you can resume nl services.

R
RobertoCervantesAuthor
Level 2
June 17, 2024

Thank you very much @shashanknigam02  for your answer, but I think we are talking about different things.

What I mean is that before updating the application it seems that there was a configuration that when a workflow was working for a long time waiting for a SQL response it stopped the process by itself.

 

After upgrading the application we noticed that it doesn't happen. It is not a problem with a specific workflow, we stopped each and every one of the services before upgrading, I think it is a problem of loss of some global configuration that has disappeared after the upgrade but I don't really know what.

 

The question is that this past weekend a wkf was working for more than 2 hrs waiting for a database query and this has caused interlocks in the database and this did not happen before with the same wkf.

 

 

Manoj_Kumar
Community Advisor
Manoj_KumarCommunity AdvisorAccepted solution
Community Advisor
June 18, 2024

Hello @robertocervantes 

 

This happens because of bad query design. There shouldn't be any query that runs for 2 hours. I would look at Adobe Control Panel to see which query is running what data it is querying. I would first kill the PID associated with the query so that it is not creating deadlocks.

 

The only solution is to optimize the queries.

 

My assumption is before the upgrade the queries were timing out and this is not happening anymore.

 

Manoj  | https://themartech.pro
    Terms & ConditionsAccessibility statement

    Loading footer...