Database access errors

This forum is for general support of Xbase++
Message
Author
reganc
Posts: 244
Joined: Thu Jan 28, 2010 3:08 am
Location: Hersham, Surrey, UK
Contact:

Database access errors

#1 Post 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?
Regan Cawkwell
Real Business Applications Ltd
http://www.rbauk.com

skiman
Posts: 1052
Joined: Thu Jan 28, 2010 1:22 am
Location: Sijsele, Belgium
Contact:

Re: Database access errors

#2 Post 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.
Best regards,

Chris.
www.aboservice.be

User avatar
Tom
Posts: 1023
Joined: Thu Jan 28, 2010 12:59 am
Location: Berlin, Germany

Re: Database access errors

#3 Post 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.
Best regards,
Tom

"Did I offend you?"
"No."
"Okay, give me a second chance."

reganc
Posts: 244
Joined: Thu Jan 28, 2010 3:08 am
Location: Hersham, Surrey, UK
Contact:

Re: Database access errors

#4 Post 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.
Regan Cawkwell
Real Business Applications Ltd
http://www.rbauk.com

User avatar
rdonnay
Site Admin
Posts: 4562
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: Database access errors

#5 Post 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 13798 times
The eXpress train is coming - and it has more cars.

User avatar
Tom
Posts: 1023
Joined: Thu Jan 28, 2010 12:59 am
Location: Berlin, Germany

Re: Database access errors

#6 Post by Tom »

You're looking better than ever, my friend.
Best regards,
Tom

"Did I offend you?"
"No."
"Okay, give me a second chance."

User avatar
rdonnay
Site Admin
Posts: 4562
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: Database access errors

#7 Post 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.
The eXpress train is coming - and it has more cars.

User avatar
Tom
Posts: 1023
Joined: Thu Jan 28, 2010 12:59 am
Location: Berlin, Germany

Re: Database access errors

#8 Post by Tom »

If we all survive this, we will need to get together again for a much-needed reunion.
I agree. Definitely.
Best regards,
Tom

"Did I offend you?"
"No."
"Okay, give me a second chance."

skiman
Posts: 1052
Joined: Thu Jan 28, 2010 1:22 am
Location: Sijsele, Belgium
Contact:

Re: Database access errors

#9 Post by skiman »

Wish all the best to Bobby, and keep it safe.
Best regards,

Chris.
www.aboservice.be

reganc
Posts: 244
Joined: Thu Jan 28, 2010 3:08 am
Location: Hersham, Surrey, UK
Contact:

Re: Database access errors

#10 Post by reganc »

skiman wrote:Wish all the best to Bobby, and keep it safe.
Same here!
Regan Cawkwell
Real Business Applications Ltd
http://www.rbauk.com

Post Reply