Re: WEB400 Digest, Vol 5, Issue 145

[jlowary@xxxxxxxxxxxxx]

> 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