Entrar
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
CRM 2011 Accounts Entity View produces CRM Failed to Load error Works fine through IE

Proposed CRM 2011 Accounts Entity View produces CRM Failed to Load error Works fine through IE

  • terça-feira, 15 de maio de 2012 15:19
     
     
    Entrar para Votar
    0

    I have been troubleshooting this for about 4 weeks without any resolution.  Basically if you click the accounts entity while using Outlook integration you get the error CRM Failed to Load.  The trace logs don't actually capture the error when I look at the log file no information is in there right after I click the accounts entity and get that error.  

    1.  This is occurring to all users even those with System Admin and have full permission to every entity and field in CRM.  

    2.  I have created a new default Accounts View with just one single column --> Account Name and set that as the default view, synched outlook with CRM, deleted old files from CRM using the diagnostic tool.  Nothing works, creating new views and setting them as the default view and publishing the changes does nothing.  

    3.  I know that users can create their own views I am not exactly sure how that overrides things but I wouldnt think it would be an issue if everyone had this problem. 

    4.  I am running CRM 2011 Rollup 8 with Outlook Client.  

    Maybe someone out there knows something I dont and can assist me because this little annoying issue is causing me a ton of grief.  

     

Todas as Respostas

  • terça-feira, 15 de maio de 2012 19:02
     
     Resposta Proposta
    Entrar para Votar
    0

    Try this:

    First find a GUID for a user having trouble with this view by a SQL query

    USE ORG-DB_MSCRM
    SELECT SystemUserId, DomainName FROM SystemUserBase WHERE DomainName = ‘DOMAIN\Username’

    then start a second query

    USE ORG-DB_MSCRM
    SELECT TabOrderXml FROM UserEntityUISettings WHERE OwnerId = ‘GUID of User who has problems’
    AND ObjectTypeCode = OTC of Entity which is causing error (account = 1)

    Returned value should be

    • NULL
    • A single GUID: {00000000-0000-0000-00AA-000010001002}
    • A semi-colon delimited list of GUIDs: {00000000-0000-0000-00AA-000010001002};{00000000-0000-0000-00AA-000010001003}

    If you find something like {00000000-0000-0000-00AA-000010001002}; or {00000000-0000-0000-00AA-000010001002};;
    you should update this to {00000000-0000-0000-00AA-000010001002} or NULL by using this query

    update UserEntityUISettings
            set TabOrderXml = NULL
    where OwnerId = 'GUID of systemuser having trouble'
    and ObjectTypeCode = 1

    Carsten Groth http://carstengroth.wordpress.com Microsoft Dynamics Certified Technology Specialist