Published by

Rajeev Pentyala

December 18, 2013

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.

🙂

2 responses to “Table alias is not unique amongst all top-level table and join aliases – Exception”

PeterTox

March 14, 2014

Hi,

We run RU15 but the issue is still present. Can you confirm it was fixed for you?

Kind Regards,
Peter

Reply
1. Rajeev Pentyala
  
  March 14, 2014
  
  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
  
  Reply

Rajeev Pentyala – Technical Blog on Power Platform, Azure and AI

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

2 responses to “Table alias is not unique amongst all top-level table and join aliases – Exception”

Leave a reply to Rajeev Pentyala Cancel reply

Visitors

Top Posts

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

Share this:

2 responses to “Table alias is not unique amongst all top-level table and join aliases – Exception”

Leave a reply to Rajeev Pentyala Cancel reply

Visitors

Top Posts