Error “FP Can’t Close Table”

Error “FP Can’t Close Table”

I first discovered this issue when one of the AR users kept calling me with the error everyday after she would come back from lunch. She would find a stopping point in her work and lock her computer without closing her open windows in GP. When she would get back from lunch and login to Windows and try to start working in GP her open windows would freeze and then close out with the error “FP Can’t Close Table”. I was told by Microsoft at a Convergence I attended that this error was happening because GP holds working data in a temporary table until processed/saved and if something causes GP to lose connection to SQL for any reason it resulted in the error because the temporary table was cleared due to the loss of connection to SQL.

There were two things I was told to do to fix the issue:

First, the client computer’s power options needed to be modified so that the option of when to put the hard drive to sleep is set to never.

Second, disable TCP Chimney on the client computer. I did this via the command line with the following scripts:

Command line to Check if TCP Chimney Offload is enabled
netsh int tcp show global

Command line to disable TCP Chimney Offload
netsh int tcp set global chimney=disabled

Confirm TCP Chimney Offload is Disabled.
netsh int tcp show global