PDA

View Full Version : Error: Xx002



VincentAgain
01-06-2010, 04:07 PM
After installing 1.10 beta 6 I have this error when clicking on "Reports" in HM. All other Tabs work.

http://s8.directupload.net/file/d/2031/d35x5uzh_jpg.htm

fozzy71
01-06-2010, 07:21 PM
That is a problem with one of your DB indexes.

You can try to fix that index - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=168

Or you can try a general Reindex from the PGAdmin > Maintenance menu - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163


If neither of those things help, you will need to create 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, 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

VincentAgain
01-07-2010, 09:18 AM
That is a problem with one of your DB indexes.

You can try to fix that index - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=168

Or you can try a general Reindex from the PGAdmin > Maintenance menu - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163


If neither of those things help, you will need to create 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, 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


Thank You

Fixing the index helped.