Open Side Menu Go to the Top
Register
Holdem Manager Support Holdem Manager Support

06-26-2019 , 08:49 PM
Does lots of hands in HM2 database occupy lots of space in computer memory ?

I got 1,6 million hands in my HM2 database and I suspect this is the reason my computer is slow.

How can I delete part of this hands ? Is there a way to delete all hands from 2017 or 2018 ?
Holdem Manager Support Quote
06-26-2019 , 10:10 PM
Quote:
Originally Posted by urubu222
Does lots of hands in HM2 database occupy lots of space in computer memory ?

I got 1,6 million hands in my HM2 database and I suspect this is the reason my computer is slow.

How can I delete part of this hands ? Is there a way to delete all hands from 2017 or 2018 ?
You can purge hands in the Database Manager. Or you can just create a new database and import only the hands from 2019 (and delete* the old DB if you don't need it to free up space).

Are you using an SSD? There are some SSD specific tips below along with other general info, and links to more info, in regards to database total size and maintaining plenty of free space so you can perform database maintenance. If you ever run out of free space while playing or bulk importing (or have an unexpected PC shutdown) your database is almost certainly going to be damaged and possibly corrupted beyond repair.


Quote:
You can use NTFS compression on the DB folder in roaming and the postgres\data\base folder to make it smaller - http://support.microsoft.com/kb/251186

You can put your postgres data folder and the HM2 database parent folder on a different drive but if you move it from a SSD to a HDD you will suffer a decrease in performance - http://hm2faq.holdemmanager.com/ques...e+or+Partition

In HM1 there are a lot of tables that deal with a specific hand played by a specific player. In HM2 we don't have these tables, instead, for player related hand data, we use a flat file approach. Each player has his own folder and each file represents a single day. Each line within the file is a tokenized version of a single hand with incredible amounts of detail. Your overall HM2 spaced used (DB + Files) is about 2/3 of HM1 and we store probably 2-3 times as much info plus it can be accessed many, many times faster and allows us to do some things that wouldn't be possible otherwise. If you don't want the space in your Roaming folder due to limited C: file space, we do give you the option of storing this data anywhere when creating the database.

General rule is 1 million hands = 10 GB.

In reality it's: 1 million hands
HM1: 6.8 GB
HM2: 4.3 GB
PT4: 13.6 GB
HM3:* 6.0*GB

So with a 10 million hand database you need a SSD of at least 60 GB (Windows) + 100 GB = 160 GB. We use 1 million = 10 GB (instead of 6.8) because when you want to perform a vacuum/analyse or backup/restore a database it will require a LOT of disk space to perform such a task.

We recommend you maintain more than 20% free space on your system drive. Please see this FAQ to clear up some more free space - http://hm2faq.holdemmanager.com/ques...+of+Disk+Space

Please see these guide to optimize your SSD:

http://www.tomshardware.com/reviews/...weak,2911.html

http://itexpertvoice.com/home/super-...at-them-right/
*If you want to backup/save that current database (and create a new 2019+ DB) and are able to free up 20%+ free space you can back that up before you delete it

*Hopefully you are also aware that all auto import hands get archived to C:\HM2Archive by default. I configured HM2 to archive mine to my google drive cloud subscription personally. You can archive hands to a cloud service you just can not create HM2/3 databases in a sub-folder of your local cloud hosting folder as the constant up/down syncing while you import will also corrupt a database.

Fozzy71
Customer Support
Holdem Manager Support Quote
06-27-2019 , 09:31 PM
Hi,
Since the ACR reboot I have had problems with HM2, I have tried to fix them but with no success. Such as I have downloaded latest update. Checked the folders the hands are going in. Checked Site setup. Hand importing.

I have duplicate hands showing both cash and tournament.
Some tournaments have disappeared.
For tournaments, the dates of the tournaments don't correspond with the dates of the hands displayed.
I have to edit the tournaments details because it just shows zeros. Such as Buy In, number of players etc.
And my HUD isn't working now however a 'HUD default 2.0' is displayed in the top right of each table.

Thanks
Holdem Manager Support Quote
06-28-2019 , 07:32 AM
Quote:
Originally Posted by Madsaac
Hi,
Since the ACR reboot I have had problems with HM2, I have tried to fix them but with no success. Such as I have downloaded latest update. Checked the folders the hands are going in. Checked Site setup. Hand importing.

I have duplicate hands showing both cash and tournament.
Some tournaments have disappeared.
For tournaments, the dates of the tournaments don't correspond with the dates of the hands displayed.
I have to edit the tournaments details because it just shows zeros. Such as Buy In, number of players etc.
And my HUD isn't working now however a 'HUD default 2.0' is displayed in the top right of each table.

Thanks

a) Duplicate hands indicates a corrupt database:

i) Please try to vacuum/analyze and reindex your database.

ii) If you continue to have problems, try the following:

Try creating a new DataBase and import a small portion of your \HM2Archive so you can see if the problem exists in the new DB.

If the new database seems to work properly, it sounds like your database might be corrupt. Please continue to use the new database and import the rest of your hands using the steps above. This is why regular backups are a good idea. If your database becomes corrupt you can restore a backup and only have to import the most recent hands (that were played after the backup was created) and edit any tournament results if necessary. I recommend keeping at least the most recent 2 or 3 backups in case the most recent one does not restore properly you can try the previous backup.

Here is a FAQ explaining how to backup your database and all settings in one easy step.

iii) If none of that helps please zip and email the problem hand histories, with a link to this thread and your forum name, to us using the 'Contact Support' link.

Make sure you also include screenshots of your reports and a detailed description by tournament number, session, hole cards, stat, etc. of some of the errors we need to test.



b) The new WPN v2 software in HM2 needs to be (re)configured like it is the first time you have ever played at this site/network.

Make sure your site is configured to save hands and that HM2 is setup to auto import those hands.

*Note that we do not support play money hands so you must test/play real money hands when using HM2.

Make sure the poker client and hand histories are both in English. If it is not, you need to change it in the Lobby Options or reinstall the software and choose English.

Make sure that the Site Time Adjustment is properly configured such that the Time Stamp in the Reports for the hand matches your local windows clock time.

Please see this FAQ on how to use table finder if you are playing regular non-zoom type tables.

If you continue to have problems:

Please follow the instructions in this FAQ and reply back with the answers to the 12 questions in that FAQ. Those answers should help us quickly identify your issue, skipping questions will just mean we have to ask again in the next email and will delay the resolution of the issue.

Please enable the Settings > Feature Logging > [x] 'HUDStats' and 'FastPoker' option and increase the Max number of log files option to 10 so old logs are saved with date/time stamps. You can also enable this before you launch HM2 from the Start Menu.

Please reproduce the problem and:
- Attach a screenshot of the table/desktop
- Try to include the Active Sessions tab and/or Sessions Report that also includes your windows clock and poker client lobby clock in the screen shot
- Save a copy of the original Hand history for the table with the issue
- Close HM2 and attach your HM2Logs folder with a detailed description of what you were doing and what problems you were experiencing.

With all the above information we should be able to narrow down what is causing the issue. If all the information is not included we will need to email you again to request it.

Please zip and email the requested files via the 'Contact Support' link and if there is a forum thread with additional information please link to this thread and let us know your forum name if there are several people in the thread.

Fozzy71
Customer Support
Holdem Manager Support Quote
06-28-2019 , 12:57 PM
Hi,
Are you working on WPN update to HUD on blitz tables?
Holdem Manager Support Quote
06-28-2019 , 03:02 PM
Quote:
Originally Posted by Childintime
Hi,
Are you working on WPN update to HUD on blitz tables?
No, not yet. We were having login and table sit issues after their first major update so we could not test it. You are the first customer to ask about it so far that I am aware of. I don't have enough funds there to sit/test that table.

Are the hands importing?

Please follow the instructions in this FAQ and reply back with the answers to the 12 questions in that FAQ. Those answers should help us quickly identify your issue, skipping questions will just mean we have to ask again in the next email and will delay the resolution of the issue.

Please enable the Settings > Feature Logging > [x] 'HUDStats' and 'FastPoker' option and increase the Max number of log files option to 10 so old logs are saved with date/time stamps. You can also enable this before you launch HM2 from the Start Menu.

Please reproduce the problem and:
- Attach a screenshot of the table/desktop
- Try to include the Active Sessions tab and/or Sessions Report that also includes your windows clock and poker client lobby clock in the screen shot
- Attach a copy of the original Hand history for the table with the issue*
- Close HM2 and send your HM2Logs folder with a detailed description of what you were doing and what problems you were experiencing.

* All original hands that are auto-imported get moved to an archive for performance reasons. Your \HM2Archive is in C:\HM2Archive by default, but you may have put it anywhere. The archive should be organized by \Month\DayOfMonth (example: D:\HM2Archive\2009\07\31) or if it was auto-imported with 7283+ it would be in \HM2Archive\SiteName\YYYY\MM\DD.* It is configured in the Site Setup - Auto Import Folders menu.

With all the above information we should be able to narrow down what is causing the issue. If all the information is not included we will need to email you again to request it.

Fozzy71
Customer Support
Holdem Manager Support Quote
06-28-2019 , 07:11 PM
My HM2 wont open all of a sudden for some reason. When I click it launches and load but it won't pop up. It's stuck at alt tab and every time I click nothing happens. I didn't do anything. It just happened all of a sudden mid session. Restarted my computer and it still tuck in minimized mode for some reason.

Help please.

EDIT: I disabled my 2nd monitor and it popped up.

Last edited by SGR; 06-28-2019 at 07:18 PM.
Holdem Manager Support Quote
06-28-2019 , 08:34 PM
Quote:
Originally Posted by Holdem Manager
No, not yet. We were having login and table sit issues after their first major update so we could not test it. You are the first customer to ask about it so far that I am aware of. I don't have enough funds there to sit/test that table.

Are the hands importing?

Please follow the instructions in this FAQ and reply back with the answers to the 12 questions in that FAQ. Those answers should help us quickly identify your issue, skipping questions will just mean we have to ask again in the next email and will delay the resolution of the issue.

Please enable the Settings > Feature Logging > [x] 'HUDStats' and 'FastPoker' option and increase the Max number of log files option to 10 so old logs are saved with date/time stamps. You can also enable this before you launch HM2 from the Start Menu.

Please reproduce the problem and:
- Attach a screenshot of the table/desktop
- Try to include the Active Sessions tab and/or Sessions Report that also includes your windows clock and poker client lobby clock in the screen shot
- Attach a copy of the original Hand history for the table with the issue*
- Close HM2 and send your HM2Logs folder with a detailed description of what you were doing and what problems you were experiencing.

* All original hands that are auto-imported get moved to an archive for performance reasons. Your \HM2Archive is in C:\HM2Archive by default, but you may have put it anywhere. The archive should be organized by \Month\DayOfMonth (example: D:\HM2Archive\2009\07\31) or if it was auto-imported with 7283+ it would be in \HM2Archive\SiteName\YYYY\MM\DD.* It is configured in the Site Setup - Auto Import Folders menu.

With all the above information we should be able to narrow down what is causing the issue. If all the information is not included we will need to email you again to request it.

Fozzy71
Customer Support
OK! Thank you!
I did all steps and waiting now!
Holdem Manager Support Quote
06-29-2019 , 12:43 AM
Quote:
Originally Posted by Holdem Manager
a) Duplicate hands indicates a corrupt database:

i) Please try to vacuum/analyze and reindex your database.

ii) If you continue to have problems, try the following:

Try creating a new DataBase and import a small portion of your \HM2Archive so you can see if the problem exists in the new DB.

If the new database seems to work properly, it sounds like your database might be corrupt. Please continue to use the new database and import the rest of your hands using the steps above. This is why regular backups are a good idea. If your database becomes corrupt you can restore a backup and only have to import the most recent hands (that were played after the backup was created) and edit any tournament results if necessary. I recommend keeping at least the most recent 2 or 3 backups in case the most recent one does not restore properly you can try the previous backup.

Here is a FAQ explaining how to backup your database and all settings in one easy step.

iii) If none of that helps please zip and email the problem hand histories, with a link to this thread and your forum name, to us using the 'Contact Support' link.

Make sure you also include screenshots of your reports and a detailed description by tournament number, session, hole cards, stat, etc. of some of the errors we need to test.



b) The new WPN v2 software in HM2 needs to be (re)configured like it is the first time you have ever played at this site/network.

Make sure your site is configured to save hands and that HM2 is setup to auto import those hands.

*Note that we do not support play money hands so you must test/play real money hands when using HM2.

Make sure the poker client and hand histories are both in English. If it is not, you need to change it in the Lobby Options or reinstall the software and choose English.

Make sure that the Site Time Adjustment is properly configured such that the Time Stamp in the Reports for the hand matches your local windows clock time.

Please see this FAQ on how to use table finder if you are playing regular non-zoom type tables.

If you continue to have problems:

Please follow the instructions in this FAQ and reply back with the answers to the 12 questions in that FAQ. Those answers should help us quickly identify your issue, skipping questions will just mean we have to ask again in the next email and will delay the resolution of the issue.

Please enable the Settings > Feature Logging > [x] 'HUDStats' and 'FastPoker' option and increase the Max number of log files option to 10 so old logs are saved with date/time stamps. You can also enable this before you launch HM2 from the Start Menu.

Please reproduce the problem and:
- Attach a screenshot of the table/desktop
- Try to include the Active Sessions tab and/or Sessions Report that also includes your windows clock and poker client lobby clock in the screen shot
- Save a copy of the original Hand history for the table with the issue
- Close HM2 and attach your HM2Logs folder with a detailed description of what you were doing and what problems you were experiencing.

With all the above information we should be able to narrow down what is causing the issue. If all the information is not included we will need to email you again to request it.

Please zip and email the requested files via the 'Contact Support' link and if there is a forum thread with additional information please link to this thread and let us know your forum name if there are several people in the thread.

Fozzy71
Customer Support
Thanks, I'll have a go
Holdem Manager Support Quote
06-29-2019 , 08:04 AM
Quote:
Originally Posted by SGR
My HM2 wont open all of a sudden for some reason. When I click it launches and load but it won't pop up. It's stuck at alt tab and every time I click nothing happens. I didn't do anything. It just happened all of a sudden mid session. Restarted my computer and it still tuck in minimized mode for some reason.

Help please.

EDIT: I disabled my 2nd monitor and it popped up.
This can happen if you change your display settings, add remove monitors, have a graphics card/driver update, etc.

Please follow this FAQ to fix the problem with windows moving off screen:
http://www.howtogeek.com/howto/windo...eyboard-trick/

If you have any problems with those steps you can also reset the position manually:

If you want to reset the HM2 to default size/position:

- Close HM2
- Open your holdemmanager.config file from C:\Users\YourName\AppData\Roaming\HoldemManager in a text editor.
- If your Windows is hiding known file extensions the file will simply be called 'holdemmanager'.
- If you can't see it, turn off the windows option that is hiding that directory. http://faq.holdemmanager.com/questio...es+in+Windows+
- Look for the 'WindowStates' section and delete this line, which should not have any name between the first two quotation marks, in that section:

Code:
<Key Name="" Value="0|30|400|720|Normal" />
- Save/close the file and restart HM2.



Fozzy71
Customer Support
Holdem Manager Support Quote
06-29-2019 , 07:55 PM
So I am still having complete failure of the HM2 hud on ACR. Took a few weeks off as I could never solve my issue of the hud simply not appearing and hands not importing. Completely uninstalled and reinstalled ACR, HM2, and PostgreSQL. Started with a fresh db. Site setup looks fine, pointing to correct folder. Hands are being written to the folder. HM2 simply won't import them or fire up the HUD. I have tried automatic and manual import. Table finder doesn't even detect open tables.

I don't have time right now to go through the lengthy support ticket preparation requested. Can support think of any basic reason the tables aren't detected and the hand history files aren't imported?
Holdem Manager Support Quote
06-30-2019 , 06:21 AM
Is there a manual/forum/link/etc... where I can read the meaning of stat definitions? Can't seem to find it anywhere.
Holdem Manager Support Quote
06-30-2019 , 07:41 AM
Quote:
Originally Posted by Theo_Brixton
So I am still having complete failure of the HM2 hud on ACR. Took a few weeks off as I could never solve my issue of the hud simply not appearing and hands not importing. Completely uninstalled and reinstalled ACR, HM2, and PostgreSQL. Started with a fresh db. Site setup looks fine, pointing to correct folder. Hands are being written to the folder. HM2 simply won't import them or fire up the HUD. I have tried automatic and manual import. Table finder doesn't even detect open tables.

I don't have time right now to go through the lengthy support ticket preparation requested. Can support think of any basic reason the tables aren't detected and the hand history files aren't imported?
The new WPN v2 software has to be (re)configured like it is the first time you ever played on that software/site. You need to check/configure the auto import folder in the client and hm2, preferred seating in both, site time adjustment in HM2, etc.

The most common causes of HUD problems I have seen is incorrect site time adjustment and/or not properly configured auto import folders.

Make sure your site is configured to save hands and that HM2 is setup to auto import those hands.

*Note that we do not support play money hands so you must test/play real money hands when using HM2.

Make sure the poker client and hand histories are both in English. If it is not, you need to change it in the Lobby Options or reinstall the software and choose English.

Make sure that the Site Time Adjustment is properly configured such that the Time Stamp in the Reports for the hand matches your local windows clock time.

Please see this FAQ on how to use table finder if you are playing regular non-zoom type tables.

If you continue to have problems:

Please follow the instructions in this FAQ and reply back with the answers to the 12 questions in that FAQ. Those answers should help us quickly identify your issue, skipping questions will just mean we have to ask again in the next email and will delay the resolution of the issue.

Please enable the Settings > Feature Logging > [x] 'HUDStats' and 'FastPoker' option and increase the Max number of log files option to 10 so old logs are saved with date/time stamps. You can also enable this before you launch HM2 from the Start Menu.

Please reproduce the problem and:
- Attach a screenshot of the table/desktop
- Try to include the Active Sessions tab and/or Sessions Report that also includes your windows clock and poker client lobby clock in the screen shot
- Save a copy of the original Hand history for the table with the issue
- Close HM2 and attach your HM2Logs folder with a detailed description of what you were doing and what problems you were experiencing.

With all the above information we should be able to narrow down what is causing the issue. If all the information is not included we will need to email you again to request it.

Please zip and email the requested files via the 'Contact Support' link and if there is a forum thread with additional information please link to this thread and let us know your forum name if there are several people in the thread.

Fozzy71
Customer Support
Holdem Manager Support Quote
06-30-2019 , 07:43 AM
Quote:
Originally Posted by SGR
Is there a manual/forum/link/etc... where I can read the meaning of stat definitions? Can't seem to find it anywhere.
For HM2 all of the default popup stats are defined here - https://hm2faq.holdemmanager.com/que...t+Descriptions

If you have questions about others you will have to use the software feedback to send us a support ticket with stat questions about definitions, or you could check for the stat in HM3 as the HUD/Report stat pickers in HM3 have definitions displayed, as do the HM3 report column headers, HUDs/Popups, etc.

HM3 Pre-Release beta is now available. *Click here to register your HM3 beta now - http://www.holdemmanager.com/hm3/beta.php

- After downloading, you should right-click the file, go to properties and click unblock.*
* If you do not see an 'unblock' option you can ignore this step.
- Then, right click the file and click 'Install'.

Here are some first time install instructions - https://support.holdemmanager.com/su...tion-and-Setup

If you have any problems with HM3:

Please reproduce the problem and click the 'Send Feedback' button from the left sidebar menu (or from the 'Help' menu at the top), or choose 'Yes' if prompted to submit an error report, and send your logs and config files with a detailed step by step description of the problem that we can use to try and reproduce the problem.

If you are unable to send the logs via the automated system for any reason you can collect and send the logs manually - https://support.holdemmanager.com/su...les-to-support

Fozzy71
Customer Support
Holdem Manager Support Quote
06-30-2019 , 01:52 PM
Just open my HEM2 after 2 years break. Following error message went up
"No activation left for this license code".

What to do?
Holdem Manager Support Quote
06-30-2019 , 03:07 PM
Quote:
Originally Posted by Fisken_
Just open my HEM2 after 2 years break. Following error message went up
"No activation left for this license code".

What to do?
Your HM2 license is valid on two computers that you own. If you receive the message "there are no more activations available", you can reset your code. For the steps to reset your Holdem Manager code please see this FAQ.

If you continue to have problems, please reproduce the problem and send your HM2Logs folder with a detailed description of what you were doing and what problems you were experiencing.

Fozzy71
Customer Support
Holdem Manager Support Quote
06-30-2019 , 07:47 PM
Hi again, I switched to HM3 beta and it is reading ACR hands and the HUD works. Question: is Blitz support on ACR in the works for HM3? Thanks!
Holdem Manager Support Quote
06-30-2019 , 09:13 PM
Quote:
Originally Posted by Theo_Brixton
Hi again, I switched to HM3 beta and it is reading ACR hands and the HUD works. Question: is Blitz support on ACR in the works for HM3? Thanks!

We do not support a HUD on WPN Blitz tables or have plans to add HUD support at this time. If the HUD is showing it will be updating after the fast-folded hands finally are written and imported. I would suggest manually disabling the HUD on these tables via the Active Session / Live Play view Table History section, or by clicking the 'Stop HUD' button, until we can make HM2/3 automatically hide the HUD on these tables.



Fozzy71
Customer Support
Holdem Manager Support Quote
07-01-2019 , 10:07 AM
Just received this message from Norton. I'm using HEM3 and got this message after starting up my computer today. What is this? Why is Norton quarantining it?

https://i.imgur.com/LT10kyJ.jpg



Just realized image is blocked - It says HoldemManager.server.x86xexe (Heur.AdvML.B) detected by Auto-Protect
Holdem Manager Support Quote
07-01-2019 , 10:33 AM
This is common with new software like ours that hasn't been downloaded by a lot of customers yet that can report the false positives to antivirus companies. You need to report it as a false positive to your antivirus vendor so it won't affect other HM3 users with the same antivirus in the future, then remove the file from quarantine and/or reinstall the software and make sure to exclude HM3 from scanning by by your AntiVirus.

If you continue to have problems and need detailed instructions on how to remove it from quarantine or reinstall/update without Norton:

Please create a support ticket via the Contact Support link and if there is a forum thread with additional information please link to this thread and let us know your forum name if there are several people in the thread.

Fozzy71
Customer Support
Holdem Manager Support Quote
07-01-2019 , 11:21 AM
I’m having trouble putting ignition hands into hm2. I’ve extracted it from ignition and it’s in a folder on my computer but when I try to import the hands into hm2 it says the files have been imported but no hands were imported


Sent from my iPhone using Tapatalk Pro
Holdem Manager Support Quote
07-01-2019 , 01:43 PM
Quote:
Originally Posted by Holdem Manager
Management at the time (2014) decided that was the best course. Much has changed with our company since then and HM3 will show all known hole cards if you download the hands from the client (once IGN Grabber support is available for public beta testing) and force reimport them over the grabbed hands like PT4's beta IGN Grabber does. There are no plans to make that possible in current or future versions of HM2 that I am aware of.

Fozzy71
Customer Support
Thanks. Will there be a discount to upgrade from 2 to 3?
Holdem Manager Support Quote
07-01-2019 , 02:32 PM
Quote:
Originally Posted by mojo6911
Thanks. Will there be a discount to upgrade from 2 to 3?
We do not know when HM3 will be available for public Beta or officially released for purchase or upgrade.

We can tell you that all HM2 owners will receive a discount on any upgrade to HM3 and that the highest discounts will be given to those that purchased HM2 just prior to the release of HM3 Alpha.

In addition, those that purchase HM2 during the HM3 Alpha/Beta period will receive a free upgrade to HM3 once it is released. Anyone purchasing HM2 on January 01, 2017 or after will not have to pay to upgrade to HM3.

As we finalize other details, we will make announcements accordingly.

You can learn more about HM3 on our FAQs page here - http://support.holdemmanager.com/sup...%20Manager%203

Fozzy71
Customer Support
Holdem Manager Support Quote
07-01-2019 , 10:59 PM
Quote:
Originally Posted by Holdem Manager
We do not support a HUD on WPN Blitz tables or have plans to add HUD support at this time. If the HUD is showing it will be updating after the fast-folded hands finally are written and imported. I would suggest manually disabling the HUD on these tables via the Active Session / Live Play view Table History section, or by clicking the 'Stop HUD' button, until we can make HM2/3 automatically hide the HUD on these tables.



Fozzy71
Customer Support
Is there a reason for this????
Holdem Manager Support Quote
07-02-2019 , 08:59 AM
Is there any estimate on support for Run It Once hands? HH downloads are enabled now. Will it be for HM2 and 3 or just HM3?
Holdem Manager Support Quote

      
m