majic
11-17-2008, 02:01 AM
I've run into this scenario over and over. As updates seemed to be coming out, I pretty much just lived with it, but at this point it is very very frustrating and as my hand history becomes larger with HEM, fixing it takes longer and longer.
The issue:
1) Start new database
2) Start playing sessions
3) Hands import fine, hud works fine
4) Play several sessions over a few days, everything is great. Change nothing.
5) On xth session, no hands import.
6) Look in hands directory... files are still there.
7) Try to manually import: Says no files found.
8) Move hands to a different directory.
9) Try to import from different directory. It finds them, but reports them as duplicate hands.
10) Get mad.
11) Export ALL hands from database.
12) Create new database.
13) Import ALL hands (and wait). The missing hands show up (which were exported from the database, mind you... which means they were there... but probably not put into the database correctly).
14) Rinse and repeat after another 3-5 sessions.
There is no indication that something has gone wrong for it to stop importing.
Interestingly enough, one time I simple ignored it and kept playing sessions and a few days later it started picking up hands again without any intervention on my part.
Also worth noting that even though the hands don't show up in the reports, the hud always works.
No, I didn't change my filters. No, clearing the filters didn't produce different results. Changing the user and changing back didn't produce different results, ad nauseum.
I'm playing 25nl on Stars, 6-max, both 50bb min, fast and normal tables.
I'm using version 1.06.04beta20 (I got this version hoping it would fix the issue which I've seen since I purchased it some time ago).
I've installed it on my D: drive (as opposed to C:). Not sure if that is an issue, but I know some programs that make assumptions about the user using C:.
Based on the fact that exporting and reimporting works would seem to indicate that something got corrupted during the inserts. The hand history file obviously made it into the database (probably with some of the other data) since I'm able to export (and I remember digging around your DB schema and saw a table for the hand histories).
Is it possible you are eating some exceptions when doing the inserts? Are you validating all the values before the inserts (so that bad, blank, null, etc data can't go into the database)...?
The issue:
1) Start new database
2) Start playing sessions
3) Hands import fine, hud works fine
4) Play several sessions over a few days, everything is great. Change nothing.
5) On xth session, no hands import.
6) Look in hands directory... files are still there.
7) Try to manually import: Says no files found.
8) Move hands to a different directory.
9) Try to import from different directory. It finds them, but reports them as duplicate hands.
10) Get mad.
11) Export ALL hands from database.
12) Create new database.
13) Import ALL hands (and wait). The missing hands show up (which were exported from the database, mind you... which means they were there... but probably not put into the database correctly).
14) Rinse and repeat after another 3-5 sessions.
There is no indication that something has gone wrong for it to stop importing.
Interestingly enough, one time I simple ignored it and kept playing sessions and a few days later it started picking up hands again without any intervention on my part.
Also worth noting that even though the hands don't show up in the reports, the hud always works.
No, I didn't change my filters. No, clearing the filters didn't produce different results. Changing the user and changing back didn't produce different results, ad nauseum.
I'm playing 25nl on Stars, 6-max, both 50bb min, fast and normal tables.
I'm using version 1.06.04beta20 (I got this version hoping it would fix the issue which I've seen since I purchased it some time ago).
I've installed it on my D: drive (as opposed to C:). Not sure if that is an issue, but I know some programs that make assumptions about the user using C:.
Based on the fact that exporting and reimporting works would seem to indicate that something got corrupted during the inserts. The hand history file obviously made it into the database (probably with some of the other data) since I'm able to export (and I remember digging around your DB schema and saw a table for the hand histories).
Is it possible you are eating some exceptions when doing the inserts? Are you validating all the values before the inserts (so that bad, blank, null, etc data can't go into the database)...?