Tuesday, July 9, 2013

Table alias a_065a97880625e1118ea61cc1def13751 is not unique amongst all top-level table and join aliases

Recently we have modified few views in CRM 2011 online. After modifying the views, we were not able to access the view in CRM. Getting the following error message.

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=5.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: System.Xml.XmlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #2C52B8F9Detail: 
<OrganizationServiceFault xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://schemas.microsoft.com/xrm/2011/Contracts">
  <ErrorCode>-2147220970</ErrorCode>
  <ErrorDetails xmlns:d2p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
  <Message>System.Xml.XmlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #2C52B8F9</Message>
  <Timestamp>2013-07-09T05:42:07.7326294Z</Timestamp>
  <InnerFault>
    <ErrorCode>-2147217104</ErrorCode>
    <ErrorDetails xmlns:d3p1="http://schemas.datacontract.org/2004/07/System.Collections.Generic" />
    <Message>Table alias a_065a97880625e1118ea61cc1def13751 is not unique amongst all top-level table and join aliases</Message>
    <Timestamp>2013-07-09T05:42:07.7326294Z</Timestamp>
    <InnerFault i:nil="true" />
    <TraceText i:nil="true" />
  </InnerFault>
  <TraceText i:nil="true" />
</OrganizationServiceFault>


Looks like a bug with recent roll up's. Found the following article  to fix this issue
http://blog.salesmetrix.com/2013/02/08/corruption-of-views-dynamics-crm-2011-online-dec-2012-service-release/

work around provided in the article worked for me. Hope it helps someone..

1 comment:

  1. We have been having this issue alot recently. The following post describes what I think was causing the issue and what we did to resolve it:

    http://rule30.wordpress.com/2014/04/11/fix-table-alias-xyz-is-not-unique-amongst-all-top-level-table-and-join-aliases/

    Hope that helps someone!

    ReplyDelete