B
bvy
Guest
Thanks. The query text is generated, though I've reproduced it with the following in a SQL window: select * from PUB.idh_hist, , PUB.IH_HIST ih_hist WHERE ih_hist.ih_domain = idh_hist.idh_domain AND ih_hist.ih_inv_nbr = idh_hist.idh_inv_nbr AND ih_hist.ih_nbr = idh_hist.idh_nbr AND (substr('DAILY',1,4) != 'DAIL' OR (substr('DAILY',1,4) = 'DAIL' AND ih_hist.ih_inv_date sysdate()-10 ) ) This is a basic query against QAD. If Server A is running the query above and Server B (Test) is running the same query or a different long running query (like select * from PUB.abs_mstr), then the query on A starts returning records by the millions instead of the couple hundred or thousand we might expect. Servers A and B run the same jobs in parallel and occasionally clash like this. I've also reproduced this with select count(*)... and instead of the expected count have gotten a results 20 or 50 times (roughly) the expected count. See attachment.
Continue reading...
Continue reading...