Open Forum

Like what you see? Discover the benefits of the GPUG Community. Learn More

GP Error pop-ups when changing between companies and logging off GP

  • 1.  GP Error pop-ups when changing between companies and logging off GP

    SILVER CONTRIBUTOR
    Posted 7 days ago

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


  • 2.  RE: GP Error pop-ups when changing between companies and logging off GP

    GPUG ALL STAR
    Posted 6 days ago
    @Tonia Stephens

    Please make sure that the user does not sleep or hibernate their machine or swap from wired LAN to wireless (undocking a laptop).

    All of these are methods to break your connection to SQL. When GP reconnects it will be via a different SPID and the new SQL Process ID will not have access to any temporary ## tables that were created with the original SPID. Hence the errors.

    Regards

    David​​

    ------------------------------
    David Musgrave MVP, GPUG All-Star

    Managing Director
    Winthrop Development Consultants

    Perth, Western Australia

    http://www.winthropdc.com
    ------------------------------



  • 3.  RE: GP Error pop-ups when changing between companies and logging off GP

    GOLD CONTRIBUTOR
    Posted 6 days ago
    ​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
    ------------------------------



  • 4.  RE: GP Error pop-ups when changing between companies and logging off GP

    TOP CONTRIBUTOR
    Posted 6 days ago
    ​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
    ------------------------------