Skip to main content

Notifications

Dynamics 365 Community / Forums / Field Service forum / Copy Agreement - Gener...
Field Service forum

Copy Agreement - Generic SQL Error

Posted on by 719

I am trying to copy Agreements using the out-of-the-box 'Copy Agreement' functionality and am getting generic sql error. See screen shot below. 

2018_2D00_07_2D00_16-16_5F00_03_5F00_20_2D00_Agreement_5F00_-AGT00138.png

Does anyone know how to troubleshoot or resolve this?

Thanks!

Categories:
  • Suggested answer
    Inksrm Profile Picture
    Inksrm 719 on at
    RE: Copy Agreement - Generic SQL Error

    Finally heard back from Microsoft Support.

    Apparently this is a known issue/bug and it will be fixed in a future update however they can't give me a date or update version number.

    Will continue to post updates here as I receive them.

  • Inksrm Profile Picture
    Inksrm 719 on at
    RE: Copy Agreement - Generic SQL Error

    Bumping up.

    Microsoft Support are not responding to my service request so bumping this up in case anyone else has come across the issue.

  • Inksrm Profile Picture
    Inksrm 719 on at
    RE: Copy Agreement - Generic SQL Error

    I have raised a service request with Microsoft to help with this. Will post any updates here.

  • Inksrm Profile Picture
    Inksrm 719 on at
    RE: Copy Agreement - Generic SQL Error

    Hi Judy,

    Answers below:

    1. Yes I am the System Administrator
    2. Yes, the issue happens with all the Agreements
    3. Yes, I have tried clearing the browser cache as well as trying in different browsers
    4. We are using Dynamics 365 Online, v9.0.

    Any other ideas or troubleshooting tips?

    Regards,

    Inksrm

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Copy Agreement - Generic SQL Error

    Hi,

    1.  Are you the system administrator for Dynamics 365?

    2. Does this issue happen with all the Agreements?

    3. Have you cleaned the web browser cache and try again?

    4.. Do you use Dynamics 365 Online or Dynamics 365 On-premises?

    If you are using Dynamics 365 On-premises, you could try to restart CRM DB , application  and async server .

    Once restart server go to application server and restart all Dynamics 365 related services by going to Windows services using services.msc.

    Also restart the Microsoft SQL server services in your database server.

    Clear all cache , cookie from server.

    Hope it makes sense.

    BR,

    Judy

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Give Back to the Community this Month

Quick Links

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,807 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,135 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans