Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
:Error writing to file: on large file.
Message
From
22/10/1998 10:50:29
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
:Error writing to file: on large file.
Miscellaneous
Thread ID:
00149416
Message ID:
00149416
Views:
64
I have a vfp table with about 37000 records in it. The table also has 166 fields in it. The table is about 120 megabytes in size. The table is used to store historical records from posted transactions. A user will enter records into a temporary table called temp1.dbf. The user is accessing both files over a network. The 120 megabyte table is called history.dbf. The user then runs a transaction on the temp1.dbf table and the history.dbf table. The transaction copies the records from the temp1.dbf 1 record at a time to the history.dbf table. After each record is copied from the temp1.dbf table to the hisory.dbf table, it is deleted from the temp1.dbf table. This system has worked for about 4 months now. However, yesterday vfp reported the following error to the user during the transaction: :Error writing to file.: The transaction was aborted and the user attempted to run the transaction again. VFP reported that the tranaction succeeded. However, the history.dbf table failed to update. I restored a previous days backup to the file and rebuilt all of the indexes on it. The user then reentered the recoreds into the temp1.dbf table and then performed the transaction again on the temp1.dbf and history.dbf tables. The transaction succeeded and the files were successfully copied to the history.dbf file. I thought the problem was caused by a table corruption and figured the problem was solved by restoring the backup and rebuilding the indexes. However, 1 day later, after many successfull transactions on the temp1 table and the history table, the error message again occured during a transaction :Error writing to file.: Has anyone ever seen this happen? Any suggestions?
Next
Reply
Map
View

Click here to load this message in the networking platform