Villains Hands missing

[JPonline]

Hi.

Additionally to Holdemmanager I use a tablescanner.

Today I came upon something odd:

I scanned some tables and i found a fish at one of those. The tablescanner reported that I had about 1000 hands from the fish.

After a orbit at the table, I only had 5 Hands in my HUD.

I checked my "advanced Hud filters", but they were all set to "2 to 10 players" and all boxes checked and maximum age of hands was set to 96 months by me.

Still I have only5 Hands from the fish.
Why doesnt HEM take all hands out of the DB ? (scanner an hem access the same DB!)

Kind Regards
Julius

[Patvs]

hud options--> additional HUD filters--> do you also have turned on "include hands from other limits" and " mix FTP RUSH and non RUSH stats"?


Please update to the latest version - http://www.holdemmanager.com/Downloads/HmUpdate.exe


Try creating a NEW empty database and reimport all the hands from your archive folder.

[JPonline]

Hi

thanks for your answer.


I am already using version 1.11.06d.
As I already said, all the boxes in my HUD Filters are checked.





Reimporting my Hands (into a new DB) from the Archive folder wont do much good, because I imported Tons of Hand Histories, which I bought.

Help please !

Julius

[Patvs]

After a orbit at the table, I only had 5 Hands in my HUD.

Did it show the full 1000 hands the first hands at the table, and then suddenly jumped to only showing 5 hands? Despite all your filters being correct, did this happen when a player left the table? On which site are you playing?

Which SQL version are you using?
How did you backup all the hands you bought?
Try exporting your hands in database management:
-reimport the archive folder first into a new database
-followed by the exported hands, exported in database management

[JPonline]

Did it show the full 1000 hands the first hands at the table, and then suddenly jumped to only showing 5 hands?

No, HEM showed me first 0 Hands, then 1 and so on. (business as usual, versus a completely unknown player)

But my Tablescanner (Tablescan Turbo) reported me about 1000 Hands on this particular player.

Despite all your filters being correct, did this happen when a player left the table? On which site are you playing?

No, i sat down at the table and was dealt in. The table was always full, and no players changed during the first 2 or 3 orbits.
I am playing on Pokerstars

Which SQL version are you using?

I am running POstgreSQL 9.0

How did you backup all the hands you bought?

On the one Hand i still have the .zip archives. And I also do a backup of my Database every 5 Days, using pgAdmin.

Try exporting your hands in database management:
-reimport the archive folder first into a new database
-followed by the exported hands, exported in database management

I can try this, but to be honest this will literally take ages.

Will this prevent me from the same error, in the future ? I import about 1.2-1.7 million Hands every day.



By the way: Almost the same problem appears quite often in this scenario:

I go in HEM to the "players" tab, and filter out all players with VPIP < 40 and Min. Hands 40, Site "pokerstars" and Date range from Jan. 2000 till Dec 2011.
After that I get about 28k Players. I make a Note in the Pokerstars Software on every player (so i can see them, lets say green, in the Lobby and at the tables).

But my tablescanner shows me players I seem to have 200 hands on, with a VPIP of 50. (so very well covered by my filters from above), but they were never exported by the HEM players tab! !


It seems HEM does not get all the Data from my DB ? But the Data is apparently there, since TableScan turbo has access to it !???

any Ideas ?

Kind Regards Julius


P.S: I do the Analyze, Vacuum and Reindex routine within pgAdmin, on a two to three days basis, always without any errors.

[Patvs]

Most logical cause would be if TableScan Turbo is wrongly misreading the info from one of the indexes of the PostgreSQL database.

Can you email sales@holdemmanager.com, request a free temporary license key for TableScanner, so you can check if the same error occurs when using our TableScaner.

[JPonline]

Hi.

I can try to reproduce the error, using your tablescanner. I do have a license key.


BUT :

The problem i described with the player list, that is exported by HEM (and then saved by me as a .csv file) is even more odd, as i just discovered:

I export player names all with VPIP < 40 and Hands < 40 and date range Jan. 2000 till Dec. 2011 and Site "pokerstars".

Then I sit down at a table, and as soon as the HUD appears i see some times players with 120 hands and VPIP 45.

(No import of new hands inbetween the "player list" and the showing of the HUD)

Any ideas ?

Meanwhile i will try to reproduce the error, using the HEM Tablescanner.

Kind Regards

Julius

[Patvs]

You mean you run a filter for:
VPIP > 40 and Hands > 40
mark ALL those players, and then you still find unmarked players that match those criteria.

I think the filters are somewhat limited: meaning if you run a filter for VPIP <100, Hands >1 (which should result in ALL the players of your database).... it won't show all the players. Either it will CRASH HoldemManager, or only show a small portion of them.

It's likely with your current VPIP > 40 and Hands > 40 filter, the 28k players are also not all of them, because the query crashes at some point.

[JPonline]

Yes, I meant VPIP over 40. (for the obvious reasons :-) )

Okay, so I wont worry about that player list anymore, or try to do it in smaller steps. (maybe first vpip 40-41 and maybe different date ranges)


However, I will be able to try to reproduce the Scanner/HUD error in a few hours.

Thanks so far.

Julius

[JPonline]

I was able to reproduce the error, to some degree. (Also with HEM Scanner)

I attached two screenshots.







I was not able to find a player/table, where the scanner reports 1k hands, and HUD 0 (I didnt have the time to search for hours) but at least you can see, that the error I mentioned, does exist, and please be assured, it does even exist to such an extreme degree, that Scanner reports 1k+ Hands and HUD = 0.

(HUD Filters obviously are still the same as in my Screenshot from an earlier post)


Please help !

Kind Regards Julius


Edit: I just reuploaded the Pictures, with a better resolution.