PDA

View Full Version : import errors form ohg



babaa
01-09-2009, 01:05 PM
mined 7k hands and imported like ~200
and 6k import errors...wtf

from the importerrors.txt

Texas Hold'em $2.00-$4.00 NL (real money)
Table Bielefeld
Hand #P4-85740054-299
Started At 09 Jan 2009 01:16 PM Westeuropäische Normalzeit
Ended At 01 Jan 1970 01:00 AM Westeuropäische Normalzeit

Seat 1: nowaiiiiii ($285.70 in chips)
Seat 4: BGRAUNA ($201.00 in chips)

ANTES/BLINDS

PRE-FLOP

SHOWDOWN

SUMMARY
Dealer: nowaiiiiii
Pot: $0.00
nowaiiiiii loses $0.00
BGRAUNA loses $0.00



Texas Hold'em $2.00-$4.00 NL (real money)
Table Debrecen
Hand #P4-85746852-216
Started At 09 Jan 2009 02:30 PM Westeuropäische Normalzeit
Ended At 01 Jan 1970 01:00 AM Westeuropäische Normalzeit

Seat 1: lectpl ($172.70 in chips)
Seat 3: mgvt_11 ($384.45 in chips)
Seat 4: from Russia ($185.00 in chips)

ANTES/BLINDS

PRE-FLOP

SHOWDOWN

SUMMARY
Dealer: from Russia
Pot: $0.00
lectpl loses $0.00
mgvt_11 loses $0.00
from Russia loses $0.00



Texas Hold'em $2.00-$4.00 NL (real money)
Table Ilmenau
Hand #P4-85739405-554
Started At 09 Jan 2009 03:01 PM Westeuropäische Normalzeit
Ended At 01 Jan 1970 01:00 AM Westeuropäische Normalzeit

Seat 3: Stingerben ($154.50 in chips)
Seat 10: Kuljashin ($103.00 in chips)

ANTES/BLINDS

PRE-FLOP

SHOWDOWN

SUMMARY
Dealer: Kuljashin
Pot: $0.00
Stingerben loses $0.00
Kuljashin loses $0.00

and importerrors.log ist 30 MB big...

babaa
01-09-2009, 02:08 PM
a buddy imported the same file in PT3...and hab 2 errors...


wtf

Al1
01-09-2009, 04:38 PM
Can you attach those hands here. I will try to import them in my HEM.

babaa
01-09-2009, 09:28 PM
dont have the HH, just this error log

and i also notices a SQlerrors.txt in the HEM folder

it says: The Error: ERROR: 25P02: current transaction is aborted, commands ignored until end of transaction block

Occurred when running ExecuteNonQuery with this query: SAVEPOINT beforegame;

Al1
01-10-2009, 06:49 AM
You don't have the 7K hands anymore?

babaa
01-10-2009, 09:24 AM
well, it was a 26mb file..

can i attach it here, or can i send it per email?

Al1
01-10-2009, 01:40 PM
well, it was a 26mb file..

can i attach it here, or can i send it per email?

Check your PMs.

Al1
01-11-2009, 04:57 PM
I have imported successfully 9K hands with only 2 errors.

Can you create a new DB and try an import: http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146

If it don't works, can you reinstall HM completely:

1) Make a backup of "Config" in a safe location
2) Export your HUDs via "HUD Options => Player Preferences"
3) Uninstall HM via the Control Panel
4) Go to Program Files and delete the RVG Software directory, or the equivalent for Vista
5) Reboot your computer
6) Install the complete setup of HM: http://www.holdemmanager.com/downloads/holdemmanager.zip
7) Upload HM: http://www.holdemmanager.com/downloads/HmUpdate1.07beta.exe
8) Test if it works for a while and if it does proceed to step 9
9) Overwrite the backuped "holdemmanager.config" file in the new Config directory to recover your settings
10) Test if it works again for another while and if it does proceed to step 11
11) Import your HUDs via "HUD Options => Player Preferences"
12) Test if it works

babaa
01-12-2009, 12:50 AM
Ok, a new database a worked.

So, now I just export the hands from that broken DB and import it in the new one, right?

Al1
01-12-2009, 02:11 AM
Ok, a new database a worked.

So, now I just export the hands from that broken DB and import it in the new one, right?

Yep. Or use your original HHs files if you have them, it's more easy.
http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173

babaa
01-12-2009, 05:18 AM
Ok, thank you.

Everything seems fine now, but there is still that- SQL error(5) : database is locked - when i mine and autoimport simultaniously.

Al1
01-12-2009, 08:23 AM
Ok, thank you.

Everything seems fine now, but there is still that- SQL error(5) : database is locked - when i mine and autoimport simultaniously.

Escalated to morny (Support), he will answer asap.

morny
01-12-2009, 04:40 PM
Ok, thank you.

Everything seems fine now, but there is still that- SQL error(5) : database is locked - when i mine and autoimport simultaniously.

Where do you get that error, does it popup or something? Have you PT3 or something similar running at the same time.

babaa
01-12-2009, 05:44 PM
Yeah, it just pops up.

No, i use only HEM.

babaa
01-17-2009, 04:05 PM
bump

morny
01-17-2009, 04:36 PM
Please attach your holdemmanager.config file from C:\Program Files\RVG Software\Holdem Manager\Config folder and i look into it further.

babaa
01-17-2009, 06:52 PM
I hope this worked.

773

morny
01-17-2009, 10:22 PM
C:\Poker\OnGame Hand Grabber\textlog
C:\Poker\OnGame Hand Grabber\databases
E:\ohg text

Remove the above from the auto import folder list and restart HM and see if the problem persists

babaa
01-18-2009, 02:36 PM
It's still there.

morny
01-18-2009, 02:45 PM
Please try uninstalling and reinstalling postgreSQL and see if that helps http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=177 it also might be worth posting this on the PostgreSQL forums to see if theyve any idea as ive not seen this before

morny
01-18-2009, 03:04 PM
Ok i just realised that you using the OHG as i missed that and spotted the same error in another thread, your getting this because HM and OGH are trying to access the same file but you do know HM works without Ongame? So just stop using the OGH and it should be fine