locked
Duplicate detection Email referencing incorrect URL RRS feed

  • Question

  • Hi,

    We are using Microsoft CRM 4.0 RU 14 (server) and RU 7 &14 on the Outlook clients.

    After migrating CRM onto a new Server we are finding the duplicate detection system job email alerts are referencing the old server URL:

    Example of email:

    ***********************************

    This Microsoft Dynamics CRM duplication-detection task completed successfully.

    Name: Duplicate Detection: Contacts Advanced Find View - 07/01/2011 14:24:16

    Started: 07/01/2011 14:24

    To view and manage duplicates, do one of the following:

    Click http://OLD_SERVER_NAME:5555/OrgName/tools/asyncoperation/edit.aspx?id={xxxxxxxxx-xxx-xxx-xxxx-xxxxxxxxxxx}

    or

    Log on to Microsoft Dynamics CRM and navigate to System Tasks page and double-click the name of the task.

    ***********************************

    Does anyone know how to change this - I'm presuming this is going to have to be done via a supported change in SQL?

     Many thanks.

     

    Monday, January 10, 2011 10:12 AM

Answers

  • ok, resolved this by editing the CRM system job email template for the duplicate dection
    • Proposed as answer by ckeller Monday, January 10, 2011 11:15 AM
    • Marked as answer by Jim Glass Jr Monday, January 10, 2011 7:03 PM
    Monday, January 10, 2011 11:04 AM

All replies

  • ok, resolved this by editing the CRM system job email template for the duplicate dection
    • Proposed as answer by ckeller Monday, January 10, 2011 11:15 AM
    • Marked as answer by Jim Glass Jr Monday, January 10, 2011 7:03 PM
    Monday, January 10, 2011 11:04 AM
  • We are using MS CRM 4.0 with RU 14 / Client are using OL Client with RU 7 & 14.

    After moving CRM onto a new server we noticed that the duplicate detection email template had the wrong URL constructed in the body. We changed this to the correct URL "{!System Job:System Job;}>http://SERVER/ORGNAME/tools/asyncoperation/edit.aspx?id={!System Job:System Job;}" but now when the email is received the URL appears to be formated incorrectly and it's no not a hyperlink - just text.

    How do we go about amending the URL but keeping the hyperlink in place?

    Friday, January 14, 2011 9:19 AM
  • I'm having this issue too.  I looked in the database, and my old server name is hard-coded in the email text in the body field of the TemplateBase table even though it isn't shown when I edit the email template in CRM.  I'll probably just update the database manually unless someone has a supported way of updating the templates.

    Anyone???
    Thursday, January 27, 2011 11:01 PM
  • Hi,

    I am facing the same issue.

    I am updating the servername by clicking Ctrl + K on url text. After I change the server url, querystring value of id [referring to regardingobjectid field of entity] is not gettting passed in url.

     

     

    Tuesday, March 29, 2011 2:20 PM
  • Hi

    I have issue like this, I upload all customization from dev to production, so the System email templates showing the dev URL of links in templates.

    I tried to edit url by using ctr+k but then URL not get id.

     


    Nitin Pawar
    Tuesday, March 29, 2011 2:25 PM
  • I found the email template a bit tricky to work with, as it is an HTML template.  Normally I would visual studio to create the html then copy the html from the design pane in Visual Studio over to the email template in CRM,  but there is some other magic going on with this template (it completely broke it)

    I ended up having to manually update the TemplateBase table in SQL.

    Monday, July 18, 2011 1:33 PM
  • Can I please ask where in the database you did this or how you solved it?

    Thank you in advance!

    Monday, November 7, 2011 11:33 PM
  • In the organization database, there is a table called TemplateBase.  In management studio, I queried this table for the template I wanted to change.  There is a column in this table called 'Body' that stores the body of the template.  I edited the data in the body column, and that fixed my problem.

    Also what I've done for other templates: we have created new organizations since moving to our new server.  The same template worked correctly from new organizations, so I copied the data from the new organization and pasted in into the body column for the old organization.  Then I changed the URL in the body column to point to the correct organization.

    Make sure to take a backup before editing the database in case you screw up the templates.

    Thursday, November 10, 2011 8:21 PM
  • Hi,

    It's quite an old topic, just want to share the solution.

    You don't need to edit directly the database, you can navigate to Settings > click on templates and locate the templates with the hard-coded url, change it and then save.

    That will fix the issue, and no need to edit the database directly.
    Visit my blog for CRM material, improving performance, kerberos, IFD, development tips, etc. :) http://quantusdynamics.blogspot.com
    • Edited by nrodri Wednesday, December 21, 2011 5:21 PM
    • Proposed as answer by nrodri Wednesday, December 21, 2011 5:21 PM
    Wednesday, December 21, 2011 5:20 PM
  • Hi,

    It's quite an old topic, just want to share the solution.

    You don't need to edit directly the database, you can navigate to Settings > click on templates and locate the templates with the hard-coded url, change it and then save.

    That will fix the issue, and no need to edit the database directly.
    Visit my blog for CRM material, improving performance, kerberos, IFD, development tips, etc. :) http://quantusdynamics.blogspot.com


    Could You kindly  provide an example how to edit thar hard coded url in template.

    Sending email shows that new url line but it generates url  http://orgurl  {idpart}  and looking source there is /a that cuts url between.   

    Thursday, December 22, 2011 9:54 AM
  •  

    Hi _jani_,

    Yes, the previous posts, show admins going through the databases and referring to the database templatBase, all this data is avaiable on the CRM templates: go to Settings > Templates > Click on E-mail templates

    For example open the Duplicate Detection Task Completion Template, and you get:

     

    This Microsoft Dynamics CRM duplication-detection task completed successfully.

    Name: {!System Job:System Job Name;[Duplicate Detection task]}

    Started: {!System Job:Created On;}

    To view and manage duplicates, do one of the following:

    Click {!System Job:System Job;}>http://SERVER01/MyCompany/tools/asyncoperation/edit.aspx?id={!System Job:System Job;}

    or

    Log on to Microsoft Dynamics CRM and navigate to System Tasks page and double-click the name of the task.

     

    Where it says SERVER01 and My company just change to the correct data.



    Visit my blog for CRM material, improving performance, kerberos, IFD, development tips, etc. :) http://quantusdynamics.blogspot.com
    • Edited by nrodri Thursday, December 22, 2011 1:47 PM
    Thursday, December 22, 2011 1:47 PM
  • Hi _jani_,

    Yes, the previous posts, show admins going through the databases and referring to the database templatBase, all this data is avaiable on the CRM templates: go to Settings > Templates > Click on E-mail templates

    For example open the Duplicate Detection Task Completion Template, and you get:

    This Microsoft Dynamics CRM duplication-detection task completed successfully.

    Name: {!System Job:System Job Name;[Duplicate Detection task]}

    Started: {!System Job:Created On;}

    To view and manage duplicates, do one of the following:

    Click {!System Job:System Job;}>http://SERVER01/MyCompany/tools/asyncoperation/edit.aspx?id={!System Job:System Job;}

    or

    Log on to Microsoft Dynamics CRM and navigate to System Tasks page and double-click the name of the task.

    Where it says SERVER01 and My company just change to the correct data.



    Visit my blog for CRM material, improving performance, kerberos, IFD, development tips, etc. :) http://quantusdynamics.blogspot.com

    Click{!System Job:System Job;}>http://SERVER01/MyCompany/tools/asyncoperation/edit.aspx?id={!System Job:System Job;}

    Ive done something wrong ? text is ok but that link is http://SERVER01/MyCompany/tools/asyncoperation/edit.aspx?id=


    • Edited by _jani_ Thursday, February 16, 2012 8:35 AM
    • Proposed as answer by Cristian Mihai MBA Tuesday, December 15, 2015 12:02 PM
    • Unproposed as answer by Cristian Mihai MBA Tuesday, December 15, 2015 12:02 PM
    Thursday, February 16, 2012 8:18 AM
  • Hi

    Despite what others have posted, you CANNOT modify the template directly in CRM 4.0 by editing the template, this simply does not work, it may look correct but you will still have errors when the email gets sent.

    Updating via the database is one option. 

    Here is another way without having to pester your DB:

    Export Customizations -> just the "templates" entity

    Open in an XML editor (Visual Studio works)

    Change all instances of http://wrongserver to http://rightserver (obviously replace wrongserver and rightserver with your values)

    Save the file

    In CRM: Customizations -> import the file

    All should be fixed.  BE WARNED that modifying the customizations file directly is "unsupported".

    This does not seem to be an issue in CRM 2011.

    I hope this helps someone!


    Nick

    • Proposed as answer by kreed_i_am Friday, May 11, 2012 3:10 PM
    Friday, May 11, 2012 2:50 PM
  • Nice idea, thanks Nick.  Didn't think of that.  Much better idea than directly editing the database.
    Friday, May 11, 2012 3:06 PM
  • ok, resolved this by editing the CRM system job email template for the duplicate dection
    Where did you do this? Still very new to Dynamics, but I poked through Admin and in System Jobs there are no options, only a list of jobs that have been run.
    Tuesday, May 15, 2012 4:38 AM
  • I have the same problem: text is ok but that link is http://SERVER01/MyCompany/tools/asyncoperation/edit.aspx?id=    

    Have you found a solution?

    Monday, May 21, 2012 10:39 PM
  • Hello Henri,

    did you find a solution to your problem? I am facing the same issue.



    Tuesday, July 17, 2012 12:36 PM
  • Thanks for posting this, and I had just come to the same realization. My concern now is if I try to insert data fields for System Jobs there are two problems: 1) The old system URL is now back and 2) as others have mentioned, the actual job reference doesn't get passed.

    • Edited by SeanDMcg Thursday, July 18, 2013 4:28 PM removed sig line
    Thursday, July 18, 2013 4:26 PM
  • 1. Advanced search: Email Templates

    2. Edit the template to http://SERVER01/MyCompany/tools/asyncoperation/edit.aspx?id={!System Job:System Job;} (copy the line if you do not believe me and test without changing the original line in the template)

    3. Go to the end of the line and press backspace until the link/underline disappears. The link will be recreated in the email if you keep http:// in front of the URL.

    4. save template

    Tuesday, December 15, 2015 12:02 PM
  • 1. Advanced search: Email Templates

    2. Edit the template to http://SERVER01/MyCompany/tools/asyncoperation/edit.aspx?id={!System Job:System Job;} (copy the line if you do not believe me and test without changing the original line in the template)

    3. Go to the end of the line and press backspace until the link/underline disappears. The link will be recreated in the email if you keep http:// in front of the URL.

    4. save template

    Tuesday, December 15, 2015 12:04 PM