locked
query builder error - some mail merge templates RRS feed

  • Question

  • Hello,

    We are having the following problem:

    Click on Settings, Templates, Mail Merge Templates. 

    On our test server:
    - Error message:  Query Builder Error
    - Inability to select a view of templates

    On our prod server, views:
    My Active Mail Merge Templates - shows no templates (though some do exist)
    Inactive Mail Merge Templates - shows no templates (though I think some exist)
    Active Mail Merge Templates - error message "No Entity"
    All Mail Merge Templates - error message "No Entity"

    Any ideas of where to look for the issue?
    Tuesday, February 9, 2010 10:00 PM

Answers

  • A brilliant colleague figured it out---needed to delete an entry from the MailMergeTemplateBase - it was referencing a custom entity that had been deleted.  Not sure why the interface allowed for the delete with that dependency, but it did.

    Cheers,
    gg

    • Marked as answer by geeky girly Thursday, February 11, 2010 10:58 PM
    Thursday, February 11, 2010 10:58 PM

All replies

  • More info on prod:

    select owningbusinessunit, name, owninguser from MailMergeTemplateBase order by name

     

    owningbusinessunit       name    owninguser

    FF6E2F8C-8512-DF11-8CFF-000C2915358A            Avery 5163          041D75A4-65B2-DD11-90EC-00151728E68C

    FF6E2F8C-8512-DF11-8CFF-000C2915358A            Demo Cover Letter         041D75A4-65B2-DD11-90EC-00151728E68C

    FE6E2F8C-8512-DF11-8CFF-000C2915358A            Invoice (account)             982F5A69-BD22-DE11-874C-00151728E68C

    FE6E2F8C-8512-DF11-8CFF-000C2915358A            Invoice-charge  982F5A69-BD22-DE11-874C-00151728E68C

    006F2F8C-8512-DF11-8CFF-000C2915358A            Product Letter 779ADC02-23E4-DE11-BC9C-000C295BB9B3

    FE6E2F8C-8512-DF11-8CFF-000C2915358A            test word excel 982F5A69-BD22-DE11-874C-00151728E68C

     

    However, these queries return nothing:

    select

     

    * from SystemUserBase where SystemUserId = '041D75A4-65B2-DD11-90EC-00151728E68C'

    select

     

    * from SystemUserBase where SystemUserId = '982F5A69-BD22-DE11-874C-00151728E68C'

    select

    * from SystemUserBase where SystemUserId = '779ADC02-23E4-DE11-BC9C-000C295BB9B3'

    The mail merge records exist in the database, but the 'owninguser' GUID does not (though they all exist in the original deployment of CRM).

    ??

     

    * from SystemUserBase where SystemUserId = '779ADC02-23E4-DE11-BC9C-000C295BB9B3'

    The mail merge records exist in the database, but the 'owninguser' GUID does not (though they all exist in the original deployment of CRM).

    ??

    * from SystemUserBase where SystemUserId = '779ADC02-23E4-DE11-BC9C-000C295BB9B3'

    The mail merge records exist in the database, but the 'owninguser' GUID does not (though they all exist in the original deployment of CRM).

    ??

    Tuesday, February 9, 2010 11:51 PM
  • Hi,

    have you delete the missing user from the database? In crm4 is it not supportet to delete a user, you can only disable user.


    Viele Grüße

    Michael Sulz
    MVP für Microsoft Dynamics CRM
    Wednesday, February 10, 2010 6:40 AM
  • Sorry, forgot to include a key piece of information.  Prod is a new environment - we followed http://support.microsoft.com/default.aspx/kb/952934 to deploy CRM to a different environment.  We selected the default method of automapping AD users.  However, there appears to be an issue with the user GUIDs in the database.

    To answer your question, no, no users have been deleted.
    Wednesday, February 10, 2010 4:37 PM
  • Hi geeky girly,
    I think that during redeployment some of the users were not matched because for example they not exist in AD (they leave the company and their AD account was deleted). One of the procedures if someone is leaving is assign his records to someone else.
    What can you do is once again do redeployment (first restore DBs before you made a 1st redeployment). Match all the users automatically and these which will not be match point to other even dummy AD accounts.

    Of course you can try to modify directly database (which can be faster way) but definitelly unsupported.
    My Dynamics CRM Blog: http://bovoweb.blogspot.com
    • Marked as answer by Jim Glass Jr Wednesday, February 10, 2010 6:07 PM
    • Unmarked as answer by geeky girly Wednesday, February 10, 2010 8:07 PM
    Wednesday, February 10, 2010 4:45 PM
  • kgorczewski, Thanks for the response.  The users in question were in AD before and after redeployment.

    For example, in original database:

    'John Smith' owned mail merge 'customer letter'
    in original db, 'John Smith' has GUID  '041D75A4-65B2-DD11-90EC-00151728E68C'
    'customer letter' is owned by GUID ' 041D75A4-65B2-DD11-90EC-00151728E68C'

    In new database (post re-deployment):
    'customer letter' is owned by GUID ' 041D75A4-65B2-DD11-90EC-00151728E68C'
    'John Smith' is no longer that GUID, he is now a different GUID
    searching the system user table in CRM, there are no users with GUID '041D75A4-65B2-DD11-90EC-00151728E68C', though that is still listed as the 'owninguser' of the mail merge record

    Match all the users automatically and these which will not be match point to other even dummy AD accounts.
    Given the info above, do you still think this is worth re-deploying?  It seems to me that this would only be effective if say John Smith was no longer with the company.  But all users who are owners of mail merge documents are the same in AD before and after.



    Wednesday, February 10, 2010 8:18 PM
  • Do a quick check - look at ms crm log (all items which was changed during the redeployment will be logged to ms crm log) and try to find any errrors. if you can see any it means that something goes wrong during redeployment.

    Redeployment process should check all tables in databases and change all old GUIDs to new one.
    My Dynamics CRM Blog: http://bovoweb.blogspot.com
    Thursday, February 11, 2010 9:49 AM
  • no, it looks successful.  ??

    Thursday, February 11, 2010 6:16 PM
  • Wait, though, I'm looking at misc. logs - I don't see one specific log that shows checking all the tables and addressing GUIDs - do you know what file I should look for?

    Thanks!!!gg
    Thursday, February 11, 2010 6:44 PM
  • A brilliant colleague figured it out---needed to delete an entry from the MailMergeTemplateBase - it was referencing a custom entity that had been deleted.  Not sure why the interface allowed for the delete with that dependency, but it did.

    Cheers,
    gg

    • Marked as answer by geeky girly Thursday, February 11, 2010 10:58 PM
    Thursday, February 11, 2010 10:58 PM