• Welcome, Guest. Please login.
 
November 21, 2019, 03:10:41 pm

News:

Welcome to the SQLitening support forums!


-18 error while Procs routine is processing

Started by Bern Ertl, January 30, 2015, 11:43:11 am

Previous topic - Next topic

Bern Ertl

Hi folks, been a while since I was active here.

I've got a SQLiteningProcs DLL with a function that is doing some heavy calculations.  While testing it, I keep getting an error -18 while the routine is calculating.  Best I can tell, the (slRunProc) function is still in the process of it's calculations (no error conditions or endless loops). 

This looks like a timeout issue, but I did set ConnectionTimeout = -1 in SQLiteningServer.CFG. 

I'm not sure how to proceed in troubleshooting this.  Any ideas?

Bern Ertl

I did some testing.  Called the same Proc (using slRunProc) and added the following code to my function (at the beginning):

SLEEP <<>>
EXIT FUNCTION

When I put 28000 (28 seconds), no error is generated.  When I put 29000 (29 seconds), an error (-18 / timeout) is generated.

I guess there is some other time out issue aside from ConnectionTimeout in play here...

Bern Ertl

Found it.  slConnect has a Tn ModChar that controls how long the system will wait before a timeout.