Please help on SBT 5.0I BUILD 708 INSTALLED ON WIN2K SERVER

[ernestop]

Hi,
I have a custom server wich has a mobo asus p5b deluxe, 2 gb of ram pc-6400 ddr2, two sataii hds configured as mirror 1, E6600 conroe processor running at 2.7 ghz and windows 2000 server installed and this server is acting as a member server with 23 users added, this is not a pdc it is just a storage server with a folder PRO50 shared for all the users that need to access SBT, OF COURSE sbt and tables and everything is in that folder, ok here is the problem i have.
Sbt has been installed for yearS on an NT SERVER 4.0 SPK 6, THE worstations that access it, are a mixed of windows 98, windows 2000, windows xp pro, the reason that i added the new server 2000 is cause i have seen latelly that the NT SERVER box can be probably down at any moment cause the age of the server, so then i anticipated and installed this new WIN2K SERVER ,ok so what i did was i copy the whole pro50 folder from the NT SERVER to the new server, i did this while everyone where out of sbt in order to copy all the files, i went to each workstation and mapped each of them to the server for example, i named the new server SBT, SO in each workstation letter S is MAPPED TO \\sbt\accounting, where ACCOUNTING is a folder that is shared and in there i copy pro50 folder, so the shortcut on each machine should be s:\pro50\sbtw.exe -t, and it work ok, "THE problem is that after 10 users accessed sbt when the next new user logon on sbt, after this user select a module or whatever after a little while this user can get this error on the screen
"[ERROR 1705] fILE syualog is not available[exclusive use]
another user maybe reindexing this file or closing the period in an apllication that uses this file.when the user has finished using this file you should be able to continue."
RETRY QUIT
THOSE ARE the options buttoms i have to press, anyway if i press retry i will get the same message over and over, and if i click Quit it will quit, but the most interesting thing is that this cause also other users in Sbt when they move to another transaction or another module to recieve the same message and the have to quit, but if i have only just 10 users logon to Sbt i think this does not happen, the version we have is 20 users licences and we only need 13 users to logon to Sbt simultaneously, please i am very frustrated can any one help ? is there any special setting needed on win2k server when sbt is copied there ?, did you know of any isues like this any recommendation please help


Thanks
Ernesto

PS: i have reindexed all files clear all flags, have been doing everything i know, another test i did was i created a little EXE application on VFP 5.0 (and copied it to this win2k server) That will open a table and browse it, editing records on that table then i created a shortcut on each workstation pointing to where this exe file is on the server and allow each user to run it , in order to test if the server is falling or if it is network traffic problem and everyone can open this aplication i did w/o a problem , of course this application i created is small but i also checked the recources in my server when about 11 users are using sbt and there is not problem, i know all the files are in the server but it is a responsability of the worksattion to run the file, so i don't know whatelse to do.

 

[fitedgar]

How was SBT mapped in the old server?

The new server should be mapped same as old.

IF it is, try installing SBT on a workstation using the
workstation installer found in the WrkSTATION folder ( not sure of the folder name)

Try deleting all *.mem from the pro50 folders.

Edgar
IBS

 

[ernestop]

Edgar
it is maping in the same way cause in the Nt server box, S IS POINTING TO the pro50 folder, I DID the same on win2k server, each workstation is mapped the S letter to \\newservername\accounting where accounting is a shared folder that contains PRO50 folder, so the only change i have to do on each workstation related with mapping is just change the server name ie it was S:\\NTSERVER\ACCOUNTING (NTSERVER IS THE NAME OF THE NT 4.0 SERVER COMPUTER)NOW IS S:\\SBT\ACCOUNTING(where SBT is the name of the win2k server computer)

i installed on each workstation using the sbt cd wich allow you to install either the client(in this case for the workstation) or Full installation(for a server), on the server i did not installed cause what i did was copy the whole folder PRO50 FROM THE NT SERVER to the WIN2K SERVER ACCOUNTING FOLDER, i dont' see a folder on the cd named WRKSTATION but i guess you refer to same procedure.
Now i have not deleted the *.mem files on the new server win2k, besides that whatelse do you recommend ?
what about the file config.fpw, there is a variable in there name MVCOUNT=2000, SHOULD I INCREASE THAT IN THE WIN2K SERVER, ANYHTING ELSE TO LOOK FOR

Thanks a lot for getting back to me man, hope you can get back to me again with more options
Ernesto

 

[fitedgar]

Hmmm...
I have seen this happening when the user does not have full access (priviliges) to the drive. "S" as in your case.

Log in as the network administrator into the workstation. Install the SBT as a workstation. Run the program (Of course as administrator)
What happens?

Edgar
IBS

 

[SBTBILL]

Can you open the sysulog file and see what is in it? Also try deleting sysulog.cdx and reindexing. Sometimes a bad index will not reindex properly.

Bill Couture
http:\\

http://www.sbtbill.com

 

[ernestop]

Edgar,
I created a user group name "SBTUSERS". IN THERE i added all the users that need acces the shared folder "Accounting" of course TO "PRO50" folder so every user in that group have full control, Question can you guys tell me when a user access SBT, what should be the access to the file FOXTOOLS.FLL AND JKEY.FLL ? Cause when i open (win2k server)computer management, shares open files under the column open mode these two files mentioned above always shows for all uses like "NO ACCESS", while the other files that are open or in use shows read or read and write, but these two always area shown for all users as no access,maybe this has some effects on the error i am recieving on a particular worstation, by the way when this particular workstation shows that error(wich is running windows 98 se with 256 mb ram still) then if i go to my server to clear that user that was using that workst then i got the same error on my server, wich is weird, anyway i was then allowing all sbt users to run sbt again from the ols server NT 4.0 SPK6 to test AND WHEN I CHECKED the files i mentioned above this files under files in use the open mode is "READ" and i don't get errors on any workstation when they run sbt whie using it from the NT 4.0 SERVER, ANY COMMENTS ?

Bill,
If i open the file sysulog.dbf what should i look for ?

what do i need to identify in this table for an specific user ?

so you are suggesting to open visual foxpro 5.0 wich i have installed in my worksttion and delete the file cdx and recreate it ?
Thanks
Ernesto

 

[fitedgar]

ernestop;

SBT also needs full access to your local machine to do printing or displaying.
Depending where your temp folder is located.

What happened as per my prior suggestion?

Edgar
IBS

 

[SBTBILL]

Re checking SYSULOG, I'm wondering if you have a corrupted record. I.E. do you see one with a lot of strange stuff in it. Yes, I'm suggesting delete the SYSULOG CDX and then recreate it. There might be some corruption in it. This is unusual but it happens and when it does sometimes SBT/Fox can't delete the CDX though the normal reindexing routine.

Basically, the tak I'm taking is that you might have some file corruption. Inadiquate rights is another possibility.

FLL's are similar to DLL's. The program calls them for some routines. Never checked if you'd need write privilages on them but wouldn't think so.

Bill Couture
http:\\

http://www.sbtbill.com

 

[ernestop]

Edgar
what do You mean that the sbt server need access to my local machine ? and how can i do that ?

Bill and Edgar
Can you do me a favor, are you guys running SBT on a win 2k server ?, if so can you check the open mode from the computer management shares , files open, there is a coluun there in that list under files open named "open mode", can you check for your users connected to sbt the files FOXTOOLS.FLL, JKEY.FLL, SBTTOOLS.FLL, SBT.FXP AND SBTW.EXE WHAT DOES IT SHOWS IN THAT COLUMN please . it should say either READ, NO ACCESS, WRITE OR WRITE AND READ, I ALWAYS HAVE LISTED UNDER THA COLUMN FOR THOSEFILES "NO AC ESS" for al all users running SBT, I DON'T KNOW IF THIS IS CORRECT and if this can be causing that error i got from a particular computer/user, if you don't get in that list NO access, please let me know what you get and you can figure out why i am getting this, if you did not understand my question, i wil probably try to post it in a different way
Thanks a lot to both
Ernesto

 

[fitedgar]

All *.fll, *.dll *.exe *.esl should be marked as read only.
Leave others as read-write attributes.
These are program libraries that do not get updated.

< what do You mean that the sbt server need access to my local machine ? and how can i do that ? >

Server does not need access to your workstaion. Fox Pro does. To speed up certain processes , it creates temp files locally.

For the last time, what happens when an administrator uses SBT program? Do you get the same errors?
Edgar

 

[ernestop]

Edgar,
When you refer to the adminitrator you meant the server administrator or the sbt administrator ? anyway in each case evrything is ok, like any other user is ok too, i will probably test it today(cause i replaced that win98se comp by a win2k prof computer with more memory and 1GB Nic but the problem i have is that after 11 users running Sbt this particular user/computer that was running win98 se was giving me that error that mentioned before the 1705, and he/she lost the access to continue using SBT , as well this error cause the other users to recieve the same error, even when i go to the server to clear flags i also get in the middle of clear flags the same error and i have to reboot the server, ok then what i did was checking the access mode of each file open on the server, and these files i mentioned before shows "no access" UNDER THE ACCESS MODE COLUMN IN THE FILES OPEN, but even that, users can run SBT, i was wondering if these can be causing the problem, when i switch to run sbt(all users) by accessing the NT 4.0 SERVER, I checked the files open and those files shows as READ. so when i switch back to allow all users to run sbt now from the w2k server the same files are in use but they shown as NO ACCESS, QUESTION, Do yu run sbt ion a win2k, or win2003 server ? if so can you check under your server computer Manag, shares, files open, then under the column "access mode" the status of those files for me, when ypu mentione to mark those files as Read only.
Are you teling me to manually go to each of these files and put a check mark as READ under the attributes ?
Correct me i am wrong
Thanks
Ernesto

 

[fitedgar]

< Are you teling me to manually go to each of these files and put a check mark as READ under the attributes ? >

Yes

SBT runs fine under WIN NT 4.0 server or WIN 2003 server.

USING win 98 workstation or XP workstation.

edgar