bb.donnay-software.com

Donnay Software Web Forums
It is currently Sat May 30, 2020 11:14 pm

All times are UTC - 7 hours




Post new topic Reply to topic  [ 20 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: Database access errors
PostPosted: Thu Mar 26, 2020 3:09 am 
Offline

Joined: Thu Jan 28, 2010 3:08 am
Posts: 212
Location: Hersham, Surrey, UK
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


Top
 Profile  
 
PostPosted: Thu Mar 26, 2020 3:34 am 
Offline

Joined: Thu Jan 28, 2010 1:22 am
Posts: 863
Location: Sijsele, Belgium
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


Top
 Profile  
 
PostPosted: Thu Mar 26, 2020 5:10 am 
Offline
User avatar

Joined: Thu Jan 28, 2010 12:59 am
Posts: 772
Location: Berlin, Germany
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 ... 02(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."


Top
 Profile  
 
PostPosted: Thu Mar 26, 2020 7:27 am 
Offline

Joined: Thu Jan 28, 2010 3:08 am
Posts: 212
Location: Hersham, Surrey, UK
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


Top
 Profile  
 
PostPosted: Thu Mar 26, 2020 7:34 am 
Offline
Site Admin
User avatar

Joined: Wed Jan 27, 2010 6:58 pm
Posts: 4125
Location: Boise, Idaho USA
Quote:
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.

Attachment:
mask.jpg
mask.jpg [ 291.67 KiB | Viewed 1989 times ]

_________________
The eXpress train is coming - and it has more cars.


Top
 Profile  
 
PostPosted: Thu Mar 26, 2020 10:14 am 
Offline
User avatar

Joined: Thu Jan 28, 2010 12:59 am
Posts: 772
Location: Berlin, Germany
You're looking better than ever, my friend.

_________________
Best regards,
Tom

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


Top
 Profile  
 
PostPosted: Thu Mar 26, 2020 12:00 pm 
Offline
Site Admin
User avatar

Joined: Wed Jan 27, 2010 6:58 pm
Posts: 4125
Location: Boise, Idaho USA
Quote:
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.


Top
 Profile  
 
PostPosted: Fri Mar 27, 2020 12:29 am 
Offline
User avatar

Joined: Thu Jan 28, 2010 12:59 am
Posts: 772
Location: Berlin, Germany
Quote:
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."


Top
 Profile  
 
PostPosted: Fri Mar 27, 2020 1:57 am 
Offline

Joined: Thu Jan 28, 2010 1:22 am
Posts: 863
Location: Sijsele, Belgium
Wish all the best to Bobby, and keep it safe.

_________________
Best regards,

Chris.
www.aboservice.be


Top
 Profile  
 
PostPosted: Fri Mar 27, 2020 5:10 am 
Offline

Joined: Thu Jan 28, 2010 3:08 am
Posts: 212
Location: Hersham, Surrey, UK
skiman wrote:
Wish all the best to Bobby, and keep it safe.

Same here!

_________________
Regan Cawkwell
Real Business Applications Ltd
http://www.rbauk.com


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 20 posts ]  Go to page 1, 2  Next

All times are UTC - 7 hours


Who is online

Users browsing this forum: No registered users and 5 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Group