Home
> CRM 2011 > Table alias is not unique amongst all top-level table and join aliases – Exception
Table alias is not unique amongst all top-level table and join aliases – Exception
Recently we upgraded from UR 8 to UR 13 and from then I was getting ‘Unexpected’ error when I was adding members to my ‘Dynamic Marketing list’ using ‘Advanced Find’ window.
Below is the error log from my Event viewer
Exception type: CrmException
Exception message: Table alias a_7f4fc1baff99e111bef200155dc87c59 is not unique amongst all top-level table and join aliases
This is a known issue with UR 12 and would be resolved in UR 15.
Here is the link which has solution/workaround for the issue.
🙂
Categories: CRM 2011
CRM 2011, Table alias is not unique, Ur 12
Rajeev Pentyala - Microsoft Power Platform 
Hi,
We run RU15 but the issue is still present. Can you confirm it was fixed for you?
Kind Regards,
Peter
Hi,
As per the KB article
Installing Microsoft Dynamics CRM 2011 Update Rollup 15 resolves the issue for the views which are modified after installing Update Rollup 15. The existing views identified before installing Update Rollup 15 throwing the error needs to be fixed manually.
So only newly created views do not throw exception but all the existing views has to be fixed manually.
http://support.microsoft.com/kb/2907665