TM1 Forum

I have a nightly load process, which runs various other processes using ExecuteProcess(); problem is, if any of processes fail, it stops working and does not execute other processes. My nightly load process example:


ExecuteProcess ('export_klientu_planavimas_SQL');

ODBCOpen('cogsql2005', 'cognos', 'password');
ODBCOutput('cogsql2005', 'EXEC kgvp.pr_tm1_dim_create_klientai');

ExecuteProcess('does_not_exist');

ASCIIOutput('C:\process_return_value.txt', 'OK ', TIME, 'on', TODAY);

--------------------------------------------

this process will always fail on ExecuteProcess('does_not_exist'), but I want it to continue anyway and execute ASCIIOutput command. Is it possible? I would like universal solution, because in my production server nightly load process executes ~15 other processes.

Unless you can trap the error and avoid the fatal error then you've no where to go.

So in the example you give which I assume is an example and not real you could test for the TI "Does Not Exist" with a Dimix against the }Process dimension and then chose to call it or not on the basis of the result of the Dimix test.
HTH

I've put my nightly data load in multiple separate processes, then created a master chore and put all processes inside. This way, if an intermediate process fails chore continues to execute other processes.

The only problem is I can't write comments in chore so all data load logic is not that clear from first sight, but at least it works.

Good point and actually a genuine advantage of a chore over a sequence of ExecuteProcess commands.