How to stop these queries running in infinite loop?
Hello!
I don't know if this is the best solution, but you can end all infinite loops by restarting your IIS server.
And then you just have to prevent them from happening again.
Best regards!
Miguel
Hi,
I guess you are possibly calling Advanced SQL in loop.
Even if any infinite loop has been created, you can try republishing the app after corrections.
If possible, can you share the snapshot of logical flow where this Advanced SQL is being called ?
Any more information can help tracking further..
I used an SQL widget in "CreateSLA_Resolution" and I called the "CreateSLA_Resolution " action in "Create Incident" server action.
I deleted the "CreateSLA_Resolution" action itself and published the module but still the query is being executed.
Hi Kumar,
You need to review your logic you may use For each widget and in every loop you are calling advanced sql
Please check action which include query CreateSLA_Resolution or if you can share with us this action into a sample OML we can check and help you.
Hello,
To kill the query process, you must go to the server level,
Once the logic is running in a infinite loop, you can't stop it by changing the application in service studio or any configurations in service center. Because the process is already launched in the server.
You can restart your IIS server to solve this.
Best regards,