topic Run sas esp model every 5 minutes in Administration and Deployment

Run sas esp model every 5 minutes

SAS_LuisBolivar — Fri, 16 Oct 2020 02:39:42 GMT

Hi.

Goodnight.

I am writing to review the best practice options for running an esp model every 5 minutes.

I am currently running the model as follows:

1 I raise the xml_server
2 upload the project
3 sleep
4 delete the project

Although it has worked for me, I have had a problem with the persistence of the execution, it stops due to errors after a few days.

If you can help me by pointing out a best practice, I would really appreciate it.

Thank you.

Re: Run sas esp model every 5 minutes

SASKiwi — Fri, 16 Oct 2020 03:22:06 GMT

What are the errors you get? Are they resource-related like running out of memory for example?

I would suggest running one scheduled batch job per day that repeats running the model every 5 minutes to limit any resource issues. If the daily job runs with a zero return code then you know all of that day's runs are good.

Re: Run sas esp model every 5 minutes

SAS_LuisBolivar — Fri, 16 Oct 2020 11:57:33 GMT

Good morning.

Thanks for the support.

In the xml_server log I see the following error:

INFO DF.ESP [PubSub] Subscribe: Client disconnected, project: Continuos_rtdm_out. total active clients = 3
ERROR DF.ESP [PubSub] handle_read_magic_number() trying to read magic stream
ERROR DF.ESP [PubSub] handle_read_magic_number() trying to read magic mismatch not an ESP pub/sub client

I have noticed that it has generated many tk.reportlog.

You suggest me create scheduled batch job. Should I create a job for each command? Do I remove the sleep?.

Thanks in advance.

Re: Run sas esp model every 5 minutes

SASKiwi — Fri, 16 Oct 2020 22:40:33 GMT

I'm not familiar with SAS ESP and it looks like you are getting some sort of timeout problem. I suggest you raise a track with SAS Tech Support.