Refining Mark LaRette's answer,
You can only run his SQL script when nobody is logged into the system.
This is a query you can run at any time,
it works best if you first delete any orphaned ACTIVITY records for users who are not really logged in.
DELETE TempDB..DEX_LOCK where Session_ID not in (
SELECT SQLSESID from DYNAMICS..ACTIVITY)
DELETE TempDB..DEX_SESSION where Session_ID not in (
SELECT SQLSESID from DYNAMICS..ACTIVITY)
DELETE FROM [DYNAMICS].[dbo].[SY00800] WHERE [USERID] not in(
SELECT [USERID] FROM [DYNAMICS].[dbo].[ACTIVITY] )
DELETE FROM [DYNAMICS].[dbo].[SY00801] WHERE [USERID] not in(
SELECT [USERID] FROM [DYNAMICS].[dbo].[ACTIVITY] )
These are derived from a script originally suggested by GP Support.
------------------------------
Bruce Strom
Programmer Analyst
Associated Grocers of Florida / Supervalu
Sunrise FL
------------------------------
Original Message:
Sent: 12-05-2018 02:47 PM
From: Bruce Strom
Subject: GP Error pop-ups when changing between companies and logging off GP
In google type in the error message,
A remove operation on table 'syContentPageXMLCache' cannot find the table.
You will get what looks like many useful references to this problem.
------------------------------
Bruce Strom
Programmer Analyst
Associated Grocers of Florida / Supervalu
Sunrise FL
Original Message:
Sent: 12-05-2018 09:53 AM
From: Mark LeRette
Subject: GP Error pop-ups when changing between companies and logging off GP
You might want to clear out old sessions and locks. Find or schedule a time when all users will be out of the system, go into SQL Server Management Studio and connect to the GP database server. Then perform the following scripts on the DYNAMICS and TEMPDB datbases:
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
There are several other suggestions at the link below, but I've found the above scripts remedy alot of connection problems.
https://support.microsoft.com/en-us/help/3201492/a-remove-range-operation-on-table-sycontentpagexmlcache-cannot-find-th
------------------------------
Mark LeRette
Application System Analyst II
Muscatine Power and Water
Muscatine IA
Original Message:
Sent: 12-04-2018 02:01 PM
From: Tonia Stephens
Subject: GP Error pop-ups when changing between companies and logging off GP
Hello GP Users,
We have an AP Clerk who is getting the following errors when changing between companies and some times at log off. She says that it has always happened but just once in awhile and has nothing to do with our recent GP upgrade from 2013 R2-2016 R2 or her new Windows 10 computer. They look like disconnect from server errors or that GP is being disconnected from the server. Can anyone assist with what may be causing these intermittent errors?
1.) "A remove operation on table 'syContentPageXMLCache' cannot find the table.
2.) "[Microsoft][SQL Server Native Client 11.0][SQL Server] invalid object name '##1515903'.
3.) The following box with error popped up 5 times before it went away completely.
FP: Couldn't close table!
4.) "A SQL network connection error occurred and your connection was cleared. This probably occurred because all available connections to the server are in use. Please try again later.
Thank you,
------------------------------
Tonia Stephens
Finance Systems Manager
Stinker Stores, Inc.
Boise ID
------------------------------