Page 1 of 2

Database access errors

Posted: Thu Mar 26, 2020 3:09 am
by reganc
We have been experiencing a large amount of general database access errors. The majority of our customers are still using our application built using Xbase++ 1.9 (due to an outlook incompatibility with list & label that we're still trying to get to the bottom of) but a few customers have been given an Xbase++ 2.0 version and they get similar errors too, so I currently think this is a general issue.

We use mainly DBF+CDX although there are a number of our customers still using NTX and a small amount using ADS. The majority of the errors therefore are from the DBF+CDX ones.

The errors in general are:

'Operating System Error' on doing dbseek / dbgotop
'File can not be opened' / 'Error while reading file' on any sort of dbf access.

We also have a number of 'Operating System Error' with a OS error code 1 (Incorrect function) on opening an index which I've never understood.

We have checked things like anti-virus and oplock settings.

I'm simply interested to know if anyone else is having similar errors?

Re: Database access errors

Posted: Thu Mar 26, 2020 3:34 am
by skiman
Hi Regan,

Hope you are going well?

According to our experience we have noticed that all 'db...' errors as dbseek, dbgoto, dbskip, ... are mostly related to corrupt indexes. After reindexing this is normally solved.

Error while reading file is in my opinion more network related. I see it on networks where the performance isn't very well. I suppose that sometimes the network connection is broken and after some retries, the error comes up. Restarting the complete system as the server mostly solves this problem.

Re: Database access errors

Posted: Thu Mar 26, 2020 5:10 am
by Tom
You may have a problem with the network storage/drive beeing disconnected once in an hour. This occurs if the group policy preferences (GPO) are used for drive mappings. Windows checks all the drive mappings once in an hour, and if that happens, an action is taking place. If this action is called "replace" (drive mapping), the network drive is disconnected and re-connected, in most cases without any reason. All file handles get lost. You may get OS-error 1, but also "errors reading file" and others. Your data may be corrupted. Check the GPO and set "action" to "update". Read this document:

https://docs.microsoft.com/en-us/previo ... 2(v=ws.11)

Edit: I hope all you guys are well. What's happening now is very unexpected.

Re: Database access errors

Posted: Thu Mar 26, 2020 7:27 am
by reganc
We're all fine so far. Hope you and yours are well and stay well, too.

Chris, I always thought most of these were index related but they appear random and I haven't found that they ever relate to any actual database corruption.

Tom, hadn't heard about this but I'll mention it to our tech guy and see what he thinks.

Thanks, guys.

Re: Database access errors

Posted: Thu Mar 26, 2020 7:34 am
by rdonnay
hope all you guys are well. What's happening now is very unexpected.
I have read a lot about pandemics in the past and how they spread.
I was expecting this back in January.
It's hitting New York very hard. Bobby Drakos has the virus but he's doing well.
My granddaughter is sewing masks to give out to family and friends.
mask.jpg
mask.jpg (291.67 KiB) Viewed 16834 times

Re: Database access errors

Posted: Thu Mar 26, 2020 10:14 am
by Tom
You're looking better than ever, my friend.

Re: Database access errors

Posted: Thu Mar 26, 2020 12:00 pm
by rdonnay
You're looking better than ever, my friend.
If we all survive this, we will need to get together again for a much-needed reunion.

Even though Bobby has the virus, he and I are still working to keep the New York City taxi business running.
Lots of changes required to adapt to the changing environment.
The taxi business in NYC will look different after this, from a software and control perspective.

I'm fortunate to be 2000 miles away from NYC.

Re: Database access errors

Posted: Fri Mar 27, 2020 12:29 am
by Tom
If we all survive this, we will need to get together again for a much-needed reunion.
I agree. Definitely.

Re: Database access errors

Posted: Fri Mar 27, 2020 1:57 am
by skiman
Wish all the best to Bobby, and keep it safe.

Re: Database access errors

Posted: Fri Mar 27, 2020 5:10 am
by reganc
skiman wrote:Wish all the best to Bobby, and keep it safe.
Same here!