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.
select * from DYNAMICS..ACTIVITYselect * from DYNAMICS..SY00800select * from DYNAMICS..SY00801select * from TEMPDB..DEX_LOCKselect * from TEMPDB..DEX_SESSIONDelete DYNAMICS..ACTIVITYDelete DYNAMICS..SY00800Delete DYNAMICS..SY00801Delete TEMPDB..DEX_LOCKDelete TEMPDB..DEX_SESSION
DELETE TempDB..DEX_LOCK where Session_ID not in (
SELECT SQLSESID from DYNAMICS..ACTIVITY)
DELETE TempDB..DEX_SESSION where Session_ID not in (
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.
If you've found this thread useful, dive deeper into User Group community content by role