Product:
Planning Analytics 2.1.14
Microsoft Windows 2022 server
Issue:
How many RUNPROCESS can you run in parallel on a server?
RunProcess lets you run TurboIntegrator processes in parallel, each on its own thread that is managed by TM1® Server. This approach speeds up data load and other operations where TurboIntegrator processes are used to divide the work.
Suggested Solution:
You can only run, same number of virtual CPU cores you have on the server, with the RUNPROCESS command, to ensure proper data handling.
If you run more RUNPROCESS command than CPU cores, you may get that CELLPUTN command will not be executed, and you will not get a error. The process continue as all is fine. On the other hand ASCIIOUTPUT maybe will work fine, so to run more RUNPROCESS in parallel to only create csv files works better.
If you have the ASCIIOUTPUT in the Data tab, and then the CELLPUTN in the Epilog tab of your TI process that you call from a RUNPROCESS command,
add a SLEEP (1001) before the CELLPUTN line, will in some cases solve the issue.
The solution is to add a delay somewhere in the processes, to make the server catch up with what you try to do.
More Information:
https://code.cubewise.com/blog/4-ways-to-speed-up-your-processes-in-ibm-tm1-and-planning-analytics/
https://aggregated.blogspot.com/2015/02/running-tm1-processes-from-outside-tm1.html
https://www.ibm.com/docs/fi/planning-analytics/2.0.0?topic=mtf-logoutput-1