Our POS software is written in Advanced Revelation 3.12. We have been trying to get the NPP (1.5) setup and running. Everytime we install it we are able to process a few invoices and then we get the following message. "Fatal Error writing 49268 in table Invoices" "The total length of all the key ids in the group exceeds the maximum variable length". The 49268 is the invoice number being saved at that time.
We are running Win98 peer to peer with 3 workstations and a "dedicated" server (protocol NetBEUI). Without the NPP we appear to have record locking and have not had any GFE after 2 months of use.
I have read other post here. We have the desktop PIF configured as indicated by Revelation. I have not tried disabling write behind caching in contol panel/system/performance yet. Nor have I tried creating the REVARAM file.
Any suggestions?
Thanks
Check that there is no quickdex or rightdex on the file
From TCL enter the command DICT FILENAME
Hit F6 and remove any quickdex or rightdex.
Steve
Neither is on the file INVOICES.
Completely missed seeing the error code associated with the arev aerror message. The code is FS1001. Not listed in the readme file with the NPP disk (there are some other "FS" codes).
Anyone know what this indicates?
Thanks!
I was on-line looking for an article I had read before which is related to but not the cause of your problem. I have a client running POS software I developed for him in a Win95 peer to peer "non-dedicated" server environment and following are some rules of thumb for maximum stability (note I did not say maximum performance).
1) Never ever set or allow to be set a temporary directory on the root of a drive. Check both the autoexec.bat and each workstations .ini file. If you launch arev through a batch file also check its contents. Make sure the temporary directory actually exists.
2) While having a single workstation dedicated to indexing is often looked upon as optional, in this situation it is a must. I have setup the least used workstation for indexing because the non-dedicated server is the most used computer. In your situation I would try seting it up on the dedicated server but beware I have not tried this configuration. ARev definitely prefers a dedicated server but without the NLM or NT service I found that running reports on the server greatly eased the need for indexing.
3)Config.sys
device=c:\windows\Himem.sys
dos=High
device=c:\windows\emm386.exe noems
dos=umb
files=100 (250 on the server)
buffers=30,0
lastdrive=z
Note:that this has the effect of disabling EMS
4)Network caching is turned off.
These are all the settings I can think of right off the top of my head. You also need to find the article I am looking for now which is related to the loss of records due to duplicate keys or you can simply write your own routine for ensuring records are not overwritten due to a glitch which allows the duplicate keys to be generated.
Kevin Noseworthy
The text description for FS1001 error is :
"The total length of all key ids in the group exceeds the maximum variable length."
SEARCH THIS SITE FOR FS1001 - SOMEONE FOUND A FIX FOR THIS EARLIER