Page 1 of 1

"No Winners found" error when converting my PT2 DB

PostPosted: Fri May 30, 2008 4:43 pm
by domino66
So I'm converting my Ongame DB from PT2 to PT3 (using PT3's Convert DB feature). The DB has about 450,000 hands.

Through the first 125,000 hands it imported, there were about 400 errors (HHs that PT3 could not write for some reason), but then now it seems like it just stopped writing completely, and EVERY hand is generating the same error: "No winners Found Hand #xxxxxxxxxxx out of xxxxxxxx (id: xxxxxxxx)".

I'm watching the import right now and sure enough, the # of HHs successfully imported has more or less stopped completely around 125,000, while the # of errors is skyrocketing...it's at 75,000 now...and it looks like everything's just an error now and no more hands are being successfully imported.

Any idea what's going on here?

Also, what would you think of me trying to first "Export HHs to file" from PT2, which will generate a ton of .txt files, and then importing those HHs into PT3 instead of using the "COnvert DB" tool? Might that work, where this one is failing?

Re: "No Winners found" error when converting my PT2 DB

PostPosted: Fri May 30, 2008 4:48 pm
by WhiteRider
It's possible the file export would work better, and you would be able to do the import in batches if you are finding errors again.
If you can identify some hands which are giving errors, please attach some to the Support system and link to this thread.

Re: "No Winners found" error when converting my PT2 DB

PostPosted: Fri May 30, 2008 6:49 pm
by domino66
OK, did a little trouble-shooting and used the "Export HHs to file" from PT2, then imported using Manual Import in PT3. Here's what I discovered. about 98% of the hands from some time in Jan 2007 onward were imported successfully. 100% of the Hands that i had from before that would not import properly. What's especially odd is that, don't forget, I'm using PT2's Export HHs to File funciton, so these are .txt files being written by PT2 itself (not by a poker client), so I don't understand why the earlier ones are generating errors. I'm going to paste two HHs below, the first one imports just fine into PT3, the second one generates the"No Winners Found" error (i'll also submit a support ticket pointing to this thread).
The only thing I can see with my untrained eye is that the HH that gives the error has commas before the word "loses" in the SUMMARY, while the HHs that work fine do not. Is that the smoking gun? If it is, well what i find odd is that they are BOTH written by PT2's Export HHs to File function so why would it write them differently?

THIS ONE WORKS:

Texas Hold'em $10-$20 NL (real money), hand #P4-66951135-1455
Table Zwickau, 5 May 2008 4:22 PM ET

Seat 1: Zkrutt ($3,548.15 in chips)
Seat 2: -phoenixx- ($159.00 in chips)
Seat 3: HollabacGirl ($224.75 in chips)
Seat 4: Renaud123 ($1,095.00 in chips)
Seat 5: Ingenious89 ($1,122.75 in chips)
ANTES/BLINDS
-phoenixx- posts blind ($5), HollabacGirl posts blind ($10).

PRE-FLOP
Renaud123 bets $35, Ingenious89 folds, Zkrutt calls $35, -phoenixx- folds, HollabacGirl folds.

FLOP [board cards 4S,9S,7S ]
Renaud123 checks, Zkrutt bets $65, Renaud123 folds.

SHOWDOWN
Zkrutt wins $147.

SUMMARY
Dealer: Zkrutt
Pot: $150, (including rake: $3)
Zkrutt bets $100, collects $147, net $47
-phoenixx- loses $5
HollabacGirl loses $10
Renaud123 loses $35
Ingenious89 loses $0

THIS ONE DOESN'T:

Texas Hold'em $10-$10 NL (Real Money), hand #978,580,266
Table Norrkoeping, 10 Sep 2006 5:15 AM ET
Seat 1: RTGG ($923 in chips)
Seat 3: OtakuTiger ($973 in chips)
Seat 4: iridium.x ($952.50 in chips)
Seat 5: padidukes x ($730 in chips)
Seat 9: -BooDevil- ($572 in chips)
ANTES/BLINDS
OtakuTiger posts blind ($5), iridium.x posts blind ($10).
PRE-FLOP
padidukes x folds, -BooDevil- folds, RTGG calls $10, OtakuTiger calls $5, iridium.x checks.
FLOP [board cards 10S,KH,7D ]
OtakuTiger checks, iridium.x checks, RTGG bets $25, OtakuTiger calls $25, iridium.x folds.
TURN [board cards 10S,KH,7D,5C ]
OtakuTiger checks, RTGG checks.
RIVER [board cards 10S,KH,7D,5C,2C ]
OtakuTiger checks, RTGG checks.
SHOWDOWN
OtakuTiger shows [ 4D,10C ]
RTGG mucks cards [ QH,3H ]
OtakuTiger wins $78.
SUMMARY
Dealer: RTGG
Pot: $80, (including rake: $2)
RTGG, loses $35
OtakuTiger, bets $35, collects $78, net $43
iridium.x, loses $10
padidukes x, loses $0
-BooDevil-, loses $0

Re: "No Winners found" error when converting my PT2 DB

PostPosted: Sat May 31, 2008 4:05 am
by WhiteRider
Thanks for reporting this. What site are these hands from?
I would guess that Josh hasn't had access to old hands from that site before, so hopefully support can be added.
PT2 stores the original HH text, so will just be re-exporting that.

Re: "No Winners found" error when converting my PT2 DB

PostPosted: Sat May 31, 2008 9:53 am
by domino66
WhiteRider wrote:Thanks for reporting this. What site are these hands from?
I would guess that Josh hasn't had access to old hands from that site before, so hopefully support can be added.
PT2 stores the original HH text, so will just be re-exporting that.


They're Ongame hands from 2006.
Honestly: not all that important, but if it's an easy fix, go for it.

Re: "No Winners found" error when converting my PT2 DB

PostPosted: Sat May 31, 2008 10:03 am
by WhiteRider
I doubt it will be added immediately, but please create a ticket.

Re: "No Winners found" error when converting my PT2 DB

PostPosted: Sat May 31, 2008 1:19 pm
by domino66
already did - was told it will be passed along to josh

Re: "No Winners found" error when converting my PT2 DB

PostPosted: Sat May 31, 2008 1:23 pm
by WhiteRider
OK, thanks.