If the str file is corrupt you might just have to use the str from a previous backup or create a new one from a previous ste file. As long as you have not added, modiified or deleted any fields it will just need re-indexing and adjustment of any ::I or ::J auto incrementing fields to the appropriate number to retain uniqueness of indexes using them. All the data will be secure. Again this should all be done on a different computer.
Best Regards, Mark Date: Mon, 11 Oct 2010 17:07:04 -0400 From: [email protected] To: [email protected] Subject: Re: [Dataperf] Error 154 Pat - hey, I've been doing this for goodness knows how long and never found this one either. The nature of my data is that it's static for an election cycle so exporting it isn't really necessary if I have to re-import it. The problem is the size of the data and the time it takes to import. Nor was I able to export even if I wanted to - dp wouldn't let me in under any condition nor would dpexp. I don't know anything about the raw coding so even if I had a Forth editor (which I don't) I wouldn't have been able to look inside and see what went wrong. It's a good thing I have fast computers. It takes just a matter of hours to suck in a million voters and another couple of hours to populate the related panels. Once the data is there it doesn't change except as to update some of the related panels with information about the related records (how many voters at an address, what their voting likelihood is based on past history, etc.). I remember when I'd do my fall update while on vacation towards the end of August and bring an AT machine with me along with a power backup and literally watch data being soaked in for days at a time. By the end of two weeks I would have accomplished about what I'll accomplish at the end of a long evening. I'm more concerned about the possible disk errors that Tim alluded to. I'm being real careful. Thanks. Don 2010/10/11 Patrick Riley <[email protected]> Don, congratulations on breaking new ground. This is an error I've never seen before. Here's the textbook information on an error 154: Error 154 Attempt to read block 0 as text. The file DataPerfect is trying to read is corrupt or not a valid format. Restore from backup. If there is no backup, try deleting the .IND file, exporting all data, deleting panel files and .TXX file, importing data. I think the issue is not the report. Try exporting without using the indexes, deleting everything except the STR file and importing each panel. Good luck. Pat Riley At 09:30 AM 10/11/2010, you wrote: I am in an election cycle and was just modifying a report on a very large voter database and got kicked out with an error code 154. Re-entering the database doesn't work. Removing the index file and attempting to rebuild that doesn't work. Trying to export the .str file so I could delete the report I was working on doesn't work. Every attempt to use the database is stymied by this error code. Does anyone have any ideas on how I could recover this? Don -- Don Friedman ProfessionalRecords.Com LLC PRS Data Systems 205 S Main Street Pittsburgh, PA 15215 412-784-1600 - 1-800-PRS-FILE 412-784-1615 Fax _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf -- Don Friedman ProfessionalRecords.Com LLC PRS Data Systems 205 S Main Street Pittsburgh, PA 15215 412-784-1600 - 1-800-PRS-FILE 412-784-1615 Fax _______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________ Dataperf mailing list [email protected] http://lists.dataperfect.nl/mailman/listinfo/dataperf
