Hello!

 

I have a few processes that have a trigger to run daily at 2AM or 4AM. Unfortunately, on my local environment, they start running only after I open Creatio. Also, all processes that have triggers don't work on weekends.

 

Dows anybody know how I can set up my IIS in order for them to work?

 

Thank you!

Like 0

Like

2 comments

Ghiu Diana Stefania,



The BP will be executed only when the Creatio Application (i.e., the Creatio worker process is running) running. Unless there is no application pool/worker process of the Creatio instance running, any configuration like auto trigger event designed inside the application won't work.



The trigger should be all day, if the weekends are excluded the trigger wont be initiated.

 

 

BR,

Bhoobalan Palanivelu.

Hello,

 

To remedy this situation, we recommend setting up a ping that will send requests to the app at a specified frequency and prevent it from "falling asleep" in the absence of active users.

The following procedure describes the setup procedure:

Set Idle Timeout = 2 for the IIS application pool on which the application is running. Configure automatic monitoring of the Loader and the application.

Use the free monitoring service https://uptimerobot.com/ to set up automatic monitoring with a frequency of 5-10 minutes.

Show all comments

Hello team,

 

I have written a script using SEQUENCE & TRIGGERS for PostGres to auto increment the record number. This was a decision taken to avoid writing multiple codes through JS and Server side because we get inputs from a lot of sources - 3rd party integration, manual entry & business process.

 

While our trigger works well, we noticed that using odata, the response returned does not have the auto numbered value, whereas the auto numbering is indeed getting stored in the data base.

 

The question is, does Odata response for POST requests get triggered after all DB triggers are completed or does it happen just before a record is inserted into the DB?



PS: I tried triggers using BEFORE update and it did not work

Like 0

Like

1 comments

Hello,

This question needs to be analyzed mo deeply, but, based on your information, the POST request isn't affected by all the DB triggers and therefore happens before the insert.

Also, a small note, if you have autonumbering both on the JS and Server side than a new number will be generated no matter what is the source of the object (data, business process, etc).

Show all comments