Party Import Errors

[kriok]

This is the file I tried importing, but all the hands had errors.

I don't understand. This also happened with a bunch of other files from a different day of dataming.

Here is the first 2 hands:

Game #7676476474 starts.

#Game No : 7676476474
***** Hand History for Game 7676476474 *****
$50 USD NL Texas Hold'em - Monday, January 05, 00:00:00 ET 2009
Table Jackpot #1304184 (No DP) (Real Money)
Seat 4 is the button
Total number of players : 4
Seat 6: BLaackDaisy ( $53.25 USD )
Seat 5: Cheecherino ( $100.30 USD )
Seat 3: GIXER333 ( $42 USD )
Seat 4: untamed1928 ( $55.62 USD )
Cheecherino posts small blind [$0.25 USD].
BLaackDaisy posts big blind [$0.50 USD].
** Dealing down cards **
GIXER333 folds
untamed1928 folds
Cheecherino raises [$1.75 USD]
BLaackDaisy folds
Cheecherino does not show cards.
The time at which hand ended:Jan 05 2009 00:00 ET
Cheecherino wins $2.50 USD




Game #7676476719 starts.

#Game No : 7676476719
***** Hand History for Game 7676476719 *****
$50 USD NL Texas Hold'em - Monday, January 05, 00:00:18 ET 2009
Table Jackpot #1304184 (No DP) (Real Money)
Seat 5 is the button
Total number of players : 4
Seat 6: BLaackDaisy ( $52.75 USD )
Seat 5: Cheecherino ( $100.80 USD )
Seat 3: GIXER333 ( $42 USD )
Seat 4: untamed1928 ( $55.62 USD )
BLaackDaisy posts small blind [$0.25 USD].
GIXER333 posts big blind [$0.50 USD].
** Dealing down cards **
untamed1928 raises [$1.50 USD]
Cheecherino folds
BLaackDaisy folds
GIXER333 calls [$1 USD]
** Dealing Flop ** [ Qs, 5s, 2s ]
GIXER333 checks
untamed1928 bets [$2.50 USD]
GIXER333 raises [$5 USD]
untamed1928 is all-In [$51.62 USD]
GIXER333 is all-In [$35.50 USD]
** Dealing Turn ** [ 7c ]
** Dealing River ** [ Ad ]
GIXER333 shows [ 2h, 2d ]three of a kind, Twos.
untamed1928 shows [ Kc, Ks ]a pair of Kings.
The time at which hand ended:Jan 05 2009 00:00 ET
untamed1928 wins $13.62 USD from the side pot 1 with a pair of Kings.
GIXER333 wins $81.75 USD from the main pot with three of a kind, Twos.


Should this give an error or is it just my HEM screwing with me?

[morny]

Theres import fine for me, possibly an issue with your database so try creating a new one and importing again

[Ergospace]

Theres import fine for me, possibly an issue with your database so try creating a new one and importing again

Hello morny!

I got the same problem today. All hands I tried to import had an error.
I tried to create a new DB, and it works well. What's the problem with my default DB? It has a lot of mined hands and my stats. What should I do? As far as I understand HM HUD works with one DB at the same time only. If I create a new DB and start import to it, how can I use my previous in order to have stats for opponents?

Yours, Kirill.

[Al1]

Hello morny!

I got the same problem today. All hands I tried to import had an error.
I tried to create a new DB, and it works well. What's the problem with my default DB? It has a lot of mined hands and my stats. What should I do? As far as I understand HM HUD works with one DB at the same time only. If I create a new DB and start import to it, how can I use my previous in order to have stats for opponents?

Yours, Kirill.

You can extract your hands from your old DB and reimport them in the new one: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173

If you have all your original HHs text files, you can also just reimport from those files.

[Ergospace]

You can extract your hands from your old DB and reimport them in the new one: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173

If you have all your original HHs text files, you can also just reimport from those files.

Is there any possibilities to fix my DB?
ImportErrors.txt says smth like this:
"C:\...\112SH2009.01.0810.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block"

I did a large import yesterday, about 300k hands, if it makes any sense.

Exporting and reimporting will take a whole day...

Any other suggestions?

[morny]

Unless HM is giving an error about a specific index while running a report otherwise youll need to export and import as its likely a table thats damaged