Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Suggested answer

GP18R2 - "Unable to preview this attachment" on client machines only

Posted on by 445

Our customer has been using GP attachments for over a year and today none of them can view an existing attachment or attach something new.  If they try to view one they get "Unable to preview this attachment".  If they try to add one they get "A save operation on table 'coAttachMSTR' has created a duplicate key".

I saw this many times with GP15, but this is an existing GP18R2 customer.  We tested with a regular user, a new test user and the 'sa' user.  All of them can view and attach on the GP SQL server, but none of them (including 'sa') can view or attach from any client machine.  I have asked their I.T. dept to let us know if there have been any recent Windows updates to try and roll back but have not heard back yet.  I am wondering if others are having this issue.  Or If this is a known issue.

I appreciate you anticipated guidance!

Althea

  • Suggested answer
    Althea ADS Profile Picture
    Althea ADS 445 on at
    RE: GP18R2 - "Unable to preview this attachment" on client machines only

    Good news - there was one .Net patch available for 1903, they installed it and rebooted and now they can view and add attachments!  Thank you for replying so quick!

  • Althea ADS Profile Picture
    Althea ADS 445 on at
    RE: GP18R2 - "Unable to preview this attachment" on client machines only

    Just tested and only the machines with the Windows 10 1903 update have this issue.  Can anyone from Microsoft test this please?

  • Althea ADS Profile Picture
    Althea ADS 445 on at
    RE: GP18R2 - "Unable to preview this attachment" on client machines only

    Hi Nattis - yes - all clients and the server used the same client install pkg file, so same ODBC.  Their I.T. dept said client machines had just installed the 1903 update for Windows 10 and they cannot roll back.  They have one machine with GP that has not had that update yet so when that user is in they are going to test.  But we believe it is due to this 1903 update.  Not sure who to put the incident with - GP or Windows 10....

  • Nattis Profile Picture
    Nattis 485 on at
    RE: GP18R2 - "Unable to preview this attachment" on client machines only

    Althea,

    ODBC for the GP SQL Server and Client Machine are same?

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans