[sqr-users] query returns no rows for no obvious reason - it worksfine on another machine

[Jae Lee <leejc@appstate.edu>]

hi, all,

i have a program which has quite complex query("union", etc.) that takes 
over an hour to finish.  it is SQR 8.1.  it runs and pulls data fine on 
one of our sun solaris  box, but not on the other - it returns zero 
row.  Our database is Oracle 9.  the other machine where it fails to 
return any data has 10 instances of oracle db, while the machine where 
this program works has only one instance.  Could it be timing out, b/c 
too much is going on on that box?  But it doesn't abort, ends normally - 
only it does not pull any data.  also we run the executable SQR program 
through SCT Banner 7.1 job submission on this machine with 10 
instances.  On the other machine we have Banner 6.x.  Did anybody have 
this kind of thing happen to them?  The programs and data are identical 
on two machines.  Any insight, hint, ideas are welcome..  Help!

-- jae at applachian state university, boone, nc



_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users