Connection establishment timeout?

[Jun]

everytime i open holdem manager, it will auto start optimization of my own stats. after 30 mins working, it returns

The following error occurred:Connection establishment timeout. Increase timeout value in connectionstring.

i am using 1.09 beta 23a and i do have a huge database.

thx

-jun

[fozzy71]

The optimize reports should only happen once, per player imported with known hole cards. It usually happens after a bulk import.

Please update to the latest beta - http://www.holdemmanager.com/downloads/HmBetaUpdate.exe.

Reboot, and run the installer first thing.

If it continues to optimize every time you restart HM:

You can disable this (make sure HM is closed) by going into the Holdem Manager\Config folder then right click and choose "New text Document" and name it NoOpt. Next time you launch HM it should skip this process.
__________________

[Jun]

well, i stopped the opt by using ur method. thanks

but, it seems that hm is not working properly.

i am seeing all the data in sessions tab, but in reports tab, i am only seeing the data from the last session played.

don't tell me that i need to rebulit the database cuz my data is pretty large.

thx

-jun

[fozzy71]

....

don't tell me that i need to rebulit the database cuz my data is pretty large.
.....

http://i207.photobucket.com/albums/bb176/fozzy71/Smileys/tape.gif

Unfortunately, that is often the sign of a corrupt DB. You can try a Reindex thru PGAdmin3 > Maintenance (same window as the Vacuum DB option), but I wouldnt really expect it to fix this.

http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=163


*Try creating a new UTF DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=146
*Now import a small portion of your \HMArchive so you can see if the problem exists in the new DB - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=173
*If the new DB seems to work properly, you will want to import the rest of your archives to the new DB, export/import the hands from the old DB to the new DB, and export/import any player notes and tourney summaries - and then delete the old DB. - http://www.holdemmanager.net/faq/afmviewfaq.aspx?faqid=21

Make sure you export/backup everything before deleting the old DB - http://www.holdemmanager.net/forum/showthread.php?t=20754