PDA

View Full Version : Urgent: HM does not import all hands



Gilberto
04-18-2009, 10:11 PM
I bought a new computer, installed HM, restored the database of my old computer (via pgadmin).

However, when I play a session many hands are not imported. I don't see them in the graph nor at the sessions tab.
I think about half of the hands were normally imported, but a few hands are not in the database.

Besides, I buy Hand histories from hhdealer.com. However, the hands can not be imported (import errors). With the old computer, there were never problems.


It is very important for me to have all the hands in the database, and it is really annoying to miss hands, so how can I fix this?

morny
04-19-2009, 11:08 AM
Can you create a new database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146 and try importing and see if the problem persists

Gilberto
04-19-2009, 08:52 PM
I already tried that, and there were no problems at all.

morny
04-20-2009, 10:04 AM
Ok the old database seems to have become corrupt

Please export your hands from the old database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173 then create a new database http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146 and reimport the hands into the new database

Gilberto
04-20-2009, 11:04 AM
Ok I already did that about 30 hours a go, but the import is still running...

I have a big database so this might be normal, right?

I will post here whenever the import has been finished.

Gilberto
04-20-2009, 12:08 PM
When I look into the installation directory, I see this error:

"The Error: ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
Occurred when running ExecuteNonQuery with this query: SAVEPOINT beforegame;"



I am not sure whether this error has comething to do with the problems I suffer, but perhaps you can do something with this?

Gilberto
04-20-2009, 07:24 PM
I think it's fixed, I don't want to be happy too early though...

I imported some hands, results:

Hands imported: 27941
Duplicate hands 871
Import Errors: 610


so still a lot of import errors, but I am happy that they are not all import errors though.

Gilberto
04-21-2009, 06:11 AM
I get these errors:



__No_DP__19_04_2009.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Poker\Eyepoker\Red_Bluff_19_04_2009.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Poker\Eyepoker\Restar__No_DP_50_bb_min__19_04_2 009.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Poker\Eyepoker\Rialto_19_04_2009.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Poker\Eyepoker\Salter__No_DP_50_bb_min___19_04_ 2009.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Poker\Eyepoker\_TURBO__Korsor_19_04_2009.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-150.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-151.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-1510.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-1511.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-1512.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-1513.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-1514.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-1515.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-1516.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-1517.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-1518.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-1519.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-152.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-1520.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-1521.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-1522.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-1523.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-1524.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-1525.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-1526.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-1527.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-1528.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-1529.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-153.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-1530.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-154.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-155.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-156.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-157.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-158.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Users\Main User\Poker\HH Dealer\2414SH2009-04-159.xml ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Program Files (x86)\RVG Software\Holdem Manager\Importing\Work Folder\File340_28.txt ERROR: 57014: canceling statement due to user request
C:\Program Files (x86)\RVG Software\Holdem Manager\Importing\Work Folder\File340_29.txt Kan de tabel 0 niet vinden.
C:\Program Files (x86)\RVG Software\Holdem Manager\Importing\Work Folder\File340_30.txt Kan de tabel 0 niet vinden.
C:\Program Files (x86)\RVG Software\Holdem Manager\Importing\Work Folder\File341_0.txt Kan de tabel 0 niet vinden.
C:\Program Files (x86)\RVG Software\Holdem Manager\Importing\Work Folder\File341_1.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block
C:\Program Files (x86)\RVG Software\Holdem Manager\HandHistoryExport_HoldemManagerLaptop\File 341.txt ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block

morny
04-21-2009, 01:22 PM
Are you getting errors since you done the original import? If so email me some of these HH to morny@holdemmanager.net and also link to this thread