FWI, When you browse, there is a cursor open on the table...
----- Original Message ----- From: "Dennis Fleming" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Saturday, November 17, 2012 12:40 PM Subject: [RBASE-L] - Re: Resources Unavailable : Thanks Karen. : I've also seen this when browsing a large table by one user and another process attempts to update the same table (maybe using a cursor). : In the very old days I recall "exceeding the number of file handles available". : But I may have mis-remembered. : : Dennis : ***** : : : At 08:57 AM 11/17/2012, you wrote: : : My usual culprit is a cursor that is not dropped, still open. : : Karen : : In a message dated 11/16/2012 4:17:14 PM Central Standard Time, [email protected] writes: : : RB7x user is getting "Resources Unavailable" message and then they have to reset. : If a table is locked this will happen. Other causes? : : TIA, : : Dennis : : : Dennis Fleming : IISCO : www.TheBestCMMS.com : Phone: 570 775-7593 : Mobile: 570 351-5290 --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
