STUDENT RECORDS/A+/GRADE BOOK SECURITY PROGRAM BUG: (1/29/2003)

 If a user attempts to add a new user to security maintenance AND attach a teacher to the record the following error will occur:                                

Error accessing:  Sturec05

                  Code 47:  Invalid Record Declaration

    Press OK to return to DOS 

To correct, download the appropriate Stu.exe.  Then using Student Records Security Maintenance add the new user and attach the appropriate teacher to the user record.  (Attaching the teacher record to the user will not be possible in A+ or Grade Book)   Setting what the user should have access to in Grade Book and A+ will not be a problem.  Just run those programs as normal, go into security maintenance, highlight the new user just added using Student Records and use the Access Button to set their levels of access to the program. To download the appropriate Stu.exe go to Downloads for Student Records, A+, and Food Service and choose multi or single user.

TROUBLESHOOTING

Many customers frequently receive the following error:

This error is a result of Btrieve not being loaded by your individual workstation or server if you are on a network. Btrieve is a database management system that the student records program uses to maintain all student records data files.

STANDALONE / NETWORK OTHER THAN NOVELL

1. When running on a standalone machine or a Non Novell Network you must run one of the following batch files: STUS or STUS.BAT. Running the STU or STU.EXE will result in the above error because this command does not load Btrieve. The STUS batch file gives your computer the command to load btrieve and then run the stu program. If the above error occurs you will need to make sure you are typing the right command at the DOS prompt or that your menu/icon is set up to run the correct file.

2. DOS If you are running student records from a DOS prompt be sure you are running STUS.

WINDOWS 3.1
If you are running the program from an icon setup on Windows 3.1, then click one time on your icon to highlight it, select the File pull down menu, then choose properties. Change the command line to run STUS instead of STU.

WINDOWS 95
If you are running the program from an icon setup in Windows 95, then right click on your icon, choose properties from the pull down menu. Next, select the Program Folder and change the command line to run STUS instead of STU.

OTHER MENUS
Edit the command line for you menu option and change it to run STUS.BAT instead of STU.EXE.

NOVELL NETWORK

1. There are three things that must be setup correctly to run Student Records off of a Novell server when running STUN. If running STUS there are no special settings and you may run as you do a standalone. Ex: F:\STUDENT\STUS.BAT

If running STUN, you must follow these procedures.

A: You must have the location of brequest.exe on the server in each work stations PATH statement.

B: You must run one of these brequest batch files STUN, STUN.BAT, STUS. or STUS.BAT. You must run the same batch file on every work station.

C. You must have Btrieve setup on the server only if running STUN. When running STUS then you may follow the instructions for a standalone.

When running STUN you must follow the following procedures. You must have Btrieve setup on your server and your computer's path must be able to find brequest.exe on the server.

2. To locate for sure where brequest.exe if found on your server, go to the root directory of your server and type DIR BREQUEST.EXE /S. If brequest is not found please call The Lemberger Company for further assistance. If brequest is found on your server then you need to make sure your computer's path is set correctly. To do this exit to a DOS prompt. You will then need to access the drive your Student Records programs resides in. (ie. F:\STUDENT) Once you are in your student sub directory, type BR to load the brequest.exe and press ENTER. You should then receive the following message:

F:\STUDENT>brequest /d:40000 /1 Btrieve Requester for DOS v6.16.2 Copyright (c) 1982-1995, Btrieve Technologies, Inc. All Rights Reserved.

If the command has any errors loading you should receive a message that it couldn't find brequest or that the program would not load. Your path statement on your computer will need to be edited to include the directory brequest.exe resides. For example if brequest.exe is found on the server in the F:\PUBLIC drive you would want this in your path statement so that your individual work station could find btrieve to load it. To find out what your path is exit to DOS and type PATH and press ENTER. You should then see a line similar to this:

PATH=C:\WINDOWS;C:\WINDOWS\COMMAND;C:\;C:\DOS;F:\PUBLIC

Your path statement is set in the autoexec.bat file, this is found in the root directory of your computer. Use t he dos editor to edit the autoexec.bat and add the drive and directory where brequest can be found.

3. If brequest is loading properly then you will want to check the batch file you are running next. When running on a Novell network you MUST run one of these batch files STUN, STUN.BAT, STUS, or STUS.BAT (preferably STUN). Every workstation running Student Records must run the same batch file so if you have started out using STUN then you should always have to use STUN or vice versa with STUS. Make sure the menu/icon is set up to run one of these batch files. If the menu is set up correctly then you may go on to check the next step.

4. If the workstation is running the correct batch file and the brequest path is found then we are ready to check the server.

From the server console type LOAD BSETUP. Choose to configure Btrieve. "Set Btrieve Configuration" Number of Open Files: min 150 preferably 200. Ex: 600 Number of Handles: min 150 preferably 200. Ex: 500 Number of Locks: min of 100. Ex: 100 Number of Transactions: 25. Ex: 25 Largest Compressed Record Size: 0 is appropriate. Ex: 0 Largest Record Size: min size must be 40000. Ex: 40000 Largest Page Size: 4096 Ex: 4096 Number of Remote Sessions: leave as is. Ex: leave as is Cache Allocation: server 8 meg or less use 256K of 512K 16 or 32 meg use 512 or even 1024K Ex: 1024 Perform Index Balancing: NO Ex: NO Logging of Selected Files: NO Ex: NO Create Btrieve Files in Pre v6.x Format: YES Ex: YES Create Files as Transactional: NO Ex: NO Configure BSTART.NCF to Load BROUTER: NO Ex: NO Exit BSETUP and save the configuration changes.

5. If these are the current settings or close to the current settings on your server for Btrieve then we will move on to the next thing to check. Exit back until you are back at a prompt where you may type. We will now need to check to see what btrieve settings your server is currently using. If there is other software that utilizes Btrieve, the settings for Student Records may be getting overridden.

From the console type LOAD BTRMON and select the Resource Usage Menu. You should see a table that looks like this:

Current Peak Max Files 0 13 600 Handles 0 13 500 Locks 0 2 100 Transactions 0 0 25 Clients 0 2 30 Threads 0 1 0

The settings you need to look at are those of the Files and Handles. If these settings are below the amount you previously set in the Btrieve Configuration such as Files = 20 and Handles =30 then you will know some other program is overriding the Btrieve Student Records utilizes.

In order to prevent Student Records Btrieve from being overridden we will need to put BSTART in the AUTOEXEC.NCF. You may manually load Btrieve by typing BSTART at the console but in cases where Btrieve is being overridden you will need to load it in the Autoexec.ncf so that we can get it to load before the other program utilizing it gets loaded. When manually typing BSTART to load Btrieve everytime your server is downed Btrieve is unloaded and you will manually have to load it again. However if you include BSTART in the autoexec.ncf it will automatically load upon restarting the computer.

6. We want to put the BSTART command into the AUTOEXEC.NCF. On a Novell 3.x or 4.x you will need to type LOAD INSTALL at the console and select to modify the AUTOEXEC.NCF. On a Novel 5.x you will need to type LOAD NWCONFIG and select NCF file options, then select to edit the AUTOEXEC.NCF. If the BSTART command is already in the AUTOEXEC.NCF we will want to move it higher. Here is an example of what the AUTOEXEC.NCF will have in it and also where we have BSTART loaded on our server. Try to load BSTART after the IPX address. After you have inserted the line with BSTART you will then have to reset your server in order for it to read the changes.

File Server name LEMCO IPX internal net 1 Register memory 1000000 3000000 Set immediate purge of deleted files=ON LOAD C:\NW_312\MSM31X.NLM LOAD C:\NW_312\ETHERTSM LOAD C:\NW_312\SMCPWR LINE_SPEED=100 FRAME=ETHERNET_802.2 NAMES LOAD PSERVER LEMCO BIND ipx to SMCPWR NET 00000002 LOAD UPS TYPE=STANDALONE PORT=231 DISCHARGE=20 RECHARGE=60 MOUNT ALL SPOOL 0 TO QUEVE PRINTQ_0 BSTART LOAD C:\TC\MONITOR

You then want to go through step 5 again and LOAD BTRMON. If loading the BSTART higher helped your cause you will see the settings for files and handles you set earlier in the Btrieve Configuration. You will now need to go into Student Records into Data Entry. If you fail to receive the Error Code 90 message your problem has been fixed. If you continue to have problems please contact us at The Lemberger Company 573/422-3355.

You will also need to make sure each workstation can locate the Brequest file when running the batch file STUN.BAT. To check this at each individual workstation go to the drive and subdirectory where student records is loaded and type BR and press enter. If that workstation is properly finding student records you will receive this message:

F:\STUDENT>brequest /d:40000 /l Btrieve Requester for DOS v6.16.2 Copyright © 1982-1995, Btrieve Technologies, Inc. All Rights Reserved

BREQUESTER and BTRIEVE

If you receive any other message such as File Not Found or unable to load brequest then your workstation is not properly loading the Brequest files needed when running STUN.BAT. The Brequest files are normally located in your F:\PUBLIC drive. Each workstation may have F:\PUBLIC in their path statement. You may also have this in the login script on the network so that when each workstation logs onto the network they will find the F:\PUBLIC and load btrieve.

NETWORK USERS RIGHTS

In order for each user on the network to be able to properly add, modify, change, delete, and rebuild keys in the student records program they will need all rights except supervisory when logging onto the network. If you fail to give them all rights except supervisor they may receive an error message or it may not be able to run the program at all. To test this theory login onto the network as the admin at that work station to see if it works.

BACKING UP

When attempting to make a backup in Student Records or Food Service and you receive the error message "Error Attempting Exclusive Access". This means that someone else has the student records/food service program open. All users must be completely out of student records/food service before you will be allowed to make a backup. There will be times also when a workstation or your network will not close student records/food service files and you will receive the same message. In this case restart the computer you are on and make everyone else that uses student records/food service shut their computer off.