error message

[vettro]

I get this message when trying to run a report by stakes grouped by month. "The following error occured when running this report: ERROR 42703. column month does not exist.

Also, I get an error when trying to vacuum database. Then it says please vacuum manually using pgadmin.

I also get an error message sometimes that says HM was forcibly closed by a remote host.

Thanks

Scott

[fozzy71]

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.


I get this message when trying to run a report by stakes grouped by month. "The following error occured when running this report: ERROR 42703. column month does not exist.

This is an indication there are problems with the current DB.

*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



Also, I get an error when trying to vacuum database. Then it says please vacuum manually using pgadmin.

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163


I also get an error message sometimes that says HM was forcibly closed by a remote host.

.

This is usually a firewall or windows update issue.

First try to reboot.

If no help, try this:

Start > Programs > PostgreSQL > 8.x > Stop Service

Start > Programs > PostgreSQL > 8.x > Start Service

If that doesnt help delete the \postgresql\8.x\data\postmaster.pid file, if you see it.

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

Please try following all of these FAQs, step by step:

1) http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=34
2) reinstall the same version of postgresql, using the same \data folder - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177
3) http://www.holdemmanager.net/forum/showthread.php?t=8261

If that doesn't help you will probably have to reinstall PostgreSQL completely and reimport your hands using these instructions - http://forums.holdemmanager.com/showthread.php?t=20755

[Patvs]

The error in HEM when trying to vacuum the database is normal.
Try to vacuum the database in pgAdminIII instead. How to do that (http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163) (click)

I would suggest to do that first. If you get an error during the vacuum, your database is corrupt and you should start a NEW database and reimport your hands.

Your run report error:
Please update to the latest version - http://www.holdemmanager.com/downloads/HmUpdate.exe

Reinstall Microsoft .NET Framework:
1) Download and run this uninstaller - http://www.holdemmanager.com/downloads/dotnetfx_cleanup_tool.zip
2) Install this one: http://download.microsoft.com/download/2/0/e/20e90413-712f-438c-988e-fdaa79a8ac3d/dotnetfx35.exe

Remote host error:
Under Vista and Windows 7 make sure UAC is disabled - http://www.petri.co.il/disable_uac_in_windows_vista.htm
Add exceptions to the windows firewall for holdemmanager.exe, hmhud.exe, dbcontrolpanel.exe, port 5432, and your pokerroom (for example fulltiltpoker.exe), even if it is off. If you have a 3rd party firewall, do the equivalent