GP2013 on SQL2012 Timing Out?

This question is not answered

I have a client where people who leave MDGP 2013 untouched for a while receive an error message stating "A remove range operation on table 'syContentPageXMLCache' cannot find the table" when they resume using GP.

The More Info is "[Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid object name '##1675106'".

It looks to me like it might be a timeout but I wondered if anyone could shed more light on the issue? Hopefully including a resolution.

This is Microsoft Dynamics GP 2013 running on SQL Server 2012.

Thanks.

Ian


Author of azurecurve|Ramblings of a Dynamics GP Consultant
Senior Consultant at Perfect Image Ltd

Perfect Image/ Dynamics GP
Tel: +44 (0) 843 289 2656
1 Kings Manor, Newcastle upon Tyne, NE1 6PA, United Kingdom

All Replies
  • You can try by setting as 'Never' for sleep mode.

    I have seen errors like FP:Couldn't Close table when users do not use their machine for sometime. This error occurs due to the interruption in network connection as system goes to sleep mode. I have seen results by changing the sleep option to Never for this error. I would suggest you can also try this.

    Hope this helps.

    RENJAN MATHEW VARUGHESE

    DYNAMICS GP CONSULTANT, MCP, PMP

  • Hi Renjan,

    Where is this setting?

    Ian


    Author of azurecurve|Ramblings of a Dynamics GP Consultant
    Senior Consultant at Perfect Image Ltd

    Perfect Image/ Dynamics GP
    Tel: +44 (0) 843 289 2656
    1 Kings Manor, Newcastle upon Tyne, NE1 6PA, United Kingdom

  • Do you have any third party products installed on GP?  There is one that logs people out after a specific amount of time.  You may need an upgrade to this.

    Richard L. Whaley Author, Publisher, Consultant

    http://www.AccoladePublications.com

    Enhancing your Dynamics Knowledge!

  • No, there are no third party addons.


    Author of azurecurve|Ramblings of a Dynamics GP Consultant
    Senior Consultant at Perfect Image Ltd

    Perfect Image/ Dynamics GP
    Tel: +44 (0) 843 289 2656
    1 Kings Manor, Newcastle upon Tyne, NE1 6PA, United Kingdom

  • The setting is in Control Panel >> PowerOptions.

    Click on 'Change plan settings' for the plan which is selected.

    Select 'Never' for 'Put the computer to sleep'

    RENJAN MATHEW VARUGHESE

    DYNAMICS GP CONSULTANT, MCP, PMP

  • Control Panel>Power options...

    I have seen this in GP 10, when the default settings  were changed the interruptions stopped.

  • Hi Ian,

    Thanks for posting this.  We have a client that also is getting this error, and, thanks to you, we now have a fast resolution.  Thanks to Rejan, too, for the solution!

    Thanks,

    Judy

     Judy Hirst CMA

    Senior Financial Systems Consultant| Etelligent Solutions

    (403) 204-6930 | jhirst@esicanada.com

     

  • Is there any other settings to check regarding this issue? I have a client with the same issue occurring on the Terminal Server - I checked the Power Options on both the SQL Server and the Terminal Server and the 'Put The Computer To Sleep' is set to NEVER for both machines.  

    Anything else that can cause the Network Connection to timeout or cause connection issues?