Re: WEB400 Digest, Vol 5, Issue 145

I recently had an issue where inconsistent results came up or getting a
generic SQl error. I found (somewhere, I think I ended the server

instance

in questions, restarted it so I was only one or first one in it and in

the

joblog for one of the QHTTPSVR sbs running it foudn that I was hitting

the

qry time limit because due to policy/procedure changes were retrieving

over

10x as many records as before (and legitmately now). I upped the
appropriate system value for qry time limits and it fixed.

I was hopping this might be the case, as it sounds like what is happening,
but I checked our system values and it is set to:

Query time limit
allowed . . . . . . : *NOMAX

So unless this can get overridden somewhere else I'd say it not the
culprit.

Thanks,

Jim Lowary
System Analyst, Salton Inc.
(573) 447-5500