Import fails on apparent enormous buyin/bounty numbers

Questions and discussion about PokerTracker 4 for Windows

Moderators: WhiteRider, kraada, Flag_Hippo, morny, Moderators

Import fails on apparent enormous buyin/bounty numbers

Postby Parket » Wed Jan 04, 2012 12:00 pm

I'm still waiting for the PT4 Import crash fix in the next beta, but I noticed something else in my log files.

I have a ton of the following messages :

2012/01/03 07:25:38.882 [00076]: [00000F94][PostgresConnection (Error)] Unable to execute query: UPDATE tourney_summary SET id_tourney_type = 200, date_start = '2010/04/13 20:26:57', date_end = '2010/04/13 20:26:57', hand_no_start = '42620597745', hand_no_end = '42620597745', cnt_players = 4, amt_buyin = 42107526.51, amt_fee = 0.40, currency = 'USD', amt_bounty = 842150.45 WHERE id_tourney = 2968;; Reason: Fatal Error (ERROR: numeric field overflow DETAIL: A field with precision 7, scale 2 must round to an absolute value less than 10^5. )
2012/01/03 07:25:38.882 [00000]: [00000F94][HandHistoryDatabaseImport] DatabaseVariables: Query(Error): Unable to execute query: UPDATE tourney_summary SET id_tourney_type = 200, date_start = '2010/04/13 20:26:57', date_end = '2010/04/13 20:26:57', hand_no_start = '42620597745', hand_no_end = '42620597745', cnt_players = 4, amt_buyin = 42107526.51, amt_fee = 0.40, currency = 'USD', amt_bounty = 842150.45 WHERE id_tourney = 2968;; Reason: Fatal Error (ERROR: numeric field overflow DETAIL: A field with precision 7, scale 2 must round to an absolute value less than 10^5. )

This is for about 5 PokerStars tournaments in my PT3 database. I checked the actual tournaments/hands and in fact see nothing wrong. E.g. the tournament for above errors simply shows a buy-in of $4.00 in PT3, so I'm wondering where this 42107526.51 is coming from. And I wasn't even aware there is an amt_bounty field as well (have never seen bounty-support in PT3).
Parket
 
Posts: 367
Joined: Mon Mar 24, 2008 1:03 pm

Re: Import fails on apparent enormous buyin/bounty numbers

Postby kraada » Wed Jan 04, 2012 12:57 pm

Bounty support was not as well used in PT3 as it will be in PT4. Could you attach the tournament hands in question to a support ticket for us?
kraada
Moderator
 
Posts: 54430
Joined: Wed Mar 05, 2008 2:32 am
Location: NY


Return to PokerTracker 4

Who is online

Users browsing this forum: No registered users and 17 guests