Network Errors for TI Processes

Post Reply
Paul-TM1
Posts: 71
Joined: Tue Jun 13, 2017 3:20 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Network Errors for TI Processes

Post by Paul-TM1 » Thu Oct 17, 2019 11:43 am

Hi All,
I have a few TI Processes that are regularly failing due to network issues and want to add something like a re-try should it fail. The processes run well during the day when I retry. I am looking for ideas. Can anyone please share ideas?

Error in the log file

Code: Select all

Error: Data procedure line (0): 01000[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()).
Thanks,
Paul.

ascheevel
Posts: 104
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.8
Excel Version: 2016

Re: Network Errors for TI Processes

Post by ascheevel » Thu Oct 17, 2019 2:03 pm

One option that isn't terribly elegant would be to call your process from a separate process and evaluate the results of the called process from within a WHILE loop. If the process returns anything other than ProcessExitNormal, call it again. You'd want to set a limit, so it doesn't get stuck in an endless loop if the process was finishing with errors for unrelated reasons.


Something like this:

Code: Select all

nLimit = 5;
sPass = 0;
WHILE(nLimit > 0);
	nLimit = nLimit - 1;
	sReturn = ExecuteProcess(......)
	IF(sReturn = ProcessExitNormal);
		nLimit = 0;
		sPass = 1;
	ENDIF;
END;

IF(sPass = 0);
	# process rerun still failed after max attempts, add error handling notification here.
	
ENDIF;


Paul-TM1
Posts: 71
Joined: Tue Jun 13, 2017 3:20 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: 2010

Re: Network Errors for TI Processes

Post by Paul-TM1 » Thu Oct 17, 2019 10:32 pm

Thanks Ascheevel. I will wait for another day to get other ideas and will try this. I was too was thinking in the same lines..

Thanks,
Paul.

Post Reply