Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
DBIsam 4.0 reports 'table does not exist' when it clearly does why ? |
Fri, Jan 14 2011 1:13 PM | Permanent Link |
John Taylor | I just spend 45 minutes in a remote session to a user's system trying to
troubleshoot and issue of the db engine throwing an exception 'table does not exist'. The tables clearly do exist. I used dbsys to select the database folder, it listed all of the expected files. 4 of the tables when trying to either 'repair' or browse the data caused dbsys to report 'table does not exist'. The tables and indexes were there as I verified with Windows Explorer. I disabled their anti virus real time scanning of the data folder. Same result when trying to repair or browse data in the tables with dbsys. The only resolution was to delete the tables and then recreate them. Can someone explain to me why the db engine reports 'table does not exist' when it clearly does ? I see this often and am becoming quite exasperated by it. This is dbisam 4.29 build 4 not database server, local session John Taylor |
Mon, Jan 17 2011 4:27 AM | Permanent Link |
Chris Holland SEC Solutions Ltd. Team Elevate | Hi John,
I suspect that the .blb file is missing for the specified table. Chris Holland [Team Elevate] On 14/01/2011 18:13, John Taylor wrote: > I just spend 45 minutes in a remote session to a user's system trying to > troubleshoot and issue of the db engine throwing an > exception 'table does not exist'. The tables clearly do exist. I used > dbsys to select the database folder, it listed all of the expected > files. 4 of the tables when trying to either 'repair' or browse the data > caused dbsys to report 'table does not exist'. The tables and > indexes were there as I verified with Windows Explorer. > > I disabled their anti virus real time scanning of the data folder. Same > result when trying to repair or browse data in the tables > with dbsys. The only resolution was to delete the tables and then > recreate them. > > Can someone explain to me why the db engine reports 'table does not > exist' when it clearly does ? I see this often and am > becoming quite exasperated by it. > > This is dbisam 4.29 build 4 not database server, local session > > John Taylor -- Chris Holland [Team Elevate] |
Mon, Jan 17 2011 1:00 PM | Permanent Link |
John Taylor | Thanks for you reply, Chris
I don't recall checking for that specifically in Windows Explorer but my memory isn't what it used to be John "Chris Holland" <mail@chrisholland.me.uk> wrote in message news:961073CA-9701-454E-8A6C-050130120A3B@news.elevatesoft.com... > Hi John, > > I suspect that the .blb file is missing for the specified table. > > Chris Holland > [Team Elevate] > > > On 14/01/2011 18:13, John Taylor wrote: >> I just spend 45 minutes in a remote session to a user's system trying to >> troubleshoot and issue of the db engine throwing an >> exception 'table does not exist'. The tables clearly do exist. I used >> dbsys to select the database folder, it listed all of the expected >> files. 4 of the tables when trying to either 'repair' or browse the data >> caused dbsys to report 'table does not exist'. The tables and >> indexes were there as I verified with Windows Explorer. >> >> I disabled their anti virus real time scanning of the data folder. Same >> result when trying to repair or browse data in the tables >> with dbsys. The only resolution was to delete the tables and then >> recreate them. >> >> Can someone explain to me why the db engine reports 'table does not >> exist' when it clearly does ? I see this often and am >> becoming quite exasperated by it. >> >> This is dbisam 4.29 build 4 not database server, local session >> >> John Taylor > > -- > Chris Holland > [Team Elevate] |
Wed, Jan 19 2011 6:44 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | John,
<< I just spend 45 minutes in a remote session to a user's system trying to troubleshoot and issue of the db engine throwing an exception 'table does not exist'. The tables clearly do exist. >> As Chris indicated, this can also occur if the .blb file is missing, which I suspect it is. -- 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 |