Datamining party

[iwanturcoin]

when trying to import observed hand sfrom party, it keeps coming up with this error in the import status box :

PartyGaming: Unable to import hand (#7074554383). Reason: Unable to execute query: COPY holdem_hand_histories FROM STDIN;; Reason: Fatal Error (ERROR: literal newline found in data HINT: Use "\n" to represent newline. CONTEXT: COPY holdem_hand_histories, line 2: "" )


????whats goin on

[WhiteRider]

What application are you using to generate the hand histories?
It looks like it's generating invalid hand histories.

[iwanturcoin]

spadeye....it works fine with pt2

[pr1mo]

i'm getting similar type of error when i import observed hands saved from idle miner:

it's coming up in about 1.5% of the hands i import.

i never got this error with pt2.

2008/05/21 18:18:18: 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 60, column amt_rake: "701.31" )
2008/05/21 18:18:19: 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: "954.10" )
2008/05/21 18:18:19: 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 96, column amt_rake: "316.00" )
2008/05/21 18:18:19: 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 31, column amt_rake: "159.85" )
2008/05/21 18:18:19: 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 37, column amt_rake: "255.00" )

[mhorowit]

I'm getting the same error.
Was working fine this afternoon. I shut it down. We had a power failure and I came back to a powered down machine. When I brought it up and cranked up PT3 and PS, I got that series of errors when I asked that PT3 begin importing.
Did someone come up with a solution? - MIke

[iwanturcoin]

bump...

[iwanturcoin]

seriously this is getting on my nerves now.....some response would be good and by the looks of it in the forums there are more problems with PT3 than u can handle. How can you charge us for a program that obviously isn't finished and has a LOT of problems with it still??.....at the moment i really wish i did'nt buy it.

[kraada]

Can you please attach some of these hand histories to a support ticket? Once we have the histories we will be able to fix what needs to get fixed so they get imported properly.