Symptoms

You get this message when trying to process in Microsoft Dynamics GP

"A remove range operation on table 'syContentPageXMLCache' cannot find the table"


Cause

This message is usually encountered due to a network connection getting dropped or other connectivity issue.

Resolution

We have ways to help test a network disconnect, but it would be up to you to resolve the issue. Helping you dig into this would be considered a consulting service to look at your environment and is out of scope for our regular support policy.

A.) A good test to test the network connectivity on your machine is to have the user go into SQL Server Management Studio and save data from a SQL table into a temp table such as:

select * into ##GL00100 from GL00100


Then periodically have the user query on this table at different times:

select * from ##GL00100


If they ever get the message "invalid object name ##GL00100" then it is because the connection is getting dropped.


B.) Run a continuous ping from the workstation to the SQL database server. Let the ping run, but if you see a 'Request Timed Out" message, this indicates the connection to the server is not stable.

ping SERVERNAME -t -I 65500



C.) In SQL Server Management Studio, right-click on the SQL instance name in the left margin and choose PROPERTIES. In the Server Properties window, click on the CONNECTIONS page. Verify the 'Maximum number of concurrent connections' is set to 0 (zero) which is for unlimited connections. This is the default setting for SQL Server. 

D.) Ensure any Anti-virus software is found in the exclusions from scanning:

  • GP Code folder

  • Any network shares containing shared reports and forms dictionaries

  • The user's TEMP directory



E.) Set up and use a new ODBC System DSN connection using the following KB article:


https://mbs.microsoft.com/customersource/northamerica/GP/learning/documentation/how-to-articles/MDGP_HOWTO_SETUP_ODBC

F.) Check the user's Sleep settings.

Make sure the Network card is not set to sleep. Open Device Manager, right-click on your NIC | Properties | Advanced tab, disable anything that has to do with power saving.

G.) When all users are out of Microsoft Dynamics GP, run these scripts to make sure these tables are empty:
 There tables should be empty when all users are logged out of Microsoft Dynamics GP.

select * from DYNAMICS..ACTIVITY
select * from DYNAMICS..SY00800
select * from DYNAMICS..SY00801
select * from TEMPDB..DEX_LOCK
select * from TEMPDB..DEX_SESSION


Delete DYNAMICS..ACTIVITY
Delete DYNAMICS..SY00800
Delete DYNAMICS..SY00801
Delete TEMPDB..DEX_LOCK
Delete TEMPDB..DEX_SESSION


H.) Restart both the SQL Server and the terminal servers.


I.) Disable TCP Chimney on server and workstations. Refer to these KB articles for more information:


https://support.microsoft.com/en-us/kb/951037

https://support.microsoft.com/en-us/kb/942861
 

More Information

You can also look for more troubleshooting tips in the White Paper:

https://mbs.microsoft.com/customersource/northamerica/GP/learning/documentation/white-papers/MDGP2010_WhitePaper_Performance



Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×