A customer of mine has a web server that is a seperate box from his main file server. The company uses an A5 LAN/desktop system against this file server for the majority of their work.
If we access files through the web server, it appears that they are being held open, which means we can't manage structures, field rules, or indexes.
This is a Windows Server 2003. After accessing files through the web, my customer goes to Computer Management / Shared Folders where he can view open files, and he can see, even after the web user (me) has logged out and even closed my browser, that the various files that were used
are still shown as "in use."
He can force them to be closed, but when he does that and I come back in to try again through the web server, I get this error when trying to make use of the customer.dbf:
The only solution to getting things back in running order is to reboot the web server.
What to do?
Edit: Customer reminds me that it appears the problem began about the same time we rolled back the build to Build 1658-3088 last week in our attempt to solve the pdf printing problem. Dunno how exact the timing might have been, and if you've been reading here you know that the pdf problem didn't get resolved anyway. I s'pose we could try yet another more recent patch, but quite frankly I've lost track of builds and which one(s) might not have a critical problem.
If we access files through the web server, it appears that they are being held open, which means we can't manage structures, field rules, or indexes.
This is a Windows Server 2003. After accessing files through the web, my customer goes to Computer Management / Shared Folders where he can view open files, and he can see, even after the web user (me) has logged out and even closed my browser, that the various files that were used
are still shown as "in use."
He can force them to be closed, but when he does that and I come back in to try again through the web server, I get this error when trying to make use of the customer.dbf:
500 Internal Server Error
"Script Error
Error:Script:pagetop.a5w line:39
t = table.open("f:\customer.dbf", file_rw_shared, "", "mypassword")
Error loading f:\customer.dbf: The handle is invalid.
customer.dbf"
"Script Error
Error:Script:pagetop.a5w line:39
t = table.open("f:\customer.dbf", file_rw_shared, "", "mypassword")
Error loading f:\customer.dbf: The handle is invalid.
customer.dbf"
What to do?
Edit: Customer reminds me that it appears the problem began about the same time we rolled back the build to Build 1658-3088 last week in our attempt to solve the pdf printing problem. Dunno how exact the timing might have been, and if you've been reading here you know that the pdf problem didn't get resolved anyway. I s'pose we could try yet another more recent patch, but quite frankly I've lost track of builds and which one(s) might not have a critical problem.
Comment