Re: Unable to position within table

On Thu, 2006-02-09 at 10:47 -0600, Bill wrote: > This concerns IDS 9.4 TC2 on Windows 2000 server. > > Sometimes a com object will throw a message like "unable to position within > table". When I run the same sql through dbaccess, it runs fine. > Yesterday I ran one via dbaccess and got the same message the object got. > When I commented out the "order by" the message went away. > I checked all indexes and looked at the temp space. > I don't see any problems there. > After all users went home and the objects timed out the query ran ok with > the order by in it. > This was the sql: > > select mo.*, moc.data_type > from mat_options mo, mat_opt_cat moc > where mo.category = moc.category > and mo.material_id in ( 35780,255470,20580,254047,32970 ) > order by mo.material_id, mo.per_item, mo.opt_line_no, mo.position; > > The mo.material_id has a referential constraint to another table (material) > and therefore has an index on it. > The mo table has only 5900 rows with 15 columns. > The second table only about 200. > The material table around 3500 rows. > The result of the query is only about 10 rows. > > The problem occurs only randomly. > Is this a possible lock issue? Yes. How are your tables defined. lock mode row? lock mode page? If the problem lasts for minutes at a time, gind the stored procedure sp_show_locks on the iiug website and be prepared to run it the next time you have this problem. It will tell you session is holding the locks on the table. > Is there anything else that jumps out as a reason? Not immediately, do your application logs tell you anything? DT