View Full Version : hands not appearing under reports

11-20-2009, 10:22 AM
when I go to cash games -> reports I can't get any hands to appear at the bottom, clicking on last 100 / last 500 / all seems to do nothing. this is also the same when I go on the cash games -> hands tab

11-20-2009, 11:57 AM
Some of the other tabs function properly though? This is often a sign of a corrupt DB.

Which Operating System, Firewall, and Anti-Virus are you using?

Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe

Under Vista and Windows 7 make sure UAC is disabled http://www.holdemmanager.net/faq/afmmain.aspx?faqid=73 or else you must set \holdem manager\dbcontrolpanel.exe, holdemmanager.exe and hmhud.exe are started as administrator. Run the windows explorer and navigate to your Holdemmanager installation directory. Right click the executables and select "Run as admin" from the compatibility tab. Windows 7 you MUST set all the executables to always run as admin.

Add exceptions to the windows firewall, even if it is off. If you have a 3rd party firewall, do the equivalent or uninstall it temporarily - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=171

*Try creating a new UTF DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173
*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. - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=21

Make sure you export/backup everything before deleting the old DB - http://www.holdemmanager.net/forum/showthread.php?t=20754

11-23-2009, 05:46 PM
sorry, i have been away for the last few days -updating the to the latest beta seems to have fixed it. Just so you know, the problem occurred after I manually vacuum analyzed the database. All hand reports were appearing, all graphs etc, just the lists where it actually displays each hand individually was missing.

11-24-2009, 12:00 PM
this problem is not fixed after all, seems to be totally random if hands will load or not. I have been trying to go over my hands from todays session and all I get is this:


I'm using windows Vista with the latest version of HM, I've done all the UAC stuff. Have you any other suggestions because I would rather not transfer my database to a new one as it has around four million hands.

11-24-2009, 01:19 PM
You could try a reindex via pgadmin ->maintenance but if that doesn't fix it its time for a new database.

12-06-2009, 01:55 PM
how can I get my hands into a new database? I have had to avoid this for the last few days because I need to play every day to hit a milestone, and moving the amount of hands that I need to will waste a day. The HMArchive folder doesn't only contains 400 hands...

12-06-2009, 02:47 PM
Then you need to export and import them:

12-06-2009, 06:50 PM