Open Forum

Expand all | Collapse all

Adjust Cost fails with SQL server connection error

  • 1.  Adjust Cost fails with SQL server connection error

    Posted Jan 07, 2020 10:53 AM
    Dear valuable Community Members - Happy New Year! Your contributions are very much appreciated.

    This is happening when Adjust Cost runs on the Job Queue - on occasion.
    Also when I run Adjust Cost manually for one Item - After 45-60 min.
    We using NAV 2016 with SQL Server version 2016 Service Pack 2.

    Has anyone seen this error and what can be done to fix it? Any ideas are welcome.
    Logs apparently do not show anything useful according to out infrastructure expert.
    Here is the complete text of the error.

    A Connection to SQL Server is no longer usable.
    This could be caused by one of the following reasons:
    The Server has been shut down manually or because of an error.
    The SQL Server Connection Settings are not correct.
    A Network failure has occurred.
    A hardware failure has occurred on the server or on your computer.

    Try to connect again later or contact your system administrator.

    Aydan Golaszewski
    Lead ERP Analyst
    Jason Pharmaceuticals (Medifast)
    Owings Mills MD
    Academy - Online Interactive Learning from Experts

  • 2.  RE: Adjust Cost fails with SQL server connection error

    Posted Jan 14, 2020 10:42 AM
    Hi Ayden,

    Not sure if you already figured it out or not. I have seen this error in the past. In our case, it was caused by the expiration of the password for the login that runs the adjust cost. Some times it would run as I would restart the service but then it would run under my login but as soon as I switched it to NAV service account, it would stop running. Even if that account is set to not expire, just re-enter the password and restart the service.

    Good luck!

    Meenakshi Singh
    Senior Manager, Business Applications
    Home Market Foods, Inc.
    NAVUG Programming Committee

    Academy - Online Interactive Learning from Experts

If you've found this thread useful, dive deeper into User Group community content by role