PDA

View Full Version : Corrupted import file



abear
06-16-2010, 02:16 AM
Hello!

While playing and running autoimport today the electric cut and my pc went down. When I tried to restart HM i get the following message: "Error initializing importer: The file or directory is corrupted and unreadable. Params: C\Program Files\RVG Software\Holdem Manager\HMImport.exe/POM". Needless to say I cant import any files to me DB.
I have tried to reinstall HM,but the problem persists. Do anyone have suggestions how to repair the corrupted file?

netsrak
06-16-2010, 03:32 AM
Please rename your config folder.
Download and install the latest update.
Start HM and test it.
After everything is running fine you can copy back your original config folder with your settings.


If that doesn't work please try a complete uninstall using revo uninstaller: FAQ - Hold'em Manager Poker Tracking Software :: Using Revo Uninstaller (http://faq.holdemmanager.com/questions/126/Using+Revo+Uninstaller+)

abear
06-16-2010, 09:32 AM
Please rename your config folder.
Download and install the latest update.
Start HM and test it.

I did this and thereafter I could import the files. However all hands are reported as errors.


If that doesn't work please try a complete uninstall using revo uninstaller: FAQ - Hold'em Manager Poker Tracking Software :: Using Revo Uninstaller (http://faq.holdemmanager.com/questions/126/Using+Revo+Uninstaller+)

As the first option didnt work, I tried this one as well. I get the same result as from the first option, the files are imported but all are registered as errors.

I have tried to search the FAQ and forum for an answer, but cant find anything helpful. Any suggestions on what to do?:confused:

morny
06-16-2010, 08:14 PM
This sounds like a problem with your database. Please follow the instructions to backup and export your database details where applicable:

Please export your hands from the old database
Export and Import your Hand Histories FAQ
FAQ - Hold'em Manager Poker Tracking Software :: How to Import & Export Hands (http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands)

Export Your Notes
http://faq.holdemmanager.com/images/notes-02.jpg

Export Your Bonuses and Rakeback - Options > Rakeback & Bonuses http://faq.holdemmanager.com/images/rakeback-bonuses-01.jpg

Export any tourney summaries by selecting all your tournaments in the Data View Sub-Tab of the Tourney > Results Menu and choose Export Tourney Results and summaries

Once you do this create a new database FAQ - Hold'em Manager Poker Tracking Software :: Create / Delete Database (http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database) and import all the exported data into the new database

The 2 most common causes of this problems are 1) powering off your computer or having your computer lose power while the database is doing something and 2) an old drive with bad sectors on it. Basically what happens is a small portion of a file gets slightly corrupt and then when you reboot and windows goes into that checkdsk procedure it finds the bad section and, thinking it is doing a good thing, removes it. Postgres then loads the table and a portion of it is gone so it doesn’t like that and blocks access to the entire table. Normally when this happens it is on a completely useless file that you'll never even notice is now gone and quite often it will happen to an index in the DB which can easily be rebuilt but in your case it happened to one or more of the tables.

So, to protect against this

1) keep you hands histories in case you do need to reimport
2) use a power bar and avoid hard shutdowns (when you flick the power switch on the pc)
3) if your drive is old consider replacing it with a new one. They are cheap and much faster now than even a few years ago.

FWIW ive been using HM for probably 2 years, as part of internal testing we try out internal betas which would have more bugs than the versions we release, i regularly import hands people send that they cant get to import, i datamine 24 hours on a networked PC and i play poker regularly using HM and ive only gotten 1 corruption when my PC lost power during an import so it is extremely stable so if your having issues its most likely something on your PC

abear
06-16-2010, 10:56 PM
Hello and thank you for your reply, the problem is now fixed.

I suspect, as you say, that the problem is because of my PC as I am using a 5 year old laptop atm.