error XX001 when running a report for the 3rd Feb
Results 1 to 2 of 2
  1. #1
    Junior Member
    Join Date
    Apr 2009
    Posts
    2

    Default error XX001 when running a report for the 3rd Feb

    I have the above error popping up when I run a report for the 3rd Feb 2010. I use iPoker (Dafa).

    The full message on the HM pop up is

    The following error occurred when running this report:ERROR: XX001: invalid page header in block 6506 of relationship "playerhandscashmisc_hero"

    I can run reports before and after this date but not any reports that include this data, I am using HM version 1.10.01

    can you help pls. Thanks

  2. #2
    *** HM3! *** fozzy71's Avatar
    Join Date
    Jun 2005
    Location
    HM Support
    Posts
    32,803

    Default

    That is a problem with one of your DB indexes.

    You can try to fix that index - http://faq.holdemmanager.com/questions/86/Fix+Indexes

    Or you can try a general Reindex from the PGAdmin > Maintenance menu - http://faq.holdemmanager.com/questio...lyze+Database+


    If neither of those things help, you will need to create a new DB.

    *Try creating a new UTF DB - http://faq.holdemmanager.com/questio...elete+Database
    *Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - http://faq.holdemmanager.com/questio...6+Export+Hands
    *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.
    *Make sure you export/backup everything before deleting the old DB

Similar Threads

  1. Error Message When Running Report
    By cmozingo in forum Manager General
    Replies: 7
    Last Post: 01-02-2010, 06:34 AM
  2. Error message when running "Sessions"-report
    By AAkekAA_ in forum Manager General
    Replies: 6
    Last Post: 05-23-2009, 12:23 AM
  3. Report error while running "Plugging Leaks"
    By crosswalkryan in forum Manager General
    Replies: 1
    Last Post: 05-05-2009, 09:16 PM
  4. Getting error running report for full year
    By allabout in forum Manager General
    Replies: 1
    Last Post: 01-04-2009, 10:05 AM
  5. Replies: 2
    Last Post: 10-13-2008, 02:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •