PDA

View Full Version : error XX001 when running a report for the 3rd Feb



freesim
02-04-2010, 10:18 AM
I have the above error popping up when I run a report for the 3rd Feb 2010. I use iPoker (Dafa).

The full message on the HM pop up is

The following error occurred when running this report:ERROR: XX001: invalid page header in block 6506 of relationship "playerhandscashmisc_hero"

I can run reports before and after this date but not any reports that include this data, I am using HM version 1.10.01

can you help pls. Thanks

fozzy71
02-05-2010, 03:12 AM
That is a problem with one of your DB indexes.

You can try to fix that index - http://faq.holdemmanager.com/questions/86/Fix+Indexes

Or you can try a general Reindex from the PGAdmin > Maintenance menu - http://faq.holdemmanager.com/questions/88/Vacuum+Analyze+Database+


If neither of those things help, you will need to create a new DB.

*Try creating a new UTF DB - http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands
*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, export/import the hands from the old DB to the new DB, and export/import any player notes and tourney summaries - and then delete the old DB.
*Make sure you export/backup everything before deleting the old DB