Network Errors for TI Processes

[Paul-TM1]

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]

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]

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.