web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / Server to Server CRM 2...
Microsoft Dynamics CRM (Archived)

Server to Server CRM 2016 On-Premise to SharePoint 2013 On-Premise Integration issues BUGS?

(0) ShareShare
ReportReport
Posted on by BobBreton

Hi

Not sure if anyone else uses CRM 2016 and SharePoint2013 both On-Premise Server to Server with OWA (WOPI) integration? The issue I will describe is rather strange but the documents Word, Excel and PowerPoint all seem to show in the CRM grid as having the same editurl as the first upload document under an account or any other entity. We verified that the documents are indeed on SharePoint are different, in fact opening the location and then selecting any of the documents they open fine in both OWA and the office application. But when trying to open them from CRM they always open the first document even if the selected document is Excel or Power Point the document that was first uploaded being a word document well we get that word document. The grid HTML is below and shows this is by design. Is this a serious BUG in CRM->SP on-premise integration or something I can configure differently?

#1 Document:

First document (absoluteurl): intranet.trapptechnology.com/.../Test Account1_3C2A4D755548E61180E30050569F48D9/CRM_CW_ETL.docx

editurl="intranet.trapptechnology.com/.../WopiFrame.aspx Account1_3C2A4D755548E61180E30050569F48D9/CRM_CW_ETL.docx&action=edit"

readurl="intranet.trapptechnology.com/.../WopiFrame.aspx Account1_3C2A4D755548E61180E30050569F48D9/CRM_CW_ETL.docx&action=view"

#2 Document

absoluteurl="intranet.trapptechnology.com/.../Test Account1_3C2A4D755548E61180E30050569F48D9/excel New 2.xlsx" editurl="https://intranet.trapptechnology.com/CRM/_layouts/15/WopiFrame.aspx?sourcedoc=/CRM/account/Test Account1_3C2A4D755548E61180E30050569F48D9/CRM_CW_ETL.docx&action=edit"

readurl="intranet.trapptechnology.com/.../WopiFrame.aspx Account1_3C2A4D755548E61180E30050569F48D9/CRM_CW_ETL.docx&action=view"

#3 Document

absoluteurl="intranet.trapptechnology.com/.../Test Account1_3C2A4D755548E61180E30050569F48D9/New Excel.xlsx"

editurl="intranet.trapptechnology.com/.../WopiFrame.aspx Account1_3C2A4D755548E61180E30050569F48D9/CRM_CW_ETL.docx&action=edit"

readurl="intranet.trapptechnology.com/.../WopiFrame.aspx Account1_3C2A4D755548E61180E30050569F48D9/CRM_CW_ETL.docx&action=view">

S2SBuggy.png

<tr class="ms-crm-List-Row-Lite" onmouseover="Mscrm.GridControl.mouseOver(this);" onmouseout="Mscrm.GridControl.mouseOut(this);" onclick="Mscrm.GridControlLite.SelectRow(this)" otypename="sharepointdocument" otype="9507" oid="{3D0A85E6-C17B-45D2-9DD7-5B0FECE58A62}" author="Bob Breton" filetype="docx" locationid="70eabcc9-7886-e611-80ef-0050569f7caf" absoluteurl="intranet.trapptechnology.com/.../Test Account1_3C2A4D755548E61180E30050569F48D9/CRM_CW_ETL.docx" iconclassname="officeIcon wordFile" ischeckedout="0" sharepointdocumentid="{3D0A85E6-C17B-45D2-9DD7-5B0FECE58A62}" sharepointmodifiedby="Bob Breton" documentid="11" sharepointcreatedon="2016-09-29T12:13:31" editurl="intranet.trapptechnology.com/.../WopiFrame.aspx;amp;action=edit" readurl="intranet.trapptechnology.com/.../WopiFrame.aspx;amp;action=view">

                                                <tr class="ms-crm-List-Row-Lite" onmouseover="Mscrm.GridControl.mouseOver(this);" onmouseout="Mscrm.GridControl.mouseOut(this);" onclick="Mscrm.GridControlLite.SelectRow(this)" otypename="sharepointdocument" otype="9507" oid="{64E21F0C-5E69-4E68-A298-099F56E38A88}" author="Bob Breton" filetype="xlsx" locationid="70eabcc9-7886-e611-80ef-0050569f7caf" absoluteurl="intranet.trapptechnology.com/.../Test Account1_3C2A4D755548E61180E30050569F48D9/excel New 2.xlsx" iconclassname="officeIcon excelFile" ischeckedout="0" sharepointdocumentid="{64E21F0C-5E69-4E68-A298-099F56E38A88}" sharepointmodifiedby="Bob Breton" documentid="14" sharepointcreatedon="2016-09-29T12:18:18" editurl="intranet.trapptechnology.com/.../WopiFrame.aspx;amp;action=edit" readurl="intranet.trapptechnology.com/.../WopiFrame.aspx;amp;action=view">

                                               

<tr class="ms-crm-List-Row-Lite" onmouseover="Mscrm.GridControl.mouseOver(this);" onmouseout="Mscrm.GridControl.mouseOut(this);" onclick="Mscrm.GridControlLite.SelectRow(this)" otypename="sharepointdocument" otype="9507" oid="{4397D3B5-E6FA-4B84-9D7A-30F6AEA5B484}" author="Bob Breton" filetype="xlsx" locationid="70eabcc9-7886-e611-80ef-0050569f7caf" absoluteurl="intranet.trapptechnology.com/.../Test Account1_3C2A4D755548E61180E30050569F48D9/New Excel.xlsx" iconclassname="officeIcon excelFile" ischeckedout="0" sharepointdocumentid="{4397D3B5-E6FA-4B84-9D7A-30F6AEA5B484}" sharepointmodifiedby="Bob Breton" documentid="13" sharepointcreatedon="2016-09-29T12:15:01" editurl="intranet.trapptechnology.com/.../WopiFrame.aspx;amp;action=edit" readurl="intranet.trapptechnology.com/.../WopiFrame.aspx;amp;action=view">

                                               

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Avishesh Shrestha Profile Picture
    Avishesh Shrestha 50 on at
    RE: Server to Server CRM 2016 On-Premise to SharePoint 2013 On-Premise Integration issues BUGS?

    Microsoft provided latest update (KB4078185) that fixed the issue of D365 and SharePoint integration, as raised by BobBrenton :)

  • Avishesh Shrestha Profile Picture
    Avishesh Shrestha 50 on at
    RE: Server to Server CRM 2016 On-Premise to SharePoint 2013 On-Premise Integration issues BUGS?

    Hi guys

    We have exactly same issue as well. We have raised the issue with Microsoft premier-support. I will update once the issue is resolved.

    Cheers,

    -avi

  • Community Member Profile Picture
    Community Member on at
    RE: Server to Server CRM 2016 On-Premise to SharePoint 2013 On-Premise Integration issues BUGS?

    Hi,

    I try using Office Web Apps in Sharepoint 2013, and Dynamics CRM 2016

    and i facing this problem, too.

  • ronsonpetrenko Profile Picture
    ronsonpetrenko 276 on at
    RE: Server to Server CRM 2016 On-Premise to SharePoint 2013 On-Premise Integration issues BUGS?

    Hi Bob!

    I have faced too this UNKNOWN behavior.

    Did you resolved this bug?

  • BobBreton Profile Picture
    BobBreton on at
    RE: Server to Server CRM 2016 On-Premise to SharePoint 2013 On-Premise Integration issues BUGS?

    More Info:

    If I run: Remove-SPWOPIBinding –All:$true on SharePoint and then in CRM Click [Document Management Settings] and follow the wizard to configure my SharePoint Document libraries the Documents all open correctly in the client application.

    I then run New-SPWOPIBinding –ServerName ... and rebind WOPI to sharepoint, everything in CRM seems to link correctly still, I click an existing document, it opens in the client application (Like word...), I create a new document word... and it open in WOPI in Browser. After I create it, I open it again it opens in the client.

    If I then run [Document Management Settings] while SharePoint is bound to WOPI, I am presented again with my problem originally stated. The URL's generated in the Server based CRM grid are all opened as if they are the first document in WOPI even if the clicked document is WORD, or Excel or even PowerPoint. This only affects WOPI enabled documents because PDF's and Text files open correctly.

    I believe this is a bug related to SharePoint On-Premise, OWA (Office Web Apps Server) and CRM Dynamics On-Premise and needs to be addressed by Microsoft yet I have no support agreement nor should I have to in able to submit an actual Bug. Curious how many others run an on premise setup like this and are able to duplicate the issue.

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

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
Aric Levin - MVP Profile Picture

Aric Levin - MVP 2 Moderator

#2
MA-04060624-0 Profile Picture

MA-04060624-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans