Problem with importing(ERROR: numeric field overflow DETAIL

Experiencing technical difficulties? Think you've found a problem with PokerTracker 3? Report it here.

Moderator: Moderators

Problem with importing(ERROR: numeric field overflow DETAIL

Postby Suwalski » Fri May 16, 2008 1:15 pm

I've exported my old pt2 databse to a folder(fisse), when i try to import from pt3 i get this error for every file it attempts to import.

2008/05/16 19:01:56: Import file: C:\Documents and Settings\Bossen\Skrivebord\fisse\pty_new NL $1000 (6 max) 6967091432 to 6967170858.txt
2008/05/16 19:02:07: Unable to import hand. Reason: Unable to execute query: COPY holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: numeric field overflow DETAIL: A field with precision 4, scale 2 must round to an absolute value less than 10^2. CONTEXT: COPY holdem_hand_summary, line 1, column amt_rake: "2545.00" )
2008/05/16 19:02:07: Unable to import hand. Reason: Unable to execute query: COPY holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: numeric field overflow DETAIL: A field with precision 4, scale 2 must round to an absolute value less than 10^2. CONTEXT: COPY holdem_hand_summary, line 1, column amt_rake: "405.00" )
2008/05/16 19:02:07: Unable to import hand. Reason: Unable to execute query: COPY holdem_hand_summary FROM STDIN;; Reason: Fatal Error (ERROR: numeric field overflow DETAIL: A field with precision 4, scale 2 must round to an absolute value less than 10^2. CONTEXT: COPY holdem_hand_summary, line 1, column amt_rake: "1106.50" )
2008/05/16 19:02:13: + Complete (0 hands, 3 errors, 297 duplicates)

How do i solve this, what have i done wrong? My old pt db was also postreqsl if thats important in any way.
Suwalski
 
Posts: 2
Joined: Thu May 15, 2008 9:17 am

Re: Problem with importing(ERROR: numeric field overflow DETAIL

Postby Josh » Fri May 16, 2008 5:37 pm

If this still occurs in build 2, please attach the hand history file to a support ticket and be sure to reference this thread.
Josh
Site Admin
 
Posts: 6222
Joined: Sat Dec 08, 2007 6:03 pm


Return to Technical Support / Bug Reports [Read Only]

Who is online

Users browsing this forum: Amazonbot and 34 guests

cron