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
