Cant select player

[md1988]

My problem is little strange. There are players in my database whom I cant select as hero in hm2. Its funny cause I can filter hands played against them and HUD in replayer is showing that I have large sample on them. I also have one 'unfindable' player on short list and I can choose him as hero. HM2 will reload hands and then display 'no hands found'. There is another funny thing - when I choose another player as hero of course soft will preload hands and when its done I can see for few seconds current report generated for 'invisible' villain.

I used google to solve this and:
-I reimported hands for villain
-'clean' database with pgadmin(vacuum+analyze+reindex)
but still i cant fix it.

Ah last thing - this problem occur after loading large amount of hands into database.

[udbrky]

How did you get the hands? Were they exported or just imported from a site?

Does the player show in the active player list?

Please create a new database.

1) Click the database name in the bottom right corner (2nd in)

2) Click the green + sign

3) Name it, click ok.

4) Import the hands from c:\hm2archive using the hand importing function on the ribbon, not the import from database in the database manager.

[md1988]

How did you get the hands? Were they exported or just imported from a site?

Hands are from datamining(hhdealer)

Does the player show in the active player list?

Player is on recent players list(i checked him before import) but I cant find him with function 'select player...'

Ok, i will create new database as you say but still i'm curious if I can avoid another database integrity failure in future.

[Patvs]

Ah last thing - this problem occur after loading large amount of hands into database.

It's likely a database corruption. Import the hands into a new empty database, then check if you can select those players.