PDA

View Full Version : Import error on 2M hands



clockwork84
09-04-2009, 01:27 PM
I recently tried to import 5,000 files into HEM (each file has roughly 1k hands), and received import errors on over 2M hands. I looked at ImportTraceError.log (which was over 500MB) and it repeated this error:

(ImportTraceError.log):

EXECUTE PHCashKeyEXECUTE(440952,3003566,to_timestamp('08/18/2009 16:31:17','MM/DD/YYYY HH24:MI:SS'),38,37264,8,3,0,0,0,0,0,0,False,False, 0,0,0,0,0,0,0,0,0,0,False,False,False,False,-1,False,False,False,False,-1,False,False,False,False,-1,0,0); EXECUTE PHCashMiscEXECUTE(3003566,170.00,170.00,1,2,-1,False,-1,0,0,0,0,0,-1,-1,False,False,False,False,False,False,False,0,0); EXECUTE PHCashKeyEXECUTE(440952,3003567,to_timestamp('08/18/2009 16:31:17','MM/DD/YYYY HH24:MI:SS'),38,129969,8,4,0,0,0,0,0,0,False,False ,0,0,0,0,0,0,0,0,0,0,False,False,False,False,-1,False,False,False,False,-1,False,False,False,False,-1,0,0); EXECUTE PHCashMiscEXECUTE(3003567,1189.00,1189.00,2,1,-1,False,-1,0,0,0,0,0,-1,-1,False,False,False,False,False,False,False,0,0); EXECUTE PHCashKeyEXECUTE(440952,3003568,to_timestamp('08/18/2009 16:31:17','MM/DD/YYYY HH24:MI:SS'),38,127842,8,5,0,0,0,0,0,0,False,False ,0,0,0,0,0,0,0,0,0,0,False,False,False,False,-1,False,False,False,False,-1,False,False,False,False,-1,0,0); EXECUTE PHCashMiscEXECUTE(3003568,200,200,3,0,-1,False,-1,0,0,0,0,0,-1,-1,False,False,False,False,False,False,False,0,0); EXECUTE PHCashKeyEXECUTE(440952,3003569,to_timestamp('08/18/2009 16:31:17','MM/DD/YYYY HH24:MI:SS'),38,130057,8,0,0,0,0,0,9,0,True,False, 0,2,1,1,0,0,0,0,0,66,False,False,False,False,44,Fa lse,False,False,False,-1,False,False,False,False,-1,0,0); EXECUTE PHCashMiscEXECUTE(3003569,1231.00,985.00,4,7,-1,False,0,0,5,5,0,1,-1,-1,False,False,False,False,False,False,False,0,0); EXECUTE PHFlopExecute(3003569,20,0,False,False,False,1,1,0 ,0,0,False,True,-1,-1,-1,24.5); EXECUTE PVPExecute(130057,52666,440952,10,1); EXECUTE PHCashKeyEXECUTE(440952,3003570,to_timestamp('08/18/2009 16:31:17','MM/DD/YYYY HH24:MI:SS'),38,52666,8,1,0,0,0,0,-10,0,False,False,1,1,1,0,0,0,0,0,0,22,False,False, False,False,0,False,False,False,False,-1,False,False,False,False,-1,0,0); EXECUTE PHCashMiscEXECUTE(3003570,500,500,5,6,-1,False,0,0,0,10,0,0,-1,-1,False,False,False,False,False,False,False,0,0);

I am using HEM 1.09 beta 29 - do you think this is a problem with HEM or my HH's?

netsrak
09-04-2009, 04:49 PM
Set the language and currency settings on your system to standard (english (USA)) and try to import some hands into a new database.