john doed wrote: > 1) > This SELECT produces a -9111 System Error - Move Error > -- > SELECT * FROM FOOTPRINTS_ONLINE WHERE (updated>'2003-01-10 > 00:29:00.061') > AND (fpo_id IN (SELECT fpo_id FROM OPS_FPO_WORKLOAD WHERE op_id=1 AND > master_id=1)) ORDER BY created ASC > -- > As you can see I am using 2 WHERE conditions. If I only have > 1 condition > (it doesnt matter which one) it will work. If I substitute > one condition > with ANY other field in that table it will work. But having > those exact two > conditions causes this error. Why?
Could you please post the knldiag.err file of the database because it will tell us more about the problem. You will find it in the rundirectory of the database. > 2) > When executing my app, it's first session with the SAPDB produces > SQLExceptions errors (this is normal because the SQL has not > been converted > from Postgresql), however the 2nd attempt by my App will give me a > "connection refused error". I have to restart the database > before I can try > again. > > Now I have commented out my code so I only produce 1 > Exception, and I dont > have to restart the database. I'm not sure if I understand your problem but perhaps your user is defined as an exclusive user. For more information see http://www.sapdb.org/htmhelp/48/f0daa5225811d3a97d00a0c9449261/frameset.htm. HTH. Kind regards, Holger SAP Labs Berlin _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
