PDA

View Full Version : Play Hand Error



jgunnip
08-06-2008, 08:27 PM
This might be a table manager thing since it's affected my hud. I am frequently getting this message.

"Player Hand Error: Connection estabslishment timeout. Increase Timeout value in ConnectionString."

What is this and how do I fix it? It appears to be causing my HUD to lag severely and freeze up my tables.

I just manually vacuumed my db but started getting the message like the session before I did that. I have installed the latest patch (1.06.01p) and am using windows XP.


edit- I've reinstalled the patch and still have the same problem.

edit2- it appears it is strictly an import problem. When the notification pops up the import stops. Even if I don't have any tables open.

morny
08-07-2008, 10:33 AM
If it happens can you verify whether the postgreSQL service is running or not and restart it if not. http://208.109.95.123/faq/?f=34

Are you using PT at the same time?

jgunnip
08-07-2008, 02:35 PM
yes, postgreSQL is running. fwiw I'm usuing 8.0. PT is not running.

jgunnip
08-07-2008, 03:56 PM
would it be possible to troubleshoot this over AIM or teamviewer? I'd really like to fix this ASAP.

morny
08-07-2008, 05:21 PM
Ill be available for the next hour if youd like to email me at morny@holdemmanager.net and if not let me know a suitable time tommorrow. I can do teamviewer.

morny
08-07-2008, 05:33 PM
Actually ive been looking into this and it appears this is one of those errors that indicate something like anti virus / firewall / komodo type software is getting in the way of the connection between HM and postgres. The timeout is 15 seconds - normally it takes a few milliseconds to create a connection.

Can you disable any of these kind of software to test, also sometimes a simple reboot does the trick but basically close down any non essential programs to make sure something isnt blocking them

jgunnip
08-07-2008, 07:35 PM
I made exceptions for the HEM folder in my Windows and AVG Firewall so it doesn't scan/block anything in there and rebooted.

Upon opening up HEM I got this message,

"The following error has occured when tryin to open database: Connection establishment timeout. Increase Timeout value in ConnectionString."

I pressed ok and was prompted by the Connect to postgreSQL dbcontrol box. Connected and after a minutes it said that HEM was already running and shut down.

I ctrl-alt-deleted and only Firefox and FTP were running. I checked the processes and there was the HMImport.exe running so I quick that and reopened HEM.

I then opened up HEM again, this time it worked. Opened up a FTP table and began auto import. However the screen just stayed at "starting import..." while I played a few orbits. It did not seem to respond when I clicked the Stop Import button. I then tried to exit out of HEM and got the "Import is still running do you want to exit and have HoldemManager stop the import?" prompt. I clicked yes, then got a Microsoft .NET Framework box that said,

"Unhandled exception has occured in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately."

Details,


See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.InvalidOperationException: Collection was modified; enumeration operation may not execute.
at System.Collections.ArrayList.ArrayListEnumeratorSi mple.MoveNext()
at System.Windows.Forms.Application.ExitInternal()
at System.Windows.Forms.Application.Exit(CancelEventA rgs e)
at System.Windows.Forms.Application.Exit()
at HoldemManager.ଚ.෥(Object ՘, EventArgs ՙ)
at System.Windows.Forms.ToolStripItem.RaiseEvent(Obje ct key, EventArgs e)
at System.Windows.Forms.ToolStripMenuItem.OnClick(Eve ntArgs e)
at System.Windows.Forms.ToolStripItem.HandleClick(Eve ntArgs e)
at System.Windows.Forms.ToolStripItem.HandleMouseUp(M ouseEventArgs e)
at System.Windows.Forms.ToolStripItem.FireEventIntera ctive(EventArgs e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStripItem.FireEvent(Event Args e, ToolStripItemEventType met)
at System.Windows.Forms.ToolStrip.OnMouseUp(MouseEven tArgs mea)
at System.Windows.Forms.ToolStripDropDown.OnMouseUp(M ouseEventArgs mea)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Mes sage& m)
at System.Windows.Forms.ToolStrip.WndProc(Message& m)
at System.Windows.Forms.ToolStripDropDown.WndProc(Mes sage& m)
at System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///c:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
----------------------------------------
HoldemManager
Assembly Version: 1.6.0.0
Win32 Version: 1.6.0.0
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/HoldemManager.exe
----------------------------------------
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
----------------------------------------
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
----------------------------------------
DevComponents.DotNetBar2
Assembly Version: 7.3.0.1
Win32 Version: 7.3.0.1
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/DevComponents.DotNetBar2.DLL
----------------------------------------
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
----------------------------------------
HMClass
Assembly Version: 1.0.0.0
Win32 Version: 1.0.0.0
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/HMClass.DLL
----------------------------------------
System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll
----------------------------------------
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
----------------------------------------
DeployLX.Licensing.v3
Assembly Version: 3.1.2000.0
Win32 Version: 3.1.2000.19165
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/DeployLX.Licensing.v3.DLL
----------------------------------------
System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll
----------------------------------------
System.Web
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll
----------------------------------------
Softelvdm.SftTreeNET
Assembly Version: 2.0.5.0
Win32 Version: 2.0.5.0
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/Softelvdm.SftTreeNET.DLL
----------------------------------------
Softelvdm.Controls
Assembly Version: 1.0.0.8
Win32 Version: 1.0.0.8
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/Softelvdm.Controls.DLL
----------------------------------------
Npgsql
Assembly Version: 1.98.4.0
Win32 Version: 1.98.4.0
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/Npgsql.DLL
----------------------------------------
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
----------------------------------------
System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.1433 (REDBITS.050727-1400)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll
----------------------------------------
Mono.Security
Assembly Version: 2.0.0.0
Win32 Version: 2.0.0.0
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/Mono.Security.DLL
----------------------------------------
ZedGraph
Assembly Version: 5.1.0.621
Win32 Version: 5.1.0.621
CodeBase: file:///C:/Program%20Files/RVG%20Software/Holdem%20Manager/ZedGraph.DLL
----------------------------------------

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

morny
08-08-2008, 02:25 PM
Did you add holdemmanager.exe,hmhud.exe and dbcontrolpanel.exe to the exceptions list? Analternative is to completely close it down just to verify

jgunnip
08-08-2008, 05:45 PM
I disabled Windows Firewall and terminated avgsrx.exe but still get the message.

jgunnip
08-08-2008, 07:54 PM
I have started a new db in 8.2.9 and will just reimport that hands. I was able to reimport all of my played hands from my HEM processed hands file without any trouble and am currently importing my exported hands from PT.

One question I have though is how do I reimport the observed hands I imported while running HEM on my 8.0 db?