Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 6 of 6 total |
Duplicate key |
Mon, Feb 27 2006 2:54 AM | Permanent Link |
"Godfrey" | Dbisam V4.22 B5
Hi All I am picking up a duplicate key error on a table with a autoinc primary key (Unique). There are not other unique indexes on the table. It happens once in a while and the only way to get rid of it is to switch off the machine and do a repair on the table. If I view the table in DBSys there appears to nothing wrong with it. I am using a local database with up to approx 5 users, also using transactions when editing and posting. Problem seems to occur when system is busy. Any suggestions |
Mon, Feb 27 2006 7:10 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Godfrey,
<< I am picking up a duplicate key error on a table with a autoinc primary key (Unique). There are not other unique indexes on the table. It happens once in a while and the only way to get rid of it is to switch off the machine and do a repair on the table. If I view the table in DBSys there appears to nothing wrong with it. >> What does the repair say is wrong with the table ? Is there any chance that someone is shutting off their machine improperly after working with your application ? << I am using a local database with up to approx 5 users, also using transactions when editing and posting.>> This is peer-to-peer, correct ? -- Tim Young Elevate Software www.elevatesoft.com |
Mon, Feb 27 2006 7:32 AM | Permanent Link |
"Godfrey" | Hi Tim
What does the repair say is wrong with the table ? Unfortunately it seems to happen at the most unopportune moment like late on a Saturday. I was not onsite at the time. It is a pos system and I had to get it up and running asap. Did not manage to get any details. Is there any chance that someone is shutting off their machine improperly after working with your application ? There is unfortunately a chance of this happening with my clients. The system however should only be shutdown at the end of the evening. > This is peer-to-peer, correct ? Yes Thanks Godfrey |
Tue, Feb 28 2006 8:46 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Godfrey,
<< There is unfortunately a chance of this happening with my clients. The system however should only be shutdown at the end of the evening. >> You could log the application startups to a table (call FlushBuffers after the insert to preserve it in case of a crash) or text file and use that to analyse this. It will at least help you determine what is going on. -- Tim Young Elevate Software www.elevatesoft.com |
Thu, Mar 2 2006 1:05 AM | Permanent Link |
"Godfrey" | Hi Tim
I am using ForceFlushBuffers for the entire app. I notice recentlyyou have been advising to rather use FlushBuffers after each post. Does this make a big difference? Thanks Godfrey "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message news:3F4A960D-9296-4026-B545-A7F9F73A8340@news.elevatesoft.com... > Godfrey, > > << There is unfortunately a chance of this happening with my clients. The > system however should only be shutdown at the end of the evening. >> > > You could log the application startups to a table (call FlushBuffers after > the insert to preserve it in case of a crash) or text file and use that to > analyse this. It will at least help you determine what is going on. > > -- > Tim Young > Elevate Software > www.elevatesoft.com > > |
Thu, Mar 2 2006 9:39 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Godfrey,
<< I am using ForceFlushBuffers for the entire app. I notice recentlyyou have been advising to rather use FlushBuffers after each post. Does this make a big difference? >> It can in some cases, but if you haven't noticed a difference then I wouldn't change a thing if I were you. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Thursday, March 28, 2024 at 06:05 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |