Bde Error 10249
Construction and real estate Wholesale Distribution Manufacturing Product quick access: Sage One Sage 50 Accounting Sage 100 ERP Sage 300 ERP Sage ERP X3 Sage HRMS Sage Impact Sage Life Sage Payments Sage Payroll SageCity Site Search Sage City User Site Search Sage City User SageCity Home Support Business Partners Accountants Students Town Hall Blogs More ... Sage Timeslips Sage Timeslips Forum Home Forums Blog Training Ideation ACA Members More Cancel This group requires membership for participation - click to join Not Answered Lock time out. (10249) Database Error, suggestions? Hi all. I've got some users geting a Lock time out (10249) error Area: Database Code: 4 Class: tBDEDatabaseExceptionC I've searched and read similar posts but I'm not quite sure if our problems/solutions are the same. Can anyone what's causing this, and what can be done to resolve it. Mini TimeSlips 2014 Category: Data and Database Subcategory: Database software lawyer2 3 Dec 2014 5:39 PM Cancel 4 Replies Nancy Duhon 3 Dec 2014 6:12 PM As a general rule, it means that the Borland Database Engine (BDE) that Timeslips runs on is trying to establish a lock on a record in the database, and it does not receive a confirmation of that attempt fast enough (it times out). It is often an indication that something with the network is too slow, but not specific enough about WHAT is the problem. So you can chase this one for a while. Hope this helps. If you think this suggestion was especially helpful, please consider rating it within the five star option, or clicking the green Yes button next to the "Did this answer your question?" option below. Thanks. Nancy Duhon, Esq. Master Certified Consultant for Timeslips,Certified Consultant for Amicus Attorney and Credenza Duhon Technol
Paradox database using a Delphi 5 application in a multi-user environment on a Windows NT server? It appears that it is the Pdoxusrs.net file that is locked and causing the error. I have an application that runs a query against a Paradox table. Then once the query is run the application is minimized and placed in the systray. At that time I close the query. The application stays in the tray and every hour it reruns the query and displays a message if certain criteria are met. It looks like even though the application closes the query the pdoxusrs.net file remains open https://sagecity.na.sage.com/support_communities/sage_timeslips/f/51/t/80891 and according to the open file display it has a lock on it. -- Regards Kevin Campbell TMA Corporation/Bath, ME Team Delphi Developer Sun, 05 Jan 2003 03:00:00 GMT Re:Error 10249 Lock Time Out Does the app update any tables? How many users are acessing the database. Usually a lock timeout occurs if there is a network problem or a lot of users are trying to place or release locks at http://www.delphigroups.info/2/8d/354418.html the same time. Try using DbiSetLockRetry (see the BDE API help file) to see the lock retry period to two seconds or so and see if that helps. -- Bill Todd (TeamB) (Questions received via email cannot be answered.) Brian Bushay Tea Delphi Developer Mon, 06 Jan 2003 03:00:00 GMT Re:Error 10249 Lock Time Out Quote>Can anyone give me some information on what sort of things cause a lock >timeout in a Paradox database Network errors. -- Brian Bushay (TeamB) Bbus...@NMPLS.com Kevin Campbel Delphi Developer Tue, 07 Jan 2003 03:00:00 GMT Re:Error 10249 Lock Time Out I actually have two applications that users run. One is the app I specified. All it does is query one table out of our database to let the user know how may overdue or new tasks they have. It is something like the reminder in Microsoft Money. It just sits in the systray and periodically queries the table to see if there are new tasks. It does not update any tables at all. The other application is the main data entry, reporting, maintenance, lookup application that everyone uses to manage the data. There are about two hundred users of this system with maybe fifty or so active at a time. The funny thing is that this main
another application has the record locked, that would return a $2801 (Record locked by another user.) I am using Paradox files on an NT http://delphigroups.info/2/c6/329590.html Server with a number of Delphi applications accessing the same main file. These http://www.delphifaq.com/faq/delphi/database/f1.shtml applications access different parts of the main file and place an "Edit" lock on the desired record before attempting to post the record. All PCs accessing the files are on the same version of the BDE (5.0.1) with the NetDir set to the same location and Share Local = True. The main application bde error which gets the error has three different PCs all running the application. This application is a Fax Server whichgets the first request for a Fax form a queue and locks that request (puts the record into an "edit" state), then checks if other fax requests exist for the same fax number and receiver(using a different Ttable to ensure that the original request stays locked), formats the requests, bde error 10249 sends them and then rewrites the records to place them in a completed queue. The secondary requests are rewritten first and finally the original request. The application recognizes and handles $2801 (Record locked by another user.) and will not attempt to lock and request which has a fax number being handled by another user. Steve Hardy CenterTech Computer Products Team Delphi Developer Sat, 20 Sep 2003 07:59:04 GMT Re:BDE Error $2809 Try adding DbiSetLockRetry(3); to your main form's OnCreate event handler. The error occurs when one application needs to place or release a lock and the other application has the lock file locked because it is placing or releasing a lock. -- Bill Other Threads 1. BDE error $2809 2. HELP: Suggestions wanted for Lock Timeout (BDE Error $2809) 3. BDE 5.01 error $2809 10249(d) 4. $2808 and $2809 BDE Errors 5. BDE error $251E - An Error occurred while attempting to initialize the BDE 6. BDE Error $210D and BDE Error $2A04, dilemma !!! 7. BDE error Record/Key Deleted BDE-Error:8708 8. Error occured while trying to initialize BDE, Error in modifying BDE 9. Application without BDE, but still BDE error? 10. BDE Error $2104 calling BDE API
message)Physical Data Corruption (BDE error message)I/O Related Error (BDE error message)Object of Interest not FoundCouldn't perform the edit because another user changed the recordWhat to do about $210A error message This article has not been rated yet. After reading, feel free to leave comments and rate it. Some of those errors represent classes of errors - they are linked e.g. error 34. To obtain more information about BDE Errors at runtime, please read Obtaining more information about BDE Errors Additional information about BDE error codes are available in file \DELPHI\DOC\DBIERRS.INT. 0 0000 Successful completion. 33 0021 System Error 34 0022 Object of Interest Not Found 35 0023 Physical Data Corruption 36 0024 I/O Related Error 37 0025 Resource or Limit Error 38 0026 Data Integrity Violation 39 0027 Invalid Request 40 0028 Lock Violation 41 0029 Access/Security Violation 42 002A Invalid Context 43 002B OS Error 44 002C Network Error 45 002D Optional Parameter 46 002E Query Processor 47 002F Version Mismatch 48 0030 Capability Not Supported 49 0031 System Configuration Error 50 0032 Warning 51 0033 Miscellaneous 52 0034 Compatibility Error 62 003E Driver Specific Error 63 003F Internal Symbol 256 0100 KEYVIOL 257 0101 PROBLEMS 258 0102 CHANGED 512 0200 Production Index file missing, corrupt or cannot interpret index key 513 0201 Open Read Only 514 0202 Open the table in read only mode 515 0203 Open and Detach 516 0204 Open the table and detach the Production Index file 517 0205 Fail Open 518 0206 Do not open the table 519 0207 Convert Non-dBase Index 520 0208 Convert production index to dBase format 521 0209 BLOB file not found 522 020A Open without blob file 523 020B Open the table without the blob file 524 020C Empty all blob fields 525 020D Reinitialize BLOB file and LOSE all blobs 526 020E Fail Open 527 020F Do not open the table 528 0210 Import Non-dBASE BLOB file 529 0211 Import BLOB file to dBASE format 530 0212 Open as Non-dBASE table 531 0213 Open Table and BLOB file in its native format 532 0214 Production Index Language driver mismatch 533 0215 Production Index damaged 534 0216 Rebuild Production Index 535 0217 Rebuild all the Production Indexes 1024 0400 Lookup table not found or corrupt 1025 0401 Blob file not found or corrupt 1026 0402 Open Read Only 1027 0403 Open the table in read only mode 1