PDA

View Full Version : Error Message When Running Report



cmozingo
10-15-2009, 08:04 PM
When I go to Tourney/Reports and select report name "Holecards" I get the following error. Other reports seem to work ok from what I've seen. I'm using 1.09 beta 38.

<a href="http://s72.photobucket.com/albums/i182/beanmo/?action=view&current=HEMerror.jpg" target="_blank"><img src="http://i72.photobucket.com/albums/i182/beanmo/HEMerror.jpg" border="0" alt="HEM Error Message"></a>

Any ideas? Thanks.

fozzy71
10-15-2009, 08:23 PM
It is a DB problem. You can try to fix that particular index:

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


If that doesnt work you can try a general reindex:

start > programs > postgresql > 8.x > pgadmin3 > right-click > connect > right-click > Maintenance > Reindex.


If that doesnt work you will have to build a new 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, and export/import the hands from the old DB, and then delete the old DB. - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=21

cmozingo
10-15-2009, 08:40 PM
Thanks Fozzy. Do you know which index I need to reindex?

fozzy71
10-15-2009, 08:50 PM
The one specified in quotations in the error message.

cmozingo
10-15-2009, 08:55 PM
That's just it. When I go to Rebuild Indexes, I don't see a "ph.netamountwon" index listed.

fozzy71
10-15-2009, 08:56 PM
:(

Not sure what else to suggest then, other than a new DB.

Thunza
01-01-2010, 11:21 AM
I get exactly the same error and the re-indexing of tables does not help. This looks like a problem with the SQL script itself in that this field (netwinamount) was omitted from the group by clause. Is there any way I can go into the SQL script myself and make the change?

netsrak
01-02-2010, 06:34 AM
Edit: lets stay in one thread.