Hi All,

I have a client who has been using my app for many many years. They are on a Small 4 user network with a Windows Server. They have been for a while so I am not blaming the server for this error - or the NPP they are using.

I issue barcodes to all new stock created and more than one user may create stock at any one time.

They probably create 100 items a day

Somewhere between 3% and 5% of the time the app is unable to open the Barcode table.

The command is simple

open "BARCODE_TABLE" to Barcode.file then

Well - I end up in the end else section

I've put in a try to open the table again 100 times loop and if that fails then wait 5 secs and try again 100 times and if that fails then wait 5 secs and try again 100 times and if that fails then wait 5 secs and try again 100 times

As this is purely intermittent, I can't work out why the table won't open.

Is there something I can do to force the table open or at least find out who has the table locked or why it won't open

Any suggestions would be greatly appreciated

TIA

Claude

My years of experience tells me to look at the network. Network cards, routers, hubs, cables, etc. Try to isolate the problem to only certain devices. Maybe that will give a clue.

If it is only this one table… Then maybe it has an issue with the disk drive it is on. Maybe the disk drive has a "soft spot" on it. A spot on the disk drive that is not 100% good. You then might want to copy the table and rename the old file to something else. This will allow the old file to keep the soft spot "used" and maybe that will solve the problem.

What is the FS Error?

The Sprezzatura Group

World leaders in all things RevSoft

I am not recording the FS error.

I literally end up in the else section when opening the table.

I pause for 5 secs (after 100 attempts to open the table)

I then do an attachtable

A system error telling me the table is not available for attaching kicks up.

And yes, it is ONLY this table - no other

I hope this helps

Claude

Do you have a call to FSMSG in your ELSE branch? If not, I would add that. Additionally, details of the nature of the error are stored in @FILE.ERROR.

Perhaps there is a rights issue or something. One other thing to try would be to recreate the file. That will give you fresh files on the OS level. That might skirt the problem if it is an OS-related problem.

Perhaps if you were to post on here the contents of the Systables record for this table, it might give some suggestions …

Simon

Not sure what you mean but the SYSTABLES record says

GOLDMARK_DATA

BARCODE_CROSSREF

GOLDMARK

RTP57

The first is the data location the third is the application

Am I missing something?

No, you are not missing anything - I was just checking for any MFS'es that might be on the table, including indexes etc.

The only other basic check I can think of it to check that the dictionary exists, sometimes that causes issues. But otherwise, as per the previous posts in this thread, I think we need to know the FS number on the else clause to help point in the right direction.

The only other thought that springs to mind - what are the dos sizes of the .lk and .ov files, and is there a lot of data in the table ??

Simon

Speaking of indexes, the name seems to indicate that it might be a candidate for indexing, but SI.MFS was not listed. If this table is updated by a relational index, it's possible the index may need to be re-established. Both the related from and related to files should list SI.MFS. If only the related from one does, then it's possible the index might still work, but there could be issues accessing the file.

OK,

It is error FS401 Table not Created or Attached

There is no Index

There are only 3 fields

It is used as a lookup table

e.g Barcode 100254 - Refers to Product code ABC123

At this stage I am just opening it to write the latest Barcode.

Code is as such

0114 | loop until Barco.Read=1

0115 | | open "BARCODE_CROSSREF" to Barco.file then

0116 | | | Barco.Read=1

0117 | | end else

*–*-*-*- Various error messages - where the FS401 was trapped

0144 | | end

0145 | repeat

* Once open I run this simple routine to get the next Barcode number 0148 | | Lock count.file,"BARCODE" Then 0149 | | | read next.barcode from count.file, "BARCODE" else 0150 | | | # ERROR Message - Abort 0151 | | | end 0152 | | | @record=next.barcode 0153 | | | next.barcode += 1 0154 | | | write next.barcode to count.file, "BARCODE" else 0155 | | | # ERROR Message - Abort 0156 | | | end 0157 | | end else 0158 | | # ERROR Message - Abort 0159 | | end 0160 | | UnLock count.file,"BARCODE" 0161 | | * I then write it to the BARCODE_CROSSREF file

0162 | | stock.cross.ref='

0163 | | stock.cross.ref=@id

0164 | | stock.cross.ref=RETAIL_STOCK"

0165 | | write stock.cross.ref to barco.file, @record else

I've truncated the error messages as I use my own util

Pretty basic really

They tell me that sometimes after a pause (I put in) and Retry it is able to attach the table and continue. Other times no way will it re-attach.

Thanks for your input

Claude

What is the user count on the AREV executable?

The Sprezzatura Group

World leaders in all things RevSoft

Another thing to check is if you use setattach. I don't, and I'm not really up on the issues. The thing about setattach, though, is that it uses a cached image of the volume. If there is a problem with the image, you need to rebuild it. Perhaps someone more familiar with attach images can expound on this. If you don't use attach images, though, you can just ignore this post.

Thanks for that Victor

I don't use setattach at all

Can't Remember but it is probably a 3 user with the NPP

They are using a MS Server.

Don't ask them to use the Universal driver as they are as tight as…..

Also all other tables work and which have more records, more fields, loads of indexes etc. etc.

All workstations are XP

There are probably 50 - 60 tables. Why do the others work seamlessly and this one intermittently drops out

Claude

Without investigating real time no clue. Check that write behind caching is disabled on all workstations.

The Sprezzatura Group

World leaders in all things RevSoft

I still think you should try recreating the file. Whatever the problem is, I think that is likely to resolve the problem (unless the error happens during the recreate process).

View this thread on the forum...