error when running reports

[doudou86]

hi,

i downloaded HEM 1.11.03 pre release version and all worked properly.
But today, when i run reports in cash game, i have the following message :
the following error occured when running this report : ERROR : XX001 : invalid page header in block 1490 of relation "pokerhands_hero"
Then i tried with "real" 1.11.03 version but the same problem occurs.
What can i do?

Regards

[_Loki_]

###
It has nothing to do with the update
You have a slightly corrupt DB

you can do this:
>> FAQ - Hold'em Manager Poker Tracking Software :: Fix Indexes (http://faq.holdemmanager.com/questions/86/Fix+Indexes)

Or even better in pgAdminIII do a vacuum/analyse full followed by reindex of your whole DB

###

[doudou86]

hi,
thank you for your help loki
i tried both methods and i still have the same problem :(

[_Loki_]

###
1] Create a new UTF8 DB:
>> FAQ - Hold'em Manager Poker Tracking Software :: Database Management (http://faq.holdemmanager.com/questions/190/Database+Management)
>> FAQ - Hold'em Manager Poker Tracking Software :: Create / Delete Database (http://faq.holdemmanager.com/questions/75/Create+%7B47%7D+Delete+Database)

2] Import a small sample of hands from your "C:\HMArchive" - a single session is enough:
>> FAQ - Hold'em Manager Poker Tracking Software :: How to Import & Export Hands (http://faq.holdemmanager.com/questions/98/How+to+Import+%26+Export+Hands)

3] Set your Hero Name:
>> FAQ - Hold'em Manager Poker Tracking Software :: Player Name & Alias (http://faq.holdemmanager.com/questions/33/Player+Name+%26+Alias+)

4] Close/Open HM - this lets the DB initialise to your Hero Name properly

5] Test if you can now run reports in the test DB

###

[doudou86]

hi,
i did what you said with a testDB and it works...
so what now? :)

[_Loki_]

###
Good news - I think you could back up your DB & restore it, but I don't know if that is wise with a damaged DB...

###
So I suggest you use your new DB or create a further new one

Import your Hand Histories
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://1.2.3.10/bmi/faq.holdemmanager.com/images/notes-02.jpg

Export Your Bonuses and Rakeback - Options > Rakeback & Bonuses http://1.2.3.13/bmi/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

http://1.2.3.13/bmi/faq.holdemmanager.com/images/tourney-data-view-01.jpg

###
After that I would do...
Vacuum/Analyse full
Reindex
close all progs (inc antivirus etc) & stop postgreSQL service & defrag
reboot
this will make your DB faster & reduce the size by > 5%

###
Try & vacuum every 30k hands in future - this should reduce greatly the risk of DB corruption
###