I don't know if this will help. In the past month, 9.1 was changed to have the scratch files ($$$) changed from an 8 character file to a GUID 32 character file (I think). I believe the reason was because of network collisions over duplicate scratch files.
-----Original Message----- From: Lawrence Lustig <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Tue, 18 Oct 2011 08:55:24 -0700 (PDT) Subject: [RBASE-L] - Re: Hanging terminal server sessions? Thanks Bob. I don't believe there are any ODBC connections in this system (I recall writing an R:Base-to-R:Base ODBC thing for them years ago but I believe it's rarely if ever used). Is the Windows RDP profile temp folder different from setting SCRATCH to TMP? How do you get this folder from the environment? When you saw this problem was it sporadic? The report I have is sporadic -- sometimes once a week, sometimes several times a day. But the system does run most of the time. -- Larry From: Bob Thompson <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Tuesday, October 18, 2011 10:54 AM Subject: [RBASE-L] - Re: Hanging terminal server sessions? Larry, I experienced the very same symptoms a couple of years ago, running 7.5 compiled. I was able to resolve my issue, however I modified more than one possible cause, so I'm not 100% sure which fixed it. So I will list what I did and perhaps, where applicable, one might help. ODBC connections: My database had several ODBC connections to non-Rbase tables. Some of these were originally attached without a "using" clause. This resulted in all columns being a "Qualkey" link in these tables. I corrected this to have only one QualKey column. I also changed code to DisConnect ODBC connections after use where ever I could, not leaving them open "all day" Temp files: I originally was using a shared TEMP folder for all RDP user's $$$ files. I changed the code to use the user's Windows RDP profile temp folder. I set the RDP user's rights to full for the shared Database folder. (This added erase authority, but I was grasping for solutions) Compiled file: I had about 20 RDP sessions running from 1 shared folder and compiled .exe. I made 4 duplicate folders and went to about 5 users per .exe. This might seem strange, but I had reasons to suspect some odd trerminal server issue running so many copies of the same exe. Anyway, after the above, my issue went away. I could introduce one back in at a time, but the system is working great and I do not have the time for that luxury. I suspect the ODBC changes were probably causing my iisues, but it could have been any of the above. Good luck. Bob Thompson LaPorte, IN 219-363-7441 Sent from my iPod On Oct 18, 2011, at 8:07 AM, Lawrence Lustig <[email protected] [mailto:[email protected]]> wrote: A client has recently started having problems with their R:Base system "hanging" -- all attached sessions stop running and the database files become unavailable until the server is rebooted. I believe that the onset of this problem more or less coincides with their changing some machines in their facility from networked workstations to thin clients attaching to RDP sessions. I'm wondering if dropped or incorrectly terminated RDP sessions could account for the sudden onset of problems they're seeing. Does anyone have an experience with this? -- Larry
