Alaska Software Inc. - Error while reading a file
Username: Password:
AuthorTopic: Error while reading a file
Scott KriseError while reading a file
on Mon, 12 Aug 2019 14:48:12 -0400
Hello Everyone,

I'm having an on-going issue at one particular customer site. This is my 
largest customer with the most concurrent users (30-35 users). I user 
dbf/ntx tables.

I'm seeing a lot of "Error while reading a file" when the users is opening 
tables using the USE command, and I can't pinpoint why it's happening.

Here is a sample of the code I use to open tables.

function ojobbom
   select 57
   do while .t.
      use jobbom.dbf alias jobbom    <<<<--------- ERROR IS OCCURRING ON 
THIS LINE.
      if neterr()
         xtry = .f.
         do filelocked with xtry, "JOB BOM"
         if xtry
            loop
         endif
         return .f.
      endif
      if used()
         set index to jobbom1.ntx, jobbom2.ntx
      else
         return .f.
      endif

      exit
   enddo
return .t.

So, here is where I am thinking:

1)    I originally thought it was some sort of network connectivity issue 
where they were loosing connection with the network. Dropped packets, etc. 
But we've recently upgraded servers and the problem still occurs. I don’t 
feel like this is the problem completely because the error log gets written 
to the network as soon as the error occurs, so obviously that couldn’t 
happen if they lost the network...unless of course it is intermittent and is 
back when it comes time to write the error log.

2)  The other thing I think, but cannot prove or disprove, is that there is 
some sort of crash occurring where too many users are using/opening the 
table at the same time and the USE fails. In either case, shouldn’t the 
neterr() function deal with that sort of issue if that were occurring?

3) I have very similar issues when using GOTO TOP of a table.

Anyone have any thoughts on what might be causing this...or what I can try 
to do to capture it without causing the system to crash?

Thanks,

Scott