"A remove range operation on table 'syContentPageXMLCache' cannot find the table" message when processing in Microsoft Dynamics GP

Applies to: Dynamics GP 2016Microsoft Dynamics GP 2015Dynamics GP 2013

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 date 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