PDA

View Full Version : Problem creating HEM db



Epic Monolith
08-06-2008, 01:33 AM
I just purchased HEM, and I keep receiving this error message when I try to create a Holdem Manager database:

"Connection establishment timeout. Increase Timeout value in ConnectionString."

What does this mean, and what do I need to do to resolve this?

Regards,

Chris

fabio
08-06-2008, 02:41 AM
Hi Chris,

make sure PostgreSQL is running.

domino66
08-07-2008, 09:23 AM
Hi Chris,

make sure PostgreSQL is running.

I'm getting this exact error too...and i posted about it in your forums without knowing that the Q had been asked already:
http://208.109.95.123/forum/showthread.php?t=942

But the weird thing is that it only pops up half way thru an import. I exported 400K HHs to file from a PT2 DB, and set up HEM to import them all...it got about 1/3 of the way thru the import, and then gave me that error...and now i can't even import a single more HH file >> it just keeps giving me that error.

What do u mean make sure postgres is running? How do i make sure that it is? (And how could that be the problem when HEM successfully gets thru 1/3 of the import, but THEN gives me that error?)

Last Q while I have your attention here: what's the quickest way to check in HEM how many TOTAL HHs are in a DB? I want to check that so i know exactly how far into the import process it got before giving me the error.

morny
08-07-2008, 10:01 AM
http://208.109.95.123/faq/?f=34 How to restart PostgreSQL if it stops

http://208.109.95.123/faq/?f=19 How to get total HH in the database

domino66
08-07-2008, 10:05 AM
http://208.109.95.123/faq/?f=34 How to restart PostgreSQL if it stops

http://208.109.95.123/faq/?f=19 How to get total HH in the database

Don't have time to try this now, but something caught my eye in that first FAQ -- both times I've gotten this error it's while I've had a PT2 import running simultaneously...could that be the problem?

p.s. those instructions seem to be for Vista (?) -- b/c in my control panel, i don't have an "Administrative Tools" option...can u tell me what the corrolary would be for XP?

morny
08-07-2008, 10:15 AM
Its very possible that PT running together is causing a problem as they both use PostgreSQL although that dosent mean to say they shouldnt be able to function at the same time as they are using different databases, however if both are using the same folders to import from at the same time it could cause permission problems etc plus youll find HM wont be able to move some processed files aswell because PT is using them

Same in Vista and XP, they both have Administrative tools, in category view its under Maintenance IIIRC and in classic view youll find it 4 or 5 icons in 100% is definetely there you must have just missed it.

fabio
08-07-2008, 10:25 AM
Don't have time to try this now, but something caught my eye in that first FAQ -- both times I've gotten this error it's while I've had a PT2 import running simultaneously...could that be the problem?

Possible.